<?
php session_start();
$conn=mysqli_connect("localhost","root","root","userman");
$conn->query('set names gb2312');
if(empty($conn))
{
   die("数据库连接失败");
}
$UserName=$_POST['username'];
$pwd=$_POST['password'];
$email=$_POST['email'];
$sex=$_POST['sex'];
$time=time();
$code=strtolower($_POST["code"]);
$str="select * from users where username='".$username."'";
   $result1=$conn->query($str);
   $row=$result1->fetch_row();
if($row)
{
$temp="已有人注册此名，请重新选择名字!";
echo $temp;
echo"<a href=zhuce.php>返回</a>";
}
else {
if( $_SESSION['sname']==$code)
{
   echo $temp="认证码成功";
   $sql="INSERT INTO users VALUES('$username', '$password','$email','$sex','$time')";
   $result=$conn->query($sql);
   if($result==true)
      {
      $_SESSION['mail']="注册成功,请登陆";
      echo "<script>window.location.href='login1.php'</script>";
      }
      else {echo "注册失败".mysql_error();}
}
else {echo "认证码错误";}
}
?>