MysqlndUhConnection::nextResult

(PECL mysqlnd-uh >= 1.0.0-alpha)

MysqlndUhConnection::nextResult — Prepare next result from multi_query

说明

public MysqlndUhConnection::nextResult ( mysqlnd_connection $connection ) : bool

Prepare next result from multi_query.

参数

connection

Mysqlnd connection handle. Do not modify!

返回值

Returns TRUE on success. Otherwise, returns FALSE

范例

Example #1 MysqlndUhConnection::nextResult() example

<?php
class proxy extends MysqlndUhConnection {
 public function nextResult($res) {
  printf("%s(%s)\n", __METHOD__, var_export(func_get_args(), true));
  $ret = parent::nextResult($res);
  printf("%s returns %s\n", __METHOD__, var_export($ret, true));
  return $ret;
 }
}
mysqlnd_uh_set_connection_proxy(new proxy());

$mysqli = new mysqli("localhost", "root", "", "test");
$mysqli->multi_query("SELECT 1 AS _one; SELECT 2 AS _two");
do {
  $res = $mysqli->store_result();
  var_dump($res->fetch_assoc());
  printf("%s\n", str_repeat("-", 40));
} while ($mysqli->more_results() && $mysqli->next_result());
?>

以上例程会输出：

array(1) {
  ["_one"]=>
  string(1) "1"
}
----------------------------------------
proxy::nextResult(array (
  0 => NULL,
))
proxy::nextResult returns true
array(1) {
  ["_two"]=>
  string(1) "2"
}
----------------------------------------

参见

相关文章
php cubrid 函数 get result of next query when executing multiple sql statementsphp ibm db2 函数 requests the next result set from a stored procedurephp dbx 函数 fetches rows from a query result that had the dbx result unbuffered flag setphp dbx 函数 sort a result from a dbx query by a custom sort functionphp firebird/interbase 函数 fetch a result row from a query as an associative arrayphp maxdb 函数 check if there any more query results from a multi queryphp maxdb 函数 prepare next result from multi queryphp maxdb 函数 transfers a result set from the last queryphp oci8 函数 returns the next row from a query as an associative or numeric arrayphp oci8 函数 returns the next row from a query as an associative arrayphp oci8 函数 returns the next row from a query as a numeric arrayphp oci8 函数 returns the next child statement resource from a parent statement resource that has oracle database 12c implicit result setsphp sqlite 函数 fetches the next row from a result set as an arrayphp sqlite 函数 fetches the next row from a result set as an objectphp mysqli stmt reads the next result from a multiple queryphp mysqlnduhconnection returns the number of warnings from the last query for the given linkphp mysqlnduhconnection check if there are any more query results from a multi queryphp mysqlnduhconnection prepare next result from multi queryphp mysqlnduhconnection get result from async queryphp mysqlnduhconnection transfers a result set from the last query
关注编程学问公众号