sqlsrv_has_rows
(No version information available, might only be in Git)
sqlsrv_has_rows — Indicates whether the specified statement has rows
Beschreibung
$stmt
): boolIndicates whether the specified statement has rows.
Rückgabewerte
Returns true
if the specified statement has rows and false
if the statement
does not have rows or if an error occurred.
Beispiele
Beispiel #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 />";
}
?>
Siehe auch
- sqlsrv_num_rows() - Retrieves the number of rows in a result set
- sqlsrv_query() - Prepares and executes a query