PHP Manual
SQLSRV 函数
Indicates whether the specified statement has rows

sqlsrv_has_rows

(No version information available, might only be in Git)

sqlsrv_has_rows — Indicates whether the specified statement has rows

说明

sqlsrv_has_rows ( resource $stmt ) : bool

Indicates whether the specified statement has rows.

参数

stmt: A statement resource returned by sqlsrv_query() or sqlsrv_execute().

返回值

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 />";
}
?>

参见

sqlsrv_num_rows() - Retrieves the number of rows in a result set
sqlsrv_query() - Prepares and executes a query

php ibm db2 函数 returns the number of rows affected by an sql statement php frontbase 函数 get the number of rows affected by the last statement php intl 函数 check whether the given error code indicates failure php maxdb 函数 returns the total number of rows changed deleted or inserted by the last executed statement php mysqlnd qc 函数 installs a callback which decides whether a statement is cached php 杂项函数 indicates whether the codepage is utf 8 compatible php sqlite 函数 returns the number of rows that were changed by the most recent sql statement php sqlite 函数 finds whether or not more rows are available php sqlite 函数 returns whether more rows are available php sqlsrv 函数 cancels a statement php sqlsrv 函数 returns information about the client and specified connection php sqlsrv 函数 executes a statement prepared with sqlsrv prepare php sqlsrv 函数 retrieves metadata for the fields of a statement prepared by sqlsrv prepare or sqlsrv query php sqlsrv 函数 frees all resources for the specified statement php sqlsrv 函数 returns the value of the specified configuration setting php sqlsrv 函数 indicates whether the specified statement has rows php sqlsrv 函数 makes the next result of the specified statement active php sqlsrv 函数 retrieves the number of fields columns on a statement php sqlsrv 函数 retrieves the number of rows in a result set php sqlsrv 函数 returns the number of rows modified by the last insert update or delete query executed