无法使用 MySqli 插入查询插入数据 - Not able to insert data using MySqli Insert Query

Not able to insert data using MySqli Insert Query

本文关键字：插入查询数据 MySqli | 更新日期: 2023-09-27

我有以下php代码将数据插入mysql，同时发送电子邮件。电子邮件正在发送，但数据未插入数据库。

<?php
$connection = mysqli_connect("localhost", "username", "password", "database_name"); 

$cName = $_POST['cName'];
$contact = $_POST['contact'];
$address = $_POST['address'];

$query = mysqli_query($connection,"INSERT INTO registration(CompanyName,Contact,Address) VALUES('$cName','$contact','$address')");
$message = "Registration Details";
$message .= $cName;
$message .= $contact;
$message .= $address;
mail("example@domain.com", "Registration Email", $message);

mysql_close($connection);

?>

问题是这段代码在使用本地主机的本地机器中工作正常。当我把它放到网上时，问题就出现了。电子邮件正在发送，但数据未插入。请帮助我..

只需修改代码即可调试错误。这是您以正确方式的完整代码。

<?php
$connection = mysqli_connect("localhost", "username", "password", "database_name"); 
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
// Perform a query, check for error
if (!mysqli_query($connection,"INSERT INTO registration(CompanyName,Contact,Address) VALUES('".$cName."','".$contact."','".$address."')"))
{
echo("Error description: " . mysqli_error($connection));
}
$message = "Registration Details";
$message .= $cName;
$message .= $contact;
$message .= $address;
mail("example@domain.com", "Registration Email", $message);
mysqli_close($connection);
?>