下面是注册页面的代码:
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>VIP用户注册</title>
</head>
<body>
<?php
echo $_COOKIE['cautionWord'];
?><br><br>
<form name="registerForm" onsubmit="return isRight()" action="testinputUser.php" method="get">
填写用户名:<input type="text" name="userName" ><br><br>
请填写密码:<input type="text" name="userPassword1"><br><br>
请重复密码:<input type="text" name="userPassword2"><br><br>
请输入年龄:<input type="text" name="userAge" ><br><br>
请选择性别:<input type="radio" name="userSex" value="male">男性   
<input type="radio" name="userSex" value="female">女性<br><br>
<input type="reset" value="重写" width=60 length=30>     
<input type="submit" value="提交" width=60 length=30>
</form>
<script>
function isRight(){
var userName=document.getElementsByName('userName')[0];
var userPassword1=document.getElementsByName('userPassword1')[0];
var userPassword2=document.getElementsByName('userPassword2')[0];
var userAge=document.getElementsByName('userAge')[0];
var userSex=document.getElementsByName('userSex')
if (userName.value==""||userPassword1.value==""||userPassword2.value==""||userAge.value==''){
alert('全部都要填写哦');
return false;
}
if(userPassword1.value != userPassword2.value){
alert('密码请保持一致');
return false;
}
var isCheckedSex=0;
for(m=0;m<userSex.length;m++){
if(userSex[m].checked){
isCheckedSex=1;
}
}
if(isCheckedSex==0){
alert('请选择性别');//必须放在return的前面,return后面的好像都无法执行哦
return false;
}
}
</script>
</body>
</html>
下面是处理注册信息的页面代码
<?php
$servername = "---";
$username = "--";
$password = "---";
$dbname = "--l";
// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
} else {
echo '连接成功!<br>';
}
$loginName=$_GET['userName'];
$userPassword=$_GET['userPassword1'];
$userAge=$_GET['userAge'];
$userSex=$_GET['userSex'];
//firstly we make sure if the userName has been put into database?
$sql="SELECT * FROM user_table WHERE userName='$loginName'";//这里给变量加上引号,是为了表明是文本字段
if($result=$conn->query($sql)){
setcookie('cautionWord','用户名已存在,请重新输入');
header('location:./register.php');
exit();//如果不加上die()或者exit(),即算是跳转了,后面的代码还是会执行
}else{
setcookie('cautionWord','');
}
//now we begin to put the user's info into database
//$conn->query('set names utf8;');
$sql="INSERT INTO user_table (userName,userPassword,userAge,userSex)VALUES('$loginName','$userPassword','$userAge','$userSex')";
if($result = $conn->query($sql)){ //nn ->query is important
echo '成功录入';
header("location:./corePage.php");
setcookie('userName',$loginName);
setcookie('userPassword',$userPassword);
}else{
echo 'please insert again';
header('location:./register.php');
}
?>
不知道为什么,总是被判定为用户名已经存在而返回到上面的注册页面?