Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

sqlsrv_has_rows

Indicates if the result set has one or more rows.


sqlsrv_has_rows( resource $stmt )

$stmt: The executed statement.

If there are rows in the result set, the return value will be true. If there are no rows, or if the function call fails, the return value will be false.

<?php
   $server = "server_name";
   $conn = sqlsrv_connect( $server, array( 'Database' => 'Northwind' ) );

   $stmt = sqlsrv_query( $conn, "select * from orders where CustomerID = 'VINET'" , array());

   if ($stmt !== NULL) {
      $rows = sqlsrv_has_rows( $stmt );
   
      if ($rows === true)
         echo "\nthere are rows\n";
      else 
         echo "\nno rows\n";
   }
?>

Community Additions

Show:
© 2015 Microsoft