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 php 选项/信息函数 returns the current process title php ibm db2 函数 returns a result set listing the unique row identifier columns for a table php eio 函数 returns number of not yet handled requests php fam 函数 get next pending fam event 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 函数 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 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 svn 函数 returns a stream to access the contents of a file from a given version of the fs php com 函数 divides two variants and returns only the remainder php yp/nis 函数 returns the next key value pair in the named map

关注编程学问公众号