Home
last modified time | relevance | path

Searched refs:query (Results 1 – 25 of 491) sorted by relevance

12345678910>>...20

/PHP-8.0/ext/pdo_firebird/tests/
H A Dbug_77863.phpt28 $query->execute();
32 $query->execute();
36 $query->execute();
40 $query->execute();
44 $query->execute();
48 $query->execute();
52 $query->execute();
57 $query->execute();
61 $query->execute();
65 $query->execute();
[all …]
H A Ddialect_1.phpt25 $query = $dbh->prepare($sql);
26 $query->execute();
27 $row = $query->fetch(\PDO::FETCH_OBJ);
33 unset($query);
37 $query = $dbh->prepare($sql);
38 $query->execute([0.76, '2019-06-12']);
39 unset($query);
42 $query = $dbh->prepare($sql);
43 $query->execute();
44 $row = $query->fetch(\PDO::FETCH_OBJ);
[all …]
H A Dignore_parammarks.phpt20 $query = $dbh->prepare($sql);
21 $query->execute(['d' => 1, 'e' => 2]);
22 $row = $query->fetch(\PDO::FETCH_OBJ);
24 unset($query);
31 $query = $dbh->prepare($sql);
32 $query->execute(['d' => 1, 'e' => 2]);
33 $row = $query->fetch(\PDO::FETCH_OBJ);
35 unset($query);
/PHP-8.0/ext/pdo_pgsql/tests/
H A Dbug62593.phpt21 $query->execute();
22 $errors[] = $query->errorInfo();
26 $query->execute();
27 $errors[] = $query->errorInfo();
33 $query->execute();
34 $errors[] = $query->errorInfo();
40 $query->execute();
41 $errors[] = $query->errorInfo();
42 var_dump($query->fetchColumn());
46 $query->execute();
[all …]
/PHP-8.0/ext/standard/tests/url/
H A Dbug74780.phpt2 Bug #74780 parse_url() borks when query string contains colon
6 parse_url('//php.net/path?query=1:2'),
7 parse_url('//php.net/path.php?query=a:b'),
8 parse_url('//username@php.net/path?query=1:2')
18 ["query"]=>
19 string(9) "query=1:2"
26 ["query"]=>
27 string(9) "query=a:b"
36 ["query"]=>
37 string(9) "query=1:2"
/PHP-8.0/ext/mysqli/tests/
H A Dbug79375.phpt25 echo "Running query on $name\n";
26 $stmt = $mysqli->prepare($query);
39 echo "Running query on $name\n";
55 $res = $mysqli->query($query);
81 $res = $mysqli->query($query, MYSQLI_USE_RESULT);
147 Running query on first connection
149 Running query on second connection
152 Running query on first connection
157 Running query on first connection
162 Running query on first connection
[all …]
H A Dmysqli_pam_sha256.phpt22 if (!($res = $link->query("SHOW PLUGINS"))) {
36 if (!($res = $link->query("SHOW STATUS LIKE 'Rsa_public_key'"))) {
48 if (!$link->query("SET @@session.old_passwords=2")) {
52 $link->query('DROP USER shatest');
53 $link->query("DROP USER shatest@localhost");
66 if (!$link->query("DROP TABLE IF EXISTS test") ||
67 !$link->query("CREATE TABLE test (id INT)") ||
68 !$link->query("INSERT INTO test(id) VALUES (1), (2), (3)"))
88 if (!$res = $link->query("SELECT id FROM test WHERE id = 1"))
108 $link->query('DROP USER shatest');
[all …]
H A Dgh7837.phpt17 $mysql->query("DROP TABLE IF EXISTS test");
18 $mysql->query("CREATE TABLE test (`ubigint` bigint unsigned NOT NULL) ENGINE=InnoDB");
19 $mysql->query("INSERT INTO test (`ubigint`) VALUES (18446744073709551615)");
20 $mysql->query("INSERT INTO test (`ubigint`) VALUES (9223372036854775808)");
21 $mysql->query("INSERT INTO test (`ubigint`) VALUES (1)");
22 $result = $mysql->query("SELECT ubigint FROM test");
/PHP-8.0/Zend/tests/variadic/
H A Dvariadic_changed_byref_error.phpt7 public function query($query, &...$params);
11 public function query($query, ...$params) { }
16 Fatal error: Declaration of MySQL::query($query, ...$params) must be compatible with DB::query($que…
H A Dvariadic_changed_typehint_error.phpt7 public function query($query, string ...$params);
11 public function query($query, int ...$params) { }
16 Fatal error: Declaration of MySQL::query($query, int ...$params) must be compatible with DB::query(…
H A Dnon_variadic_implements_variadic_error.phpt7 public function query($query, ...$params);
11 public function query($query, $params) { }
16 Fatal error: Declaration of MySQL::query($query, $params) must be compatible with DB::query($query,…
H A Dadding_additional_optional_parameter_error.phpt7 public function query($query, string ...$params);
11 public function query($query, int $extraParam = null, string ...$params) { }
16 …ror: Declaration of MySQL::query($query, ?int $extraParam = null, string ...$params) must be compa…
H A Dvariadic_implements_non_variadic.phpt7 public function query($query);
11 public function query($query, ...$params) { }
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.0/ext/pdo_dblib/tests/
H A Dbug_38955.phpt13 $db->query("CREATE table php_test(val int)");
15 $db->query("INSERT INTO php_test(val) values(1)");
16 $db->query("INSERT INTO php_test(val) values(2)");
17 $db->query("INSERT INTO php_test(val) values(3)");
18 $db->query("INSERT INTO php_test(val) values(4)");
23 $db->query("INSERT INTO php_test(val) values(5)");
24 $db->query("INSERT INTO php_test(val) values(6)");
25 $db->query("INSERT INTO php_test(val) values(7)");
26 $db->query("INSERT INTO php_test(val) values(8)");
29 $rs = $db->query("SELECT * FROM php_test");
[all …]
/PHP-8.0/ext/pdo_mysql/tests/
H A Dbug_51670.phpt2 Bug #51670 (getColumnMeta causes segfault when re-executing query after calling nextRowset)
14 $query = $db->prepare('SELECT 1 AS num');
15 $query->execute();
16 if(!is_array($query->getColumnMeta(0))) die('FAIL!');
17 $query->nextRowset();
18 $query->execute();
19 if(!is_array($query->getColumnMeta(0))) die('FAIL!');
H A Dbug79375.phpt31 echo "Running query on $name\n";
33 $stmt = $db->query($query);
44 echo "Running query on $name\n";
45 $stmt = $db->prepare($query);
60 $stmt = $db->prepare($query);
100 Running query on first connection
102 Running query on second connection
105 Running query on first connection
107 Running query on second connection
110 Running query on first connection
[all …]
H A Dpdo_mysql_rollback.phpt23 $db->query("INSERT INTO test(id, label) VALUES (100, 'z')");
37 $db->query('DROP TABLE IF EXISTS test2');
38 $db->query('CREATE TABLE test2(id INT)');
50 $db->query('DROP TABLE IF EXISTS test2');
51 $db->query('CREATE TABLE test2(id INT) ENGINE=MyISAM');
53 $db->query('INSERT INTO test2(id) VALUES (1)');
59 $db->query('DROP TABLE IF EXISTS test2');
63 $db->query('DELETE FROM test');
69 $db->query('DELETE FROM test');
75 $db->query('DELETE FROM test');
[all …]
H A Dbug75177.phpt15 $pdo->query("DROP TABLE IF EXISTS $tbl");
16 $pdo->query("CREATE TABLE $tbl (`bit` bit(8)) ENGINE=InnoDB");
17 $pdo->query("INSERT INTO $tbl (`bit`) VALUES (1)");
18 $pdo->query("INSERT INTO $tbl (`bit`) VALUES (0b011)");
19 $pdo->query("INSERT INTO $tbl (`bit`) VALUES (0b01100)");
21 $ret = $pdo->query("SELECT * FROM $tbl")->fetchAll();
/PHP-8.0/ext/pdo_oci/tests/
H A Dpdo_oci_attr_action.phpt14 $query = 'select action from v$session where sid = sys_context(\'USERENV\', \'SID\')';
18 $stmt = $dbh->query($query);
25 $stmt = $dbh->query($query);
32 $stmt = $dbh->query($query);
39 $stmt = $dbh->query($query);
H A Dpdo_oci_attr_client_identifier.phpt14 $query = 'select client_identifier from v$session where sid = sys_context(\'USERENV\', \'SID\')';
18 $stmt = $dbh->query($query);
25 $stmt = $dbh->query($query);
32 $stmt = $dbh->query($query);
39 $stmt = $dbh->query($query);
H A Dpdo_oci_attr_client_info.phpt14 $query = 'select client_info from v$session where sid = sys_context(\'USERENV\', \'SID\')';
18 $stmt = $dbh->query($query);
25 $stmt = $dbh->query($query);
32 $stmt = $dbh->query($query);
39 $stmt = $dbh->query($query);
/PHP-8.0/ext/pdo/tests/
H A Dbug_44173.phpt2 PDO Common: Bug #44173 (PDO->query() parameter parsing/checking needs an update)
23 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_LAZY, 0, []);
32 $stmt = $db->query("SELECT * FROM test", 'abc');
39 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_CLASS, 0, 0, 0);
48 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_INTO);
57 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_COLUMN);
66 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_CLASS);
75 PDO::query() expects exactly 2 arguments for the fetch mode provided, 4 given
76 PDO::query(): Argument #2 ($fetchMode) must be of type ?int, string given
77 PDO::query() expects at most 4 arguments for the fetch mode provided, 5 given
[all …]
/PHP-8.0/ext/pdo_sqlite/tests/
H A Dpdo_sqlite_createcollation.phpt11 $db->query('CREATE TABLE IF NOT EXISTS foobar (id INT AUTO INCREMENT, name TEXT)');
13 $db->query('INSERT INTO foobar VALUES (NULL, "1")');
14 $db->query('INSERT INTO foobar VALUES (NULL, "2")');
15 $db->query('INSERT INTO foobar VALUES (NULL, "10")');
19 $result = $db->query('SELECT name FROM foobar ORDER BY name COLLATE MYCOLLATE');
24 $result = $db->query('SELECT name FROM foobar ORDER BY name');
29 $db->query('DROP TABLE foobar');
H A Dpdo_sqlite_transaction.phpt13 $db->query('CREATE TABLE IF NOT EXISTS foobar (id INT AUTO INCREMENT, name TEXT)');
17 $db->query('INSERT INTO foobar VALUES (NULL, "PHP")');
18 $db->query('INSERT INTO foobar VALUES (NULL, "PHP6")');
21 $r = $db->query('SELECT COUNT(*) FROM foobar');
25 $db->query('DROP TABLE foobar');
31 Warning: PDO::query(): SQLSTATE[HY000]: General error: 6 database table is locked in %s on line %d

Completed in 29 milliseconds

12345678910>>...20