php.net |  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 (profile)
Status: Closed Package: MySQLi related
PHP Version: 5.3.2 OS: Win 7
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: uramihsayibok at gmail dot com
New email:
PHP Version: OS:

 

 [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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2010-06-18 19:25 UTC] andrey@php.net
Automatic comment from SVN on behalf of andrey
Revision: http://svn.php.net/viewvc/?view=revision&revision=300581
Log: Fix for bug #52115  	mysqli_result::fetch_all returns null, not an empty array
 [2010-06-18 19:26 UTC] andrey@php.net
-Status: Open +Status: Closed -Assigned To: +Assigned To: mysql
 [2010-06-18 19:26 UTC] andrey@php.net
Fix will appear in 5.3.3
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Nov 21 13:01:29 2024 UTC