sqlsrv_has_rows
(バージョン情報なし。おそらく SVN 版にしか存在しないでしょう)
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 occured.
例
例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.