Home
last modified time | relevance | path

Searched refs:mysql_query (Results 1 – 25 of 56) sorted by relevance

123

/PHP-5.5/ext/mysql/tests/
H A Dmysql_query.phpt2 mysql_query()
15 if (!is_null($tmp = @mysql_query()))
18 if (false !== ($tmp = @mysql_query($link)))
26 if (false !== ($tmp = mysql_query('THIS IS NOT SQL', $link)))
41 if (!$res = mysql_query("SELECT 'a' AS ''", $link))
51 if (mysql_query('DROP PROCEDURE IF EXISTS p', $link)) {
54 $res = mysql_query('CALL p(@version)', $link);
70 mysql_query('DROP FUNCTION IF EXISTS f', $link);
105 if (!mysql_query('DROP TABLE IF EXISTS test', $link)) {
110 @mysql_query('DROP PROCEDURE IF EXISTS p', $link);
[all …]
H A Dbug53649.phpt2 Bug #53649 (mysql_query with "load data" unable to save result set)
12 if (!mysql_query("DROP TABLE IF EXISTS test", $link) ||
13 …!mysql_query("CREATE TABLE test (dump1 INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE=" . $engine, $lin…
19 if (!mysql_query("LOAD DATA LOCAL INFILE 'bug53649.data' INTO TABLE test", $link) &&
31 if (!mysql_query("DROP TABLE IF EXISTS test", $link)) {
35 …if (!mysql_query("CREATE TABLE test (dump1 INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE=" . $engine, …
42 if (!mysql_query("SELECT 1 FROM DUAL", $link))
45 if (!mysql_query("LOAD DATA LOCAL INFILE 'bug53649.data' INTO TABLE test", $link)) {
62 if (!mysql_query($link, 'DROP TABLE IF EXISTS test', $link)) {
H A Dbug47438.phpt17 mysql_query("DROP TABLE IF EXISTS test_47438", $link);
18 mysql_query("CREATE TABLE test_47438 (a INT, b INT, c INT)", $link);
19 mysql_query("INSERT INTO test_47438 VALUES (10, 11, 12), (20, 21, 22)", $link);
20 $result = mysql_query("SELECT * FROM test_47438", $link);
32 mysql_query("DROP TABLE IF EXISTS test_47438", $link);
44 !mysql_query("DROP TABLE IF EXISTS test_47438", $link))
H A Dmysql_affected_rows.phpt33 if (!mysql_query('DROP TABLE IF EXISTS test', $link))
39 if (!mysql_query("INSERT INTO test(id, label) VALUES (1, 'a')", $link))
46 @mysql_query("INSERT INTO test(id, label) VALUES (1, 'a')", $link);
56 if (!mysql_query("INSERT INTO test(id, label) VALUES (2, 'b'), (3, 'c')", $link))
62 if (!mysql_query("INSERT IGNORE INTO test(id, label) VALUES (1, 'a')", $link)) {
75 if (!mysql_query("REPLACE INTO test(id, label) values (4, 'd')", $link))
81 if (!mysql_query("REPLACE INTO test(id, label) values (5, 'e')", $link))
87 if (!mysql_query("UPDATE test SET label = 'a' WHERE id = 2", $link))
93 if (!mysql_query("UPDATE test SET label = 'a' WHERE id = 2", $link)) {
100 if (!mysql_query("UPDATE test SET label = 'a' WHERE id = 100", $link)) {
[all …]
H A Dmysql_max_persistent.phpt9 mysql_query('DROP USER pcontest', $link);
10 if (!mysql_query('CREATE USER pcontest IDENTIFIED BY "pcontest"', $link)) {
17 if (!mysql_query(sprintf("GRANT SELECT ON TABLE %s.test TO pcontest@'%%'", $db), $link)) {
19 mysql_query('REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest', $link);
20 mysql_query('DROP USER pcontest', $link);
72 mysql_query('REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest', $links[0]);
73 mysql_query('DROP USER pcontest', $links[0]);
87 @mysql_query('REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest', $link);
88 @mysql_query('DROP USER pcontest', $link);
H A Dmysql_pconn_max_links.phpt21 if (!$res = mysql_query('SHOW VARIABLES LIKE "old_passwords"', $link)) {
34 if (!$res = mysql_query("SELECT CURRENT_USER() AS _user", $link))
41 mysql_query('DROP USER pcontest', $link);
42 mysql_query(sprintf('DROP USER pcontest@"%s"', mysql_real_escape_string($host, $link)), $link);
90 if (!$res = mysql_query('SELECT id, label FROM test WHERE id = 1', $plink))
101 if (!$res = mysql_query("SELECT CURRENT_USER() AS _user", $link))
109 if (!mysql_query($sql, $link))
114 if (!mysql_query(sprintf('KILL %d', $pthread_id), $link))
119 if (!$res = mysql_query("SHOW FULL PROCESSLIST", $link))
157 if (!$res = mysql_query('SELECT id, label FROM test WHERE id = 1', $plink))
[all …]
H A Dmysql_trace_mode.phpt15 $res1 = mysql_query('SELECT id FROM test', $link);
22 $res3 = mysql_query('BOGUS_SQL', $link);
34 Warning: mysql_query(): You have an error in your SQL syntax; check the manual that corresponds to …
37 …. Use mysql_free_result to free result sets which were requested using mysql_query() in %s on line…
H A Dtable.inc11 if (!mysql_query('DROP TABLE IF EXISTS test', $link)) {
16 if (!mysql_query('CREATE TABLE test(id INT, label CHAR(1), PRIMARY KEY(id)) ENGINE=' . $engine, $li…
21 if (!mysql_query("INSERT INTO test(id, label) VALUES (1, 'a'), (2, 'b'), (3, 'c'), (4, 'd'), (5, 'e…
H A D002.phpt18 var_dump(mysql_query('DROP TABLE IF EXISTS test'));
20 var_dump(mysql_query('CREATE TABLE test(col1 int PRIMARY KEY, col2 varchar(50), col3 char(5))'));
22 var_dump(mysql_query("INSERT INTO test(col1, col2, col3) VALUES(1, 'foo', 'bar'),(2, 'foo', 'bar')"…
24 var_dump($res = mysql_query('SELECT col1, col2, col3 FROM test ORDER BY col1 ASC'));
H A D003.phpt24 if (!mysql_query('DROP TABLE IF EXISTS test', $link))
27 if (!mysql_query("CREATE TABLE test(a varchar(10))", $link))
31 if (!mysql_query(sprintf("INSERT INTO test VALUES('%s')", $str), $link))
36 if (!$res = mysql_query("SELECT a FROM test", $link))
45 if (!$res = mysql_query("SELECT a FROM test", $link))
H A Dmysql_pconn_kill.phpt31 if (!($res = mysql_query("SHOW FULL PROCESSLIST", $link)))
44 if (!mysql_query(sprintf("KILL %d", $pthread_id), $link))
48 if (!($res = mysql_query("SHOW FULL PROCESSLIST", $link)))
71 if (!($res = mysql_query("SELECT 1", $plink)))
77 if (!($res = mysql_query("SELECT 1", $plink)))
85 if (!mysql_query(sprintf("KILL %d", $thread_id), $link2))
92 if (!($res = mysql_query("SELECT * FROM test", $link)))
95 if (!($res = mysql_query("SELECT * FROM test", $link2)))
H A Dmysql_info.phpt19 if (!$res = mysql_query("INSERT INTO test(id, label) VALUES (100, 'a')", $link))
25 if (!$res = mysql_query("INSERT INTO test(id, label) VALUES (101, 'a'), (102, 'b')", $link))
31 if (!$res = mysql_query('INSERT INTO test(id, label) SELECT id + 200, label FROM test', $link))
37 if (!$res = mysql_query('ALTER TABLE test MODIFY label CHAR(2)', $link))
43 if (!$res = mysql_query("UPDATE test SET label = 'b' WHERE id >= 100", $link))
H A Dmysql_fetch_field.phpt29 if (!$res = mysql_query("SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 1", $link)) {
39 if (!$res = mysql_query("SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 1", $link)) {
84 if (!mysql_query("DROP TABLE IF EXISTS test", $link))
86 …if (!mysql_query(sprintf("CREATE TABLE test(id INT, label %s) ENGINE = %s", $type_name, $engine), …
96 if (!mysql_query($insert, $link)) {
104 if (!$res = mysql_query("SELECT id, label FROM test", $link)) {
118 if (!mysql_query("DROP TABLE IF EXISTS test", $link))
121 if (!mysql_query("CREATE TABLE test(id INT DEFAULT 1)"))
124 if (!mysql_query("INSERT INTO test(id) VALUES (2)"))
127 if (!$res = mysql_query("SELECT id FROM test", $link)) {
[all …]
H A Dmysql_create_db.phpt26 if (!mysql_query("CREATE DATABASE mysqlcreatedb", $link))
29 if (!mysql_query("DROP DATABASE mysqlcreatedb", $link))
38 if (!mysql_query("DROP DATABASE mysqlcreatedb", $link))
50 if (!mysql_query("DROP DATABASE IF EXISTS mysqlcreatedb", $link))
H A Dmysql_insert_id.phpt30 if (!$res = mysql_query("SELECT id, label FROM test ORDER BY id LIMIT 1", $link)) {
38 if (!$res = mysql_query("INSERT INTO test(id, label) VALUES (100, 'a')", $link)) {
44 if (!$res = mysql_query("ALTER TABLE test MODIFY id INT NOT NULL AUTO_INCREMENT", $link)) {
47 if (!$res = mysql_query("INSERT INTO test(label) VALUES ('a')", $link)) {
H A Dmysql_drop_db.phpt22 if (!mysql_query('DROP DATABASE IF EXISTS mysqldropdb'))
25 if (!mysql_query('CREATE DATABASE mysqldropdb'))
49 if (!mysql_query("DROP DATABASE IF EXISTS mysqldropdb", $link))
H A Dmysql_list_fields.phpt25 if (!mysql_query("DROP TABLE IF EXISTS test2", $link))
58 if (!mysql_query("DROP TABLE IF EXISTS test", $link))
61 if (!mysql_query("DROP TABLE IF EXISTS test2", $link))
H A Dmysql_field_flags.phpt22 if (!$res = mysql_query("SELECT id, label FROM test ORDER BY id LIMIT 2", $link)) {
96 if (!mysql_query("DROP TABLE IF EXISTS test", $link)) {
101 if (!@mysql_query($sql, $link)) {
109 if (!mysql_query($sql, $link)) {
114 if (!$res = mysql_query(sprintf("SELECT id, %s FROM test", $values[0]), $link)) {
H A Dmysql_query_load_data_openbasedir.phpt86 if (!mysql_query($sql, $link))
89 if (!($res = mysql_query('SELECT label FROM test WHERE id = 97', $link)) ||
97 if (!mysql_query('DELETE FROM test', $link))
105 if (!mysql_query($sql, $link))
H A Dmysql_fetch_assoc.phpt24 if (!$res = mysql_query("SELECT id, label FROM test ORDER BY id LIMIT 1", $link)) {
36 if (!$res = mysql_query("SELECT 1 AS a, 2 AS a, 3 AS c, 4 AS C, NULL AS d, true AS e", $link)) {
50 if (!$res = mysql_query("SELECT id, label, id AS _id, CONCAT(label, 'a') _label, NULL as _foo FROM …
H A Dclean_table.inc10 if (!mysql_query('DROP TABLE IF EXISTS test', $link)) {
H A Dmysql_errno.phpt30 if (!mysql_query('DROP TABLE IF EXISTS test', $link)) {
34 mysql_query('SELECT * FROM test', $link);
H A Dmysql_fetch_array.phpt22 if (!$res = mysql_query("SELECT * FROM test ORDER BY id LIMIT 5", $link)) {
43 if (!$res = mysql_query("SELECT 1 AS a, 2 AS a, 3 AS c, 4 AS C, NULL AS d, true AS e", $link)) {
50 if (!$res = mysql_query("SELECT 1 AS a, 2 AS b, 3 AS c, 4 AS C", $link)) {
73 if (!mysql_query("DROP TABLE IF EXISTS test", $link)) {
78 …if (!mysql_query($sql = sprintf("CREATE TABLE test(id INT NOT NULL, label %s, PRIMARY KEY(id)) ENG…
83 …if (is_null($php_value) && !mysql_query($sql = sprintf("INSERT INTO test(id, label) VALUES (1, NUL…
89 …if (is_int($sql_value) && !mysql_query(sprintf("INSERT INTO test(id, label) VALUES (1, '%d')", $sq…
92 …} else if (!is_int($sql_value) && !mysql_query(sprintf("INSERT INTO test(id, label) VALUES (1, '%s…
98 if (!$res = mysql_query("SELECT id, label FROM test", $link)) {
H A Dmysql_client_encoding.phpt25 if (!$res = mysql_query('SELECT version() AS server_version', $link))
36 if (!$res = mysql_query('SELECT @@character_set_connection AS charset, @@collation_connection AS co…
H A Dmysql_error.phpt33 if (!mysql_query('DROP TABLE IF EXISTS test', $link)) {
37 mysql_query('SELECT * FROM test', $link);

Completed in 37 milliseconds

123