Home >Backend Development >PHP Tutorial >PHP mysql code example for adding user (registration)

PHP mysql code example for adding user (registration)

WBOYOriginal: 2016-07-25 08:58:361758browse

本文介绍下，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>

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>

Statement：

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Previous article：php curl error code list (collection)Next article：php curl error code list (collection)

See more

PHP mysql code example for adding user (registration)

Related articles