mssql_next_result Move the internal result pointer to the next result php函数


mssql_next_result

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

mssql_next_resultMove the internal result pointer to the next result

说明

bool mssql_next_result ( resource $result_id )

When sending more than one SQL statement to the server or executing a stored procedure with multiple results, it will cause the server to return multiple result sets. This function will test for additional results available form the server. If an additional result set exists it will free the existing result set and prepare to fetch the rows from the new result set.

参数

result_id

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

返回值

Returns TRUE if an additional result set was available or FALSE otherwise.

范例

Example #1 mssql_next_result() example

<?php
// Connect to MSSQL and select the database
$link mssql_connect('MANGOSQLEXPRESS''sa''phpfi');
mssql_select_db('php'$link);

// Send a query to MSSQL
$sql 'SELECT [name], [age] FROM [php].[dbo].[persons]';
$query mssql_query($sql$link);

// Iterate through returned records
do {
    while (
$row mssql_fetch_row($query)) {
        
// Handle record ...
    
}
} while (
mssql_next_result($query));

// Clean up
mssql_free_result($query);
mssql_close($link);
?>



相关阅读:
mssql_num_fields Gets the number of fields in result
mssql_num_rows Gets the number of rows in result
mssql_pconnect Open persistent MS SQL connection
mssql_query Send MS SQL query
mssql_result Get result data
mssql_rows_affected Returns the number of records affected by the query
mssql_select_db Select MS SQL database
mt_getrandmax 显示随机数的最大可能值
mt_rand 生成更好的随机数
mt_srand 播下一个更好的随机数发生器种子
mysqli_bind_param mysqli_stmt_bind_param的别名
mysqli_bind_result mysqli_stmt_bind_result的别名
mysqli_client_encoding mysqli_character_set_name的别名
mysqli_connect 别名 mysqli::__construct
快速导航

Copyright © 2016 phpStudy |