|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #52115 mysqli_result::fetch_all returns null, not an empty array
Submitted: 2010-06-17 23:25 UTC Modified: 2010-06-18 19:26 UTC
From: uramihsayibok at gmail dot com Assigned: mysql
Status: Closed Package: MySQLi related
PHP Version: 5.3.2 OS: Win 7
Private report: No CVE-ID:
 [2010-06-17 23:25 UTC] uramihsayibok at gmail dot com
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");

Expected result:
array(0) {

Actual result:


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2010-06-18 19:25 UTC]
Automatic comment from SVN on behalf of andrey
Log: Fix for bug #52115  	mysqli_result::fetch_all returns null, not an empty array
 [2010-06-18 19:26 UTC]
-Status: Open +Status: Closed -Assigned To: +Assigned To: mysql
 [2010-06-18 19:26 UTC]
Fix will appear in 5.3.3
PHP Copyright © 2001-2015 The PHP Group
All rights reserved.
Last updated: Tue Oct 06 20:01:32 2015 UTC