致命错误:调用未定义的方法 mysqli::error()
我可以连接,但是当涉及到准备好的语句时,我遇到了错误.有什么问题吗?
I can connect but when it comes to the prepared statement that is the error i got. anything wrong there?
代码:
// Open connection
$db = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);
//check connection
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
// Create statement object
$stmt = $db->stmt_init();
// sql statement
$sql = "INSERT INTO ch_users ('uid','admin','password','directory','size','format','locationid') VALUES (?, 1, ?, ?, ?, ?, 1)";
// Create a prepared statement
$stmt = $db->prepare($sql) or die($db->error());
推荐答案
对于那些偶然发现此页面的人.
For those who stumbled on this page.
你从中得到的错误
Fatal error: Call to undefined method mysqli::error()
这是因为我们需要将错误作为变量而不是作为函数
This is because we need to access the error as variable not as function
所以正确的代码是
if(! empty( $mysqli->error ) ){
echo $mysqli->error; // <- this is not a function call error()
}
相关文章