Home
last modified time | relevance | path

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

12345678910>>...19

/PHP-7.4/ext/pdo_mysql/tests/
H A Dbug70066.phpt19 $db = $pdo->query('SELECT DATABASE()')->fetchColumn(0);
22 $pdo->query('USE ' . $db);
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_subclass.phpt27 public function query() {
29 return call_user_func_array(array($this, 'parent::query'), func_get_args());
57 $stmt = $db->query('SELECT * FROM test ORDER BY id ASC');
82 query('SELECT * FROM test ORDER BY id ASC')
H A Dbug66528.phpt22 $stmt = $dbh->query('SELECT * FROM test');
49 …ely, if your code is only ever going to run against mysql, you may enable query buffering by setti…
50 …ely, if your code is only ever going to run against mysql, you may enable query buffering by setti…
51 …ely, if your code is only ever going to run against mysql, you may enable query buffering by setti…
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 Dbug_38546.phpt23 $query = "CREATE TABLE test(
29 $db->exec($query);
52 foreach ($db->query('SELECT * from test') as $row) {
78 foreach ($db->query('SELECT * from test') as $row) {
104 foreach ($db->query('SELECT * from test') as $row) {
131 foreach ($db->query('SELECT * from test') as $row) {
158 foreach ($db->query('SELECT * from test') as $row) {
185 foreach ($db->query('SELECT * from test') as $row) {
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_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 Dbug_74376.phpt22 $stmt = $db->query("select (select 1 union select 2)");
28 Warning: PDO::query(): SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 ro…
/PHP-7.4/ext/mysqli/tests/
H A Dbug77935.phpt14 $db->query('DROP PROCEDURE IF EXISTS testSp');
15 $db->query(<<<'SQL'
H A Dbug34810.phpt22 $mysql->query("DROP TABLE IF EXISTS test_warnings");
23 $mysql->query("CREATE TABLE test_warnings (a int not null)");
24 $mysql->query("SET sql_mode=''");
25 $mysql->query("INSERT INTO test_warnings VALUES (1),(2),(NULL)");
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",
/PHP-7.4/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()
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'");
/PHP-7.4/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.4/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_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…
/PHP-7.4/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.4/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);
/PHP-7.4/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.4/ext/pdo_firebird/tests/
H A Dbug_76450.phpt21 $query = $dbh->prepare($sql);
23 $query->execute();

Completed in 37 milliseconds

12345678910>>...19