Home
last modified time | relevance | path

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

12345678910>>...22

/PHP-8.1/ext/pdo_firebird/tests/
H A Dbug_77863.phpt30 $query->execute();
34 $query->execute();
38 $query->execute();
42 $query->execute();
46 $query->execute();
50 $query->execute();
54 $query->execute();
59 $query->execute();
63 $query->execute();
67 $query->execute();
[all …]
H A Ddialect_1.phpt27 $query = $dbh->prepare($sql);
28 $query->execute();
29 $row = $query->fetch(\PDO::FETCH_OBJ);
35 unset($query);
39 $query = $dbh->prepare($sql);
40 $query->execute([0.76, '2019-06-12']);
41 unset($query);
44 $query = $dbh->prepare($sql);
45 $query->execute();
46 $row = $query->fetch(\PDO::FETCH_OBJ);
[all …]
H A Dignore_parammarks.phpt22 $query = $dbh->prepare($sql);
23 $query->execute(['d' => 1, 'e' => 2]);
24 $row = $query->fetch(\PDO::FETCH_OBJ);
26 unset($query);
33 $query = $dbh->prepare($sql);
34 $query->execute(['d' => 1, 'e' => 2]);
35 $row = $query->fetch(\PDO::FETCH_OBJ);
37 unset($query);
/PHP-8.1/ext/pdo_pgsql/tests/
H A Dbug62593.phpt24 $query->execute();
25 $errors[] = $query->errorInfo();
29 $query->execute();
30 $errors[] = $query->errorInfo();
36 $query->execute();
37 $errors[] = $query->errorInfo();
43 $query->execute();
44 $errors[] = $query->errorInfo();
45 var_dump($query->fetchColumn());
49 $query->execute();
[all …]
/PHP-8.1/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.1/ext/mysqli/tests/
H A Dbug79375.phpt27 echo "Running query on $name\n";
28 $stmt = $mysqli->prepare($query);
41 echo "Running query on $name\n";
57 $res = $mysqli->query($query);
83 $res = $mysqli->query($query, MYSQLI_USE_RESULT);
149 Running query on first connection
151 Running query on second connection
154 Running query on first connection
159 Running query on first connection
164 Running query on first connection
[all …]
H A Dmysqli_pam_sha256.phpt23 if (!($res = $link->query("SHOW PLUGINS"))) {
37 if (!($res = $link->query("SHOW STATUS LIKE 'Rsa_public_key'"))) {
50 $link->query("SET @@session.old_passwords=2");
52 $link->query('DROP USER shatest');
53 $link->query("DROP USER shatest@localhost");
61 if (!$link->query('SET PASSWORD FOR shatest@"%" = "shatest"') ||
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)"))
109 $link->query('DROP USER shatest');
[all …]
/PHP-8.1/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) { }
/PHP-8.1/ext/pdo_dblib/tests/
H A Dbug_38955.phpt14 $db->query("CREATE table php_test(val int)");
16 $db->query("INSERT INTO php_test(val) values(1)");
17 $db->query("INSERT INTO php_test(val) values(2)");
18 $db->query("INSERT INTO php_test(val) values(3)");
19 $db->query("INSERT INTO php_test(val) values(4)");
24 $db->query("INSERT INTO php_test(val) values(5)");
25 $db->query("INSERT INTO php_test(val) values(6)");
26 $db->query("INSERT INTO php_test(val) values(7)");
27 $db->query("INSERT INTO php_test(val) values(8)");
30 $rs = $db->query("SELECT * FROM php_test");
[all …]
/PHP-8.1/ext/pdo_mysql/tests/
H A Dbug79375.phpt33 echo "Running query on $name\n";
35 $stmt = $db->query($query);
46 echo "Running query on $name\n";
47 $stmt = $db->prepare($query);
62 $stmt = $db->prepare($query);
102 Running query on first connection
104 Running query on second connection
107 Running query on first connection
109 Running query on second connection
112 Running query on first connection
[all …]
H A Dbug_51670.phpt2 Bug #51670 (getColumnMeta causes segfault when re-executing query after calling nextRowset)
16 $query = $db->prepare('SELECT 1 AS num');
17 $query->execute();
18 if(!is_array($query->getColumnMeta(0))) die('FAIL!');
19 $query->nextRowset();
20 $query->execute();
21 if(!is_array($query->getColumnMeta(0))) die('FAIL!');
H A Dpdo_mysql_rollback.phpt24 $db->query("INSERT INTO test(id, label) VALUES (100, 'z')");
38 $db->query('DROP TABLE IF EXISTS test2');
39 $db->query('CREATE TABLE test2(id INT)');
51 $db->query('DROP TABLE IF EXISTS test2');
52 $db->query('CREATE TABLE test2(id INT) ENGINE=MyISAM');
54 $db->query('INSERT INTO test2(id) VALUES (1)');
60 $db->query('DROP TABLE IF EXISTS test2');
64 $db->query('DELETE FROM test');
70 $db->query('DELETE FROM test');
76 $db->query('DELETE FROM test');
[all …]
H A Dpdo_mysql_attr_autocommit.phpt21 $row = $db->query('SELECT @@autocommit AS _autocommit')->fetch(PDO::FETCH_ASSOC);
29 $row = $db->query('SELECT @@autocommit AS _autocommit')->fetch(PDO::FETCH_ASSOC);
34 if (!$db->query('SET autocommit = 1'))
41 if (!$db->query('SET autocommit = 0'))
47 $row = $db->query('SELECT @@autocommit AS _autocommit')->fetch(PDO::FETCH_ASSOC);
61 $db->query("INSERT INTO test(id, label) VALUES (100, 'z')");
68 $db->query('ROLLBACK');
76 $db->query('DELETE FROM test WHERE id = 100');
77 $db->query('ROLLBACK');
82 $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
28 $stmt = $db->query('SELECT id, label FROM test WHERE id = 1');
30 $stmt = $db->query('SELECT id, label FROM test WHERE id = 1');
36 $stmt = $db->query('SELECT id, label FROM test WHERE id = 1');
42 PDO::query() will prepare and execute a statement in one step.
49 $stmt = PDO::query(<some query>)
57 $stmt = PDO::query(<some query>)
58 PDO::query(<some query>)
64 $stmt = PDO::query(<some query>)
83 - use prepare() + execute() instead of query()
[all …]
/PHP-8.1/ext/pdo_oci/tests/
H A Dpdo_oci_attr_action.phpt16 $query = 'select action from v$session where sid = sys_context(\'USERENV\', \'SID\')';
20 $stmt = $dbh->query($query);
27 $stmt = $dbh->query($query);
34 $stmt = $dbh->query($query);
41 $stmt = $dbh->query($query);
H A Dpdo_oci_attr_client_identifier.phpt16 $query = 'select client_identifier from v$session where sid = sys_context(\'USERENV\', \'SID\')';
20 $stmt = $dbh->query($query);
27 $stmt = $dbh->query($query);
34 $stmt = $dbh->query($query);
41 $stmt = $dbh->query($query);
H A Dpdo_oci_attr_client_info.phpt16 $query = 'select client_info from v$session where sid = sys_context(\'USERENV\', \'SID\')';
20 $stmt = $dbh->query($query);
27 $stmt = $dbh->query($query);
34 $stmt = $dbh->query($query);
41 $stmt = $dbh->query($query);
H A Dpdo_oci_attr_module.phpt16 $query = 'select module from v$session where sid = sys_context(\'USERENV\', \'SID\')';
22 $stmt = $dbh->query($query);
29 $stmt = $dbh->query($query);
36 $stmt = $dbh->query($query);
/PHP-8.1/ext/pdo/tests/
H A Dbug_44173.phpt2 PDO Common: Bug #44173 (PDO->query() parameter parsing/checking needs an update)
24 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_LAZY, 0, []);
33 $stmt = $db->query("SELECT * FROM test", 'abc');
40 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_CLASS, 0, 0, 0);
49 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_INTO);
58 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_COLUMN);
67 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_CLASS);
76 PDO::query() expects exactly 2 arguments for the fetch mode provided, 4 given
77 PDO::query(): Argument #2 ($fetchMode) must be of type ?int, string given
78 PDO::query() expects at most 4 arguments for the fetch mode provided, 5 given
[all …]
/PHP-8.1/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 33 milliseconds

12345678910>>...22