Home
last modified time | relevance | path

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

12345678910

/PHP-8.1/ext/mysqli/tests/
H A Dmysqli_query.phpt2 mysqli_query()
16 mysqli_query($link, '');
36 if (!$res = mysqli_query($link, "SELECT 'a' AS ''"))
48 mysqli_query($link, 'DROP PROCEDURE IF EXISTS p');
50 $res = mysqli_query($link, 'CALL p(@version)');
64 mysqli_query($link, 'DROP FUNCTION IF EXISTS f');
97 mysqli_query($link, "SELECT id FROM test");
110 if (!mysqli_query($link, "DROP TABLE IF EXISTS test"))
113 @mysqli_query($link, "DROP FUNCTION IF EXISTS f");
114 @mysqli_query($link, 'DROP PROCEDURE IF EXISTS p');
[all …]
H A Dmysqli_query_unicode.phpt2 mysqli_query() - unicode (cyrillic)
10 if (!$res = mysqli_query($link, "SHOW CHARACTER SET LIKE 'utf8'"))
21 if (TRUE !== ($tmp = @mysqli_query($link, "set names utf8")))
24 if (false !== ($tmp = mysqli_query($link, 'това не е ескюел')))
33 if (!$res = mysqli_query($link, "SELECT 'това ескюел, но с точка и запетая' AS правилен ; "))
44 mysqli_query($link, 'DROP PROCEDURE IF EXISTS процедурка');
46 $res = mysqli_query($link, 'CALL процедурка(@version)');
47 $res = mysqli_query($link, 'SELECT @version AS п_версия');
60 mysqli_query($link, 'DROP FUNCTION IF EXISTS функцийка');
62 $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.phpt30 if (!mysqli_query($link, 'SET AUTOCOMMIT = 0'))
51 if (!mysqli_query($link, 'DROP TABLE IF EXISTS test'))
58 if (!mysqli_query($link, 'INSERT INTO test(id) VALUES (1)'))
61 if (!mysqli_query($link, 'ROLLBACK'))
73 if (!mysqli_query($link, 'DROP TABLE IF EXISTS test'))
76 if (!mysqli_query($link, 'SET AUTOCOMMIT = 1'))
93 if (!mysqli_query($link, 'INSERT INTO test(id) VALUES (1)'))
96 if (!mysqli_query($link, 'ROLLBACK'))
106 if (!mysqli_query($link, 'INSERT INTO test(id) VALUES (1)'))
109 if (!mysqli_query($link, 'COMMIT'))
[all …]
H A Dmysqli_fetch_column.phpt19 $res = mysqli_query($link, "SELECT id, label FROM test ORDER BY id LIMIT 1");
30 $res = mysqli_query($link, "SELECT
37 $res = mysqli_query($link, "SELECT
44 $res = mysqli_query($link, "SELECT
52 $res = mysqli_query($link, "SELECT
61 $res = mysqli_query($link, "SELECT
71 $res = mysqli_query($link, "SELECT
77 $res = mysqli_query($link, "SELECT
83 $res = mysqli_query($link, "SELECT id, label FROM test ORDER BY id LIMIT 1");
91 $res = mysqli_query($link, "SELECT id, label FROM test ORDER BY id LIMIT 1");
H A Dmysqli_fetch_column_libmysql.phpt19 $res = mysqli_query($link, "SELECT id, label FROM test ORDER BY id LIMIT 1");
28 $res = mysqli_query($link, "SELECT
35 $res = mysqli_query($link, "SELECT
42 $res = mysqli_query($link, "SELECT
50 $res = mysqli_query($link, "SELECT
59 $res = mysqli_query($link, "SELECT
69 $res = mysqli_query($link, "SELECT
75 $res = mysqli_query($link, "SELECT
81 $res = mysqli_query($link, "SELECT id, label FROM test ORDER BY id LIMIT 1");
89 $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.phpt25 if (!mysqli_query($link, "DROP TABLE IF EXISTS test"))
28 if (!mysqli_query($link, "CREATE TABLE test(a int, b varchar(10)) engine=InnoDB"))
31 if (!mysqli_query($link, "INSERT INTO test VALUES (1, 'foobar')"))
37 if (!mysqli_query($link, "DELETE FROM test"))
40 if (!mysqli_query($link, "INSERT INTO test VALUES (2, 'egon')"))
46 if (!$result = mysqli_query($link, "SELECT * FROM test"))
57 if (!mysqli_query($link, "DELETE FROM test"))
60 if (!mysqli_query($link, "INSERT INTO test VALUES (2, 'egon')"))
66 if (!$result = mysqli_query($link, "SELECT * FROM test"))
76 mysqli_query($link, "DROP TABLE IF EXISTS test");
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 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 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 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 Dbug67983.phpt22 mysqli_query($connection, 'DROP TABLE IF EXISTS test');
23 mysqli_query($connection, 'CREATE TABLE test (id BIT(8))');
24 mysqli_query($connection, 'INSERT INTO test VALUES (0), (1), (42)');
26 $res = mysqli_query($connection, 'SELECT * FROM test');
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 Dmysqli_query_stored_proc.phpt2 mysqli_query() - Stored Procedures
21 if (!mysqli_query($link, 'DROP PROCEDURE IF EXISTS p'))
72 if (!mysqli_query($link, 'DROP PROCEDURE IF EXISTS p'))
95 if (!mysqli_query($link, 'DROP PROCEDURE IF EXISTS p'))
100 if (!mysqli_query($link, 'CALL p(@version)'))
103 if (!mysqli_query($link, "SET @version = 'unknown'"))
106 if (!mysqli_query($link, 'CALL p(@version)'))
123 if (!mysqli_query($link, 'DROP PROCEDURE IF EXISTS p'))
131 if (!mysqli_query($link, "SET @version = 'unknown'"))
160 if (!mysqli_query($link, "DROP TABLE IF EXISTS test"))
[all …]
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 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 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_fetch_assoc_no_alias_utf8.phpt13 if (!$res = mysqli_query($link, "SHOW CHARACTER SET LIKE 'UTF8'"))
24 if (!$res = mysqli_query($link, "SHOW CHARACTER SET LIKE 'UCS2'"))
41 if (!$res = mysqli_query($link, "SET NAMES UTF8")) {
45 …if (!$res = mysqli_query($link, "SELECT 1 AS 'Андрей Христов', 2 AS 'Улф Вендел', 3 AS 'Георг Рихт…
52 …if (!$res = mysqli_query($link, "CREATE TABLE автори_на_mysqlnd (id integer not null auto_incremen…
55 …if (!$res = mysqli_query($link, "INSERT INTO автори_на_mysqlnd (име, фамилия) VALUES ('Андрей', 'Х…
58 …if (!$res = mysqli_query($link, "INSERT INTO автори_на_mysqlnd (име, фамилия) VALUES ('Andrey', 'H…
61 …if (!$res = mysqli_query($link, "INSERT INTO автори_на_mysqlnd (име, фамилия) VALUES ('安德烈', 'Hris…
65 …if (!$res = mysqli_query($link, "SELECT id, име, фамилия FROM автори_на_mysqlnd ORDER BY фамилия, …
74 if (!$res = mysqli_query($link, "DROP TABLE автори_на_mysqlnd")) {

Completed in 24 milliseconds

12345678910