ID: 32882
User updated by: sales at girderboot dot com
Reported By: sales at girderboot dot com
Status: Open
Bug Type: MySQLi related
Operating System: Windows Server 2003
PHP Version: 5.0.4
New Comment:
Upgraded to latest CVS [5.1.0-dev, Apr 26 2005 04:15:08 ]
Still same Problem.
Previous Comments:
------------------------------------------------------------------------
[2005-04-29 02:45:50] sales at girderboot dot com
Description:
------------
After executing a query using a stored procedure that returns a result
set, no futher queries can be executed.
SProc's that don't return a result set, or embedded SQL queries are not
affected (but even they still cannot run after a SP with a result set is
run.)
MySQL and PHP both version 5.0.4
Reproduce code:
---------------
$db = new mysqli('localhost','xxx','xxx','campnet');
if (!$exec = $db->query("CALL Acct_Bal(1)"))
echo $db->error;
$balance = $exec->fetch_row();
$exec->close();
echo $balance[0];
echo "<BR>";
// Second Time
if (!$exec = $db->query("CALL Acct_Bal(1)"))
echo $db->error;
$balance = $exec->fetch_row();
$exec->close();
echo $balance[0];
Expected result:
----------------
Should Output the same result Twice (In this case, the accout
balance):
0.00
0.00
Actual result:
--------------
0.00
Lost connection to MySQL server during query
Fatal error: Call to a member function fetch_row() on a non-object in
C:\Program Files\Apache Group\Apache2\htdocs\driver.php on line 40
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=32882&edit=1
