(No versionen information available, might only be in Guit)
sqlsrv_has_rows — Indicates whether the specified statement has rows
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.
Example #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 />"
;
}
?>