??? ??? ?? ??? ?? ???????. ? ?????? ??? ??? PHP ??? ?? ?????.

POST ???? ???? ???? ????.

<?php
$username = $_POST['username']; //注冊的用戶名
$password = $_POST['password'];  //注冊密碼
$confirm = $_POST['confirm'];  //確認密碼
$email = $_POST['email'];  //郵箱
$code = $_POST['code'];   //驗證碼
?>

??? ??? ??????? ???? ?? ?????

<?php
$link = mysqli_connect('localhost','root','root','test');
if (!$link) {
  die("連接失敗:".mysqli_connect_error());
}
$sql = "select * from login";
$result = mysqli_query($link, $sql);
$rows = mysqli_fetch_array($result);
?>

??? ??? ??? ??? ??? ????? ???

<?php
if ((strlen($username) < 3)||(!preg_match('/^\w+$/i', $username))) 
{  
     echo "<script>alert('用戶名至少3位且不含非法字符！重新填寫');window.location.href='zhuce'</script>";  
     //判斷用戶名長度和非法字符
}
if (!preg_match('/^[\w\.]+@\w+\.\w+$/i', $email)) 
{    
     echo "<script>alert('郵箱不合法！重新填寫');window.location.href='zhuce.html'</script>";    
     //判斷郵箱格式是否合法
}
?>

??? ??? ???? ?? ? ???? ?? ??? ??? ?? ???? ??? ???? ???? ? ????. ? ??? ??? ?????.

?? ??????? ?? ???? ??? ?? ???? ???? ???? ???.

<?php
if(mysqli_fetch_array(mysqli_query($link,"select * from login where username = '$username'")))
{     
    echo "<script>alert('用戶名已存在');window.location.href='zhuce.html'</script>";
    // 判斷用戶名是否已經(jīng)被注冊
}
?>

??? zhuce.php ?? ??:

<?php
  session_start();
  header("Content-type:text/html;charset=utf-8");
  $link = mysqli_connect('localhost','root','root','test');
  if (!$link) {
    die("連接失敗:".mysqli_connect_error());
  }
  
  $username = $_POST['username'];
  $password = $_POST['password'];
  $confirm = $_POST['confirm'];
  $email = $_POST['email'];
  $code = $_POST['code'];
  
  if($username == "" || $password == "" || $confirm == "" || $email == "" || $code == "")
  {
    echo "<script>alert('信息不能為空！重新填寫');window.location.href='zhuce.html'</script>";
  } elseif ((strlen($username) < 3)||(!preg_match('/^\w+$/i', $username))) {
    echo "<script>alert('用戶名至少3位且不含非法字符！重新填寫');window.location.href='zhuce'</script>";
    //判斷用戶名長度
  }elseif(strlen($password) < 5){
      echo "<script>alert('密碼至少5位！重新填寫');window.location.href='zhuce.html'</script>";
      //判斷密碼長度
  }elseif($password != $confirm) {
      echo "<script>alert('兩次密碼不相同！重新填寫');window.location.href='zhuce.html'</script>";
      //檢測兩次輸入密碼是否相同
  } elseif (!preg_match('/^[\w\.]+@\w+\.\w+$/i', $email)) {
      echo "<script>alert('郵箱不合法！重新填寫');window.location.href='zhuce.html'</script>";
      //判斷郵箱格式是否合法
  } elseif($code != $_SESSION['authcode']) {
    echo "<script>alert('驗證碼錯誤！重新填寫');window.location.href='zhuce.html'</script>";
    //判斷驗證碼是否填寫正確
  } elseif(mysqli_fetch_array(mysqli_query($link,"select * from login where username = '$username'"))){
    echo "<script>alert('用戶名已存在');window.location.href='zhuce.html'</script>";
  } else{
    $sql= "insert into login(username, password, confirm, email)values('$username','$password','$confirm','$email')";
    //插入數(shù)據(jù)庫
    if(!(mysqli_query($link,$sql))){
      echo "<script>alert('數(shù)據(jù)插入失敗');window.location.href='zhuce.html'</script>";
    }else{
      echo "<script>alert('注冊成功！)</script>";
    }
  }
?>

?? ???? ??? ??? ???? ?? ??? ?? ??????? ?? ?? ??? ???? ?? ???? ?? ??? ? ????.

?: ???? ??? ?? Sell, ????, ?? ???? 12345, ??? ?? 123@www.com? ?? ???? ?????.

??: ? ??? ??? ??? ?? ??? ????. ?? ??? ?? ???? ??? ????? ?? ??? ? ????.