数据库成功连接;我不能让它插入表单中的数据 .
<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'root';
$db = 'final';
$dbconn = mysqli_connect($dbhost, $dbuser, $dbpass, $db);
if ($dbconn)
echo 'connected succesfully';
if (isset($_POST['submit']))
{
$Customer_ID = $_POST['Customer_ID'];
$Name = $_POST['Name'];
$Email = $_POST['Email'];
$Password = $_POST['Password'];
$PhoneNumber = $_POST['PhoneNumber'];
$Address = $_POST['Address'];
$query = "INSERT INTO `customers`(`Customer_ID`, `Name`, `Email`,
`Password`, `PhoneNumber`, `Address`) VALUES ('$Customer_ID', '$Name',
'$Email', '$Password', '$PhoneNumber','$Address')";
if(mysqli_query($query))
{
echo "<script>alert('INSERTED SUCCESSFULLY');</script>";
}
else
{
echo "<script>alert('FAILED TO INSERT');</script>";
}
}
?>
</body>
</html>