如何在没有任何错误的情况下插入INTO数据库 - How can INSERT INTO database with out any ERROR?

How can INSERT INTO database with out any ERROR?

我已经写了这段代码，用于将数据插入数据库，它也会连接到数据库，但当我检查插入数据库的结果时，它会给出错误，哪里出了问题？

<?php
define("HOST", "localhost");        
define("USER", "admin"); 
define("PASSWORD", "Og%rA#b@d"); 
define("DATABASE", "database"); 
$mysqli = new mysqli(HOST, USER, PASSWORD, DATABASE);
if ($mysqli->connect_error) {
echo 'DataBase Connection Error';
exit();
}
$result = mysql_query("INSERT INTO table (id, name, family) VALUES (2, 'a','b')");
if($result)
{
   echo "Success";
}
else
{
   echo "Error";
}
?>

看起来就像是在混合mysqli_和mysql_。。。尝试将mysql_query("INSERT...")更改为mysqli_query($mysqli, "INSERT INTO...")

mysqli_query 的W3学校说明

试试这个：

<?php
define("HOST", "localhost");        
define("USER", "admin"); 
define("PASSWORD", "Og%rA#b@d"); 
define("DATABASE", "database"); 
$mysqli = new mysqli(HOST, USER, PASSWORD, DATABASE);
if ($mysqli->connect_error) {
echo 'DataBase Connection Error';
exit();
}
$result = mysqli_query($mysqli,"INSERT INTO table (id, name, family) VALUES (2, 'a','b')"); // use here mysqli_query and give connection object also in it before insert query
if($result)
{
   echo "Success";
}
else
{
   echo "Error";
}
?>

 mysql_query("INSERT INTO 'table' (id, name, family) VALUES (2, 'a','b')");

表是mysql 中的保留字

尝试在mysql控制台上运行查询并检查它是否有效。

然后，正如在上面的文章中提到的，您正在尝试混合mysql和mysqli

尝试msyqli_query