PDOStatement::nextRowset

Microsoft Drivers for PHP for SQL Server

previous page next page
Collapse image Expand Image Copy image CopyHover image

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

  Copy imageCopy Code 
<?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

Reference

PDOStatement Class

Other Resources

PDO
previous page start next page