PDOStatement::nextRowset — Advance to the next rowset in a multi-rowset statement handle (PHP 5 >= 5.1.0, PECL pdo >= 0.2.0)
bool PDOStatement::nextRowset ( void )
Some database services support stored procedures that return more than one rowset (also called a result set).
PDOStatement::nextRowset() enables you to access the second and subsequent rowsets in conjunction with a PDOStatement object. Each row set above can have a different set of columns.
Returns TRUE on success, or FALSE on failure.
The following example shows how to call a stored procedure that returns MULTIPLE_ROWSETS for three rowsets. Use a do / while loop to loop through the PDOStatement::nextRowset() method, returning false and ending the loop when no more rowsets are returned.
<?php$sql = 'CALL multiple_rowsets()';$stmt = $conn->query($sql);$i = 1;do { $rowset = $stmt->fetchAll(PDO::FETCH_NUM); if ( $rowset) { printResultSet($rowset, $i); } $i++;} while ($stmt->nextRowset());function printResultSet(&$rowset, $i) { print "Result set $i:n"; foreach ($rowset as $row) { foreach ($row as $col) { print $col . "t"; } print "n"; } print "n";}?>The above example output:
Result set 1:apple redbanana yellowResult set 2:orange orange 150banana yellow 175Result set 3:lime greenapple redbanana yellow