????JFIF??x?x????'
Server IP : 79.136.114.73 / Your IP : 18.188.123.155 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-- Multiple result set with PS --SKIPIF-- <?php require_once('skipif.inc'); require_once("connect.inc"); if (!$IS_MYSQLND) { die("skip mysqlnd only test"); } require_once('skipifconnectfailure.inc'); ?> --FILE-- <?php require_once("connect.inc"); require('table.inc'); $stmt = mysqli_stmt_init($link); if (!$link->query('DROP PROCEDURE IF EXISTS p123')) { printf("[001] [%d] %s\n", $link->error, $link->errno); } if (!$link->query("CREATE PROCEDURE p123() BEGIN SELECT id+12, CONCAT_WS('-',label,'ahoi') FROM test ORDER BY id LIMIT 1; SELECT id + 42, CONCAT_WS('---',label, label) FROM test ORDER BY id LIMIT 1; END")) { printf("[002] [%d] %s\n", $link->error, $link->errno); } if (!($stmt = $link->prepare("CALL p123"))) { printf("[003] [%d] %s\n", $stmt->error, $stmt->errno); } if (!$stmt->execute()) { printf("[005] [%d] %s\n", $stmt->error, $stmt->errno); } $c_id = NULL; $c_label = NULL; if (!$stmt->bind_result($c_id, $c_label)) { printf("[004] [%d] %s\n", $stmt->error, $stmt->errno); } var_dump("pre:",$c_id, $c_label); if (!$stmt->fetch()) { printf("[006] [%d] %s\n", $stmt->error, $stmt->errno); } var_dump("post:",$c_id, $c_label); if ($stmt->fetch()) { printf("[007] Shouldn't have fetched anything\n"); var_dump($c_id, $c_label); } if ($stmt->fetch()) { printf("[008] No more rows expected\n"); } if (!$stmt->more_results()) { printf("[009] Expected more results\n"); } else { var_dump("[009] next_result:", $stmt->next_result()); } if (!$stmt->bind_result($c_id, $c_label)) { printf("[010] [%d] %s\n", $stmt->error, $stmt->errno); } var_dump("pre:",$c_id, $c_label); if (!$stmt->fetch()) { printf("[011] [%d] %s\n", $stmt->error, $stmt->errno); } var_dump("post:",$c_id, $c_label); if ($stmt->fetch()) { printf("[012] No more rows expected\n"); } if (!$stmt->more_results()) { printf("[013] Expected more results\n"); } else { var_dump("[013] next_result:", $stmt->next_result()); } if ($stmt->more_results()) { printf("[014] No more results expected\n"); } else { printf("[014] No result, as expected\n"); } $stmt->close(); $link->close(); echo "done"; ?> --CLEAN-- <?php require_once("connect.inc"); if (!$link->query('DROP PROCEDURE IF EXISTS p123')) { printf("[001] [%d] %s\n", $link->error, $link->errno); } ?> --EXPECTF-- string(4) "pre:" NULL NULL string(5) "post:" int(13) string(6) "a-ahoi" string(18) "[009] next_result:" bool(true) string(4) "pre:" int(13) string(6) "a-ahoi" string(5) "post:" int(43) string(5) "a---a" string(18) "[013] next_result:" bool(true) [014] No result, as expected done