在准备好的语句上使用fetch_assoc(php mysqli) [英] Using fetch_assoc on prepared statements (php mysqli)
问题描述
我目前正在使用登录脚本,并且得到了以下代码:
I'm currently working on a login script, and I got this code:
$selectUser = $db->prepare("SELECT `id`,`password`,`salt` FROM `users` WHERE `username`=?");
$selectUser->bind_param('s', $username);
$selectUser->execute();
if ($selectUser->num_rows() < 0)
echo "no_user";
else
{
$user = $selectUser->fetch_assoc();
echo $user['id'];
}
这是我得到的错误:
致命错误:未捕获错误:调用未定义的方法 mysqli_stmt :: fetch_assoc()
Fatal error: Uncaught Error: Call to undefined method mysqli_stmt::fetch_assoc()
我尝试了各种变化,例如:
I tried all sorts of variations, like:
$result = $selectUser->execute();
$user = $result->fetch_assoc();
还有更多...什么都不起作用.
and more... nothing worked.
推荐答案
这是因为fetch_assoc
不是mysqli_stmt
对象的一部分. fetch_assoc
属于mysqli_result
类.您可以使用mysqli_stmt::get_result
首先获取结果对象,然后调用fetch_assoc
:
That's because fetch_assoc
is not part of a mysqli_stmt
object. fetch_assoc
belongs to the mysqli_result
class. You can use mysqli_stmt::get_result
to first get a result object and then call fetch_assoc
:
$selectUser = $db->prepare("SELECT `id`,`password`,`salt` FROM `users` WHERE `username`=?");
$selectUser->bind_param('s', $username);
$selectUser->execute();
$result = $selectUser->get_result();
$assoc = $result->fetch_assoc();
或者,您可以使用bind_result
将查询的列绑定到变量,然后使用fetch()
:
Alternatively, you can use bind_result
to bind the query's columns to variables and use fetch()
instead:
$selectUser = $db->prepare("SELECT `id`,`password`,`salt` FROM `users` WHERE `username`=?");
$selectUser->bind_param('s', $username);
$selectUser->bind_result($id, $password, $salt);
$selectUser->execute();
while($selectUser->fetch())
{
//$id, $password and $salt contain the values you're looking for
}
这篇关于在准备好的语句上使用fetch_assoc(php mysqli)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!