????JFIF??x?x????'
Server IP : 79.136.114.73 / Your IP : 18.117.249.37 Web Server : Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.29 OpenSSL/1.0.1f System : Linux b8009 3.13.0-170-generic #220-Ubuntu SMP Thu May 9 12:40:49 UTC 2019 x86_64 User : www-data ( 33) PHP Version : 5.5.9-1ubuntu4.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /proc/self/root/home/b8009/php-5.6.22/ext/mysqli/tests/ |
Upload File : |
--TEST-- mysqli_fetch_array() --SKIPIF-- <?php require_once('skipif.inc'); require_once('skipifemb.inc'); require_once('skipifconnectfailure.inc'); ?> --FILE-- <?php require("table.inc"); // do as much as we can do in 5 seconds $start = microtime(true); for ($id = 100, $start = microtime(true); (microtime(true) - $start) < 5; $id++) { if (!mysqli_query($link, $sql = sprintf("INSERT INTO test(id, label) VALUES (%d, '%s')", $id, mysqli_real_escape_string($link, chr(65 + ($id % 26)))))) { printf("[001] %s failed: [%d] %s\n", $sql, mysqli_errno($link), mysqli_error($link)); break; } } if (!$res = mysqli_query($link, 'SELECT id, label FROM test')) { printf("[002] SELECT failed: [%d] %s\n", mysqli_errno($link), mysqli_errno($link)); } while ($row = mysqli_fetch_array($res)) { // overwrite results and check if the cache magic works $row['label'] = NULL; } mysqli_free_result($res); if (!$res = mysqli_query($link, 'SELECT id, label FROM test')) { printf("[003] SELECT failed: [%d] %s\n", mysqli_errno($link), mysqli_errno($link)); } $i = 0; $results = array(); while ($row = mysqli_fetch_array($res, MYSQLI_BOTH)) { // create copies and destroy later $results[$i++] = &$row; if ($i % 999) { $results = array(); } if ($row[0] < 0 || $row[0] > $id) { printf("[004] Unexpected result row[0] = '%s' (range 0...%d), [%d] %s\n", $row[0], $id, mysqli_errno($link), mysqli_error($link)); break; } if ($row[0] !== $row['id']) { printf("[005] Unexpected result row[0] = '%s', row[id] = '%s', [%d] %s\n", $row[0], $row[id], mysqli_errno($link), mysqli_error($link)); break; } $len = strlen($row[1]); if (!is_string($row[1]) || $len == 0 || $len > 1) { printf("[006] Unexpected result row[1] = '%s', [%d] %s\n", $row[1], mysqli_errno($link), mysqli_error($link)); break; } if ($row[1] !== $row['label']) { printf("[007] Unexpected result row[1] = '%s', row[label] = '%s', [%d] %s\n", $row[1], $row['label'], mysqli_errno($link), mysqli_error($link)); break; } } mysqli_free_result($res); if (!$res = mysqli_query($link, 'SELECT id, label FROM test')) { printf("[008] SELECT failed: [%d] %s\n", mysqli_errno($link), mysqli_errno($link)); } while ($row = mysqli_fetch_array($res, MYSQLI_ASSOC)) { // overwrite results and check if the cache magic works $row['label'] = NULL; } mysqli_free_result($res); if (!$res = mysqli_query($link, 'SELECT count(*) AS num FROM test')) { printf("[009] SELECT failed: [%d] %s\n", mysqli_errno($link), mysqli_errno($link)); } $row = mysqli_fetch_assoc($res); $num = $row['num']; mysqli_free_result($res); if (!$res = mysqli_query($link, 'SELECT id, label FROM test')) { printf("[010] SELECT failed: [%d] %s\n", mysqli_errno($link), mysqli_errno($link)); } $i = 0; while ($row = mysqli_fetch_array($res, MYSQLI_NUM)) { // overwrite results and check if the cache magic works $row[0] = NULL; $i++; } mysqli_free_result($res); if ($i != $num) printf("[011] Expecting %d results, got %d results, [%d] %s\n", $num, $i, mysqli_errno($link), mysqli_error($link)); mysqli_close($link); print "done!"; ?> --CLEAN-- <?php require_once("clean_table.inc"); ?> --EXPECTF-- done!