php - 从 mysqli 语句结果返回关联数组

Question

我有以下代码。

public function fetch_questions($count=null)
{
    $stmt = $this->mysqli->prepare("SELECT question,question_title FROM questions order by id");
    $stmt->execute();

    $stmt->bind_result($question,$question_title);

    $arr = array();
    while ($stmt->fetch()) {
        $arr = array('question_title'=>$question_title,'question'=>$question);
    }
    $stmt->close();

    return $arr;
}

输出仅包含一行，即最后一行。如何检索所有记录？

$questions = $db->fetch_questions();
var_dump($questions);

var_dump 的输出:

    array
  'question_title' => string 'aaaaaa' (length=6)
  'question' => string 'aaaaaaaaaaaaaaaaaaaa' (length=20)

Answer 1

您需要附加到 $arr通过 [] ，不直接赋值。否则，您将在每次循环迭代中覆盖它。

while ($stmt->fetch()) {
    $arr[] = array('question_title'=>$question_title,'question'=>$question);
    //-^^^^
}