Home
last modified time | relevance | path

Searched refs:query (Results 101 – 125 of 428) sorted by relevance

12345678910>>...18

/PHP-5.6/ext/pdo_mysql/tests/
H A Dbug_41997.phpt12 $row = $db->query('SELECT VERSION() as _version')->fetch(PDO::FETCH_ASSOC);
30 $stmt = $db->query("CALL p()");
36 $stmt = $db->query('SELECT 2 AS "two"');
H A Dpdo_mysql_stmt_multiquery.phpt2 PDOStatements and multi query
15 …$stmt = $db->query('SELECT label FROM test ORDER BY id ASC LIMIT 1; SELECT label FROM test ORDER B…
24 …$stmt = $db->query('SELECT label FROM test ORDER BY id ASC LIMIT 1; SELECT label FROM test ORDER B…
100 Warning: PDO::query(): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in…
H A Dpdo_mysql_attr_fetch_table_names.phpt16 $stmt = $db->query('SELECT label FROM test LIMIT 1');
21 $stmt = $db->query('SELECT label FROM test LIMIT 1');
H A Dpdo_mysql_subclass.phpt33 public function query() {
35 return call_user_func_array(array($this, 'parent::query'), func_get_args());
63 $stmt = $db->query('SELECT * FROM test ORDER BY id ASC');
88 query('SELECT * FROM test ORDER BY id ASC')
H A Dbug41125.phpt33 foreach ($queries as $k => $query) {
34 $stmt = $db->prepare($query);
36 printf("[%d] Query: [[%s]]\n", $k + 1, $query);
74 foreach ($queries as $k => $query) {
75 $stmt = $db->prepare($query);
79 printf("[%d] Query: [[%s]]\n", $k + 1, $query);
H A Dpdo_mysql_stmt_rowcount.phpt17 if (0 !== ($tmp = $db->query('SELECT id FROM test WHERE 1 = 0')->rowCount()))
20 if (1 !== ($tmp = $db->query('SELECT id FROM test WHERE id = 1')->rowCount()))
H A Dbug46292.phpt39 $pdoDb->query('DROP TABLE IF EXISTS testz');
41 $pdoDb->query('CREATE TABLE testz (name VARCHAR(20) NOT NULL, value INT)');
43 …$pdoDb->query("INSERT INTO testz VALUES ('myclass', 1), ('myclass2', 2), ('myclass', NULL), ('mycl…
/PHP-5.6/ext/pdo_pgsql/tests/
H A Dbug66584.phpt20 $pdo->query("CREATE TABLE b66584 (a int)");
21 $pdo->query("INSERT INTO b66584 VALUES (165)");
40 $pdo->query("DROP TABLE b66584");
/PHP-5.6/ext/sqlite3/tests/
H A Dsqlite3_16_select_no_results.phpt2 SQLite3::query SELECT with no results
15 $results = $db->query("SELECT * FROM test ORDER BY id ASC");
H A Dbug69972.phpt11 $result = $db->query("SELECT * FROM non_existent_table");
23 Warning: SQLite3::query(): Unable to prepare statement: 1, no such table: non_existent_table in %sb…
H A Dbug73068.phpt13 $r = $db->query("SELECT * FROM t1 WHERE a='1' AND b='2'");
18 $r = $db->query("SELECT * FROM t1;");
H A Dsqlite3_20_error.phpt11 $result = $db->query("SELECT * FROM non_existent_table");
23 Warning: SQLite3::query(): Unable to prepare statement: 1, no such table: non_existent_table in %s …
H A Dbug63921-32bit.phpt12 $conn->query('CREATE TABLE users (id INTEGER NOT NULL, num INTEGER NOT NULL, PRIMARY KEY(id))');
19 $stmt = $conn->query('SELECT num FROM users');
H A Dbug63921-64bit.phpt12 $conn->query('CREATE TABLE users (id INTEGER NOT NULL, num INTEGER NOT NULL, PRIMARY KEY(id))');
19 $stmt = $conn->query('SELECT num FROM users');
/PHP-5.6/ext/pdo_sqlite/tests/
H A Dbug35336.phpt16 $a->query ("CREATE TABLE test (a integer primary key, b text)");
19 $rez = $a->query ("SELECT * FROM test")->fetchAll(PDO::FETCH_CLASS, 'EEE');
H A Dbug_63916.phpt12 $conn->query('CREATE TABLE users (id INTEGER NOT NULL, num INTEGER NOT NULL, PRIMARY KEY(id))');
19 $stmt = $conn->query('SELECT num FROM users');
H A Dbug_63916-2.phpt12 $conn->query('CREATE TABLE users (id INTEGER NOT NULL, num INTEGER NOT NULL, PRIMARY KEY(id))');
19 $stmt = $conn->query('SELECT num FROM users');
H A Dbug44327_2.phpt12 $x = $db->query('select 1 as queryString');
20 $x = $db->query('select 1 as queryString');
/PHP-5.6/ext/standard/tests/strings/
H A Durl_t.phpt292 ["query"]=>
406 ["query"]=>
417 ["query"]=>
430 ["query"]=>
443 ["query"]=>
454 ["query"]=>
467 ["query"]=>
478 ["query"]=>
491 ["query"]=>
502 ["query"]=>
[all …]
/PHP-5.6/ext/oci8/tests/
H A Dlob_022.phpt46 $query = 'SELECT * FROM lob_test ORDER BY mykey ASC';
47 $statement = oci_parse ($c, $query);
55 $query = 'SELECT * FROM lob_test ORDER BY mykey DESC';
56 $statement = oci_parse ($c, $query);
/PHP-5.6/ext/interbase/tests/
H A Dibase_free_query_001.phpt24 Warning: ibase_free_query(): 11 is not a valid Firebird/InterBase query resource in %s on line %d
27 Warning: ibase_free_query(): supplied resource is not a valid Firebird/InterBase query resource in …
/PHP-5.6/ext/mysqli/tests/
H A Dbug52891.phpt19 if (!$link->query("DROP TABLE IF EXISTS tuint") ||
20 !$link->query("DROP TABLE IF EXISTS tsint")) {
24 if (!$link->query("CREATE TABLE tuint(a BIGINT UNSIGNED) ENGINE=" . $engine) ||
25 !$link->query("CREATE TABLE tsint(a BIGINT) ENGINE=" . $engine)) {
84 $result = $link->query("SELECT * FROM tsint ORDER BY a ASC");
85 $result2 = $link->query("SELECT * FROM tuint ORDER BY a ASC");
H A Dbug42548.phpt26 $mysqli->query("DROP PROCEDURE IF EXISTS p1") or die($mysqli->error);
27 $mysqli->query("CREATE PROCEDURE p1() BEGIN SELECT 23; SELECT 42; END") or die($mysqli->error);
49 $mysqli->query("DROP PROCEDURE p1") or die($mysqli->error);
/PHP-5.6/ext/interbase/
H A Dibase_query.c50 struct _ib_query *query; member
69 char *query; member
177 if (ib_query->query) { in _php_ibase_free_query()
178 efree(ib_query->query); in _php_ibase_free_query()
322 if (*query == '\0') { in _php_ibase_alloc_query()
335 ib_query->query = estrdup(query); in _php_ibase_alloc_query()
426 if (ib_query->query) { in _php_ibase_alloc_query()
427 efree(ib_query->query); in _php_ibase_alloc_query()
950 res->query = ib_query; in _php_ibase_exec()
1062 char *query; in PHP_FUNCTION() local
[all …]
/PHP-5.6/ext/pdo/tests/
H A Dbug_34687.phpt2 PDO Common: Bug #34687 (query doesn't return error information)
18 $x = $db->query("UPDATE non_existent_pdo_test_table set foo = 'bar'");

Completed in 43 milliseconds

12345678910>>...18