我的数据无法传输到phpMyAdmin时遇到问题。服务器和数据库连接PHP，但数据没有插入到表中。
这就是我到目前为止所拥有的。
<?php
$dbConnect = mysqli_connect("xxxxxxx", "xxxxx","xxxxx");
if (!$dbConnect)
die("<p>The database server is not available.</p>");
echo "<p>Successfully connected to the database server.</p>";
$dbSelect = mysqli_select_db( $dbConnect,"sxxxxxxx_db" );
if (!$dbSelect)
die("<p>The database is not available.</p>");
echo "<p>Successfully opened the database.</p>";
$sql = "INSERT INTO customer (Name,Password,Email,Phone) VALUES ('$_POST[namefield]', '$_POST[pwdfield]','$_POST[email]','$_POST[phone]' ) ";
mysqli_query($sql,$dbConnect);
mysqli_close($dbConnect);
if(isset($_POST['namefield']) && isset($_POST['pwdfield']) && isset($_POST['cpwdfield']) && isset($_POST['email']) && isset($_POST['phone']) && isset($_POST['submit']))
{
$name = $_POST['namefield'];
$password = $_POST['pwdfield'];
$cpassword = $_POST['cpwdfield'];
$email = $_POST['email'];
$phone = $_POST['phone'];
if ($_POST["pwdfield"] == $_POST["cpassword"])
mysqli_query("INSERT INTO user VALUES('','$password')") or die(mysqli_error());
else {
echo("Password did not match! Try again. ");
- 关闭您的连接
- 您不应该在查询中直接使用$_POST，请使用以下方法来防止SQL注入
//Connect
$unsafe_variable = $_POST["user-input"];
$safe_variable = mysql_real_escape_string($unsafe_variable);
mysql_query("INSERT INTO table (column) VALUES ('" . $safe_variable . "')");
//Disconnect您已关闭数据库连接
mysqli_close($dbConnect);
稍微更改sql
$sql = "INSERT INTO customer (Name,Password,Email,Phone) VALUES ('".$_POST['namefield']."', '".$_POST['pwdfield']."','".$_POST['email']."','".$_POST['phone']."' ) "