bug31668.phpt

来自「linux下安装不上mysql5与php5的可用此关联」· PHPT 代码 · 共 57 行

--TEST--
Bug #31668 multi_query works exactly every other time (multi_query was global, now per connection)
--SKIPIF--
<?php require_once('skipif.inc'); ?>
--FILE--
<?php
	include "connect.inc";

	$mysql = new mysqli($host, $user, $passwd, $db, $port, $socket);
	$mysql->multi_query('SELECT 1;SELECT 2');
	do {
		$res = $mysql->store_result();	
		if ($mysql->errno == 0) {
			while ($arr = $res->fetch_assoc()) {
				var_dump($arr);
			}
			$res->free();
		}
	} while ($mysql->next_result());
	var_dump($mysql->error, __LINE__);
	$mysql->close();

	$mysql = new mysqli($host, $user, $passwd, $db, $port, $socket);
	$mysql->multi_query('SELECT 1;SELECT 2');
	do {
		$res = $mysql->store_result();	
		if ($mysql->errno == 0) {
			while ($arr = $res->fetch_assoc()) {
				var_dump($arr);
			}
			$res->free();
		}
	} while ($mysql->next_result());
	var_dump($mysql->error, __LINE__);
?>
--EXPECTF--
array(1) {
  [1]=>
  %s(1) "1"
}
array(1) {
  [2]=>
  %s(1) "2"
}
%s(0) ""
int(%d)
array(1) {
  [1]=>
  %s(1) "1"
}
array(1) {
  [2]=>
  %s(1) "2"
}
%s(0) ""
int(%d)