From: michael at kofler dot cc
Operating system: linux (suse 9.1)
PHP version: 5CVS-2004-11-01 (dev)
PHP Bug Type: MySQLi related
Bug description: getting rowset from a stored procedure, with/without
mysqli_realconnect
Description:
------------
I am using MySQL 5.0.1 (snapshot) and PHP 5.0.2 with mysqli interface
(latest snapshot) under Linux (SUSE 9.1).
I use $mysqli->multi_query to call a SP. I want to get back the SELECT
results of the SP.
With a normal connect ($mysqli = new mysqli($mysqlhost, $mysqluser,
$mysqlpasswd, $mysqldb)), I don't get results.
However, if I instead use $mysqli = mysqli_init + $mysqli->real_connect()
with the very same parameters, everything works fine (many thanks to Gleb
Paharenko for this tip).
Reproduce code:
---------------
This is my SP:
CREATE PROCEDURE `test`()
BEGIN
SELECT * FROM t1;
END
And this it the PHP code
$ok = $mysqli->multi_query("CALL test()");
if($ok) {
echo "<p>OK</p>\n";
do {
echo "<p>result</p>\n";
$result = $mysqli->store_result();
if($result) {
show_table($result); // shows result details
$result->close();
}
} while($mysqli->next_result());
}
Expected result:
----------------
With $mysqli->real_connect, the code above works fine.
Actual result:
--------------
With a normal connect ($mysqli = new mysqli(...)), $ok is always false.
--
Edit bug report at http://bugs.php.net/?id=30645&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=30645&r=trysnapshot4
Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=30645&r=trysnapshot50
Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=30645&r=trysnapshot51
Fixed in CVS: http://bugs.php.net/fix.php?id=30645&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=30645&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=30645&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=30645&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=30645&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=30645&r=support
Expected behavior: http://bugs.php.net/fix.php?id=30645&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=30645&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=30645&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=30645&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=30645&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=30645&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=30645&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=30645&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=30645&r=float
MySQL Configuration Error: http://bugs.php.net/fix.php?id=30645&r=mysqlcfg
