Bug #52302 [Asn->Bgs]: mysqli_fetch_all does not work with MYSQLI_USE_RESULT
Edit report at http://bugs.php.net/bug.php?id=52302&edit=1
ID: 52302
Updated by: andrey@php.net
Reported by: brianlmoon@php.net
Summary: mysqli_fetch_all does not work with MYSQLI_USE_RESULT
-Status: Assigned
+Status: Bogus
Type: Bug
Package: MySQLi related
Operating System: Linux
PHP Version: 5.3.2
Assigned To: mysql
New Comment:
Makes no sense to use USE_RESULT and buffer the result. Use
STORE_RESULT, it is more effective for fetch_all(). Artifically limited.
Previous Comments:
------------------------------------------------------------------------
[2010-07-12 18:16:35] brad at njoe dot com
Confirmed on Windows build as well using: PHP 5.3.2 (cli) (built: Mar 3
2010
19:40:13).
Even SELECT'ing a static string (e.g. SELECT 'This is a test.') exhibits
this
behavior.
------------------------------------------------------------------------
[2010-07-10 10:39:32] brianlmoon@php.net
Description:
------------
When using MYSQLI_USE_RESULT as the second parameter to mysqli_query,
fetch_all returns null.
Test script:
---------------
<?php
$m = new MySQLi("", "root", "", "information_schema");
$sql = "show tables";
$res = $m->query($sql, MYSQLI_USE_RESULT);
$rows = $res->fetch_all();
var_dump($rows);
?>
Expected result:
----------------
An array of the table data.
Actual result:
--------------
NULL
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/bug.php?id=52302&edit=1
Thread (9 messages)