Home
last modified time | relevance | path

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

12345678910>>...17

/PHP-5.5/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.5/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 …
H A Dsqlite3stmt_reset_params.phpt18 $query = "SELECT name FROM foobar WHERE id = 1";
20 echo "Prepare query\n";
21 $stmt = $db->prepare($query);
23 echo "Reset query\n";
41 Prepare query
42 Reset query
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-5.5/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.5/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.5/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.5/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.5/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);
H A Dbug30312.phpt17 $query= sybase_unbuffered_query('select datepart(yy, getdate())');
18 $array= sybase_fetch_array($query);
21 $query= sybase_unbuffered_query('select datepart(yy, getdate())');
22 $array= sybase_fetch_array($query);
/PHP-5.5/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 …]
H A Dmysqli_autocommit_oo.phpt31 if (!$mysqli->query('SET AUTOCOMMIT = 0'))
52 if (!$mysqli->query('DROP TABLE IF EXISTS test'))
59 if (!$mysqli->query('INSERT INTO test(id) VALUES (1)'))
62 if (!$mysqli->query('ROLLBACK'))
74 if (!$mysqli->query('DROP TABLE IF EXISTS test'))
77 if (!$mysqli->query('SET AUTOCOMMIT = 1'))
95 if (!$mysqli->query('INSERT INTO test(id) VALUES (1)'))
98 if (!$mysqli->query('ROLLBACK'))
108 if (!$mysqli->query('INSERT INTO test(id) VALUES (1)'))
111 if (!$mysqli->query('COMMIT'))
[all …]
/PHP-5.5/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');
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');
/PHP-5.5/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 33 milliseconds

12345678910>>...17