PHP mysql code example for adding user (registration)-PHP Tutorial-php.cn

PHP mysql code example for adding user (registration)

WBOY

Release： 2016-07-25 08:58:36

Original

1754 people have browsed it

本文介绍下，php与mysql实现添加用户，即用户注册功能的一段代码，有需要的朋友，参考下吧。

介绍下php实现用户注册功能的方法，使用mysql数据库存储注册信息。

本文给出的实例，用到二个程序代码。一个是create_user.php，用于添加用户信息。另一个是create_userok.php，用于数据库操作。

1，添加新用户 create_user.php

<html>
<head>
<meta http-equiv="Content-type" content="html/text; charset=gb2312">
<title>添加新的用户_bbs.it-home.org</title></head>
<script language=javascript>
 function checkcreate_user(){
  if(document.getelementbyid("lname").value=='')
  {
   alert('用户名不能为空');
   document.getelementbyid("lname").focus();
   return false;
  }
  if(document.getelementbyid("lpwd").value=''){
   alert('密码不能为空');
   document.getelementbyid("lpwd").focus();
   return false;
  }
  if(document.getelementbyid("lpwd").value!=document.getelementbyid("relpwd").value){
   alert('两次输入的密码不一致！');
   document.getelementbyid("relpwd").focus();
   return false;
  }
 }
</script>
<body>
<table cellspacing=1 cellpadding=0 width=60% align=center bgcolor=#cccccc border=0>
 <tbody>
  <tr> 
   <td><div align=center><strong>添 加 用 户</strong></td>
   <td><div align=center><strong>输入你的个人信息，带*号的为必填项</strong></td>
  </tr>
  <tr>
   <td valign=top width=620 bgcolor=#ffffff colspan=2>
    <table cellspacing=0 cellpadding=0 width=100% border=0>
     <tbody>
     <tr>
     <form action=create_userok.php method=post id=create_user>
     <td>用户名称：<input type=text name=lname id=lname>*
     <br>真实姓名：<input type=text name=rname id=rname>
     <br>设置密码：<input type=password name=lpwd id=lpwd>*
     <br>确认密码：<input type=password name=relpwd id=relpwd>*
     <br>电子邮件：<input type=text name=lemail id=lemail>
     <br>联系电话：<input type=text name=lphone id=lphone>
     <br>通信地址：<input type=text name=laddress id=laddress>
     <br>
     <input type=reset name=reset value=清除>
     <input type=submit name=submit value=确认提交 checkcreate_user();">
     </td>
     </form>
     </tr>
     </tbody>
    </table>
   </td>
  </tr>
 </tbody>
</table>
</body>
</html>

Copy after login

2，保存用户信息入库 create_userok.php

<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=gb2312">
<title>保存用户信息_bbs.it-home.org</title>
</head>
<body>
<center>
<?php
 $lname=$_POST['lname'];
 $rname=$_POST['rname'];
 $lpwd=$_POST['lpwd'];
 $relpwd=$_POST['relpwd'];
 $lemail=$_POST['lemail'];
 $lphone=$_POST['lphone'];
 $laddress=$_POST['laddress'];
 
 $link=mysql_connect("localhost","root","wutianshen");
 if(!$link){
  echo "数据库连接错误！";
  mysql_errro();
 }
  mysql_select_db("user");
 $exec = "SELECT * FROM myuser WHERE lname='$lname'";
 $result = mysql_query($exec);
 $rows = mysql_num_rows($result); //这边是检测用户是否存在
 if($rows>0){
  echo "添加用户失败！<hr><p>";
  echo "用户：【".$lname;
  echo "】已经存在！";
  echo "<br>请返回重新输入，";
 }else{
  $exec = "INSERT INTO myuser(lname,rname,lpwd,lemail,lphone,laddress)"."VALUES('$lname','$rname','$lpwd','$lemail','$lphone','$laddress')";
  $result = mysql_query($exec);
  $id = mysql_insert_id();  //读取用户ID
  if($id>0){
   echo "添加用户成功！<hr>";
   echo "新添加的用户是：".$rname."<p>";
  }else{
   echo "添加用户失败！<hr><p>";
   echo "用户：【".$rname."】";
   echo "添加失败";
  }
  echo "<br>";
 }
?> 
</center>
</body>
</html>

Copy after login