php - 准备好的语句 : Fetch as array

Question

我有这样的查询:

$stmt = $cxn->prepare('SELECT post_id, user_id, content, datetime, total_comments, total_likes FROM posts WHERE user_id = ?');
$stmt->bind_param('i', $user_id);
$stmt->execute();
$stmt->bind_result($post_id, $user_id, $content, $datetime, $total_comments, $total_likes);
$stmt->fetch();
$stmt->close();

我只想将结果直接放入数组中。我如何更改我的代码以反射(reflect)这一点(PHP 和 MySQLi)？

谢谢。

Answer 1

对于普通数组(由数字索引)，您可以使用$stmt->fetch_array()看起来像这样:[ ['x', 'y'], ['a', 'b'] ]

当你需要关联数组时，这样做:$stmt->fetch_assoc()它看起来像这样:[ ['field1' => 'x', 'field2' => 'y'], ['field1' => 'a', 'field2' => 'b'] ]