Search Results
The following example shows how to call a stored procedure, MULTIPLE_ROWSETS, which returns three rowsets. We use a do-while loop to call the PDOStatement::nextRowset () method until it returns false and terminates the loop when no more rowsets are available.
Apr 19, 2025 · PHP PDO tutorial shows how to work with databases using PDO in PHP. Learn PDO with practical examples.
Retrieving Multiple Rowsets Returned by a Stored Procedure The following example shows how to call a stored procedure, MULTIPLE_ROWSETS, that returns three rowsets. A do/while loop is used to repeatedly call the PDOStatement::nextRowset () method until it returns false, indicating no more rowsets.
PDOStatement::nextRowset () enables you to access the second and subsequent rowsets associated with a PDOStatement object. Each rowset can have a different set of columns from the preceding rowset.
Some database servers support stored procedures that return more than one rowset (also known as a result set). PDOStatement::nextRowset () enables you to access the second and subsequent rowsets associated with a PDOStatement object. Each rowset can have a different set of columns from the preceding rowset.
The following example shows how to call a stored procedure, MULTIPLE_ROWSETS, which returns three rowsets. We use a do-while loop to call the PDOStatement::nextRowset method until it returns false and terminates the loop when no more rowsets are available.
Some database servers support stored procedures that return more than one rowset (also known as a result set). PDOStatement::nextRowSet () enables you to access the second and subsequent rowsets associated with a PDOStatement object. Each rowset can have a different set of columns from the preceding rowset.
