Home
last modified time | relevance | path

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

12345678910>>...22

/PHP-8.1/ext/mysqli/tests/
H A Dgh7837.phpt18 $mysql->query("DROP TABLE IF EXISTS test");
19 $mysql->query("CREATE TABLE test (`ubigint` bigint unsigned NOT NULL) ENGINE=InnoDB");
20 $mysql->query("INSERT INTO test (`ubigint`) VALUES (18446744073709551615)");
21 $mysql->query("INSERT INTO test (`ubigint`) VALUES (9223372036854775808)");
22 $mysql->query("INSERT INTO test (`ubigint`) VALUES (1)");
23 $result = $mysql->query("SELECT ubigint FROM test");
H A Dmysqli_autocommit_oo.phpt31 if (!$mysqli->query('SET AUTOCOMMIT = 0'))
52 if (!$mysqli->query('DROP TABLE IF EXISTS test'))
59 if (!$mysqli->query('INSERT INTO test(id) VALUES (1)'))
62 if (!$mysqli->query('ROLLBACK'))
74 if (!$mysqli->query('DROP TABLE IF EXISTS test'))
77 if (!$mysqli->query('SET AUTOCOMMIT = 1'))
95 if (!$mysqli->query('INSERT INTO test(id) VALUES (1)'))
98 if (!$mysqli->query('ROLLBACK'))
108 if (!$mysqli->query('INSERT INTO test(id) VALUES (1)'))
111 if (!$mysqli->query('COMMIT'))
[all …]
H A Dmysqli_pam_sha256_public_key_ini.phpt23 if (!($res = $link->query("SHOW PLUGINS"))) {
37 if (!($res = $link->query("SHOW STATUS LIKE 'Rsa_public_key'"))) {
62 $link->query("SET @@session.old_passwords=2");
64 $link->query('DROP USER shatest');
65 $link->query("DROP USER shatest@localhost");
73 if (!$link->query('SET PASSWORD FOR shatest@"%" = "shatest"') ||
78 if (!$link->query("DROP TABLE IF EXISTS test") ||
79 !$link->query("CREATE TABLE test (id INT)") ||
80 !$link->query("INSERT INTO test(id) VALUES (1), (2), (3)"))
119 $link->query('DROP USER shatest');
[all …]
H A Dmysqli_pam_sha256_public_key_option.phpt23 if (!($res = $link->query("SHOW PLUGINS"))) {
37 if (!($res = $link->query("SHOW STATUS LIKE 'Rsa_public_key'"))) {
59 $link->query("SET @@session.old_passwords=2");
61 $link->query('DROP USER shatest');
62 $link->query("DROP USER shatest@localhost");
70 if (!$link->query('SET PASSWORD FOR shatest@"%" = "shatest"') ||
75 if (!$link->query("DROP TABLE IF EXISTS test") ||
76 !$link->query("CREATE TABLE test (id INT)") ||
77 !$link->query("INSERT INTO test(id) VALUES (1), (2), (3)"))
125 $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 Dgh8267.phpt14 $mysqli->query("DROP TABLE IF EXISTS foo");
15 $mysqli->query("CREATE TABLE foo (id BIGINT UNSIGNED AUTO_INCREMENT, PRIMARY KEY (id))");
16 $mysqli->query("INSERT INTO foo VALUES (9223372036854775807)");
18 $mysqli->query("INSERT INTO foo VALUES (0)");
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')");
/PHP-8.1/ext/pdo_mysql/tests/
H A Dbug75177.phpt17 $pdo->query("DROP TABLE IF EXISTS $tbl");
18 $pdo->query("CREATE TABLE $tbl (`bit` bit(8)) ENGINE=InnoDB");
19 $pdo->query("INSERT INTO $tbl (`bit`) VALUES (1)");
20 $pdo->query("INSERT INTO $tbl (`bit`) VALUES (0b011)");
21 $pdo->query("INSERT INTO $tbl (`bit`) VALUES (0b01100)");
24 $ret = $pdo->query("SELECT * FROM $tbl")->fetchAll();
30 $ret = $pdo->query("SELECT * FROM $tbl")->fetchAll();
H A Dunsigned_bigint.phpt19 $pdo->query("DROP TABLE IF EXISTS $tbl");
20 $pdo->query("CREATE TABLE $tbl (`ubigint` bigint unsigned NOT NULL) ENGINE=InnoDB");
21 $pdo->query("INSERT INTO $tbl (`ubigint`) VALUES (18446744073709551615)");
22 $pdo->query("INSERT INTO $tbl (`ubigint`) VALUES (9223372036854775808)");
23 $pdo->query("INSERT INTO $tbl (`ubigint`) VALUES (1)");
24 $result = $pdo->query("SELECT ubigint FROM $tbl")->fetchAll(PDO::FETCH_ASSOC);
H A Dbug76815.phpt17 $pdo->query('DROP FUNCTION IF EXISTS tst');
18 $pdo->query('DROP PROCEDURE IF EXISTS tst2');
19 $pdo->query('CREATE FUNCTION tst() RETURNS VARCHAR(5) DETERMINISTIC BEGIN RETURN \'x12345\'; END');
20 $pdo->query('CREATE PROCEDURE tst2() BEGIN SELECT tst(); END');
36 $pdo->query('DROP FUNCTION IF EXISTS tst');
37 $pdo->query('DROP PROCEDURE IF EXISTS tst2');
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;');
79 Warning: PDO::query(): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in…
/PHP-8.1/ext/pdo_dblib/tests/
H A Dbug_47588.phpt13 $db->query('CREATE TABLE "Test Table" ("My Field" int, "Another Field" varchar(32) not null default…
14 $db->query('INSERT INTO "Test Table" ("My Field") values(1)');
15 $db->query('INSERT INTO "Test Table" ("My Field") values(2)');
16 $db->query('INSERT INTO "Test Table" ("My Field") values(3)');
17 $rs = $db->query('SELECT * FROM "Test Table"');
19 $db->query('DROP TABLE "Test Table"');
H A Dbug_68957.phpt2 PDO_DBLIB bug #68957 PDO::query doesn't support several queries
13 $query = "declare @myInt int = 1; select @myInt;";
14 $stmt = $db->query($query);
H A Dtimeout.phpt2 PDO_DBLIB: Set query timeouts
16 … timeout attribute, set after instance created, will affect query timeout, causing this query to f…
30 …timeout attribute, set after instance created, will control query timeout, causing this query to f…
44 // regular timeout attribute will affect query timeout, causing this query to fail
56 // pdo_dblib-specific timeout attribute will control query timeout, causing this query to fail
/PHP-8.1/Zend/tests/variadic/
H A Dadding_additional_optional_parameter.phpt7 public function query($query, string ...$params);
11 public function query($query, string $extraParam = null, string ...$params) { }
/PHP-8.1/ext/pdo_sqlite/tests/
H A Dpdo_sqlite_lastinsertid.phpt9 $db->query('CREATE TABLE IF NOT EXISTS foo (id INT AUTO INCREMENT, name TEXT)');
10 $db->query('INSERT INTO foo VALUES (NULL, "PHP")');
11 $db->query('INSERT INTO foo VALUES (NULL, "PHP6")');
12 var_dump($db->query('SELECT * FROM foo'));
16 $db->query('DROP TABLE foo');
H A Dpdo_sqlite_createaggregate.phpt10 $db->query('CREATE TABLE IF NOT EXISTS foobar (id INT AUTO INCREMENT, name TEXT)');
12 $db->query('INSERT INTO foobar VALUES (NULL, "PHP")');
13 $db->query('INSERT INTO foobar VALUES (NULL, "PHP6")');
18 foreach ($db->query('SELECT testing(name) FROM foobar') as $row) {
22 $db->query('DROP TABLE foobar');
H A Dpdo_sqlite_createfunction.phpt10 $db->query('CREATE TABLE IF NOT EXISTS foobar (id INT AUTO INCREMENT, name TEXT)');
12 $db->query('INSERT INTO foobar VALUES (NULL, "PHP")');
13 $db->query('INSERT INTO foobar VALUES (NULL, "PHP6")');
19 foreach ($db->query('SELECT testing(name) FROM foobar') as $row) {
23 $db->query('DROP TABLE foobar');
H A Dpdo_sqlite_createfunction_with_flags.phpt14 $db->query('CREATE TABLE IF NOT EXISTS foobar (id INT AUTO INCREMENT, name TEXT)');
16 $db->query('INSERT INTO foobar VALUES (NULL, "PHP")');
17 $db->query('INSERT INTO foobar VALUES (NULL, "PHP6")');
23 foreach ($db->query('SELECT testing(name) FROM foobar') as $row) {
27 $db->query('DROP TABLE foobar');
/PHP-8.1/ext/pdo/tests/
H A Dpdo_023.phpt51 function query($sql, ...$rest): PDOStatement|false
64 $db->query('CREATE TABLE test(id INT NOT NULL PRIMARY KEY, val VARCHAR(10))');
65 $db->query('INSERT INTO test VALUES(0, \'A\')');
66 $db->query('INSERT INTO test VALUES(1, \'B\')');
69 $stmt = $db->query('SELECT val, id FROM test');
87 PDODatabaseX::query()
90 PDODatabaseX::query()
93 PDODatabaseX::query()
96 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…
32 $query .= ' FROM DUAL';
35 $query .= ' FROM RDB$DATABASE';
39 $stmt = $db->query($query);
44 …query in use, the number of parameters used (Params), the list of parameters, with their name, typ…
/PHP-8.1/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:
/PHP-8.1/ext/standard/tests/url/
H A Dbug69976.phpt14 ["query"]=>
20 ["query"]=>
26 ["query"]=>
32 ["query"]=>
/PHP-8.1/ext/oci8/tests/
H A Dbug38161.phpt10 $query = "begin if false then :bv := 1; end if; end;";
11 $stid = oci_parse($c, $query);
18 $query = "begin if false then :bv := 1; end if; end;";
19 $stid = oci_parse($c, $query);

Completed in 26 milliseconds

12345678910>>...22