php - mysqli_fetch_array 只返回一个结果

Question

我正在尝试使用以下代码(在 $host 等中使用适当的值)对小型 mysql 数据库进行非常非常简单的查询:

$result = mysqli_query($connection, "select university from universities_alpha");
$row = mysqli_fetch_array($result);

echo print_r($result);
echo '<br><br>';
echo print_r($row);

如您所见，我以人类可读的方式打印出结果，产生:

mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => Array ( [0] => 19 ) [num_rows] => 9 [type] => 0 ) 1

Array ( [0] => Arizona State Univ. [university] => Arizona State Univ. ) 1

该专栏中有一些示例大学，所以我不确定我做错了什么。

Answer 1

mysqli_fetch_array 每次调用时都通过指针工作

想象一下

$result = mysqli_query($connection, "select university from universities_alpha");
$row = mysqli_fetch_array($result); // this is the first row
$row = mysqli_fetch_array($result); // now it's the second row
$row = mysqli_fetch_array($result); // third row

要以您希望的方式实际显示数据，我建议您执行以下操作

$rows = array();
$result = mysqli_query($connection, "select university from universities_alpha");
while($row = mysqli_fetch_array($result)) {
    $rows[] = $row;
}

print_r($rows);