1、本文代码能够完成的功能有:用户注册,用户注册项检查,用户名重复检测(该功能要重新设计),首先要在mysql数据库test中创建users表格
2、代码
index.html
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
<title>注册页面</title>
<script language="javascript">
function check()
{
if(myform.realname.value == "")
{
alert("请输入真实姓名!");
myform.realname.focus();
return false;
}
if(myform.pwd.value == "")
{
alert("请输入密码!");
myform.pwd.focus();
return false;
}
if(myform.cpwd.value == "")
{
alert("请输入确认密码!");
myform.cpwd.focus();
return false;
}
if(myform.pwd.value.length<6)
{
myform.pwd.value="";
myform.cpwd.value="";
alert("密码少于6位,请重新输入!");
return false;
}
if(myform.pwd.value != myform.cpwd.value)
{
alert("确认密码与原密码不同!");
myform.pwd.value="";
myform.cpwd.value="";
return false;
}
if(myform.email.value == "")
{
alert("您没有输入email地址!");
myform.email.focus();
return false;
}
var i=myform.email.value.indexOf("@");
var j=myform.email.value.indexOf(".");
if(i<0 || j<0 || j<i)
{
alert("您输入的email地址格式有误!");
myform.email.value="";
myform.email.focus();
return false;
}
}
function checkuser(name)
{
if(name == "")
{
alert("用户名不能为空!");
myform.username.focus();
return false;
}
else
{
window.open("http://localhost/Workspace/FirstPHP/checkuser.php?param1="+name,"checkuser","width=200,height=100");
}
}
</script>
</head>
<body>
<form action="http://localhost/Workspace/FirstPHP/deal_register.php" method="post" name="myform" onSubmit="return check()">
<table cellspacing="0" cellpadding="1" border="0">
<tr>
<td>用 户 名:</td><td><input type="text" name="username"></td><td><a href="" οnclick="javascript:checkuser(myform.username.value)">检测用户</a></td>
</tr>
<tr>
<td>真实姓名:</td><td><input type="text" name="realname">*</td>
</tr>
<tr>
<td>密 码:</td><td><input type="password" name="pwd">*</td>
</tr>
<tr>
<td>确认密码:</td><td><input type="password" name="cpwd">*</td>
</tr>
<tr>
<td>性 别:</td><td><input type="radio" name="sex" value="男" checked/>男<input type="radio" name="sex" value="女"/>女</td>
</tr>
<tr>
<td>联系电话:</td><td><input type="text" name="tel"></td>
</tr>
<tr>
<td>QQ 号码:</td><td><input type="text" name="qq"></td>
</tr>
<tr>
<td>Email:</td><td><input type="text" name="email">*</td>
</tr>
<tr>
<td>个人主页:</td><td><input type="text" name="homepage"></td>
</tr>
<tr>
<td>家庭住址:</td><td><input type="text" name="addr"></td>
</tr>
<tr>
<td align="center"><input type="submit" name="sub" value="提交"/></td><td align="center"><input type="reset" name="reset" value="重置"></td>
</tr>
</table>
</form>
</body>
</html>
deal_register.php
<meta http-equiv="Content-Type" content="text/html;charset=utf-8">
<?php
include("connect_mysql.php");
$sql="insert into users(用户名,真实姓名,密码,性别,联系电话,QQ号码,Email,个人主页,家庭住址) values('".
$_POST['username']."','".$_POST['realname']."','".$_POST['pwd']."','".$_POST['sex']."','".$_POST['tel'].
"','".$_POST['qq']."','".$_POST['email']."','".$_POST['homepage']."','".$_POST['addr']."')";
$res=mysql_query($sql);
if(!empty($res))
{
echo "<script>alert('注册成功!');window.location='index.html';</script>";
}
else
{
echo "<script>alert('注册失败!');window.location='index.html';</script>";
}
?>
checkuser.php
<meta http-equiv="Content-Type" content="text/html;charset=utf-8">
<?php
include "connect_mysql.php";
$name=$_GET['param1'];
$res=mysql_query("select * from users where 用户名='$name'");
$re=mysql_fetch_array($res);
if(!empty($re))
{
echo "<font color='red'>用户名 $name 已经存在!</font>";
}
else
{
echo "<font color='green'>用户名 $name 通过检测 !</font>";
}
?>
connect_mysql.php
<?php
$con=mysql_connect("localhost","root","08246298");
mysql_select_db("test",$con);
?>