This function cannot be relied on to report errors since both a existence negative and a SQL error will report the same boolean value.
sqlsrv_has_rows
(No version information available, might only be in Git)
sqlsrv_has_rows — Indicates whether the specified statement has rows
Опис
bool sqlsrv_has_rows
( resource
$stmt
)Indicates whether the specified statement has rows.
Значення, що повертаються
Returns TRUE if the specified statement has rows and FALSE if the statement
does not have rows or if an error occurred.
Приклади
Приклад #1 sqlsrv_has_rows() example
<?php
$server = "serverName\sqlexpress";
$connectionInfo = array( "Database"=>"dbName", "UID"=>"username", "PWD"=>"password" )
$conn = sqlsrv_connect( $server, $connectionInfo );
$stmt = sqlsrv_query( $conn, "SELECT * FROM Table_1");
if ($stmt) {
$rows = sqlsrv_has_rows( $stmt );
if ($rows === true)
echo "There are rows. <br />";
else
echo "There are no rows. <br />";
}
?>
Прогляньте Також
- sqlsrv_num_rows() - Retrieves the number of rows in a result set
- sqlsrv_query() - Prepares and executes a query.
add a note
