php - 注册表单数据未显示在数据库中

Question

我尝试将代码更改为此，以便它先连接到数据库，但现在它只是停留在 verify.php 上，没有重定向，没有数据发送到数据库。

        <?php 
if(isset($_POST['submit'])){ 
 # connect to the database here
$host="XXXXXXX"; // Host name 
   $username="XXXX"; // Mysql username 
   $password="XXXX"; // Mysql password 
  $db_name="XXXX"; // Database name 

   mysql_connect("$host", "$username", "$password")or die("cannot connect for insert"); 
    mysql_select_db("$db_name")or die("cannot select DB to insert data");

    $user_name = mysql_real_escape_string($_POST['user_name']);
    $fname =    mysql_real_escape_string($_POST['fname']);
     $lname =     mysql_real_escape_string($_POST['lname']); 
    $email =     mysql_real_escape_string($_POST['email']);
     $user_password =    mysql_real_escape_string($_POST['password']); 

     $insert_query = "INSERT INTO teachers(`user_name`,`fname`,`lname`,`email`,`password`) 
    VALUES('".$user_name."$','".$fname."','".$lname."','".$email."','".$user_password."');";
    mysql_query($insert_query) or die(mysql_error()); 
    mysql_close();

    };
      ?> 

Answer 1

您应该将 or die(mysql_error()); 放在以下行中:

$sql = mysql_query($query) or die(mysql_error());

而不是:

mysql_real_escape_string($_POST['password']))or die(mysql_error());

另一件事是你有错误的 if-else 语句。

您应该在以下 if 语句中编写代码来检查哪个字段为空:

if($row||empty($_POST['user_name'])|| empty($_POST['fname'])||empty($_POST['lname'])|| empty($_POST['email'])||empty($_POST['password'])|| empty($_POST['re_password'])||$_POST['password']!=$_POST['re_password']){ 
# if a field is empty, or the passwords don't match make a message
# YOU SHOULD PUT YOUR CODE TO CHECK EMPTY FIELDS SEPARATELY HERE
}
else { 
    # If all fields are not empty, and the passwords match, 
}