1--TEST-- 2mysqli_query() 3--SKIPIF-- 4<?php 5require_once('skipif.inc'); 6require_once('skipifconnectfailure.inc'); 7?> 8--FILE-- 9<?php 10 require_once("connect.inc"); 11 12 require('table.inc'); 13 14 try { 15 mysqli_query($link, ''); 16 } catch (\ValueError $e) { 17 echo $e->getMessage() . \PHP_EOL; 18 } 19 20 if (false !== ($tmp = mysqli_query($link, 'THIS IS NOT SQL'))) 21 printf("[004] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); 22 23 if (false !== ($tmp = mysqli_query($link, "SELECT 'this is sql but with backslash g'\g"))) 24 printf("[005] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); 25 26 if ((0 === mysqli_errno($link)) || ('' == mysqli_error($link))) 27 printf("[006] mysqli_errno()/mysqli_error should return some error\n"); 28 29 if (!$res = mysqli_query($link, "SELECT 'this is sql but with semicolon' AS valid ; ")) 30 printf("[007] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 31 32 var_dump(mysqli_fetch_assoc($res)); 33 mysqli_free_result($res); 34 35 if (!$res = mysqli_query($link, "SELECT 'a' AS ''")) 36 printf("[007a] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 37 38 var_dump($tmp = mysqli_fetch_assoc($res)); 39 var_dump($tmp[""]); 40 mysqli_free_result($res); 41 42 if (false !== ($res = mysqli_query($link, 'SELECT "this is sql but with semicolon" AS valid ; SHOW VARIABLES'))) 43 printf("[008] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 44 45 if (mysqli_get_server_version($link) > 50000) { 46 // let's try to play with stored procedures 47 mysqli_query($link, 'DROP PROCEDURE IF EXISTS p'); 48 if (mysqli_query($link, 'CREATE PROCEDURE p(OUT ver_param VARCHAR(25)) BEGIN SELECT VERSION() INTO ver_param; END;')) { 49 $res = mysqli_query($link, 'CALL p(@version)'); 50 $res = mysqli_query($link, 'SELECT @version AS p_version'); 51 52 $tmp = mysqli_fetch_assoc($res); 53 if (!is_array($tmp) || empty($tmp) || !isset($tmp['p_version']) || ('' == $tmp['p_version'])) { 54 printf("[008a] Expecting array [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 55 var_dump($tmp); 56 } 57 58 mysqli_free_result($res); 59 } else { 60 printf("[009] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 61 } 62 63 mysqli_query($link, 'DROP FUNCTION IF EXISTS f'); 64 if (mysqli_query($link, 'CREATE FUNCTION f( ver_param VARCHAR(25)) RETURNS VARCHAR(25) DETERMINISTIC RETURN ver_param;')) { 65 $res = mysqli_query($link, 'SELECT f(VERSION()) AS f_version'); 66 67 $tmp = mysqli_fetch_assoc($res); 68 if (!is_array($tmp) || empty($tmp) || !isset($tmp['f_version']) || ('' == $tmp['f_version'])) { 69 printf("[009a] Expecting array [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 70 var_dump($tmp); 71 } 72 73 mysqli_free_result($res); 74 } else { 75 printf("[010] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 76 } 77 } 78 79 if (!is_object($res = mysqli_query($link, "SELECT id FROM test ORDER BY id", MYSQLI_USE_RESULT))) 80 printf("[011] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 81 mysqli_free_result($res); 82 83 if (!is_object($res = mysqli_query($link, "SELECT id FROM test ORDER BY id", MYSQLI_STORE_RESULT))) 84 printf("[012] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 85 mysqli_free_result($res); 86 87 try { 88 mysqli_query($link, "SELECT id FROM test ORDER BY id", 1234); 89 } catch (\ValueError $e) { 90 echo $e->getMessage() . \PHP_EOL; 91 } 92 93 mysqli_close($link); 94 95 try { 96 mysqli_query($link, "SELECT id FROM test"); 97 } catch (Error $exception) { 98 echo $exception->getMessage() . "\n"; 99 } 100 101 print "done!"; 102?> 103--CLEAN-- 104<?php 105require_once("connect.inc"); 106if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) 107 printf("[c001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error()); 108 109if (!mysqli_query($link, "DROP TABLE IF EXISTS test")) 110 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 111 112@mysqli_query($link, "DROP FUNCTION IF EXISTS f"); 113@mysqli_query($link, 'DROP PROCEDURE IF EXISTS p'); 114 115mysqli_close($link); 116?> 117--EXPECTF-- 118mysqli_query(): Argument #2 ($query) cannot be empty 119array(1) { 120 ["valid"]=> 121 string(30) "this is sql but with semicolon" 122} 123array(1) { 124 [""]=> 125 string(1) "a" 126} 127string(1) "a" 128mysqli_query(): Argument #3 ($result_mode) must be either MYSQLI_USE_RESULT or MYSQLI_STORE_RESULT%S 129mysqli object is already closed 130done! 131