Home
last modified time | relevance | path

Searched refs:query (Results 126 – 150 of 470) sorted by relevance

12345678910>>...19

/PHP-7.3/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-7.3/ext/pdo_mysql/tests/
H A Dbug_33689.phpt2 PDO MySQL Bug #33689 (query() execute() and fetch() return false on valid select queries)
19 var_dump($db->query('SELECT * from test'));
20 foreach ($db->query('SELECT * from test') as $row) {
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_errorinfo.phpt40 or PDO->query() and invoke an error on the statement handle,
48 $stmt = $db->query('SELECT id, label FROM test');
59 @$stmt = $db->query('SELECT id, label FROM unknown');
63 $stmt = $db->query('SELECT id, label FROM test');
69 @$db->query('SELECT id, label FROM unknown');
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_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_subclass.phpt31 public function query() {
33 return call_user_func_array(array($this, 'parent::query'), func_get_args());
61 $stmt = $db->query('SELECT * FROM test ORDER BY id ASC');
86 query('SELECT * FROM test ORDER BY id ASC')
H A Dbug46292.phpt37 $pdoDb->query('DROP TABLE IF EXISTS testz');
39 $pdoDb->query('CREATE TABLE testz (name VARCHAR(20) NOT NULL, value INT)');
41 …$pdoDb->query("INSERT INTO testz VALUES ('myclass', 1), ('myclass2', 2), ('myclass', NULL), ('mycl…
H A Dpdo_mysql_stmt_fetchobject.phpt11 $query = "SELECT '', NULL, \"\" FROM DUAL";
12 $stmt = $db->prepare($query);
28 $query = "SELECT id, '', NULL, \"\" FROM test ORDER BY id ASC LIMIT 3";
29 $stmt = $db->prepare($query);
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);
/PHP-7.3/ext/mysqli/tests/
H A Dmysqli_pconn_limits.phpt21 printf("[001] Cannot run query, [%d] %s\n",
33 printf("[003] Cannot run query, [%d] %s\n",
47 printf("[005] Cannot run query, [%d] %s\n",
60 printf("[007] Cannot run query, [%d] %s\n",
74 printf("[009] Cannot run query, [%d] %s\n",
H A Dmysqli_fetch_all_oo.phpt26 if (!$res = $mysqli->query("SELECT * FROM test ORDER BY id LIMIT 2")) {
34 if (!$res = $mysqli->query("SELECT * FROM test ORDER BY id LIMIT 2")) {
42 if (!$res = $mysqli->query("SELECT * FROM test ORDER BY id LIMIT 2")) {
50 if (!$res = $mysqli->query("SELECT * FROM test ORDER BY id LIMIT 2")) {
61 if (!$res = $mysqli->query("SELECT * FROM test ORDER BY id LIMIT 2")) {
72 printf("[010] Cannot run query, [%d] %s\n", $mysqli->errno, $$mysqli->error);
78 if (!$res = $mysqli->query("SELECT 1 AS a, 2 AS b, 3 AS c, 4 AS C")) {
79 printf("[018] Cannot run query, [%d] %s\n",
97 if (!$link->query("DROP TABLE IF EXISTS test")) {
108 if (!$link->query($sql = sprintf("INSERT INTO test(id, label) VALUES (1, NULL)"))) {
[all …]
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 Dmysqli_connect_oo_defaults.phpt34 if (!$res = $mysqli->query("SELECT 'mysqli.default_socket' AS testing"))
57 if (!$res = $mysqli->query("SELECT 'mysqli.default_port' AS testing"))
75 if (!$res = $mysqli->query("SELECT 'mysqli.default_pw' AS testing"))
93 if (!$res = $mysqli->query("SELECT 'mysqli.default_user' AS testing"))
111 if (!$res = $mysqli->query("SELECT 1"))
115 if (!$res = $mysqli->query("SELECT SUBSTRING_INDEX(USER(),'@',1) AS username"))
/PHP-7.3/ext/sqlite3/tests/
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 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;");
/PHP-7.3/ext/pdo_dblib/tests/
H A Ddatetime_convert.phpt16 $stmt = $db->query($sql);
22 $stmt = $db->query($sql);
H A Ddatetime2.phpt17 $stmt = $db->query($sql);
22 $stmt = $db->query($sql);
H A Dbatch_stmt_ins_exec.phpt15 $db->query("create table #php_pdo(id int); ");
16 $db->query(
25 $stmt = $db->query(
/PHP-7.3/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-7.3/ext/interbase/tests/
H A Dibase_free_query_001.phpt24 Warning: ibase_free_query(): supplied resource is not a valid Firebird/InterBase query resource in …
27 Warning: ibase_free_query(): supplied resource is not a valid Firebird/InterBase query resource in …
/PHP-7.3/ext/pdo_sqlite/tests/
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');
/PHP-7.3/ext/pdo_firebird/tests/
H A Dbug_76450.phpt21 $query = $dbh->prepare($sql);
23 $query->execute();
/PHP-7.3/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 …]

Completed in 32 milliseconds

12345678910>>...19