sqlsrv_get_fieldsqlsrv_has_rows
(Não há informação de versão disponível, talvez apenas no SVN)
sqlsrv_has_rows — Indicates whether the specified statement has rows
Descrição
bool sqlsrv_has_rows
( resource
$stmt
)Indicates whether the specified statement has rows.
Valor Retornado
Returns TRUE if the specified statement has rows and FALSE if the statement
does not have rows or if an error occurred.
Exemplos
Exemplo #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 />";
}
?>
Veja Também
- sqlsrv_num_rows() - Retrieves the number of rows in a result set
- sqlsrv_query() - Prepares and executes a query.
add a note
User Contributed Notes
sqlsrv_has_rows - [0 notes]
There are no user contributed notes for this page.