xref: /PHP-8.0/ext/mysqli/tests/mysqli_query.phpt (revision e3e67b72) 
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