Home
last modified time | relevance | path

Searched refs:mysqli_query (Results 1 – 25 of 228) sorted by relevance

12345678910

/PHP-8.3/ext/mysqli/tests/
H A Dmysqli_query.phpt2 mysqli_query()
14 mysqli_query($link, '');
34 if (!$res = mysqli_query($link, "SELECT 'a' AS ''"))
46 mysqli_query($link, 'DROP PROCEDURE IF EXISTS p');
48 $res = mysqli_query($link, 'CALL p(@version)');
62 mysqli_query($link, 'DROP FUNCTION IF EXISTS f');
95 mysqli_query($link, "SELECT id FROM test");
108 if (!mysqli_query($link, "DROP TABLE IF EXISTS test"))
111 @mysqli_query($link, "DROP FUNCTION IF EXISTS f");
112 @mysqli_query($link, 'DROP PROCEDURE IF EXISTS p');
[all …]
H A Dmysqli_query_unicode.phpt2 mysqli_query() - unicode (cyrillic)
9 if (!$res = mysqli_query($link, "SHOW CHARACTER SET LIKE 'utf8'"))
18 if (TRUE !== ($tmp = @mysqli_query($link, "set names utf8")))
21 if (false !== ($tmp = mysqli_query($link, 'това не е ескюел')))
30 if (!$res = mysqli_query($link, "SELECT 'това ескюел, но с точка и запетая' AS правилен ; "))
41 mysqli_query($link, 'DROP PROCEDURE IF EXISTS процедурка');
43 $res = mysqli_query($link, 'CALL процедурка(@version)');
44 $res = mysqli_query($link, 'SELECT @version AS п_версия');
57 mysqli_query($link, 'DROP FUNCTION IF EXISTS функцийка');
59 $res = mysqli_query($link, 'SELECT функцийка(VERSION()) AS ф_версия');
[all …]
H A Dmysqli_pconn_max_links.phpt10 mysqli_query($link, 'DROP USER pcontest');
11 mysqli_query($link, 'DROP USER pcontest@localhost');
27 mysqli_query($link, 'DROP USER pcontest');
36 mysqli_query($link, 'DROP USER pcontest');
52 if (!mysqli_query($link, 'DROP USER pcontest') ||
101 !mysqli_query($link, 'FLUSH PRIVILEGES'))
107 !mysqli_query($link, 'FLUSH PRIVILEGES'))
190 mysqli_query($link, 'DROP USER pcontest');
200 if (!mysqli_query($link, "DROP TABLE IF EXISTS test"))
205 mysqli_query($link, 'DROP USER pcontest@localhost');
[all …]
H A D036.phpt22 mysqli_query($link, "DROP TABLE IF EXISTS t036");
23 …mysqli_query($link, "CREATE TABLE t036 (a bigint not null auto_increment primary key, b varchar(10…
25 mysqli_query($link, "INSERT INTO t036 (b) VALUES ('foo1')");
33 mysqli_query($link, "ALTER TABLE t036 AUTO_INCREMENT=9999999999999998");
34 mysqli_query($link, "INSERT INTO t036 (b) VALUES ('foo2')");
35 mysqli_query($link, "INSERT INTO t036 (b) VALUES ('foo3')");
36 mysqli_query($link, "INSERT INTO t036 (b) VALUES ('foo4')");
42 mysqli_query($link, "DROP TABLE IF EXISTS t036");
52 if (!mysqli_query($link, "DROP TABLE IF EXISTS t036"))
H A Dmysqli_autocommit.phpt29 if (!mysqli_query($link, 'SET AUTOCOMMIT = 0'))
50 if (!mysqli_query($link, 'DROP TABLE IF EXISTS test'))
57 if (!mysqli_query($link, 'INSERT INTO test(id) VALUES (1)'))
60 if (!mysqli_query($link, 'ROLLBACK'))
72 if (!mysqli_query($link, 'DROP TABLE IF EXISTS test'))
75 if (!mysqli_query($link, 'SET AUTOCOMMIT = 1'))
92 if (!mysqli_query($link, 'INSERT INTO test(id) VALUES (1)'))
95 if (!mysqli_query($link, 'ROLLBACK'))
105 if (!mysqli_query($link, 'INSERT INTO test(id) VALUES (1)'))
108 if (!mysqli_query($link, 'COMMIT'))
[all …]
H A Dmysqli_fetch_column.phpt14 $res = mysqli_query($link, "SELECT id, label FROM test ORDER BY id LIMIT 1");
25 $res = mysqli_query($link, "SELECT
32 $res = mysqli_query($link, "SELECT
39 $res = mysqli_query($link, "SELECT
47 $res = mysqli_query($link, "SELECT
56 $res = mysqli_query($link, "SELECT
66 $res = mysqli_query($link, "SELECT
72 $res = mysqli_query($link, "SELECT
78 $res = mysqli_query($link, "SELECT id, label FROM test ORDER BY id LIMIT 1");
86 $res = mysqli_query($link, "SELECT id, label FROM test ORDER BY id LIMIT 1");
H A D015.phpt32 if (!mysqli_query($link,"DROP TABLE IF EXISTS test") ||
33 !mysqli_query($link,"CREATE TABLE test(a int, b varchar(10)) Engine=InnoDB") ||
34 !mysqli_query($link, "INSERT INTO test VALUES (1, 'foobar')"))
42 if (!mysqli_query($link, "DELETE FROM test") ||
43 !mysqli_query($link, "INSERT INTO test VALUES (2, 'egon')"))
51 $result = mysqli_query($link, "SELECT SQL_NO_CACHE * FROM test");
59 if (!mysqli_query($link, "DELETE FROM test") ||
60 !mysqli_query($link, "INSERT INTO test VALUES (2, 'egon')"))
66 $result = mysqli_query($link, "SELECT * FROM test");
74 mysqli_query($link, "DROP TABLE IF EXISTS test");
H A D029.phpt18 mysqli_query($link, "DROP TABLE IF EXISTS general_test");
19 mysqli_query($link, "CREATE TABLE general_test (a INT)");
20 mysqli_query($link, "INSERT INTO general_test VALUES (1),(2),(3)");
26 mysqli_query($link, "DROP TABLE IF EXISTS general_test");
36 if (!mysqli_query($link, "DROP TABLE IF EXISTS general_test"))
H A D009.phpt20 if (!mysqli_query($link, "SET sql_mode=''"))
23 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch"))
26 $rc = mysqli_query($link,"CREATE TABLE test_bind_fetch(c1 bigint default 5,
37 $rc = mysqli_query($link, "INSERT INTO test_bind_fetch (c2,c3,c4,c5,c6,c7,c8) ".
60 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch_uint"))
62 …$rc = mysqli_query($link, "CREATE TABLE test_bind_fetch_uint(c1 integer unsigned, c2 integer unsig…
66 …if (!mysqli_query($link, "INSERT INTO test_bind_fetch_uint (c1,c2) VALUES (20123456, 3123456789)"))
77 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch");
78 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch_uint");
88 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch"))
[all …]
H A D014.phpt24 if (!mysqli_query($link, "DROP TABLE IF EXISTS test"))
27 if (!mysqli_query($link, "CREATE TABLE test(a int, b varchar(10)) engine=InnoDB"))
30 if (!mysqli_query($link, "INSERT INTO test VALUES (1, 'foobar')"))
36 if (!mysqli_query($link, "DELETE FROM test"))
39 if (!mysqli_query($link, "INSERT INTO test VALUES (2, 'egon')"))
45 if (!$result = mysqli_query($link, "SELECT * FROM test"))
56 if (!mysqli_query($link, "DELETE FROM test"))
59 if (!mysqli_query($link, "INSERT INTO test VALUES (2, 'egon')"))
65 if (!$result = mysqli_query($link, "SELECT * FROM test"))
75 mysqli_query($link, "DROP TABLE IF EXISTS test");
H A D060.phpt23 mysqli_query($link, "SET sql_mode=''");
25 mysqli_query($link,"DROP TABLE IF EXISTS test_fetch");
26 mysqli_query($link,"CREATE TABLE test_fetch(c1 smallint unsigned,
34 mysqli_query($link, "INSERT INTO test_fetch VALUES ( -23, 35999, NULL, -500, -9999999, -0, 0)");
36 $result = mysqli_query($link, "SELECT * FROM test_fetch");
52 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_fetch"))
H A D043.phpt18 mysqli_query($link,"DROP TABLE IF EXISTS test_update");
19 mysqli_query($link,"CREATE TABLE test_update(a varchar(10),
22 mysqli_query($link, "INSERT INTO test_update VALUES ('foo', 2)");
34 $result = mysqli_query($link, "SELECT concat(a, ' is No. ', b) FROM test_update");
40 mysqli_query($link, "DROP TABLE IF EXISTS test_update");
50 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_update"))
H A D032.phpt18 mysqli_query($link, "DROP TABLE IF EXISTS general_test");
19 mysqli_query($link, "CREATE TABLE general_test (a INT)");
20 mysqli_query($link, "INSERT INTO general_test VALUES (1),(2),(3)");
26 mysqli_query($link, "DROP TABLE IF EXISTS general_test");
36 if (!mysqli_query($link, "DROP TABLE IF EXISTS general_test"))
H A Dbug67983.phpt19 mysqli_query($connection, 'DROP TABLE IF EXISTS test');
20 mysqli_query($connection, 'CREATE TABLE test (id BIT(8))');
21 mysqli_query($connection, 'INSERT INTO test VALUES (0), (1), (42)');
23 $res = mysqli_query($connection, 'SELECT * FROM test');
H A Dmysqli_affected_rows.phpt21 if (!mysqli_query($link, 'DROP TABLE IF EXISTS test'))
27 if (!mysqli_query($link, "INSERT INTO test(id, label) VALUES (1, 'a')"))
34 mysqli_query($link, "INSERT INTO test(id, label) VALUES (1, 'a')");
44 if (!mysqli_query($link, "INSERT INTO test(id, label) VALUES (2, 'b'), (3, 'c')"))
50 if (!mysqli_query($link, "INSERT IGNORE INTO test(id, label) VALUES (1, 'a')")) {
63 if (!mysqli_query($link, "REPLACE INTO test(id, label) values (4, 'd')"))
69 if (!mysqli_query($link, "REPLACE INTO test(id, label) values (5, 'e')"))
75 if (!mysqli_query($link, "UPDATE test SET label = 'a' WHERE id = 2"))
93 if (!mysqli_query($link, "UPDATE test SET label = 'a' WHERE id = 2")) {
100 if (!mysqli_query($link, "UPDATE test SET label = 'a' WHERE id = 100")) {
[all …]
H A D037.phpt19 mysqli_query($link, "DROP TABLE IF EXISTS test_result");
21 mysqli_query($link, "CREATE TABLE test_result (a int, b varchar(10)) ENGINE = " . $engine);
23 mysqli_query($link, "INSERT INTO test_result VALUES (1, 'foo')");
32 mysqli_query($link, "DROP TABLE IF EXISTS test_result");
42 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_result"))
H A D038.phpt18 mysqli_query($link, "DROP TABLE IF EXISTS test_result");
20 mysqli_query($link, "CREATE TABLE test_result (a int, b varchar(10)) ENGINE = " . $engine);
22 mysqli_query($link, "INSERT INTO test_result VALUES (1, 'foo')");
33 mysqli_query($link, "DROP TABLE IF EXISTS test_result");
42 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_result"))
H A D042.phpt17 mysqli_query($link, "SET sql_mode=''");
19 mysqli_query($link,"DROP TABLE IF EXISTS test_bind_fetch");
20 mysqli_query($link,"CREATE TABLE test_bind_fetch(c1 smallint unsigned,
42 $result = mysqli_query($link, "SELECT * FROM test_bind_fetch");
48 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch");
58 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch"))
H A D046.phpt18 mysqli_query($link, "DROP TABLE IF EXISTS test_affected");
19 mysqli_query($link, "CREATE TABLE test_affected (foo int) ENGINE=" . $engine);
21 mysqli_query($link, "INSERT INTO test_affected VALUES (1),(2),(3),(4),(5)");
34 mysqli_query($link, "DROP TABLE IF EXISTS test_affected");
44 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_affected"))
H A D040.phpt18 mysqli_query($link, "DROP TABLE IF EXISTS test_result");
19 mysqli_query($link, "CREATE TABLE test_result (a int, b varchar(10)) ENGINE=" . $engine);
20 mysqli_query($link, "INSERT INTO test_result VALUES (1, 'foo')");
31 mysqli_query($link, "DROP TABLE IF EXISTS test_result");
41 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_result"))
H A Dmysqli_query_stored_proc.phpt2 mysqli_query() - Stored Procedures
19 if (!mysqli_query($link, 'DROP PROCEDURE IF EXISTS p'))
70 if (!mysqli_query($link, 'DROP PROCEDURE IF EXISTS p'))
93 if (!mysqli_query($link, 'DROP PROCEDURE IF EXISTS p'))
98 if (!mysqli_query($link, 'CALL p(@version)'))
101 if (!mysqli_query($link, "SET @version = 'unknown'"))
104 if (!mysqli_query($link, 'CALL p(@version)'))
121 if (!mysqli_query($link, 'DROP PROCEDURE IF EXISTS p'))
129 if (!mysqli_query($link, "SET @version = 'unknown'"))
158 if (!mysqli_query($link, "DROP TABLE IF EXISTS test"))
[all …]
H A D004.phpt18 if (!mysqli_query($link,"DROP TABLE IF EXISTS test_bind_fetch"))
21 if (!mysqli_query($link,"CREATE TABLE test_bind_fetch(c1 char(10), c2 text) ENGINE=" . $engine))
24 … if (!mysqli_query($link, "INSERT INTO test_bind_fetch VALUES ('1234567890', 'this is a test0')"))
27 … if (!mysqli_query($link, "INSERT INTO test_bind_fetch VALUES ('1234567891', 'this is a test1')"))
30 … if (!mysqli_query($link, "INSERT INTO test_bind_fetch VALUES ('1234567892', 'this is a test2')"))
33 … if (!mysqli_query($link, "INSERT INTO test_bind_fetch VALUES ('1234567893', 'this is a test3')"))
50 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch");
60 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch"))
H A Dmysqli_change_user_locks_temporary.phpt19 if (!mysqli_query($link, 'LOCK TABLE test WRITE'))
23 if ($res = mysqli_query($link2, 'SELECT COUNT(*) AS _num FROM test')) {
33 if (!$res = mysqli_query($link2, 'SELECT COUNT(*) AS _num FROM test'))
45 if (!mysqli_query($link, 'DROP TABLE test'))
48 if (!mysqli_query($link, 'CREATE TEMPORARY TABLE test(id INT)'))
51 if (!mysqli_query($link, 'INSERT INTO test(id) VALUES (1), (2), (3)'))
54 if (!$res = mysqli_query($link, 'SELECT COUNT(*) AS _num FROM test'))
68 if ($res = mysqli_query($link, 'SELECT COUNT(*) AS _num FROM test')) {
74 if (!$res = mysqli_query($link, 'SELECT GET_LOCK("phptest", 2) AS _ok'))
88 if (!$res = mysqli_query($link, 'SELECT IS_FREE_LOCK("phptest") AS _ok'))
H A Dmysqli_insert_packet_overflow.phpt13 if (!$res = mysqli_query($link, "SHOW GLOBAL VARIABLES LIKE 'max_allowed_packet'"))
16 if (!mysqli_query($link, "SET NAMES 'latin1'"))
29 if (!$res = mysqli_query($link, "SHOW GLOBAL VARIABLES LIKE 'max_allowed_packet'"))
42 if (!mysqli_query($link, "SET GLOBAL max_allowed_packet = " . ($max_len + 100))) {
56 if (!mysqli_query($link, "SET NAMES 'latin1'"))
59 if (!$res = mysqli_query($link, "SHOW GLOBAL VARIABLES LIKE 'max_allowed_packet'"))
76 if (!mysqli_query($link, "DROP TABLE IF EXISTS {$table_name}")) {
80 if (!mysqli_query($link, "CREATE TABLE {$table_name}(col_blob LONGBLOB) ENGINE=" . $engine))
92 if (!mysqli_query($link, $query))
95 if (!$res = mysqli_query($link, "SELECT col_blob FROM {$table_name}"))
[all …]
H A D013.phpt16 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_result"))
19 $rc = mysqli_query($link, "CREATE TABLE test_bind_result(c1 tinyint, c2 smallint,
27 if (!mysqli_query($link, "INSERT INTO test_bind_result VALUES(120,2999,3999,54,
41 $result = mysqli_query($link, "select * from test_bind_result");
53 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_result");
63 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_result"))

Completed in 28 milliseconds

12345678910