php - 注册表: No error showing but No data on mysql DATABASE

Question

我正在尝试开发注册表。

当我填写所有文件并提交表格时，没有错误显示服务器已连接，但 mysql 数据库表上没有数据。 Bellow L 附上表格的 Action 文件。我想念什么？我该如何解决？

<?php
$mysqli_servername = "localhost";
$mysqli_username = "admin_try";
$mysqli_password = "rFT5hePS5u";
$mysqli_database = "indepe";

// Create connection
$conn = mysqli_connect($mysqli_servername,$mysqli_username,$mysqli_password,$mysqli_database);

// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
 echo "<a href='index.html'>Back to main page</a>";

if (isset($_GET["submitreg"]))
{

       $id= mysqli_real_escape_string($conn, $_POST['id']);
       $country = mysqli_real_escape_string($conn, $_POST['country']);
       $email = mysqli_real_escape_string($conn,$_POST['email']);
       $password = mysqli_real_escape_string($conn,$_POST['password']);
       $re_password = mysqli_real_escape_string($conn,$_POST['re_password']);
       $compnay = mysqli_real_escape_string($conn,$_POST['compnay']);
       $contact = mysqli_real_escape_string($conn,$_POST['contact']);
       $tell = mysqli_real_escape_string($conn,$_POST['tell']);


     $sql = "INSERT INTO registration(id,country,email,password,re_password,compnay,contact,tell);  
         VALUES('id','$country','$email','$password','$re_password','$compnay','$contact'),'$tell'";

    if ($conn->query($sql) === TRUE) {

    echo "record created successfully";

} else {

    echo "Error: " . $sql . "<br>" . $conn->error;

}


if (mysqli_query($conn, $sql)) {
    echo " record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
}



//$conn->close();
mysqli_close($conn);

?>

Answer 1

您的插入查询中几乎没有错误

• 删除插入查询中 tell 之后的分号
• 你给 id 值而不是 $id

• $tell在括号外

  $sql = "INSERT INTO registration(id,country,email,password,re_password,compnay,contact,tell) VALUES('$id','$country','$email','$password ','$re_password','$compnay','$contact','$tell'");

我不确定这是你的问题还是你复制你的代码时发生的..因为没有显示错误