xref: /PHP-8.1/ext/mysqli/tests/069.phpt (revision b5a14e6c) 
1--TEST--
2mysqli multi_query, next_result, more_results
3--EXTENSIONS--
4mysqli
5--SKIPIF--
6<?php
7require_once('skipifconnectfailure.inc');
8?>
9--FILE--
10<?php
11    require_once("connect.inc");
12
13    $mysql = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
14    $mysql->multi_query('SELECT 1;SELECT 2');
15    do {
16        $res = $mysql->store_result();
17        if ($mysql->errno == 0) {
18            while ($arr = $res->fetch_assoc()) {
19                var_dump($arr);
20            }
21            $res->free();
22        }
23        if (!$mysql->more_results()) {
24            break;
25        }
26    } while (@$mysql->next_result());
27    $mysql->close();
28    print "done!";
29?>
30--EXPECT--
31array(1) {
32  [1]=>
33  string(1) "1"
34}
35array(1) {
36  [2]=>
37  string(1) "2"
38}
39done!
40