|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2005-05-07 08:51 UTC] andrey@php.net
Description:
------------
Prepare does not clean the wire before the next prepare. It should be discussed whether it should be done but this bug is created to have a track of this issue.
Reproduce code:
---------------
<?php
$st = $db->prepare("SELECT 1 AS test");
$st->execute();
$st->bind_result($x);
$st->fetch();
var_dump($x);
$st = $db->prepare("SELECT 1.23 AS test");
var_dump($st);
$st->execute();
$st->bind_result($x);
$st->fetch();
var_dump($x);
?>
Expected result:
----------------
int(1)
object(mysqli_stmt)#3 (0) {
}
string(4) "1.23"
Actual result:
--------------
int(1)
bool(false)
PHP Fatal error: Call to a member function execute() on a non-object in /home/andrey/tst/ttt.php on line 11
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Wed Nov 05 21:00:02 2025 UTC |
It makes no sense to do some magic and closing unbuffered statements when executing mysql_prepare. $stmt1 = $mysql->prepare("SELECT foo FROM bar"); $stmt1->execute(); $stmt2->prepare("SELECT foo FROM user"); So why should 2nd prepare automatically clean resultset from first statement instead of giving an error ?? It's well documented that you have to either store the resultset or to close the statement before executing any other command (execept you're using cursors with MySQL 5.0). The same is also true when executing unbuffered queries in ext/mysql and ext/mysqli.