Home
last modified time | relevance | path

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

12345678910>>...22

/PHP-8.1/ext/pdo/tests/
H A Dpdo_012.phpt24 $stmt = $db->query($SELECT, PDO::FETCH_NUM);
37 $stmt = $db->query($SELECT, PDO::FETCH_CLASS, 'Test');
42 $stmt = $db->query($SELECT, PDO::FETCH_NUM);
/PHP-8.1/ext/mysqli/tests/
H A Dmysqli_fetch_all_oo.phpt23 if (!$res = $mysqli->query("SELECT * FROM test ORDER BY id LIMIT 2")) {
31 if (!$res = $mysqli->query("SELECT * FROM test ORDER BY id LIMIT 2")) {
39 if (!$res = $mysqli->query("SELECT * FROM test ORDER BY id LIMIT 2")) {
47 if (!$res = $mysqli->query("SELECT * FROM test ORDER BY id LIMIT 2")) {
58 if (!$res = $mysqli->query("SELECT * FROM test ORDER BY id LIMIT 2")) {
68 if (!$res = $mysqli->query("SELECT 1 AS a, 2 AS a, 3 AS c, 4 AS C, NULL AS d, true AS e")) {
69 printf("[010] Cannot run query, [%d] %s\n", $mysqli->errno, $$mysqli->error);
75 if (!$res = $mysqli->query("SELECT 1 AS a, 2 AS b, 3 AS c, 4 AS C")) {
76 printf("[018] Cannot run query, [%d] %s\n",
94 if (!$link->query("DROP TABLE IF EXISTS test")) {
[all …]
H A Dbug52891.phpt20 if (!$link->query("DROP TABLE IF EXISTS tuint") ||
21 !$link->query("DROP TABLE IF EXISTS tsint")) {
25 if (!$link->query("CREATE TABLE tuint(a BIGINT UNSIGNED) ENGINE=" . $engine) ||
26 !$link->query("CREATE TABLE tsint(a BIGINT) ENGINE=" . $engine)) {
85 $result = $link->query("SELECT * FROM tsint ORDER BY a ASC");
86 $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"))
H A Dbug72489.phpt17 if (!$link->query("DROP TABLE IF EXISTS bug72489")) {
21 if (!$link->query("CREATE TABLE bug72489 (id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, code VARCH…
26 if (!$link->query($seedSQL)) {
H A Dmysqli_fetch_assoc_oo.phpt29 if (!$res = $mysqli->query("SELECT id, label FROM test ORDER BY id LIMIT 1")) {
41 if (!$res = $mysqli->query("SELECT 1 AS a, 2 AS a, 3 AS c, 4 AS C, NULL AS d, true AS e")) {
42 printf("[007] Cannot run query, [%d] %s\n", $mysqli->errno, $mysqli->error);
H A Dbug42548.phpt27 $mysqli->query("DROP PROCEDURE IF EXISTS p1") or die($mysqli->error);
28 $mysqli->query("CREATE PROCEDURE p1() BEGIN SELECT 23; SELECT 42; END") or die($mysqli->error);
50 $mysqli->query("DROP PROCEDURE p1") or die($mysqli->error);
H A Dbug79084_collision.phpt25 $res = $link->query($sql);
33 $res = $link->query($sql);
H A Dbug54221.phpt25 $query = "$create;$create;$create;";
26 if ($link->multi_query($query)) {
H A Dmysqli_insert_id_variation.phpt17 $link->query("DROP TABLE IF EXISTS test_insert_id_var");
18 $link->query("CREATE TABLE test_insert_id_var (id INT auto_increment, PRIMARY KEY (id))");
19 $link->query("INSERT INTO test_insert_id_var VALUES (null)");
88 $link->query("DROP TABLE IF EXISTS test_insert_id_var");
/PHP-8.1/ext/sqlite3/tests/
H A Dbug63921-32bit.phpt13 $conn->query('CREATE TABLE users (id INTEGER NOT NULL, num INTEGER NOT NULL, PRIMARY KEY(id))');
20 $stmt = $conn->query('SELECT num FROM users');
H A Dbug63921-64bit.phpt13 $conn->query('CREATE TABLE users (id INTEGER NOT NULL, num INTEGER NOT NULL, PRIMARY KEY(id))');
20 $stmt = $conn->query('SELECT num FROM users');
H A Dbug73068.phpt18 $r = $db->query("SELECT * FROM t1 WHERE a='1' AND b='2'");
23 $r = $db->query("SELECT * FROM t1;");
H A Dsqlite3_13_skip_all_cleanup.phpt2 SQLite3::query Skip all cleanup
19 $results = $db->query("SELECT * FROM test ORDER BY id ASC");
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
/PHP-8.1/ext/pdo_sqlite/tests/
H A Dbug44327_2.phpt10 $x = $db->query('select 1 as queryString');
18 $x = $db->query('select 1 as queryString');
H A Dbug78192.phpt9 $connection->query('CREATE TABLE user (id INTEGER PRIMARY KEY NOT NULL, name VARCHAR(255) NOT NULL)…
21 $connection->query('ALTER TABLE user ADD new_col VARCHAR(255)');
H A Dbug_42589.phpt9 $options = $db->query('PRAGMA compile_options')->fetchAll(PDO::FETCH_COLUMN);
20 $result = $db->query('SELECT * FROM test t1 LEFT JOIN test t2 ON t1.field1 = t2.field1');
/PHP-8.1/ext/pdo_pgsql/tests/
H A Dbug67462.phpt22 $pdo->query("CREATE TABLE b67462 (a int NOT NULL PRIMARY KEY DEFERRABLE INITIALLY DEFERRED)");
23 $pdo->query("INSERT INTO b67462 VALUES (1), (1)");
/PHP-8.1/ext/dom/tests/
H A Dbug36756.phpt12 $node = $xpath->query('/root')->item(0);
19 $node = $xpath->query('//child')->item(0);
/PHP-8.1/ext/pdo_oci/tests/
H A Dpdo_oci_stream_2.phpt19 $query = "begin execute immediate 'drop table pdo_oci_stream_2'; exception when others then if sqlc…
20 $stmt = $db->prepare($query);
23 $query = "create table pdo_oci_stream_2 (id number, data1 blob, data2 blob)";
24 $stmt = $db->prepare($query);
83 foreach($db->query("select data1 as d4_1, data2 as d4_2 from pdo_oci_stream_2 order by id") as $row…
/PHP-8.1/ext/pdo_mysql/tests/
H A Dbug_42499.phpt13 $stmt = $db->query('SELECT VERSION() as _version');
33 $stmt = $db->query('SELECT id AS _id FROM test');
70 …ely, if your code is only ever going to run against mysql, you may enable query buffering by setti…
80 …ely, if your code is only ever going to run against mysql, you may enable query buffering by setti…
H A Dpdo_mysql_stmt_fetchobject.phpt12 $query = "SELECT '', NULL, \"\" FROM DUAL";
13 $stmt = $db->prepare($query);
30 $query = "SELECT id, '', NULL, \"\" FROM test ORDER BY id ASC LIMIT 3";
31 $stmt = $db->prepare($query);
H A Dgh-11587.phpt38 $results = $db->query('SELECT * FROM test');
48 $results = $db->query('SELECT * FROM test');
58 $results = $db->query('SELECT * FROM test');
68 $results = $db->query('SELECT * FROM test');

Completed in 32 milliseconds

12345678910>>...22