[2010-06-17 23:25 UTC] uramihsayibok at gmail dot com

Description:
------------
The documentation says that mysqli_result::fetch_all
- "fetches all result rows and returns the result set as an associative array, a numeric array, or both"
- "Returns an array of associative or numeric arrays holding result rows"
(though the return type is "mixed").

As far as I can tell, fetch_all returns NULL when there are no rows (ie, ->num_rows==0).


Filed as a bug and not a documentation problem because it'd be nice to always get an array back.

Test script:
---------------
// Requires that mysqlnd be loaded, of course

// $mysqli = new mysqli(...)
$result = $mysqli->query("SELECT 1 LIMIT 0");
var_dump($result->fetch_all());

Expected result:
----------------
array(0) {
}

Actual result:
--------------
NULL

 [2010-06-18 19:26 UTC] andrey@php.net