Returning Multiple Rows with MySqli and Arrays

by

You have to use a loop to get them all at once:

<?php
function resultToArray($result) {
    $rows = array();
    while($row = $result->fetch_assoc()) {
        $rows[] = $row;
    }
    return $rows;
}

// Usage
$query = 'SELECT DISTINCT $fields FROM `posts` WHERE `profile_user_id` = $user_id LIMIT 4';
$result = $mysqli->query($query);
$rows = resultToArray($result);
var_dump($rows); // Array of rows
$result->free();

More Related Contents:

  1. PHP create new array by value
  2. How to bind mysqli bind_param arguments dynamically in PHP?
  3. mysqli bind_param() expected to be a reference, value given
  4. How to fix Trying to access array offset on value of type null error
  5. Fatal error: Cannot use object of type mysqli_result [closed]
  6. MySQLi Bind Param with an array for IN [duplicate]
  7. How to make array inside in foreach loop – php? [closed]
  8. How do search array values and remove them based on a condition or string? [closed]
  9. mysqli or die, does it have to die?
  10. How to Flatten a Multidimensional Array?
  11. MySQL vs MySQLi when using PHP [closed]
  12. Sort array of objects by object fields
  13. Get the first element of an array
  14. + operator for array in PHP?
  15. How to create an array from a CSV file using PHP and the fgetcsv function
  16. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  17. array_splice() for associative arrays
  18. Advantages Of MySQLi over MySQL [closed]
  19. Casting an Array with Numeric Keys as an Object
  20. Make multiple files to force-download
  21. Array_map function in php with parameter
  22. More concise way to check to see if an array contains only numbers (integers)
  23. How to merge two arrays by summing the merged values [duplicate]
  24. Is PHP’s count() function O(1) or O(n) for arrays?
  25. How to search in an array with preg_match?
  26. mysqli + xdebug breakpoint after closing statement result in many warnings
  27. Convert a String to Variable
  28. How do I select 10 random things from a list in PHP?
  29. Convert PostgreSQL array to PHP array
  30. PHP: Most frequent value in array

Leave a Comment