get array of rows with mysqli result

by

You had a slight syntax problem, namely an errant semi-colon.

while($row = $result->fetch_row());

Notice the semi-colon at the end? It means the block following wasn’t executed in a loop. Get rid of that and it should work.

Also, you may want to ask mysqli to report all problems it encountered:

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$sql = new mysqli($config['host'], $config['user'], $config['pass'], $config['db_name']);

$query = "SELECT domain FROM services";
$result = $sql->query($query);
$rows = [];
while($row = $result->fetch_row()) {
    $rows[] = $row;
}
return $rows;

More Related Contents:

  1. About how does mysqli_query() Function and mysqli_fetch_array($result) work?
  2. Can I mix MySQL APIs in PHP?
  3. How to change mysql to mysqli?
  4. Best way to INSERT many values in mysqli?
  5. Call to a member function bind_param() on a non-object [duplicate]
  6. MySQLi prepared statements error reporting [duplicate]
  7. How can I get an unknown username given an ID?
  8. mysqli last insert id
  9. mysqli: can it prepare multiple queries in one statement?
  10. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  11. MySQLi query returns only one row
  12. How to call a MySQL stored procedure from within PHP code?
  13. How do I migrate my site from mysql to mysqli? [duplicate]
  14. Converting MySQL result array to JSON [duplicate]
  15. Fatal error: Cannot use object of type mysqli_result [closed]
  16. Do I have to guard against SQL injection if I used a dropdown?
  17. Inserting data to table (mysqli insert) [duplicate]
  18. Using MySQLi from another class in PHP
  19. How to echo a MySQLi prepared statement?
  20. How do I display a MySQL error in PHP for a long query that depends on the user input? [duplicate]
  21. Returning Multiple Rows with MySqli and Arrays
  22. MySQLi prepared statements with IN operator [duplicate]
  23. MySQLI binding params using call_user_func_array
  24. mysqli_select_db() expects parameter 1 to be mysqli, string given
  25. What does the mysqli_error() expects parameter 1 to be mysqli, null given mean?
  26. Mysqli prepared statement column with variable [duplicate]
  27. Unknown database error in PHP but it exists in PHPMyAdmin
  28. Can I blindly replace all mysql_ functions with mysqli_?
  29. Is mysqli_real_escape_string safe?
  30. Strange problem with the length of the field gotten from database [duplicate]

Leave a Comment