Home
last modified time | relevance | path

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

123456789

/PHP-5.3/ext/mysqli/tests/
H A Dmysqli_query.phpt2 mysqli_query()
16 if (!is_null($tmp = @mysqli_query()))
19 if (!is_null($tmp = @mysqli_query($link)))
24 if (false !== ($tmp = @mysqli_query($link, '')))
45 if (!$res = mysqli_query($link, "SELECT 'a' AS ''"))
57 mysqli_query($link, 'DROP PROCEDURE IF EXISTS p');
59 $res = mysqli_query($link, 'CALL p(@version)');
73 mysqli_query($link, 'DROP FUNCTION IF EXISTS f');
121 if (!mysqli_query($link, "DROP TABLE IF EXISTS test"))
124 @mysqli_query($link, "DROP FUNCTION IF EXISTS f");
[all …]
H A Dmysqli_query_unicode.phpt2 mysqli_query() - unicode (cyrillic)
10 if (!$res = mysqli_query($link, "SHOW CHARACTER SET LIKE 'utf8'"))
22 if (!is_null($tmp = @mysqli_query()))
25 if (!is_null($tmp = @mysqli_query($link)))
30 if (TRUE !== ($tmp = @mysqli_query($link, "set names utf8")))
56 mysqli_query($link, 'DROP PROCEDURE IF EXISTS процедурка');
58 $res = mysqli_query($link, 'CALL процедурка(@version)');
59 $res = mysqli_query($link, 'SELECT @version AS п_версия');
72 mysqli_query($link, 'DROP FUNCTION IF EXISTS функцийка');
93 @mysqli_query($link, "DROP USER IF EXISTS 'тест'@'%'");
[all …]
H A Dmysqli_pconn_max_links.phpt10 mysqli_query($link, 'DROP USER pcontest');
11 mysqli_query($link, 'DROP USER pcontest@localhost');
26 mysqli_query($link, 'DROP USER pcontest@localhost');
27 mysqli_query($link, 'DROP USER pcontest');
35 mysqli_query($link, 'DROP USER pcontest@localhost');
36 mysqli_query($link, 'DROP USER pcontest');
51 if (!mysqli_query($link, 'DROP USER pcontest') ||
87 !mysqli_query($link, 'FLUSH PRIVILEGES'))
92 !mysqli_query($link, 'FLUSH PRIVILEGES'))
161 mysqli_query($link, 'DROP USER pcontest');
[all …]
H A D036.phpt21 mysqli_query($link, "DROP TABLE IF EXISTS t036");
22 …mysqli_query($link, "CREATE TABLE t036 (a bigint not null auto_increment primary key, b varchar(10…
24 mysqli_query($link, "INSERT INTO t036 (b) VALUES ('foo1')");
32 mysqli_query($link, "ALTER TABLE t036 AUTO_INCREMENT=9999999999999998");
33 mysqli_query($link, "INSERT INTO t036 (b) VALUES ('foo2')");
34 mysqli_query($link, "INSERT INTO t036 (b) VALUES ('foo3')");
35 mysqli_query($link, "INSERT INTO t036 (b) VALUES ('foo4')");
41 mysqli_query($link, "DROP TABLE IF EXISTS t036");
51 if (!mysqli_query($link, "DROP TABLE IF EXISTS t036"))
H A Dmysqli_autocommit.phpt42 if (!mysqli_query($link, 'SET AUTOCOMMIT = 0'))
63 if (!mysqli_query($link, 'DROP TABLE IF EXISTS test'))
70 if (!mysqli_query($link, 'INSERT INTO test(id) VALUES (1)'))
73 if (!mysqli_query($link, 'ROLLBACK'))
85 if (!mysqli_query($link, 'DROP TABLE IF EXISTS test'))
88 if (!mysqli_query($link, 'SET AUTOCOMMIT = 1'))
105 if (!mysqli_query($link, 'INSERT INTO test(id) VALUES (1)'))
108 if (!mysqli_query($link, 'ROLLBACK'))
118 if (!mysqli_query($link, 'INSERT INTO test(id) VALUES (1)'))
121 if (!mysqli_query($link, 'COMMIT'))
[all …]
H A D015.phpt31 if (!mysqli_query($link,"DROP TABLE IF EXISTS test") ||
32 !mysqli_query($link,"CREATE TABLE test(a int, b varchar(10)) Engine=InnoDB") ||
33 !mysqli_query($link, "INSERT INTO test VALUES (1, 'foobar')"))
41 if (!mysqli_query($link, "DELETE FROM test") ||
42 !mysqli_query($link, "INSERT INTO test VALUES (2, 'egon')"))
50 $result = mysqli_query($link, "SELECT SQL_NO_CACHE * FROM test");
58 if (!mysqli_query($link, "DELETE FROM test") ||
59 !mysqli_query($link, "INSERT INTO test VALUES (2, 'egon')"))
65 $result = mysqli_query($link, "SELECT * FROM test");
73 mysqli_query($link, "DROP TABLE IF EXISTS test");
H A D009.phpt19 if (!mysqli_query($link, "SET sql_mode=''"))
22 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch"))
25 $rc = mysqli_query($link,"CREATE TABLE test_bind_fetch(c1 bigint default 5,
36 $rc = mysqli_query($link, "INSERT INTO test_bind_fetch (c2,c3,c4,c5,c6,c7,c8) ".
59 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch_uint"))
61 …$rc = mysqli_query($link, "CREATE TABLE test_bind_fetch_uint(c1 integer unsigned, c2 integer unsig…
65 if (!mysqli_query($link, "INSERT INTO test_bind_fetch_uint (c1,c2) VALUES (20123456, 3123456789)"))
76 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch");
77 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch_uint");
87 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 D043.phpt17 mysqli_query($link,"DROP TABLE IF EXISTS test_update");
18 mysqli_query($link,"CREATE TABLE test_update(a varchar(10),
21 mysqli_query($link, "INSERT INTO test_update VALUES ('foo', 2)");
33 $result = mysqli_query($link, "SELECT concat(a, ' is No. ', b) FROM test_update");
39 mysqli_query($link, "DROP TABLE IF EXISTS test_update");
49 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_update"))
H A D029.phpt17 mysqli_query($link, "DROP TABLE IF EXISTS general_test");
18 mysqli_query($link, "CREATE TABLE general_test (a INT)");
19 mysqli_query($link, "INSERT INTO general_test VALUES (1),(2),(3)");
25 mysqli_query($link, "DROP TABLE IF EXISTS general_test");
35 if (!mysqli_query($link, "DROP TABLE IF EXISTS general_test"))
H A D032.phpt17 mysqli_query($link, "DROP TABLE IF EXISTS general_test");
18 mysqli_query($link, "CREATE TABLE general_test (a INT)");
19 mysqli_query($link, "INSERT INTO general_test VALUES (1),(2),(3)");
25 mysqli_query($link, "DROP TABLE IF EXISTS general_test");
35 if (!mysqli_query($link, "DROP TABLE IF EXISTS general_test"))
H A D037.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')");
31 mysqli_query($link, "DROP TABLE IF EXISTS test_result");
41 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_result"))
H A D038.phpt17 mysqli_query($link, "DROP TABLE IF EXISTS test_result");
19 mysqli_query($link, "CREATE TABLE test_result (a int, b varchar(10)) ENGINE = " . $engine);
21 mysqli_query($link, "INSERT INTO test_result VALUES (1, 'foo')");
32 mysqli_query($link, "DROP TABLE IF EXISTS test_result");
41 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_result"))
H A D004.phpt17 if (!mysqli_query($link,"DROP TABLE IF EXISTS test_bind_fetch"))
20 if (!mysqli_query($link,"CREATE TABLE test_bind_fetch(c1 char(10), c2 text) ENGINE=" . $engine))
23 if (!mysqli_query($link, "INSERT INTO test_bind_fetch VALUES ('1234567890', 'this is a test0')"))
26 if (!mysqli_query($link, "INSERT INTO test_bind_fetch VALUES ('1234567891', 'this is a test1')"))
29 if (!mysqli_query($link, "INSERT INTO test_bind_fetch VALUES ('1234567892', 'this is a test2')"))
32 if (!mysqli_query($link, "INSERT INTO test_bind_fetch VALUES ('1234567893', 'this is a test3')"))
49 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch");
59 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch"))
H A D040.phpt17 mysqli_query($link, "DROP TABLE IF EXISTS test_result");
18 mysqli_query($link, "CREATE TABLE test_result (a int, b varchar(10)) ENGINE=" . $engine);
19 mysqli_query($link, "INSERT INTO test_result VALUES (1, 'foo')");
30 mysqli_query($link, "DROP TABLE IF EXISTS test_result");
40 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_result"))
H A D046.phpt17 mysqli_query($link, "DROP TABLE IF EXISTS test_affected");
18 mysqli_query($link, "CREATE TABLE test_affected (foo int) ENGINE=" . $engine);
20 mysqli_query($link, "INSERT INTO test_affected VALUES (1),(2),(3),(4),(5)");
33 mysqli_query($link, "DROP TABLE IF EXISTS test_affected");
43 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_affected"))
H A Dmysqli_affected_rows.phpt33 if (!mysqli_query($link, 'DROP TABLE IF EXISTS test'))
39 if (!mysqli_query($link, "INSERT INTO test(id, label) VALUES (1, 'a')"))
46 mysqli_query($link, "INSERT INTO test(id, label) VALUES (1, 'a')");
56 if (!mysqli_query($link, "INSERT INTO test(id, label) VALUES (2, 'b'), (3, 'c')"))
62 if (!mysqli_query($link, "INSERT IGNORE INTO test(id, label) VALUES (1, 'a')")) {
75 if (!mysqli_query($link, "REPLACE INTO test(id, label) values (4, 'd')"))
81 if (!mysqli_query($link, "REPLACE INTO test(id, label) values (5, 'e')"))
87 if (!mysqli_query($link, "UPDATE test SET label = 'a' WHERE id = 2"))
105 if (!mysqli_query($link, "UPDATE test SET label = 'a' WHERE id = 2")) {
112 if (!mysqli_query($link, "UPDATE test SET label = 'a' WHERE id = 100")) {
[all …]
H A D042.phpt16 mysqli_query($link, "SET sql_mode=''");
18 mysqli_query($link,"DROP TABLE IF EXISTS test_bind_fetch");
19 mysqli_query($link,"CREATE TABLE test_bind_fetch(c1 smallint unsigned,
41 $result = mysqli_query($link, "SELECT * FROM test_bind_fetch");
47 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch");
57 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch"))
H A D060.phpt22 mysqli_query($link, "SET sql_mode=''");
24 mysqli_query($link,"DROP TABLE IF EXISTS test_fetch");
25 mysqli_query($link,"CREATE TABLE test_fetch(c1 smallint unsigned,
33 mysqli_query($link, "INSERT INTO test_fetch VALUES ( -23, 35999, NULL, -500, -9999999, -0, 0)");
35 $result = mysqli_query($link, "SELECT * FROM test_fetch");
51 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_fetch"))
H A Dmysqli_insert_packet_overflow.phpt12 if (!$res = mysqli_query($link, "SHOW GLOBAL VARIABLES LIKE 'max_allowed_packet'"))
15 if (!mysqli_query($link, "SET NAMES 'latin1'"))
28 if (!$res = mysqli_query($link, "SHOW GLOBAL VARIABLES LIKE 'max_allowed_packet'"))
41 if (!mysqli_query($link, "SET GLOBAL max_allowed_packet = " . ($max_len + 100))) {
55 if (!mysqli_query($link, "SET NAMES 'latin1'"))
58 if (!$res = mysqli_query($link, "SHOW GLOBAL VARIABLES LIKE 'max_allowed_packet'"))
74 if (!mysqli_query($link, "CREATE TABLE test(col_blob LONGBLOB) ENGINE=" . $engine))
86 if (!mysqli_query($link, $query))
89 if (!$res = mysqli_query($link, "SELECT col_blob FROM test"))
103 if (!mysqli_query($link, "SET GLOBAL max_allowed_packet = " . $org_max_allowed_packet))
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_query_stored_proc.phpt2 mysqli_query() - Stored Procedures
20 if (!mysqli_query($link, 'DROP PROCEDURE IF EXISTS p'))
71 if (!mysqli_query($link, 'DROP PROCEDURE IF EXISTS p'))
94 if (!mysqli_query($link, 'DROP PROCEDURE IF EXISTS p'))
99 if (!mysqli_query($link, 'CALL p(@version)'))
102 if (!mysqli_query($link, "SET @version = 'unknown'"))
105 if (!mysqli_query($link, 'CALL p(@version)'))
122 if (!mysqli_query($link, 'DROP PROCEDURE IF EXISTS p'))
130 if (!mysqli_query($link, "SET @version = 'unknown'"))
159 if (!mysqli_query($link, "DROP TABLE IF EXISTS test"))
[all …]
H A D006.phpt15 if (!mysqli_query($link, "SET sql_mode=''"))
18 if (!mysqli_query($link,"DROP TABLE IF EXISTS test_bind_fetch"))
21 $rc = mysqli_query($link,"CREATE TABLE test_bind_fetch(c1 int unsigned,
31 if (!mysqli_query($link, "INSERT INTO test_bind_fetch VALUES (-23,35999,NULL,-500,-9999999,-0,0)"))
44 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch");
54 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch"))
H A D007.phpt15 if (!mysqli_query($link, "SET sql_mode=''"))
18 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch"))
21 $rc = mysqli_query($link, "CREATE TABLE test_bind_fetch(c1 smallint unsigned,
31 …if (!mysqli_query($link, "INSERT INTO test_bind_fetch VALUES (-23,35999,NULL,-500,-9999999,+30,0)"…
44 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch");
54 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch"))
H A D008.phpt15 if (!mysqli_query($link, "SET sql_mode=''"))
18 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch"))
21 $rc = mysqli_query($link, "CREATE TABLE test_bind_fetch(c1 tinyint,
31 if (!mysqli_query($link, "INSERT INTO test_bind_fetch VALUES (-23,300,0,-100,-127,+30,0)"))
44 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch");
54 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch"))

Completed in 40 milliseconds

123456789