Home
last modified time | relevance | path

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

12345678910>>...16

/PHP-5.4/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.4/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.4/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.4/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.4/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.4/ext/pdo_mysql/tests/
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 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_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.4/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);
H A Dtest.inc63 // {{{ void sybase_select_ex(resource dbh, string query)
64 // Returns all fetched rows from an SQL query
65 function sybase_select_ex($dbh, $query) {
66 printf(">>> Query: %s\n", $query);
67 $h= sybase_query($query, $dbh);
79 // {{{ mixed sybase_select_single(resource dbh, string query)
80 // Fires an SQL query and returns the first value from the first row
81 function sybase_select_single($dbh, $query) {
82 $a = sybase_fetch_row(sybase_query($query, $dbh));
/PHP-5.4/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.4/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.4/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 …]
H A Dmysqli_affected_rows_oo.phpt25 if (!$mysqli->query('DROP TABLE IF EXISTS test'))
31 if (!$mysqli->query("INSERT INTO test(id, label) VALUES (1, 'a')"))
38 $mysqli->query("INSERT INTO test(id, label) VALUES (1, 'a')");
48 if (!$mysqli->query("INSERT INTO test(id, label) VALUES (2, 'b'), (3, 'c')"))
54 if (!$mysqli->query("INSERT IGNORE INTO test(id, label) VALUES (1, 'a')")) {
67 if (!$mysqli->query("REPLACE INTO test(id, label) values (4, 'd')"))
73 if (!$mysqli->query("REPLACE INTO test(id, label) values (5, 'e')"))
79 if (!$mysqli->query("UPDATE test SET label = 'a' WHERE id = 2"))
85 if (!$mysqli->query("UPDATE test SET label = 'a' WHERE id = 2")) {
92 if (!$mysqli->query("UPDATE test SET label = 'a' WHERE id = 100")) {
[all …]
/PHP-5.4/ext/mbstring/tests/
H A Dmb_parse_str.phpt16 function test($query) {
19 mb_parse_str($query, $array);
23 mb_parse_str($query);
27 foreach ($queries as $query) {
28 test($query);

Completed in 65 milliseconds

12345678910>>...16