get array of rows with mysqli result

mysqli, php

Solution

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;

Problem

I need to get all the rows from result object. I’m trying to build a new array that will hold all rows. Here is my code: ``` $sql = new mysqli($config['host'],$config['user'],$config['pass'],$config['db_name']); if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } $query = "SELECT domain FROM services"; $result = $sql->query($query); while($row = $result->fetch_row()); { $rows[]=$row; } $result->close(); $sql->close(); return $rows; ``` `$rows` is supposed to be the new array that contains all, rows but instead I get an empty array. Any ideas why this is happening?

Original source