函数仅返回带有 mysqli 查询结果的第一个数组值

2022-01-19 00:00:00 function return arrays php mysqli

我的 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;

相关文章