mysqli准备语句中带有fetch_array的SELECT语句 [英] SELECT statement with fetch_array in mysqli prepared statements
本文介绍了mysqli准备语句中带有fetch_array的SELECT语句的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我总是很难编写MySQLi预备语句,因为许多函数的工作方式与旧方法不同.现在,我遇到有关fetch_array()
的问题.
I always find it difficult to write MySQLi prepared statements, because many functions work differently than in the old way. Right now I am facing a problem regarding fetch_array()
.
$stmt = $db->prepare("SELECT category_id FROM post_items Where user_id = ?");
$stmt->bind_param('i', $userid);
$result = $stmt->execute();
while ($row = $result->fetch_array()) {
// ...
}
推荐答案
您正尝试通过
$result = $stmt->execute();
情况并非如此.如执行只会返回布尔值.
which is not the case. as execute will return you only a boolean value.
喜欢做.
$stmt = $db->prepare("SELECT category_id FROM post_items Where user_id = ?");
$stmt->bind_param('i', $userid);
$stmt->execute();
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
//result is in row
}
这篇关于mysqli准备语句中带有fetch_array的SELECT语句的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文