MysqlndUhConnection::moreResults

(PECL mysqlnd-uh >= 1.0.0-alpha)

MysqlndUhConnection::moreResults — Check if there are any more query results from a multi query

说明

public bool MysqlndUhConnection::moreResults ( mysqlnd_connection $connection )

Check if there are any more query results from a multi query.

参数

connection: Mysqlnd connection handle. Do not modify!

返回值

Returns TRUE on success. Otherwise, returns FALSE

范例

Example #1 MysqlndUhConnection::moreResults() example

  <?php
 class  proxy  extends  MysqlndUhConnection  {
 public function  moreResults ( $res ) {
   printf ( "%s(%s)\n" ,  __METHOD__ ,  var_export ( func_get_args (),  true ));
   $ret  =  parent :: moreResults ( $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::moreResults(array (
  0 => NULL,
))
proxy::moreResults returns true
proxy::moreResults(array (
  0 => NULL,
))
proxy::moreResults returns true
array(1) {
  ["_two"]=>
  string(1) "2"
}
----------------------------------------
proxy::moreResults(array (
  0 => NULL,
))
proxy::moreResults returns false

参见

mysqlnd_uh_set_connection_proxy() - Installs a proxy for mysqlnd connections
mysqli_more_results() - Check if there are any more query results from a multi query