未定义的函数mysqli_stmt_init()PHP错误(undefined function m

2019-10-21 20:21发布

我是新来使用PHP mysqli的预处理语句。 不管我怎么努力,我总是收到此错误信息。

Fatal error: Call to undefined function mysqli_stmt_init() in...(etc)

我已经关闭我的代码下面进一步我的数据库链接,它不会显示在这里。 这里是我的代码:

$link = mysqli_connect($mysql_host, $mysql_user, $mysql_password, $mysql_database);
if (mysqli_connect_errno()) {
    echo 'We\'re having problems connecting right now. Please try again later.';
    exit();
}
$email_query = mysqli_stmt_init($link);
if(mysqli_stmt_prepare($email_query, "SELECT * FROM users WHERE email=?")){
mysqli_stmt_bind_param($email_query, "s", $email);
mysqli_stmt_execute($email_query);
mysqli_stmt_store_result($email_query);
$exists_email = mysqli_stmt_num_rows($email_query);

mysqli_stmt_close($email_query);

在错误的行号对应于代码初始化线。

Answer 1:

你不需要mysqli_stmt_init() 只需直接将问题你准备好的声明。

if(mysqli_prepare($link, "SELECT * FROM users WHERE email=?")){
    mysqli_stmt_bind_param($email_query, "s", $email);
    mysqli_stmt_execute($email_query);
    mysqli_stmt_store_result($email_query);
    $exists_email = mysqli_stmt_num_rows($email_query);
    mysqli_stmt_close($email_query);
}


文章来源: undefined function mysqli_stmt_init() php error