Home
last modified time | relevance | path

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

12345678910>>...24

/php-src/ext/pdo_firebird/tests/
H A Dbug_77863.phpt32 $query->execute();
36 $query->execute();
40 $query->execute();
44 $query->execute();
48 $query->execute();
52 $query->execute();
56 $query->execute();
61 $query->execute();
65 $query->execute();
69 $query->execute();
[all …]
H A Ddialect_1.phpt29 $query = $dbh->prepare($sql);
30 $query->execute();
31 $row = $query->fetch(\PDO::FETCH_OBJ);
37 unset($query);
41 $query = $dbh->prepare($sql);
42 $query->execute([0.76, '2019-06-12']);
43 unset($query);
46 $query = $dbh->prepare($sql);
47 $query->execute();
48 $row = $query->fetch(\PDO::FETCH_OBJ);
[all …]
H A Dignore_parammarks.phpt24 $query = $dbh->prepare($sql);
25 $query->execute(['d' => 1, 'e' => 2]);
26 $row = $query->fetch(\PDO::FETCH_OBJ);
28 unset($query);
35 $query = $dbh->prepare($sql);
36 $query->execute(['d' => 1, 'e' => 2]);
37 $row = $query->fetch(\PDO::FETCH_OBJ);
39 unset($query);
/php-src/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-src/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-src/ext/mysqli/tests/
H A Dbug79375.phpt26 echo "Running query on $name\n";
27 $stmt = $mysqli->prepare($query);
40 echo "Running query on $name\n";
54 echo "Running query on $name\n";
56 $res = $mysqli->query($query);
82 $res = $mysqli->query($query, MYSQLI_USE_RESULT);
148 Running query on first connection
153 Running query on first connection
158 Running query on first connection
163 Running query on first connection
[all …]
H A Dmysqli_pam_sha256.phpt21 if (!($res = $link->query("SHOW PLUGINS"))) {
35 if (!($res = $link->query("SHOW STATUS LIKE 'Rsa_public_key'"))) {
48 $link->query("SET @@session.old_passwords=2");
50 $link->query('DROP USER shatest');
51 $link->query("DROP USER shatest@localhost");
59 if (!$link->query('SET PASSWORD FOR shatest@"%" = "shatest"') ||
64 if (!$link->query("DROP TABLE IF EXISTS test") ||
65 !$link->query("CREATE TABLE test (id INT)") ||
66 !$link->query("INSERT INTO test(id) VALUES (1), (2), (3)"))
107 $link->query('DROP USER shatest');
[all …]
H A Dgh7837.phpt15 $mysql->query("DROP TABLE IF EXISTS test");
16 $mysql->query("CREATE TABLE test (`ubigint` bigint unsigned NOT NULL) ENGINE=InnoDB");
17 $mysql->query("INSERT INTO test (`ubigint`) VALUES (18446744073709551615)");
18 $mysql->query("INSERT INTO test (`ubigint`) VALUES (9223372036854775808)");
19 $mysql->query("INSERT INTO test (`ubigint`) VALUES (1)");
20 $result = $mysql->query("SELECT ubigint FROM test");
H A Dmysqli_autocommit_oo.phpt25 if (!$mysqli->query('SET AUTOCOMMIT = 0'))
46 if (!$mysqli->query('DROP TABLE IF EXISTS test'))
53 if (!$mysqli->query('INSERT INTO test(id) VALUES (1)'))
56 if (!$mysqli->query('ROLLBACK'))
68 if (!$mysqli->query('DROP TABLE IF EXISTS test'))
71 if (!$mysqli->query('SET AUTOCOMMIT = 1'))
89 if (!$mysqli->query('INSERT INTO test(id) VALUES (1)'))
92 if (!$mysqli->query('ROLLBACK'))
102 if (!$mysqli->query('INSERT INTO test(id) VALUES (1)'))
105 if (!$mysqli->query('COMMIT'))
[all …]
H A Dmysqli_pam_sha256_public_key_ini.phpt21 if (!($res = $link->query("SHOW PLUGINS"))) {
35 if (!($res = $link->query("SHOW STATUS LIKE 'Rsa_public_key'"))) {
60 $link->query("SET @@session.old_passwords=2");
62 $link->query('DROP USER shatest');
63 $link->query("DROP USER shatest@localhost");
71 if (!$link->query('SET PASSWORD FOR shatest@"%" = "shatest"') ||
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)"))
117 $link->query('DROP USER shatest');
[all …]
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)");
20 $mysqli->query("DROP TABLE IF EXISTS foo");
/php-src/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-src/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);
101 Running query on first connection
103 Running query on second connection
106 Running query on first connection
108 Running query on second connection
111 Running query on first connection
[all …]
H A Dpdo_mysql_rollback.phpt25 $db->query("INSERT INTO {$table}(id, label) VALUES (100, 'z')");
38 $db->query("INSERT INTO {$table}(id, label) VALUES (100, 'z')");
39 $db->query("CREATE TABLE {$table2}(id INT)");
51 $db->query("DROP TABLE IF EXISTS {$table2}");
52 $db->query("CREATE TABLE {$table2}(id INT) ENGINE=MyISAM");
54 $db->query("INSERT INTO {$table2}(id) VALUES (1)");
60 $db->query("DROP TABLE IF EXISTS {$table2}");
64 $db->query("DELETE FROM {$table}");
70 $db->query("DELETE FROM {$table}");
76 $db->query("DELETE FROM {$table}");
[all …]
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'))
61 $db->query("INSERT INTO {$table} (id, label) VALUES (100, 'z')");
68 $db->query('ROLLBACK');
76 $db->query("DELETE FROM {$table} WHERE id = 100");
77 $db->query('ROLLBACK');
82 $db->query("DELETE FROM {$table} WHERE id = 100");
83 $db->query('COMMIT');
[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 {$table} WHERE id = 1");
30 $stmt = $db->query("SELECT id, label FROM {$table} WHERE id = 1");
42 PDO::query() will prepare and execute a statement in one step.
43 After the execution of PDO::query(), MySQL expects you to fetch
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-src/ext/pdo_dblib/tests/
H A Dbug_38955.phpt17 $db->query("CREATE table test38955(val int)");
19 $db->query("INSERT INTO test38955(val) values(1)");
20 $db->query("INSERT INTO test38955(val) values(2)");
21 $db->query("INSERT INTO test38955(val) values(3)");
22 $db->query("INSERT INTO test38955(val) values(4)");
27 $db->query("INSERT INTO test38955(val) values(5)");
28 $db->query("INSERT INTO test38955(val) values(6)");
29 $db->query("INSERT INTO test38955(val) values(7)");
30 $db->query("INSERT INTO test38955(val) values(8)");
33 $rs = $db->query("SELECT * FROM test38955");
H A Dtimeout.phpt2 PDO_DBLIB: Set query timeouts
19 … timeout attribute, set after instance created, will affect query timeout, causing this query to f…
33 …timeout attribute, set after instance created, will control query timeout, causing this query to f…
47 // regular timeout attribute will affect query timeout, causing this query to fail
59 // pdo_dblib-specific timeout attribute will control query timeout, causing this query to fail
/php-src/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 test44173", PDO::FETCH_LAZY, 0, []);
33 $stmt = $db->query("SELECT * FROM test44173", 'abc');
40 $stmt = $db->query("SELECT * FROM test44173", PDO::FETCH_CLASS, 0, 0, 0);
49 $stmt = $db->query("SELECT * FROM test44173", PDO::FETCH_INTO);
58 $stmt = $db->query("SELECT * FROM test44173", PDO::FETCH_COLUMN);
67 $stmt = $db->query("SELECT * FROM test44173", PDO::FETCH_CLASS);
82 PDO::query() expects exactly 2 arguments for the fetch mode provided, 4 given
83 PDO::query(): Argument #2 ($fetchMode) must be of type ?int, string given
84 PDO::query() expects at most 4 arguments for the fetch mode provided, 5 given
[all …]

Completed in 55 milliseconds

12345678910>>...24