sqlsrv_has_rows
Indicates if the result set has one or more rows.
Syntax
sqlsrv_has_rows( resource $stmt )
Parameters
$stmt: The executed statement.
Return Value
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.
Example
<?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";
}
?>
See Also
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for