Fatal error: Call to undefined method mysqli_result::fetch_all()

Question

I have problems with PHP in Ubuntu 10.04. When I try use mysqli_result::fetch_all this error appears:

Call to undefined method mysqli_result::fetch_all()

However, it works in Windows XP.

The Code:

$result = $this->dbh->query('SELECT [...] ');
return $result->fetch_all(MYSQLI_ASSOC);

I don't want to use fetch_assoc with a loop because I send the result to another layer for processing.

I'm using PHP 5.4.4. and with php -m | grep mysql the mysqlnd module it doesn't appear. How can I install it? Could that be the problem?

Answer 1

mysqli_result::fetch_all() requires MySQL Native Driver (mysqlnd).

chances are you might be missing it.

have a look at this posts, that might help you.

mysqli fetch_all() not a valid function?