Fatal error: Call to a member function fetch_array() on a non-object in MySQL?

Question

PHP

$query = "SELECT * from  table";
$result = $mysqli->query($query);
while ($row = $result->fetch_array(MYSQLI_ASSOC)){
…
}

I repeat the same code (but with a different select) in a file that is called via ajax (I connect to the database in a new way) and I get the error Fatal error: Call to a member function fetch_array() on a non-object in . What can be wrong?

Answer 1

For the future, the next line should always be in the file with the database connection

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

And then this error will never appear at all