#32928 [Asn->Bgs]: php dies trying to ->bind_result(...)
| From: | georg@php.net | Date: | Thu, 05 May 2005 13:41:36 +0000 |
| Subject: | #32928 [Asn->Bgs]: php dies trying to ->bind_result(...) | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-78656@lists.php.net to get a copy of this message | ||
ID: 32928
Updated by: georg@php.net
Reported By: dan at yes dot lt
-Status: Assigned
+Status: Bogus
Bug Type: MySQLi related
Operating System: winxp
PHP Version: 5.0.4
Assigned To: georg
New Comment:
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.php.net/manual/ and the instructions on how to
report
a bug at http://bugs.php.net/how-to-report.php
Prepared statements return unbuffered resultsets by default,
therefore you have to retrieve all data or close the resultset before
any command to the server.
The last statement doesn't work, cause MYSQL_TYPE_NULL is unsupported
(filed as bug #32956).
Previous Comments:
------------------------------------------------------------------------
[2005-05-04 09:58:00] georg@php.net
Looks like repreparing a statement without closing it
makes some problems -> assigned (tested against
5.0.5-beta)
The script itself works as expected - fetching a row
without executing statement before returns an error.
------------------------------------------------------------------------
[2005-05-03 16:19:30] dan at yes dot lt
Description:
------------
php dies trying to mysqli_stmt->bind_result(...) with listed queries:
SELECT 1.23 AS test
SELECT NULL AS test
php version 5.0.4, mysql version 5.0.4 beta
Reproduce code:
---------------
$st = $db->prepare("SELECT 1 AS test");
$st->bind_result($x);
$st->fetch();
var_dump($x);
$st = $db->prepare("SELECT 1.23 AS test");
$st->bind_result($x);
$st->fetch();
var_dump($x);
$st = $db->prepare("SELECT NULL AS test");
$st->bind_result($x);
$st->fetch();
echo $st;
var_dump($x);
Expected result:
----------------
int(1)
float(1.23)
NULL
Actual result:
--------------
int(1)
...FATAL ERROR WITH NO OUTPUT...
...FATAL ERROR WITH NO OUTPUT...
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=32928&edit=1