函数仅返回带有 mysqli 查询结果的第一个数组值 [英] function returns only first array value with mysqli query result

问题描述

我的 mysqli 相关函数有一个小问题.代码如下:

I have a small problem with my mysqli related function. Here is the code:

$query = "SELECT * FROM uploads";
 if ($result = $mysqli->query($query)) {
   while ($row = $result->fetch_assoc()) {
     return $row;
  }

问题是，当我使用这个函数时，$row 似乎是一个数组，但其中只有查询结果的第一个值.但是，如果我尝试 return var_dump($row) ，函数会按预期显示数组，其中包含查询结果中的所有值.您能否解释一下为什么会发生这种情况以及如何正确返回具有完整查询结果的数组.谢谢！

The problem is that when I use this function $row appears to be an array, but with only the first value from the query result in it. But if I try to return var_dump($row) instead, function displays array as expected, with all the values from the query result. Can you please explain why is this happening and how to return an array with complete query result correctly. Thanks!

推荐答案

$data  = array();
$query = "SELECT * FROM uploads";
if ($result = $mysqli->query($query)) {
  while ($row = $result->fetch_assoc()) {
     $data[] = $row;
  }
}
return $data;

这篇关于函数仅返回带有 mysqli 查询结果的第一个数组值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！