Home
last modified time | relevance | path

Searched refs:SELECT (Results 1 – 25 of 789) sorted by relevance

12345678910>>...32

/PHP-8.3/ext/mysqli/tests/
H A Dgh9841.phpt19 SELECT 1 AS val
21 SELECT 2
25 SELECT 1 AS val
27 SELECT 2
32 SELECT 1 AS val
34 SELECT 2
45 SELECT 2
52 SELECT 1 AS val
54 SELECT 2
63 SELECT 1 AS val
[all …]
H A Dmysqli_ps_select_union.phpt2 Prepared Statements and SELECT UNION
16 …if (!($res = $link->query("SELECT CAST('one' AS CHAR) AS column1 UNION SELECT CAST('three' AS CHAR…
27 …if (!($stmt = $link->prepare("SELECT CAST('one' AS CHAR) AS column1 UNION SELECT CAST('three' AS C…
71 …if (!($res = $link->query("SELECT 1 AS column1 UNION SELECT CAST('three' AS CHAR) UNION SELECT CAS…
81 …if (!($stmt = $link->prepare("SELECT 1 AS column1 UNION SELECT CAST('three' AS CHAR) UNION SELECT …
100 …if (!($stmt = $link->prepare("SELECT 1 AS column1 UNION SELECT CAST('three' AS CHAR) UNION SELECT …
118 if (!($res = $link->query("SELECT 1 AS column1 UNION SELECT 303 UNION SELECT 2")))
128 if (!($stmt = $link->prepare("SELECT 1 AS column1 UNION SELECT 303 UNION SELECT 2")))
147 if (!($stmt = $link->prepare("SELECT 1 AS column1 UNION SELECT 303 UNION SELECT 2")))
167 if (!($stmt = $link->prepare("SELECT 'one' AS column1 UNION SELECT ? UNION SELECT ?")))
[all …]
H A Dmysqli_fetch_column.phpt14 $res = mysqli_query($link, "SELECT id, label FROM test ORDER BY id LIMIT 1");
25 $res = mysqli_query($link, "SELECT
32 $res = mysqli_query($link, "SELECT
39 $res = mysqli_query($link, "SELECT
47 $res = mysqli_query($link, "SELECT
56 $res = mysqli_query($link, "SELECT
66 $res = mysqli_query($link, "SELECT
72 $res = mysqli_query($link, "SELECT
78 $res = mysqli_query($link, "SELECT id, label FROM test ORDER BY id LIMIT 1");
86 $res = mysqli_query($link, "SELECT id, label FROM test ORDER BY id LIMIT 1");
[all …]
H A Dmysqli_next_result.phpt16 $res = mysqli_query($link, "SELECT 1 AS res");
42 if (!($res = mysqli_query($link, "SELECT 1 AS b"))) {
50 …func_test_mysqli_next_result($link, "SELECT 1 AS a; SELECT 1 AS a, 2 AS b; SELECT id FROM test ORD…
51 …func_test_mysqli_next_result($link, "SELECT 1 AS a; INSERT INTO test(id, label) VALUES (100, 'y');…
52 func_test_mysqli_next_result($link, "DELETE FROM test WHERE id >= 100; SELECT 1 AS a; ", 11, 1);
H A Dbug45019.phpt2 Bug #45019 (Segmentation fault with SELECT ? and UNION)
16 …if (!($res = $link->query("SELECT CAST('one' AS CHAR) AS column1 UNION SELECT CAST('three' AS CHAR…
27 …if (!($stmt = $link->prepare("SELECT CAST('one' AS CHAR) AS column1 UNION SELECT CAST('three' AS C…
H A Dmysqli_pconn_reuse.phpt33 if (!$res = mysqli_query($link1, 'SELECT @pcondisabled AS _test'))
37 printf("Connection 1 - SELECT @pcondisabled -> '%s'\n", $row['_test']);
40 if (!$res = mysqli_query($link2, 'SELECT @pcondisabled AS _test'))
53 if (!$res = mysqli_query($link2, 'SELECT @pcondisabled AS _test'))
57 printf("Connection 2 - SELECT @pcondisabled -> '%s'\n", $row['_test']);
68 if (!$res = mysqli_query($link2, 'SELECT @pcondisabled AS _test'))
72 printf("Connection 2 (reuse) - SELECT @pcondisabled -> '%s'\n", $row['_test']);
85 Connection 1 - SELECT @pcondisabled -> 'Connection 1'
86 Connection 2 (no reuse) - SELECT @pcondisabled -> ''
88 Connection 2 - SELECT @pcondisabled -> 'Connection 2'
[all …]
H A Dmysqli_fetch_array_many_rows.phpt24 if (!$res = mysqli_query($link, 'SELECT id, label FROM test')) {
25 printf("[002] SELECT failed: [%d] %s\n", mysqli_errno($link), mysqli_errno($link));
34 if (!$res = mysqli_query($link, 'SELECT id, label FROM test')) {
35 printf("[003] SELECT failed: [%d] %s\n", mysqli_errno($link), mysqli_errno($link));
74 if (!$res = mysqli_query($link, 'SELECT id, label FROM test')) {
75 printf("[008] SELECT failed: [%d] %s\n", mysqli_errno($link), mysqli_errno($link));
84 if (!$res = mysqli_query($link, 'SELECT count(*) AS num FROM test')) {
85 printf("[009] SELECT failed: [%d] %s\n", mysqli_errno($link), mysqli_errno($link));
91 if (!$res = mysqli_query($link, 'SELECT id, label FROM test')) {
92 printf("[010] SELECT failed: [%d] %s\n", mysqli_errno($link), mysqli_errno($link));
H A Dmysqli_fetch_assoc_no_alias.phpt13 if (!$res = mysqli_query($link, "SELECT 1, 2")) {
20 if (!$res = mysqli_query($link, "SELECT 1 AS a, 2")) {
27 if (!$res = mysqli_query($link, "SELECT 1 AS a, 2, 2 as '2'")) {
34 if (!$res = mysqli_query($link, "SELECT 1 AS a, 2 as '2', 2")) {
42 if (!$res = mysqli_real_query($link, "SELECT 1, 2")) {
52 if (!$res = mysqli_real_query($link, "SELECT 1 AS a, 2")) {
62 if (!$res = mysqli_real_query($link, "SELECT 1 AS a, 2, 2 as '2'")) {
72 if (!$res = mysqli_real_query($link, "SELECT 1 AS a, 2 as '2', 2")) {
H A D057.phpt23 $stmt = mysqli_prepare($link, "SELECT * FROM test_store_result");
27 if ($result = mysqli_query($link, "SELECT * FROM test_store_result")) {
34 $stmt = mysqli_prepare($link, "SELECT * FROM test_store_result");
38 var_dump($stmt = mysqli_prepare($link, "SELECT * FROM test_store_result"));
43 … var_dump($stmt = @mysqli_prepare($link, "SELECT * FROM test_store_result"), mysqli_error($link));
45 $stmt = mysqli_prepare($link, "SELECT * FROM test_store_result");
53 if ($result = mysqli_query($link, "SELECT * FROM test_store_result")) {
H A Dmysqli_more_results.phpt16 …if (!mysqli_multi_query($link, "SELECT 1 AS a; SELECT 1 AS a, 2 AS b; SELECT id FROM test ORDER BY…
30 …if (!mysqli_multi_query($link, "SELECT 1 AS a; SELECT 1 AS a, 2 AS b; SELECT id FROM test ORDER BY…
H A Dmysqli_query.phpt22 if (false !== ($tmp = mysqli_query($link, "SELECT 'this is sql but with backslash g'\g")))
28 if (!$res = mysqli_query($link, "SELECT 'this is sql but with semicolon' AS valid ; "))
34 if (!$res = mysqli_query($link, "SELECT 'a' AS ''"))
41 …if (false !== ($res = mysqli_query($link, 'SELECT "this is sql but with semicolon" AS valid ; SHOW…
47 …if (mysqli_query($link, 'CREATE PROCEDURE p(OUT ver_param VARCHAR(25)) BEGIN SELECT VERSION() INTO…
49 $res = mysqli_query($link, 'SELECT @version AS p_version');
64 $res = mysqli_query($link, 'SELECT f(VERSION()) AS f_version');
78 … if (!is_object($res = mysqli_query($link, "SELECT id FROM test ORDER BY id", MYSQLI_USE_RESULT)))
82 …if (!is_object($res = mysqli_query($link, "SELECT id FROM test ORDER BY id", MYSQLI_STORE_RESULT)))
87 mysqli_query($link, "SELECT id FROM test ORDER BY id", 1234);
[all …]
H A Dbug31668.phpt14 $mysql->multi_query('SELECT 1;SELECT 2');
28 $mysql->multi_query('SELECT 1;SELECT 2');
/PHP-8.3/ext/pdo_mysql/tests/
H A Dbug41125.phpt28 "SELECT 1 FROM DUAL WHERE 1 = '?\'\''",
29 "SELECT 'a\\'0' FROM DUAL WHERE 1 = ?",
31 "SELECT 'foo?bar', '', '''' FROM DUAL WHERE ?"
44 $sql = "SELECT upper(:id) FROM DUAL WHERE '1'";
63 "SELECT UPPER(:id) FROM DUAL WHERE '1'",
64 "SELECT 1 FROM DUAL WHERE '\''",
67 "SELECT 1 FROM DUAL WHERE '\'' = ''''",
93 [1] Query: [[SELECT 1 FROM DUAL WHERE 1 = '?\'\'']]
97 [2] Query: [[SELECT 'a\'0' FROM DUAL WHERE 1 = ?]]
109 Query: [[SELECT upper(:id) FROM DUAL WHERE '1']]
[all …]
H A Dpdo_mysql_prepare_emulated.phpt99 // lets be fair and do the most simple SELECT first
100 $stmt = prepex(4, $db, 'SELECT 1 as "one"');
106 $stmt = prepex(8, $db, 'SELECT label FROM test');
112 $stmt = prepex(11, $db, 'SELECT label FROM test');
120 $stmt = prepex(15, $db, 'SELECT label FROM test');
199 …$sql = "SELECT id, label FROM test WHERE id = :placeholder AND label = (SELECT label AS 'SELECT' F…
208 $stmt = prepex(48, $db, 'SELECT label FROM test');
230 prepex(58, $db, 'SELECT ? FROM test WHERE ? > ?',
233 prepex(59, $db, 'SELECT ? FROM test WHERE ? > ?',
308 …$sql = "SELECT id, label FROM test WHERE id = ? AND label = (SELECT label AS 'SELECT' FROM test WH…
[all …]
H A Dbug44327.phpt17 $stmt = $db->prepare("SELECT 1 AS \"one\"");
30 $stmt = $db->prepare("SELECT id FROM test");
48 string(17) "SELECT 1 AS "one""
54 string(17) "SELECT 1 AS "one""
58 string(19) "SELECT id FROM test"
62 string(19) "SELECT id FROM test"
H A Dbug_44454.phpt26 $stmt = $db->query('SELECT a, b FROM test');
27 printf("... SELECT has returned %d row...\n", $stmt->rowCount());
46 $stmt = $db->query('SELECT a, b FROM test');
47 printf("... SELECT has returned %d row...\n", $stmt->rowCount());
80 ... SELECT has returned 1 row...
88 ... SELECT has returned 1 row...
98 ... SELECT has returned 1 row...
106 ... SELECT has returned 1 row...
/PHP-8.3/ext/pdo_firebird/tests/
H A Dgh10908.phpt41 query_and_dump($dbh, "SELECT CODE FROM gh10908"); // works fine
42 query_and_dump($dbh, "SELECT ID FROM gh10908"); // Used to "bus error"
43 query_and_dump($dbh, "SELECT NUM FROM gh10908"); // Used to "bus error"
44 query_and_dump($dbh, "SELECT DBL FROM gh10908"); // Used to "bus error"
45 query_and_dump($dbh, "SELECT TS FROM gh10908"); // Used to "bus error"
46 query_and_dump($dbh, "SELECT MYBLOB FROM gh10908"); // Used to "bus error"
47 query_and_dump($dbh, "SELECT * FROM gh10908"); // Used to "bus error"
49 query_and_dump($dbh, "SELECT CAST(NUM AS NUMERIC(9, 3)) FROM gh10908"); // works fine
50 query_and_dump($dbh, "SELECT CAST(ID AS INTEGER) FROM gh10908"); // works fine
51 query_and_dump($dbh, "SELECT CAST(ID AS BIGINT) FROM gh10908"); // Used to "bus error"
/PHP-8.3/ext/pdo_sqlite/tests/
H A Dpdo_fetch_func_001.phpt15 $st = $db->query('SELECT * FROM test_fetch_func_001');
18 $st = $db->query('SELECT name FROM test_fetch_func_001');
22 $st = $db->query('SELECT * FROM test_fetch_func_001');
29 $st = $db->query('SELECT * FROM test_fetch_func_001');
36 $st = $db->query('SELECT * FROM test_fetch_func_001');
43 $st = $db->query('SELECT * FROM test_fetch_func_001');
50 $st = $db->query('SELECT * FROM test_fetch_func_001');
82 $st = $db->query('SELECT * FROM test_fetch_func_001');
86 $st = $db->query('SELECT * FROM test_fetch_func_001');
110 string(33) "SELECT * FROM test_fetch_func_001"
[all …]
/PHP-8.3/ext/pdo/tests/
H A Dpdo_020.phpt23 foreach (array('SELECT id, val FROM test', 'SELECT id, val, val2 FROM test', 'SELECT COUNT(*) FROM …
33 Counted 2 columns after SELECT id, val FROM test.
34 Counted 3 columns after SELECT id, val, val2 FROM test.
35 Counted 1 columns after SELECT COUNT(*) FROM test.
H A Dbug_65946.phpt22 $sql = 'SELECT TOP :limit * FROM test';
25 $sql = 'SELECT TOP (:limit) * FROM test';
28 $sql = 'SELECT FIRST :limit * FROM test';
31 //$sql = 'SELECT * FROM test FETCH FIRST :limit ROWS ONLY'; // Oracle 12c syntax
32 …$sql = "select id from (select a.*, rownum rnum from (SELECT * FROM test) a where rownum <= :limit…
35 $sql = 'SELECT * FROM test LIMIT :limit';
H A Dbug_71447.phpt26 SELECT -- That's all folks!
36 SELECT
46 SELECT -- That's all folks!
56 SELECT /* That's all folks! */
66 SELECT -- Is it only \"single quotes?
76 SELECT -- What about question marks here?
87 SELECT -- What about placeholders :bar
/PHP-8.3/ext/pdo_pgsql/tests/
H A Ddisable_prepares.phpt19 $stmt = $db->prepare("SELECT statement FROM pg_prepared_statements", array(
22 $stmt2 = $db->prepare("SELECT (?)::int2");
31 $stmt3 = $db->prepare("SELECT (?)::int4", array(
51 string(17) "SELECT ($1)::int2"
55 string(17) "SELECT ($1)::int2"
/PHP-8.3/ext/pcre/tests/
H A Dbug41050.phpt9 $sql = 'SELECT * FROM #__components';
20 [0] => SELECT * FROM #__components
21 [1] => SELECT
/PHP-8.3/ext/sqlite3/tests/
H A Dsqlite3_29_createfunction.phpt12 var_dump($db->querySingle('SELECT strtoupper("test")'));
16 var_dump($db->querySingle('SELECT strtolower("TEST")'));
19 var_dump($db->querySingle('SELECT strtoupper("tEst")'));
/PHP-8.3/ext/pdo_dblib/tests/
H A Dpdo_dblib_param_str_natl.phpt13 $stmt = $db->prepare('SELECT :value');
20 SQL: [13] SELECT :value
21 Sent SQL: [13] SELECT N'foo'

Completed in 30 milliseconds

12345678910>>...32