Home
last modified time | relevance | path

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

12345678910>>...18

/PHP-5.6/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-5.6/ext/sqlite3/tests/
H A Dsqlite3_query_error.phpt2 SQLite3::query parameters
12 echo 'Testing SQLite3 query without parameters' . PHP_EOL;
13 $db->query();
15 echo 'Testing SQLite3 query with one array parameter' . PHP_EOL;
16 $db->query(array());
19 var_dump($db->query(''));
24 Testing SQLite3 query without parameters
26 Warning: SQLite3::query() expects exactly 1 parameter, 0 given in %s on line %d
27 Testing SQLite3 query with one array parameter
29 Warning: SQLite3::query() expects parameter 1 to be %binary_string_optional%, array given in %s on …
/PHP-5.6/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() must be compatible with DB::query($query, &...$params) i…
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() must be compatible with DB::query($query, string ...$par…
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 Fatal error: Declaration of MySQL::query() must be compatible with DB::query($query, string ...$par…
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() must be compatible with DB::query($query, ...$params) in…
H A Dremoving_parameter_error.phpt11 public function query($query, ...$params);
15 public function query(...$params) { }
20 Fatal error: Declaration of MySQL::query() must be compatible with DB::query($query, ...$params) in…
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-5.6/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 …]
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"');
/PHP-5.6/ext/pgsql/
H A Dmysql_users.php22 $query = '
31 return pg_query($db, $query);
41 $query = "
53 return pg_query($db, $query);
64 $query = "
79 return pg_query($db, $query);
/PHP-5.6/ext/pdo/tests/
H A Dbug_44173.phpt2 PDO Common: Bug #44173 (PDO->query() parameter parsing/checking needs an update)
22 $stmt = $db->query();
27 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_LAZY, 0, 0);
32 $stmt = $db->query("SELECT * FROM test", 'abc');
37 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_CLASS, 0, 0, 0);
42 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_INTO);
47 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_COLUMN);
52 $stmt = $db->query("SELECT * FROM test", PDO::FETCH_CLASS);
58 Warning: PDO::query() expects at least 1 parameter, 0 given in %s
64 Warning: PDO::query(): SQLSTATE[HY000]: General error: mode must be an integer in %s
[all …]
H A Dpdo_023.phpt50 function query($sql)
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-5.6/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 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)');
47 $db->query('DROP TABLE IF EXISTS test2');
48 $db->query('CREATE TABLE test2(id INT) ENGINE=MyISAM');
50 $db->query('INSERT INTO test2(id) VALUES (1)');
56 $db->query('DROP TABLE IF EXISTS test2');
60 $db->query('DELETE FROM test');
66 $db->query('DELETE FROM test');
72 $db->query('DELETE FROM test');
[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'))
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 …]
/PHP-5.6/ext/sybase_ct/tests/
H A Dbug30312-withfree.phpt17 $query= sybase_unbuffered_query('select datepart(yy, getdate())');
18 $array= sybase_fetch_row($query);
20 sybase_free_result($query);
22 $query= sybase_unbuffered_query('select datepart(mm, getdate()), datepart(dd, getdate())');
23 $array= sybase_fetch_row($query);
25 sybase_free_result($query);
/PHP-5.6/ext/mysqli/tests/
H A Dmysqli_pam_sha256.phpt23 if (!($res = $link->query("SHOW PLUGINS"))) {
37 if (!($res = $link->query("SHOW STATUS LIKE 'Rsa_public_key'"))) {
49 if (!$link->query("SET @@session.old_passwords=2")) {
53 $link->query('DROP USER shatest');
54 $link->query("DROP USER shatest@localhost");
67 if (!$link->query("DROP TABLE IF EXISTS test") ||
68 !$link->query("CREATE TABLE test (id INT)") ||
69 !$link->query("INSERT INTO test(id) VALUES (1), (2), (3)"))
89 if (!$res = $link->query("SELECT id FROM test WHERE id = 1"))
109 $link->query('DROP USER shatest');
[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 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 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 if (!$link->query("SET @@session.old_passwords=2")) {
63 $link->query('DROP USER shatest');
64 $link->query("DROP USER shatest@localhost");
77 if (!$link->query("DROP TABLE IF EXISTS test") ||
78 !$link->query("CREATE TABLE test (id INT)") ||
79 !$link->query("INSERT INTO test(id) VALUES (1), (2), (3)"))
106 if (!$res = $link->query("SELECT id FROM test WHERE id = 1"))
126 $link->query('DROP USER shatest');
[all …]
/PHP-5.6/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.phpt12 $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")');
20 $r = $db->query('SELECT COUNT(*) FROM foobar');
24 $db->query('DROP TABLE foobar');
/PHP-5.6/ext/phar/tests/files/
H A Dpear2coverage.phar.php1069 $result = $this->db->query($query);
1086 $result = $this->db->query($query);
1117 $result = $this->db->query($query);
1136 $result = $this->db->query($query);
1166 $result = $this->db->query($query);
1179 $result = $this->db->query($query);
1212 $result = $this->db->query($query);
1227 $result = $this->db->query($query);
1248 $result = $this->db->query($query);
1389 $result = $this->db->query($query);
[all …]

Completed in 57 milliseconds

12345678910>>...18