Home
last modified time | relevance | path

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

12345678910>>...18

/PHP-7.1/ext/mysqli/tests/
H A Dmysqli_commit_oo.phpt41 if (!$mysqli->query('DROP TABLE IF EXISTS test')) {
45 if (!$mysqli->query('CREATE TABLE test(id INT) ENGINE = InnoDB')) {
49 if (!$mysqli->query('INSERT INTO test(id) VALUES (1)')) {
58 if (!$mysqli->query('ROLLBACK'))
61 if (!$res = $mysqli->query('SELECT COUNT(*) AS num FROM test')) {
71 if (!$mysqli->query('DROP TABLE IF EXISTS test')) {
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 Dbug35517.phpt14 $mysql->query("CREATE TABLE temp (id INT UNSIGNED NOT NULL)");
15 $mysql->query("INSERT INTO temp (id) VALUES (3000000897),(3800001532),(3900002281),(3100059612)");
37 $mysql->query("DROP TABLE temp");
/PHP-7.1/ext/pdo_mysql/tests/
H A Dbug_61207.phpt2 PDO MySQL Bug #61207 (PDO::nextRowset() after a multi-statement query doesn't always work)
15 $db->query('DROP TABLE IF EXISTS test');
16 $db->query('create table `test`( `id` int )');
83 $db->query("DROP TABLE test");
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 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 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 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 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…
/PHP-7.1/ext/pdo/tests/
H A Dpdo_030.phpt52 function query($sql)
55 return parent::query($sql);
77 $stmt = $db->query('SELECT * FROM test');
108 PDODatabase::query()
/PHP-7.1/ext/pdo_oci/tests/
H A Dpdo_oci_stream_2a.phpt17 $query = "begin execute immediate 'drop table pdo_oci_stream_2'; exception when others then if sqlc…
18 $stmt = $db->prepare($query);
21 $query = "create table pdo_oci_stream_2 (id number, data1 blob, data2 blob)";
22 $stmt = $db->prepare($query);
/PHP-7.1/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.1/ext/sqlite3/tests/
H A Dsqlite3_04_update.phpt2 SQLite3::query UPDATE tests
19 $results = $db->query("SELECT * FROM test ORDER BY id ASC");
30 $results = $db->query("SELECT * FROM test ORDER BY id ASC");
H A Dsqlite3_05_delete.phpt2 SQLite3::query DELETE tests
19 $results = $db->query("SELECT * FROM test ORDER BY id ASC");
30 $results = $db->query("SELECT * FROM test ORDER BY id ASC");
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 …
/PHP-7.1/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-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 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.1/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.1/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-7.1/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 …

Completed in 60 milliseconds

12345678910>>...18