Home
last modified time | relevance | path

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

12345678910>>...16

/PHP-5.3/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.3/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.3/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.3/ext/sqlite/tests/
H A Dsqlite_spl_002.phpt12 $db->query("CREATE TABLE menu(id_l int PRIMARY KEY, id_r int UNIQUE, key VARCHAR(10))");
13 $db->query("INSERT INTO menu VALUES( 1, 12, 'A')");
14 $db->query("INSERT INTO menu VALUES( 2, 9, 'B')");
15 $db->query("INSERT INTO menu VALUES(10, 11, 'F')");
16 $db->query("INSERT INTO menu VALUES( 3, 6, 'C')");
17 $db->query("INSERT INTO menu VALUES( 7, 8, 'E')");
18 $db->query("INSERT INTO menu VALUES( 4, 5, 'D')");
20 $res = $db->query("SELECT * from menu");
H A Dsqlite_oo_011.phpt12 $db->query("CREATE TABLE foo (c1 char, c2 char, c3 char)");
13 $db->query("CREATE TABLE bar (c1 char, c2 char, c3 char)");
14 $db->query("INSERT INTO foo VALUES ('1', '2', '3')");
15 $db->query("INSERT INTO bar VALUES ('4', '5', '6')");
16 $r = $db->query("SELECT * from foo, bar", SQLITE_ASSOC);
H A Dsqlite_oo_027.phpt15 $db->query("CREATE TABLE strings(a VARCHAR)");
18 $db->query("INSERT INTO strings VALUES('$str')");
22 $db->query("UPDATE strings SET a='foo' WHERE a!='two'");
25 $db->query("DELETE FROM strings WHERE 1");
32 $db->query($str);
H A Dsqlite_exec_basic.phpt7 /* Prototype : boolean sqlite_exec(string query, resource db[, string &error_message])
8 * Description: Executes a result-less query against a given database
16 $query = 'CREATE TABLE foobar (id INTEGER PRIMARY KEY, name CHAR(255));';
21 var_dump( sqlite_exec($db, $query) );
26 var_dump( $db->queryExec($query, $error_message) );
H A Dsqlite_oo_003.phpt12 $db->query("CREATE TABLE foo(c1 date, c2 time, c3 varchar(64))");
13 $db->query("INSERT INTO foo VALUES ('2002-01-02', '12:49:00', NULL)");
14 $r = $db->query("SELECT * from foo");
16 $r = $db->query("SELECT * from foo");
18 $r = $db->query("SELECT * from foo");
/PHP-5.3/ext/pdo_pgsql/tests/
H A Dbug62593.phpt19 $query = $db->prepare('SELECT :foo IS FALSE as val_is_false');
20 $query->bindValue(':foo', $value, PDO::PARAM_BOOL);
21 $query->execute();
22 $errors[] = $query->errorInfo();
25 $query->bindValue(':foo', 0, PDO::PARAM_BOOL);
26 $query->execute();
27 $errors[] = $query->errorInfo();
31 $query->bindParam(':foo', $value, PDO::PARAM_BOOL);
33 $query->execute();
34 $errors[] = $query->errorInfo();
/PHP-5.3/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.3/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.3/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.3/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 …]
/PHP-5.3/ext/mysqli/tests/
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 …]

Completed in 43 milliseconds

12345678910>>...16