php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #34727 nextRowset doesn't work with mysql 5 and stored procedure
Submitted: 2005-10-04 13:27 UTC Modified: 2005-10-21 10:16 UTC
Votes:5
Avg. Score:4.8 ± 0.4
Reproduced:3 of 3 (100.0%)
Same Version:1 (33.3%)
Same OS:3 (100.0%)
From: pointeau_sylvain at yahoo dot fr Assigned: wez (profile)
Status: Wont fix Package: PDO related
PHP Version: 5CVS-2005-10-05 (snap) OS: windows XP
Private report: No CVE-ID: None
View Developer Edit
 [2005-10-04 13:27 UTC] 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.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-10-04 14:59 UTC] sniper@php.net 
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
 [2005-10-05 10:43 UTC] pointeau_sylvain at yahoo dot fr 
I tried with php 5.05, 5.1RC1, latest snapshot of 5 and 5.1.
I also take care to use the right PECL libraries.

It still doesn't work.

Please note that mysqli returns correctly the two result set.
 [2005-10-05 11:02 UTC] sniper@php.net 
Assigned to the maintainer.
 [2005-10-19 17:17 UTC] iliaa@php.net 
You need to compile pdo_mysql yourself against 5.0 libs that have this functionality. The stock mysql libs used for win32 builds do not support this feature, which is why you cannot use it.
 [2005-10-21 10:16 UTC] pointeau_sylvain at yahoo dot fr 
Please could you describe a bit how to compile the sources under windows ? I didn't find any makefile in PDO_MYSQL-1.0RC1.tgz. The compiler is MSVC or could be mingw ? Is it possible to have to link against 5.0 libs in the next release / snapshot / delivery ?

Thanks,
Sylvain
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Sat May 10 17:01:27 2025 UTC