php - 不使用 get_result() 的准备语句

Question

我的网络服务器没有 mysqlnd API 扩展，因此我无法使用它，并且希望采取解决方法。

当前给出错误:

  $postid = $_GET['p'];

  $stmt = $conn->prepare('SELECT * FROM posts WHERE post_id = ?');
  $stmt->bind_param('s', $postid);

  $stmt->execute();

  $result = $stmt->get_result();

  while($postRows = $result->fetch_assoc()){
    $posts[] = $postRows;
  }

解决方法:

  $postid = $_GET['p'];

  $stmt = $conn->prepare('SELECT * FROM posts WHERE post_id = ?');
  $stmt->bind_param('s', $postid);

  $stmt->execute();

  $stmt->bind_result($post_id, $post_submitter_id, $post_title, ... [etc]);

  while($stmt->fetch()){
    $posts[] = $postRows; // ????
  }

如何在新的解决方法中创建数组 $posts？

Answer 1

http://php.net/manual/en/mysqli-stmt.bind-result.php

此链接提供了循环结果集的示例。你可以做这样的事情。

$stmt->bind_result($post_id, $post_submitter_id, $post_title, ... [etc]);

while($stmt->fetch())
{
     $posts[] = [
         'post_id' => $post_id,
         'post_submitter_id' => $post_submitter_id,
         ...
     ];
}