#34727 [Opn->Fbk]: nextRowset doesn't work with mysql 5 and stored procedure
| From: | sniper@php.net | Date: | Tue, 04 Oct 2005 12:59:43 +0000 |
| Subject: | #34727 [Opn->Fbk]: nextRowset doesn't work with mysql 5 and stored procedure | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-85995@lists.php.net to get a copy of this message | ||
ID: 34727
Updated by: sniper@php.net
Reported By: pointeau_sylvain at yahoo dot fr
-Status: Open
+Status: Feedback
Bug Type: PDO related
Operating System: windows XP
PHP Version: 5.1.0RC1
New Comment:
Please try using this CVS snapshot:
http://snaps.php.net/php5-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php5-win32-latest.zip
Previous Comments:
------------------------------------------------------------------------
[2005-10-04 13:27:31] pointeau_sylvain at yahoo dot fr
Description:
------------
The second result set returned by the stored procedure is not
displayed.
Reproduce code:
---------------
-- MYSQL 5
CREATE PROCEDURE
SPG_PERSONS()
BEGIN
SELECT * FROM TEST_PERSON;
SELECT 'second result';
END
-- PHP / PDO
$pdo = new PDO('mysql:host=localhost;dbname=test', '***', '***');
$stmt = $pdo->query('CALL SPG_PERSONS()');
do {
$rowset = $stmt->fetchAll();
foreach ($rowset as $row) {
echo $row[0];
echo '<br>';
}
}
while( $stmt->nextRowset() );
Expected result:
----------------
the results of both result set.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=34727&edit=1