Home
last modified time | relevance | path

Searched refs:query (Results 26 – 50 of 576) sorted by relevance

12345678910>>...24

/php-src/ext/mysqli/tests/
H A Dmysqli_pam_sha256_public_key_option.phpt21 if (!($res = $link->query("SHOW PLUGINS"))) {
35 if (!($res = $link->query("SHOW STATUS LIKE 'Rsa_public_key'"))) {
57 $link->query("SET @@session.old_passwords=2");
59 $link->query('DROP USER shatest');
60 $link->query("DROP USER shatest@localhost");
68 if (!$link->query('SET PASSWORD FOR shatest@"%" = "shatest"') ||
73 if (!$link->query("DROP TABLE IF EXISTS test") ||
74 !$link->query("CREATE TABLE test (id INT)") ||
75 !$link->query("INSERT INTO test(id) VALUES (1), (2), (3)"))
123 $link->query('DROP USER shatest');
[all …]
H A Dgh11438.phpt22 if (!($res = $link->query("SHOW PLUGINS"))) {
37 $link->query("SET @@session.old_passwords=2");
39 $link->query('DROP USER shatest');
40 $link->query("DROP USER shatest@localhost");
42 if (!$link->query('CREATE USER shatest@"%" IDENTIFIED WITH sha256_password') ||
43 !$link->query('CREATE USER shatest@"localhost" IDENTIFIED WITH sha256_password')) {
48 if (!$link->query('SET PASSWORD FOR shatest@"%" = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUV…
49 …!$link->query('SET PASSWORD FOR shatest@"localhost" = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQ…
63 if (!$res = $link->query("SELECT USER()"))
84 $link->query('DROP USER shatest');
[all …]
H A Dbug75018.phpt17 $mysqli->query($sql);
20 $mysqli->query($sql);
23 $mysqli->query($sql);
25 $mysqli->query($sql);
28 $result = $mysqli->query($sql);
H A Dmysqli_affected_rows_oo.phpt25 if (!$mysqli->query('DROP TABLE IF EXISTS test'))
31 if (!$mysqli->query("INSERT INTO test(id, label) VALUES (1, 'a')"))
38 $mysqli->query("INSERT INTO test(id, label) VALUES (1, 'a')");
48 if (!$mysqli->query("INSERT INTO test(id, label) VALUES (2, 'b'), (3, 'c')"))
54 if (!$mysqli->query("INSERT IGNORE INTO test(id, label) VALUES (1, 'a')")) {
67 if (!$mysqli->query("REPLACE INTO test(id, label) values (4, 'd')"))
73 if (!$mysqli->query("REPLACE INTO test(id, label) values (5, 'e')"))
79 if (!$mysqli->query("UPDATE test SET label = 'a' WHERE id = 2"))
85 if (!$mysqli->query("UPDATE test SET label = 'a' WHERE id = 2")) {
92 if (!$mysqli->query("UPDATE test SET label = 'a' WHERE id = 100")) {
[all …]
H A Dmysqli_real_connect_compression_error.phpt2 Bug #80107 mysqli_query() fails for ~16 MB long query when compression is enabled
12 $result = $link->query("SHOW VARIABLES LIKE 'max_allowed_packet'");
28 $mysqli->query("DROP TABLE IF EXISTS test");
29 $mysqli->query("CREATE TABLE test (`blob` LONGBLOB NOT NULL) ENGINE=MyISAM");
32 $mysqli->query("INSERT INTO $db.test(`blob`) VALUE ('$data')");
43 $mysqli->query("INSERT INTO $db.test(`blob`) VALUE ('$data')");
H A Dmysqli_expire_password.phpt20 $result = $link->query("select @@disconnect_on_expired_password");
46 if (!$link->query("DROP TABLE IF EXISTS test") ||
47 !$link->query("CREATE TABLE test (id INT)") || !$link->query("INSERT INTO test(id) VALUES (1)"))
69 $link->query("SELECT id FROM test WHERE id = 1");
80 $link->query("SELECT id FROM test WHERE id = 1");
91 $link->query("SELECT id FROM test WHERE id = 1");
103 if (!$link->query("SET PASSWORD='expiretest'")) {
104 $link->query("SET PASSWORD=PASSWORD('expiretest')");
107 if ($res = $link->query("SELECT id FROM test WHERE id = 1"))
118 $link->query("SELECT id FROM test WHERE id = 1");
[all …]
H A Dmysqli_pam_sha256_public_key_option_invalid.phpt21 if (!($res = $link->query("SHOW PLUGINS"))) {
35 if (!($res = $link->query("SHOW STATUS LIKE 'Rsa_public_key'"))) {
57 $link->query("SET @@session.old_passwords=2");
59 $link->query('DROP USER shatest');
60 $link->query("DROP USER shatest@localhost");
68 if (!$link->query('SET PASSWORD FOR shatest@"%" = "shatest"') ||
73 if (!$link->query("DROP TABLE IF EXISTS test") ||
74 !$link->query("CREATE TABLE test (id INT)") ||
75 !$link->query("INSERT INTO test(id) VALUES (1), (2), (3)"))
167 $link->query('DROP USER shatest');
[all …]
H A Dbug52082.phpt17 var_dump($link->query("show variables like 'character_set_client'")->fetch_row());
18 var_dump($link->query("show variables like 'character_set_connection'")->fetch_row());
20 var_dump($link->query("show variables like 'character_set_client'")->fetch_row());
21 var_dump($link->query("show variables like 'character_set_connection'")->fetch_row());
/php-src/ext/pdo_sqlite/tests/
H A Dpdo_sqlite_transaction.phpt13 $db->query('CREATE TABLE test_pdo_sqlite_transaction (id INT AUTO INCREMENT, name TEXT)');
17 $db->query('INSERT INTO test_pdo_sqlite_transaction VALUES (NULL, "PHP"), (NULL, "PHP6")');
20 $r = $db->query('SELECT COUNT(*) FROM test_pdo_sqlite_transaction');
23 $db->query('DROP TABLE test_pdo_sqlite_transaction');
29 Warning: PDO::query(): SQLSTATE[HY000]: General error: 6 database table is locked in %s on line %d
H A Dpdo_fetch_func_001.phpt14 $st = $db->query('SELECT * FROM test_fetch_func_001');
22 $st = $db->query('SELECT name FROM test_fetch_func_001');
26 $st = $db->query('SELECT * FROM test_fetch_func_001');
33 $st = $db->query('SELECT * FROM test_fetch_func_001');
40 $st = $db->query('SELECT * FROM test_fetch_func_001');
47 $st = $db->query('SELECT * FROM test_fetch_func_001');
54 $st = $db->query('SELECT * FROM test_fetch_func_001');
86 $st = $db->query('SELECT * FROM test_fetch_func_001');
90 $st = $db->query('SELECT * FROM test_fetch_func_001');
97 $st = $db->query('SELECT * FROM test_fetch_func_001');
[all …]
H A Dpdo_sqlite_createcollation.phpt11 $db->query('CREATE TABLE test_pdo_sqlite_createcollation (id INT AUTO INCREMENT, name TEXT)');
13 $db->query('INSERT INTO test_pdo_sqlite_createcollation VALUES (NULL, "1"), (NULL, "2"), (NULL, "10…
17 $result = $db->query('SELECT name FROM test_pdo_sqlite_createcollation ORDER BY name COLLATE MYCOLL…
22 $result = $db->query('SELECT name FROM test_pdo_sqlite_createcollation ORDER BY name');
/php-src/ext/pdo/tests/
H A Dpdo_023.phpt53 function query($sql, ...$rest): PDOStatement|false
66 $db->query('CREATE TABLE test023(id INT NOT NULL PRIMARY KEY, val VARCHAR(10))');
67 $db->query("INSERT INTO test023 VALUES(0, 'A')");
68 $db->query("INSERT INTO test023 VALUES(1, 'B')");
71 $stmt = $db->query('SELECT val, id FROM test023');
95 PDODatabaseX::query()
98 PDODatabaseX::query()
101 PDODatabaseX::query()
104 PDODatabaseX::query()
H A Dbug_69356.phpt2 PDO Common: Bug #69356 (PDOStatement::debugDumpParams() truncates query)
9 if (!strncasecmp(getenv('PDOTEST_DSN'), 'oci', strlen('oci'))) die('skip query not supported');
20 $query = <<<'SQL'
22 …query in use, the number of parameters used (Params), the list of parameters, with their name, typ…
35 $query .= $from;
37 $stmt = $db->query($query);
42 …query in use, the number of parameters used (Params), the list of parameters, with their name, typ…
/php-src/ext/pdo_dblib/tests/
H A Dbug_68957.phpt2 PDO_DBLIB bug #68957 PDO::query doesn't support several queries
16 $query = "declare @myInt int = 1; select @myInt;";
17 $stmt = $db->query($query);
H A Dpdodblib_001.phpt16 $db->query("CREATE TABLE #pdo_dblib_001(name VARCHAR(32)); ");
17 $db->query("INSERT INTO #pdo_dblib_001 VALUES('PHP'), ('PHP6');");
19 foreach ($db->query('SELECT name FROM #pdo_dblib_001') as $row) {
29 $db->query('DROP TABLE IF EXISTS #pdo_dblib_001');
/php-src/ext/pdo_mysql/tests/
H A Dpdo_mysql_attr_multi_statements.phpt29 $stmt = $db->query(sprintf('SELECT * FROM %s; INSERT INTO %s(id) VALUES (2)', $table, $table));
33 $stmt = $db->query(sprintf('SELECT id FROM %s', $table));
35 // A single query with a trailing delimiter.
36 $stmt = $db->query('SELECT 1 AS value;');
43 $stmt = $db->query(sprintf('SELECT * FROM %s; INSERT INTO %s(id) VALUES (3)', $table, $table));
48 $stmt = $db->query(sprintf('SELECT id FROM %s', $table));
50 // A single query with a trailing delimiter.
51 $stmt = $db->query('SELECT 1 AS value;');
60 $db->query('DROP TABLE IF EXISTS pdo_mysql_attr_multi_statements');
84 Warning: PDO::query(): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in…
H A Dunsigned_bigint.phpt18 $pdo->query("CREATE TABLE $tbl (`ubigint` bigint unsigned NOT NULL) ENGINE=InnoDB");
19 $pdo->query("INSERT INTO $tbl (`ubigint`) VALUES (18446744073709551615)");
20 $pdo->query("INSERT INTO $tbl (`ubigint`) VALUES (9223372036854775808)");
21 $pdo->query("INSERT INTO $tbl (`ubigint`) VALUES (1)");
22 $result = $pdo->query("SELECT ubigint FROM $tbl")->fetchAll(PDO::FETCH_ASSOC);
/php-src/ext/sqlite3/tests/
H A Dsqlite3stmt_paramCount_basic.phpt27 foreach($queryArray as $key => $query) {
28 $stmt = $db->prepare($query);
30 echo 'Param count for query ' . ($key + 1) . ":\n";
49 Param count for query 1:
51 Param count for query 2:
53 Param count for query 3:
55 Param count for query 4:
H A Dsqlite3_39_toggleExtended.phpt10 $db->query("CREATE TABLE dog ( id INTEGER PRIMARY KEY, name TEXT, annoying INTEGER )");
13 $result = $db->query("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)");
17 $result = $db->query("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)");
22 $result = $db->query("INSERT INTO DOG VALUES (1, 'Annoying Dog', 1)");
34 Warning: SQLite3::query(): Unable to execute statement: UNIQUE constraint failed: dog.id in %s on l…
38 Warning: SQLite3::query(): Unable to execute statement: UNIQUE constraint failed: dog.id in %s on l…
/php-src/ext/standard/tests/url/
H A Dbug69976.phpt14 ["query"]=>
20 ["query"]=>
26 ["query"]=>
32 ["query"]=>
/php-src/Zend/tests/variadic/
H A Dremoving_parameter_error.phpt7 public function query($query, ...$params);
11 public function query(...$params) { }
/php-src/ext/pdo_sqlite/tests/subclasses/
H A Dpdosqlite_001.phpt10 $db->query('CREATE TABLE pdosqlite_001 (id INT AUTO INCREMENT, name TEXT)');
12 $db->query('INSERT INTO pdosqlite_001 VALUES (NULL, "PHP")');
13 $db->query('INSERT INTO pdosqlite_001 VALUES (NULL, "PHP6")');
17 foreach ($db->query('SELECT testing(name) FROM pdosqlite_001') as $row) {
/php-src/ext/mbstring/tests/
H A Dmb_parse_str.phpt14 function test($query) {
17 mb_parse_str($query, $array);
22 foreach ($queries as $query) {
23 test($query);
H A Dmb_parse_str02.phpt14 function test($query) {
18 mb_parse_str($query, $array);
24 foreach ($queries as $query) {
25 test($query);
/php-src/ext/zend_test/tests/
H A Dobserver_sqlite_create_function.phpt21 foreach ($db->query('SELECT returnOne()') as $row) {
36 <!-- init PDO::query() -->
37 <PDO::query>
41 </PDO::query>

Completed in 31 milliseconds

12345678910>>...24