sqlsrv_has_rows
(No hay información de versión disponible, podría estar únicamente en SVN)
sqlsrv_has_rows — Indicates whether the specified statement has rows
Descripción
bool sqlsrv_has_rows
( resource
$stmt
)Indicates whether the specified statement has rows.
Valores devueltos
Returns TRUE if the specified statement has rows and FALSE if the statement
does not have rows or if an error occurred.
Ejemplos
Ejemplo #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 />";
}
?>
Ver también
- sqlsrv_num_rows() - Retrieves the number of rows in a result set
- sqlsrv_query() - Prepares and executes a query.