使用MySQLI获取列并转换为数组[duplicate]

Question

This question already has an answer here:

• How to get MySQLi error information in different environments? / mysqli_fetch_assoc() expects parameter 1 to be mysqli_result 1 answer

So I've been trying various other threads, but none seem to use MySQLI, nor work. I'm attempting to query a MySQL table via MySQLI, the convert the returned column into an array to be used later. Here's what I have so far.

$sql = new mysqli("URL", "user", "pass","db") or die ("Not connected");
if (mysqli_connect_errno()) {
    printf("Connect failed: %s
", mysqli_connect_error());
    exit;
}
$sql_query = "SELECT Desired_column FROM Table_Name";
$result_array = $sql->query($sql_query);
while($row = $result_array->fetch_row()) {
    $rows[]=$row;
}
$result_array->close();
$sql->close();
return $rows;

And yes... I'm a complete novice at coding so PHP vets, enjoy seeing how far you've come!

The error I am getting is

Call to a member function fetch_row() on Boolean on line 60

</div>

Answer 1

Try something like this:

$query = "SELECT Desired_column FROM Table_Name";
$results = mysqli_query($sql, $query);

$rows = [];

while($row = mysqli_fetch_assoc($results)) {
    $rows[] = $row;
}

Edit 1

• Changed array_push($rows, $row); to $rows[] = $row; to reduce function calls