Home
last modified time | relevance | path

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

12345678910>>...20

/PHP-8.0/ext/pdo_oci/tests/
H A Dpdo_oci_attr_module.phpt14 $query = 'select module from v$session where sid = sys_context(\'USERENV\', \'SID\')';
20 $stmt = $dbh->query($query);
27 $stmt = $dbh->query($query);
34 $stmt = $dbh->query($query);
/PHP-8.0/ext/pdo_mysql/tests/
H A Dpdo_mysql_attr_autocommit.phpt20 $row = $db->query('SELECT @@autocommit AS _autocommit')->fetch(PDO::FETCH_ASSOC);
28 $row = $db->query('SELECT @@autocommit AS _autocommit')->fetch(PDO::FETCH_ASSOC);
33 if (!$db->query('SET autocommit = 1'))
40 if (!$db->query('SET autocommit = 0'))
46 $row = $db->query('SELECT @@autocommit AS _autocommit')->fetch(PDO::FETCH_ASSOC);
60 $db->query("INSERT INTO test(id, label) VALUES (100, 'z')");
67 $db->query('ROLLBACK');
75 $db->query('DELETE FROM test WHERE id = 100');
76 $db->query('ROLLBACK');
81 $db->query('DELETE FROM test WHERE id = 100');
[all …]
H A Dpdo_mysql_stmt_unbuffered_2050.phpt2 MySQL PDO:query() vs. PDO::prepare() and MySQL error 2050
27 $stmt = $db->query('SELECT id, label FROM test WHERE id = 1');
29 $stmt = $db->query('SELECT id, label FROM test WHERE id = 1');
35 $stmt = $db->query('SELECT id, label FROM test WHERE id = 1');
41 PDO::query() will prepare and execute a statement in one step.
48 $stmt = PDO::query(<some query>)
56 $stmt = PDO::query(<some query>)
57 PDO::query(<some query>)
63 $stmt = PDO::query(<some query>)
82 - use prepare() + execute() instead of query()
[all …]
H A Dpdo_mysql_attr_multi_statements.phpt27 $stmt = $db->query(sprintf('SELECT * FROM %s; INSERT INTO %s(id) VALUES (2)', $table, $table));
31 $stmt = $db->query(sprintf('SELECT id FROM %s', $table));
33 // A single query with a trailing delimiter.
34 $stmt = $db->query('SELECT 1 AS value;');
40 $stmt = $db->query(sprintf('SELECT * FROM %s; INSERT INTO %s(id) VALUES (3)', $table, $table));
45 $stmt = $db->query(sprintf('SELECT id FROM %s', $table));
47 // A single query with a trailing delimiter.
48 $stmt = $db->query('SELECT 1 AS value;');
76 Warning: PDO::query(): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in…
/PHP-8.0/ext/pdo_dblib/tests/
H A Dbug_47588.phpt12 $db->query('CREATE TABLE "Test Table" ("My Field" int, "Another Field" varchar(32) not null default…
13 $db->query('INSERT INTO "Test Table" ("My Field") values(1)');
14 $db->query('INSERT INTO "Test Table" ("My Field") values(2)');
15 $db->query('INSERT INTO "Test Table" ("My Field") values(3)');
16 $rs = $db->query('SELECT * FROM "Test Table"');
18 $db->query('DROP TABLE "Test Table"');
H A Dbug_68957.phpt2 PDO_DBLIB bug #68957 PDO::query doesn't support several queries
12 $query = "declare @myInt int = 1; select @myInt;";
13 $stmt = $db->query($query);
H A Dtimeout.phpt2 PDO_DBLIB: Set query timeouts
21 … timeout attribute, set after instance created, will affect query timeout, causing this query to f…
35 …timeout attribute, set after instance created, will control query timeout, causing this query to f…
49 // regular timeout attribute will affect query timeout, causing this query to fail
61 // pdo_dblib-specific timeout attribute will control query timeout, causing this query to fail
/PHP-8.0/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.phpt13 $db->query('CREATE TABLE IF NOT EXISTS foobar (id INT AUTO INCREMENT, name TEXT)');
15 $db->query('INSERT INTO foobar VALUES (NULL, "PHP")');
16 $db->query('INSERT INTO foobar VALUES (NULL, "PHP6")');
22 foreach ($db->query('SELECT testing(name) FROM foobar') as $row) {
26 $db->query('DROP TABLE foobar');
H A Dpdo_fetch_func_001.phpt17 $st = $db->query('SELECT * FROM testing');
20 $st = $db->query('SELECT name FROM testing');
24 $st = $db->query('SELECT * FROM testing');
31 $st = $db->query('SELECT * FROM testing');
38 $st = $db->query('SELECT * FROM testing');
45 $st = $db->query('SELECT * FROM testing');
52 $st = $db->query('SELECT * FROM testing');
84 $st = $db->query('SELECT * FROM testing');
88 $st = $db->query('SELECT * FROM testing');
95 $st = $db->query('SELECT * FROM testing');
[all …]
/PHP-8.0/ext/mysqli/tests/
H A Dmysqli_autocommit_oo.phpt30 if (!$mysqli->query('SET AUTOCOMMIT = 0'))
51 if (!$mysqli->query('DROP TABLE IF EXISTS test'))
58 if (!$mysqli->query('INSERT INTO test(id) VALUES (1)'))
61 if (!$mysqli->query('ROLLBACK'))
73 if (!$mysqli->query('DROP TABLE IF EXISTS test'))
76 if (!$mysqli->query('SET AUTOCOMMIT = 1'))
94 if (!$mysqli->query('INSERT INTO test(id) VALUES (1)'))
97 if (!$mysqli->query('ROLLBACK'))
107 if (!$mysqli->query('INSERT INTO test(id) VALUES (1)'))
110 if (!$mysqli->query('COMMIT'))
[all …]
H A Dmysqli_pam_sha256_public_key_ini.phpt22 if (!($res = $link->query("SHOW PLUGINS"))) {
36 if (!($res = $link->query("SHOW STATUS LIKE 'Rsa_public_key'"))) {
61 if (!$link->query("SET @@session.old_passwords=2")) {
66 $link->query('DROP USER shatest');
67 $link->query("DROP USER shatest@localhost");
80 if (!$link->query("DROP TABLE IF EXISTS test") ||
81 !$link->query("CREATE TABLE test (id INT)") ||
82 !$link->query("INSERT INTO test(id) VALUES (1), (2), (3)"))
104 if (!$res = $link->query("SELECT id FROM test WHERE id = 1"))
120 $link->query('DROP USER shatest');
[all …]
H A Dbug75018.phpt16 $mysqli->query($sql);
19 $mysqli->query($sql);
22 $mysqli->query($sql);
24 $mysqli->query($sql);
27 $result = $mysqli->query($sql);
H A Dmysqli_pam_sha256_public_key_option.phpt22 if (!($res = $link->query("SHOW PLUGINS"))) {
36 if (!($res = $link->query("SHOW STATUS LIKE 'Rsa_public_key'"))) {
58 if (!$link->query("SET @@session.old_passwords=2")) {
62 $link->query('DROP USER shatest');
63 $link->query("DROP USER shatest@localhost");
76 if (!$link->query("DROP TABLE IF EXISTS test") ||
77 !$link->query("CREATE TABLE test (id INT)") ||
78 !$link->query("INSERT INTO test(id) VALUES (1), (2), (3)"))
105 if (!$res = $link->query("SELECT id FROM test WHERE id = 1"))
125 $link->query('DROP USER shatest');
[all …]
H A Dgh8267.phpt13 $mysqli->query("DROP TABLE IF EXISTS foo");
14 $mysqli->query("CREATE TABLE foo (id BIGINT UNSIGNED AUTO_INCREMENT, PRIMARY KEY (id))");
15 $mysqli->query("INSERT INTO foo VALUES (9223372036854775807)");
17 $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
11 $result = $link->query("SHOW VARIABLES LIKE 'max_allowed_packet'");
27 $mysqli->query("DROP TABLE IF EXISTS test");
28 $mysqli->query("CREATE TABLE test (`blob` LONGBLOB NOT NULL) ENGINE=MyISAM");
31 $mysqli->query("INSERT INTO $db.test(`blob`) VALUE ('$data')");
42 $mysqli->query("INSERT INTO $db.test(`blob`) VALUE ('$data')");
/PHP-8.0/ext/pdo/tests/
H A Dpdo_023.phpt50 function query($sql, ...$rest)
63 $db->query('CREATE TABLE test(id INT NOT NULL PRIMARY KEY, val VARCHAR(10))');
64 $db->query('INSERT INTO test VALUES(0, \'A\')');
65 $db->query('INSERT INTO test VALUES(1, \'B\')');
68 $stmt = $db->query('SELECT val, id FROM test');
86 PDODatabaseX::query()
89 PDODatabaseX::query()
92 PDODatabaseX::query()
95 PDODatabaseX::query()
/PHP-8.0/ext/standard/tests/url/
H A Dbug69976.phpt14 ["query"]=>
20 ["query"]=>
26 ["query"]=>
32 ["query"]=>
/PHP-8.0/ext/sqlite3/
H A Dsqlite3.stub.php51 public function prepare(string $query) {} argument
54 public function exec(string $query) {} argument
57 public function query(string $query) {} argument
60 public function querySingle(string $query, bool $entireRow = false) {} argument
86 private function __construct(SQLite3 $sqlite3, string $query) {} argument
/PHP-8.0/Zend/tests/variadic/
H A Dremoving_parameter_error.phpt7 public function query($query, ...$params);
11 public function query(...$params) { }
/PHP-8.0/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.0/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);
/PHP-8.0/ext/pdo_pgsql/tests/
H A Dbug43925.phpt15 @$dbh->query('DROP TABLE nodes');
17 $dbh->query('
26 $dbh->query('INSERT INTO nodes (id, root, lft, rgt) VALUES (1, 1, 1, 6);');
27 $dbh->query('INSERT INTO nodes (id, root, lft, rgt) VALUES (2, 1, 2, 3);');
28 $dbh->query('INSERT INTO nodes (id, root, lft, rgt) VALUES (3, 1, 4, 5);');
53 $dbh->query('DROP TABLE nodes');

Completed in 49 milliseconds

12345678910>>...20