sqlsrv_num_rows

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

sqlsrv_num_rows — Retrieves the number of rows in a result set

说明

sqlsrv_num_rows ( resource $stmt ) : mixed

Retrieves the number of rows in a result set. This function requires that the statement resource be created with a static or keyset cursor. For more information, see sqlsrv_query(), sqlsrv_prepare(), or » Specifying a Cursor Type and Selecting Rows in the Microsoft SQLSRV documentation.

参数

stmt

The statement for which the row count is returned. The statement resource must be created with a static or keyset cursor. For more information, see sqlsrv_query(), sqlsrv_prepare(), or » Specifying a Cursor Type and Selecting Rows in the Microsoft SQLSRV documentation.

返回值

Returns the number of rows retrieved on success and FALSE if an error occurred. If a forward cursor (the default) or dynamic cursor is used, FALSE is returned.

范例

Example #1 sqlsrv_num_rows() example

<?php
$server = "serverName\sqlexpress";
$connectionInfo = array( "Database"=>"dbName", "UID"=>"username", "PWD"=>"password" );
$conn = sqlsrv_connect( $server, $connectionInfo );

$sql = "SELECT * FROM Table_1";
$params = array();
$options =  array( "Scrollable" => SQLSRV_CURSOR_KEYSET );
$stmt = sqlsrv_query( $conn, $sql , $params, $options );

$row_count = sqlsrv_num_rows( $stmt );
   
if ($row_count === false)
   echo "Error in retrieveing row count.";
else
   echo $row_count;
?>

参见

相关文章
php cubrid 函数 get the number of rows in the result setphp ibm db2 函数 returns the number of fields contained in a result setphp dbx 函数 fetches rows from a query result that had the dbx result unbuffered flag setphp firebird/interbase 函数 get the number of fields in a result setphp maxdb 函数 gets the number of rows in a resultphp maxdb 函数 return the number of rows in statements result setphp msql 函数 get number of rows in resultphp mssql 函数 gets the number of rows in resultphp odbc 函数 number of rows in a resultphp sqlite 函数 fetches all rows from a result set as an array of arraysphp sqlite 函数 returns the number of fields in a result setphp sqlite 函数 returns the number of rows in a buffered result setphp sqlite 函数 seek to the previous row number of a result setphp sqlite 函数 seek to a particular row number of a buffered result setphp sqlsrv 函数 retrieves the next row of data in a result set as an objectphp sqlsrv 函数 makes the next row in a result set available for readingphp sqlsrv 函数 retrieves the number of fields columns on a statementphp sqlsrv 函数 retrieves the number of rows in a result setphp sqlsrv 函数 returns the number of rows modified by the last insert update or delete query executedphp sybase 函数 get number of rows in a result set
关注编程学问公众号