Level 29
https://stackoverflow.com/questions/26415596/mysqli-fetch-array-returning-only-one-result
mysqli_fetch_array is only return one row of data from your selected table
Apr 28, 2021
7
Level 6
How to return Multiple values from a while loop from an SQL query.
I have an issue where I have a function like this which outputs:
while ($row = mysqli_fetch_array($sql_result)) {
$division_name = stripcslashes($row['name']);
return $division_name;
}
This works to fetch a single value, but it doesn't when I need multiple values from the query. (in that case it only returns the first match row).
If I substitute return for echo, I get unexpected behaviour from my view.
How can I structure my code so that when I call this function, it outputs multiple values properly.
Thanks
Level 5
you can initialize an empty array and insert each row into the array in the while loop:
$array = [];
while ($row = mysqli_fetch_array($sql_result)) {
$division_name = stripcslashes($row['name']);
$array[] = $division_name;
}
return $array;
your array will contain a list of all values you got from the query;
Level 6
Using an empty array works. But it only works with (print_r) which output the array indexes as well. I need the values to look good in the view. Using (return) prints the word "array" not the values.
Are there any other solutions/fixes?
Thanks for the replies.
Level 29
Are you using Laravel?
Level 6
No procedural. The empty array works. I have "echo X" in the view and I call my function which uses (print_r), so I'm printing twice, which is making the view act unexpectedly, (return) doesn't have that problem, but doesn't work here so far.
Level 29
No, I am asking which framework are you using now.
If you are using Laravel, why not switch to using
https://laravel.com/docs/8.x/queries#running-database-queries
Or
Level 29
You might need to post your view(blade file), controller etc that are related.
Please or to participate in this conversation.