PHP Manual
Mssql 函数
Returns the next batch of records

mssql_fetch_batch

(PHP 4 >= 4.0.4, PHP 5, PECL odbtp >= 1.1.1)

mssql_fetch_batch — Returns the next batch of records

Warning

This function was REMOVED in PHP 7.0.0.

说明

mssql_fetch_batch ( resource $result ) : int

Returns the next batch of records.

参数

result: The result resource that is being evaluated. This result comes from a call to mssql_query().

返回值

Returns the number of rows in the returned batch.

范例

Example #1 mssql_fetch_batch() example

 <?php
// Connect to MSSQL and select the database
$link = mssql_connect('MANGO\SQLEXPRESS', 'sa', 'phpfi');
mssql_select_db('php', $link);

// Send a query
$result = mssql_query('SELECT * FROM [php].[dbo].[people]', $link, 100);
$records = 10;

while ($records >= 0) {
    while ($row = mssql_fetch_assoc($result)) {
        // Do stuff ...
    }

    --$records;
}

if ($batchsize = mssql_fetch_batch($result)) {
    // $batchsize is the number of records left 
    // in the result, but not shown above
}
?>

相关文章

php gmp 函数 find next prime number php informix 函数 returns the current file or seek position php mailparse 函数 returns a handle on a given section in a mimemessage php maxdb 函数 returns the next field in the result set php 多字节字符串函数 returns start point for next regular expression match php mssql 函数 returns an associative array of the current row in the result php mssql 函数 returns the next batch of records php mssql 函数 free result memory php mssql 函数 returns the last message from the server php mssql 函数 move the internal result pointer to the next result php mssql 函数 returns the number of records affected by the query php mysqlnd qc 函数 returns a backtrace for each query inspected by the query cache php oci8 函数 returns the next row from a query as an associative or numeric array php oci8 函数 returns the next row from a query as an associative array php oci8 函数 returns the next row from a query as an object php oci8 函数 returns the next row from a query as a numeric array php oci8 函数 returns the next child statement resource from a parent statement resource that has oracle database 12c implicit result sets php paradox 函数 returns number of records in a database php yp/nis 函数 returns the next key value pair in the named map php sdo das xml 函数 returns sdo das xml document for a given xml instance string

关注编程学问公众号