1--TEST--
2mysqli_fetch_array()
3--SKIPIF--
4<?php
5require_once('skipif.inc');
6require_once('skipifemb.inc');
7require_once('skipifconnectfailure.inc');
8?>
9--FILE--
10<?php
11    require("table.inc");
12
13    // do as much as we can do in 5 seconds
14    $start = microtime(true);
15    for ($id = 100, $start = microtime(true); (microtime(true) - $start) < 5; $id++) {
16        if (!mysqli_query($link, $sql = sprintf("INSERT INTO test(id, label) VALUES (%d, '%s')",
17            $id, mysqli_real_escape_string($link, chr(65 + ($id % 26)))))) {
18                printf("[001] %s failed: [%d] %s\n", $sql, mysqli_errno($link), mysqli_error($link));
19                break;
20        }
21    }
22
23    if (!$res = mysqli_query($link, 'SELECT id, label FROM test')) {
24        printf("[002] SELECT failed: [%d] %s\n", mysqli_errno($link), mysqli_errno($link));
25    }
26
27    while ($row = mysqli_fetch_array($res)) {
28        // overwrite results and check if the cache magic works
29        $row['label'] = NULL;
30    }
31    mysqli_free_result($res);
32
33    if (!$res = mysqli_query($link, 'SELECT id, label FROM test')) {
34        printf("[003] SELECT failed: [%d] %s\n", mysqli_errno($link), mysqli_errno($link));
35    }
36
37    $i = 0;
38    $results = array();
39    while ($row = mysqli_fetch_array($res, MYSQLI_BOTH)) {
40
41        // create copies and destroy later
42        $results[$i++] = &$row;
43        if ($i % 999) {
44            $results = array();
45        }
46
47        if ($row[0] < 0 || $row[0] > $id) {
48            printf("[004] Unexpected result row[0] = '%s' (range 0...%d), [%d] %s\n",
49                $row[0], $id, mysqli_errno($link), mysqli_error($link));
50            break;
51        }
52        if ($row[0] !== $row['id']) {
53            printf("[005] Unexpected result row[0] = '%s', row[id] = '%s', [%d] %s\n",
54                $row[0], $row[id], mysqli_errno($link), mysqli_error($link));
55            break;
56        }
57
58        $len = strlen($row[1]);
59        if (!is_string($row[1]) || $len == 0 || $len > 1) {
60            printf("[006] Unexpected result row[1] = '%s', [%d] %s\n",
61                $row[1], mysqli_errno($link), mysqli_error($link));
62            break;
63        }
64        if ($row[1] !== $row['label']) {
65            printf("[007] Unexpected result row[1] = '%s', row[label] = '%s', [%d] %s\n",
66                $row[1], $row['label'], mysqli_errno($link), mysqli_error($link));
67            break;
68        }
69
70    }
71    mysqli_free_result($res);
72
73    if (!$res = mysqli_query($link, 'SELECT id, label FROM test')) {
74        printf("[008] SELECT failed: [%d] %s\n", mysqli_errno($link), mysqli_errno($link));
75    }
76
77    while ($row = mysqli_fetch_array($res, MYSQLI_ASSOC)) {
78        // overwrite results and check if the cache magic works
79        $row['label'] = NULL;
80    }
81    mysqli_free_result($res);
82
83    if (!$res = mysqli_query($link, 'SELECT count(*) AS num FROM test')) {
84        printf("[009] SELECT failed: [%d] %s\n", mysqli_errno($link), mysqli_errno($link));
85    }
86    $row = mysqli_fetch_assoc($res);
87    $num = $row['num'];
88    mysqli_free_result($res);
89
90    if (!$res = mysqli_query($link, 'SELECT id, label FROM test')) {
91        printf("[010] SELECT failed: [%d] %s\n", mysqli_errno($link), mysqli_errno($link));
92    }
93
94    $i = 0;
95    while ($row = mysqli_fetch_array($res, MYSQLI_NUM)) {
96        // overwrite results and check if the cache magic works
97        $row[0] = NULL;
98        $i++;
99    }
100    mysqli_free_result($res);
101
102    if ($i != $num)
103        printf("[011] Expecting %d results, got %d results, [%d] %s\n",
104            $num, $i, mysqli_errno($link), mysqli_error($link));
105
106    mysqli_close($link);
107
108    print "done!";
109?>
110--CLEAN--
111<?php
112    require_once("clean_table.inc");
113?>
114--EXPECT--
115done!
116