源码:
$db =new mysqli("localhost","root","5832528");
$db->select_db("books");
$query1 = "insert into books values('123-457','zhp','C++',56)";
if(mysqli_connect_errno()){
echo '连接错误';
exit;
}
$result = $db->query($query1);
if($result)
echo $db->affected_rows.' book inserted into database';
else
echo "Error";
$db->close();在phpmyadmin执行查询语句没问题,数据库也可以连接上去,执行查询什么的也没问题。就谁无法将数据插入mysql了
$db =new mysqli("localhost","root","5832528");
$db->select_db("books");
$query1 = "insert into books values('123-457','zhp','C++',56)";
if(mysqli_connect_errno()){
echo '连接错误';
exit;
}
$result = $db->query($query1);
if($result)
echo $db->affected_rows.' book inserted into database';
else
echo "Error";
$db->close();在phpmyadmin执行查询语句没问题,数据库也可以连接上去,执行查询什么的也没问题。就谁无法将数据插入mysql了
mysqli_error()可以显示错误因为。才发现把books表当成一个数据库。所以才插入错误。