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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: pointeau_sylvain at yahoo dot fr
New email:
PHP Version: OS:

 

 [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-2024 The PHP Group
All rights reserved. 		Last updated: Fri Dec 27 03:01:28 2024 UTC