PDOStatement::nextRowset

DownloadDownload PHP Driver

Moves the cursor to the next result set.

Syntax


bool PDOStatement::nextRowset();  

Return Value

true on success, false otherwise.

Remarks

Support for PDO was added in version 2.0 of the Microsoft Drivers for PHP for SQL Server.

Example

<?php  
   $server = "(local)";  
   $database = "AdventureWorks";  
   $conn = new PDO( "sqlsrv:server=$server ; Database = $database", "", "");  

   $query1 = "select * from Person.Address where City = 'Bothell';";  
   $query2 = "select * from Person.ContactType;";  

   $stmt = $conn->query( $query1 . $query2 );  

   $rowset1 = $stmt->fetchAll();  
   $stmt->nextRowset();  
   $rowset2 = $stmt->fetchAll();  
   var_dump( $rowset1 );  
   var_dump( $rowset2 );  
?>  

See Also

PDOStatement Class
PDO