介绍下php实现用户注册功能的方法,使用mysql/ target=_blank class=infotextkey>mysql数据库存储注册信息。
本文给出的实例,用到二个程序代码。
一个是create_user.php,用于添加用户信息。
另一个是create_userok.php,用于数据库操作。
1,添加新用户 create_user.php
<html> <head> <meta http-equiv="Content-type" content="html/text; charset=gb2312"> <title>添加新的用户_www.jb200.com</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>保存用户信息_www.jb200.com</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>请返回重新输入,<a href='#'" /a>";
}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><a href='#'" /a>";
}
?>
</center>
</body>
</html>