Home
last modified time | relevance | path

Searched refs:query (Results 201 – 225 of 491) sorted by relevance

12345678910>>...20

/PHP-8.0/ext/sqlite3/tests/
H A Dsqlite3_18_changes.phpt18 echo "UPDATE query\n";
34 UPDATE query
H A Dsqlite3_36_create_collation.phpt20 $defaultSort = $db->query('SELECT s FROM t ORDER BY s'); //memcmp() sort
21 $naturalSort = $db->query('SELECT s FROM t ORDER BY s COLLATE NAT'); //strnatcmp() sort
H A Dsqlite3_03_insert.phpt2 SQLite3::query INSERT tests
19 $results = $db->query("SELECT * FROM test ORDER BY id ASC");
/PHP-8.0/ext/pdo_sqlite/tests/
H A Dbug78192.phpt11 $connection->query('CREATE TABLE user (id INTEGER PRIMARY KEY NOT NULL, name VARCHAR(255) NOT NULL)…
23 $connection->query('ALTER TABLE user ADD new_col VARCHAR(255)');
/PHP-8.0/ext/pdo_dblib/tests/
H A Dbug_69592.phpt19 $stmt = $db->query($sql);
29 $stmt = $db->query($sql);
/PHP-8.0/ext/pdo_firebird/tests/
H A Dbug_47415.phpt20 $query = "SELECT idx, txt FROM testz ORDER by idx";
22 $stmt = $dbh->prepare($query);
H A Dbug_64037.phpt21 $query = "SELECT * from price order by ID";
22 $stmt = $dbh->prepare($query);
H A Dbug_48877.phpt22 $query = "SELECT * FROM testz WHERE A = :paramno";
24 $stmt = $dbh->prepare($query);
H A DrowCount.phpt20 $query = "SELECT * FROM testz WHERE A = ?";
22 $stmt = $dbh->prepare($query);
/PHP-8.0/ext/pdo_oci/tests/
H A Dpdo_oci_stream_2.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);
81 foreach($db->query("select data1 as d4_1, data2 as d4_2 from pdo_oci_stream_2 order by id") as $row…
/PHP-8.0/ext/pdo_mysql/tests/
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 Dpdo_mysql_connect_charset.phpt15 … $charset = $link->query("SHOW VARIABLES LIKE 'character_set_connection'")->fetchObject()->value;
24 …$conn_charset = $link->query("SHOW VARIABLES LIKE 'character_set_connection'")->fetchObject()->va…
H A Dpdo_mysql_param_str_natl.phpt24 var_dump($db->query('SELECT * from test'));
25 foreach ($db->query('SELECT * from test') as $row) {
H A Dpdo_mysql_stmt_nextrowset.phpt9 $row = $db->query('SELECT VERSION() as _version')->fetch(PDO::FETCH_ASSOC);
30 $stmt = $db->query('SELECT id FROM test');
36 $stmt = $db->query('SELECT @VERSION as _version');
44 $stmt = $db->query('SELECT @VERSION as _version');
54 $stmt = $db->query('CALL p()');
62 $stmt = $db->query('CALL p()');
/PHP-8.0/ext/mysqli/tests/
H A Dmysqli_insert_id_variation.phpt16 $link->query("DROP TABLE IF EXISTS test_insert_id_var");
17 $link->query("CREATE TABLE test_insert_id_var (id INT auto_increment, PRIMARY KEY (id))");
18 $link->query("INSERT INTO test_insert_id_var VALUES (null)");
87 $link->query("DROP TABLE IF EXISTS test_insert_id_var");
H A Dbug79084.phpt24 $res = $link->query($sql);
32 $res = $link->query($sql);
H A Dmysqli_poll.phpt64 printf("[%03d + 2] Can fetch resultset although no query has been run!\n", $offset);
69 … printf("[%03d + 4] Cannot fetch and no error set - non resultset query (no SELECT)!\n", $offset);
83 // Connections on which no query has been send - 1
98 // Connections on which no query has been send - 2
106 // Connections on which no query has been send - 3
H A Dbug73462.phpt14 $result = $mysql_1->query("SHOW STATUS LIKE 'Connections'");
30 $result = $mysql_3->query("SHOW STATUS LIKE 'Connections'");
H A Dbug_mysql_49406.phpt16 …$query = "SELECT CASE WHEN 0 THEN CAST('2009-12-03' AS DATE) ELSE CAST('2009-12-03' AS DATE) END…
18 if (!$res = $link->query($query))
30 if (!$stmt = $link->prepare($query))
H A Dmysqli_change_user_oo.phpt41 if (!$mysqli->query('SET @mysqli_change_user_test_var=1'))
44 if (!$res = $mysqli->query('SELECT @mysqli_change_user_test_var AS test_var'))
54 if (!$res = $mysqli->query('SELECT database() AS dbname, user() AS user'))
64 if (!$res = $mysqli->query('SELECT @mysqli_change_user_test_var AS test_var'))
/PHP-8.0/ext/pdo/tests/
H A Dpdo_026.phpt45 function query($sql, ...$rest)
68 $stmt = $db->query('SELECT * FROM test');
81 PDODatabase::query()
H A Dpdo_033.phpt26 $db->query("CREATE TABLE test (t char($len))");
27 $db->query("INSERT INTO test (t) VALUES($quoted)");
H A Dpdo_029.phpt51 function query($sql, ...$rest)
76 $stmt = $db->query('SELECT * FROM test');
93 PDODatabase::query()
/PHP-8.0/ext/pdo_pgsql/tests/
H A Dbug69362.phpt52 $pdo->query($sql);
54 $result = $testConn->query($testQuery)->fetch();
59 $pdo->query($dropUser);
/PHP-8.0/ext/odbc/tests/
H A Dbug73448.phpt17 "/* another erroneous query */ SELECT * FROM zwiebelfleisch",
45 string(58) "/* another erroneous query */ SELECT * FROM zwiebelfleisch"

Completed in 20 milliseconds

12345678910>>...20