Home
last modified time | relevance | path

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

12345678910>>...30

/php-src/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-src/ext/pdo_mysql/tests/
H A Dbug41125.phpt25 "SELECT 1 FROM DUAL WHERE 1 = '?\'\''",
26 "SELECT 'a\\'0' FROM DUAL WHERE 1 = ?",
28 "SELECT 'foo?bar', '', '''' FROM DUAL WHERE ?"
41 $sql = "SELECT upper(:id) FROM DUAL WHERE '1'";
60 "SELECT UPPER(:id) FROM DUAL WHERE '1'",
61 "SELECT 1 FROM DUAL WHERE '\''",
64 "SELECT 1 FROM DUAL WHERE '\'' = ''''",
90 [1] Query: [[SELECT 1 FROM DUAL WHERE 1 = '?\'\'']]
94 [2] Query: [[SELECT 'a\'0' FROM DUAL WHERE 1 = ?]]
106 Query: [[SELECT upper(:id) FROM DUAL WHERE '1']]
[all …]
H A Dbug54929.phpt26 testQuery("/* ' */ SELECT ? AS f1 /* ' */");
27 testQuery("/* '-- */ SELECT ? AS f1 /* *' */");
28 testQuery("/* ' */ SELECT ? AS f1 --';");
29 testQuery("/* ' */ SELECT ? AS f1 -- 'a;");
30 testQuery("/*'**/ SELECT ? AS f1 /* ' */");
31 testQuery("/*'***/ SELECT ? AS f1 /* ' */");
34 **/ SELECT ? AS f1 /* ' */");
H A Dbug44327.phpt16 $stmt = $db->prepare("SELECT 1 AS \"one\"");
28 $stmt = $db->prepare("SELECT id FROM test_44327");
50 string(17) "SELECT 1 AS "one""
56 string(17) "SELECT 1 AS "one""
60 string(25) "SELECT id FROM test_44327"
64 string(25) "SELECT id FROM test_44327"
H A Dpdomysql_003.phpt24 $assertWarnings($db, 'SELECT 1 = 1', 0);
25 $assertWarnings($db, 'SELECT 1 = "A"', 1);
28 Query SELECT 1 = 1 produced 0 warnings
29 Query SELECT 1 = "A" produced 1 warnings
H A Dbug_44454.phpt21 $stmt = $db->query('SELECT a, b FROM test_44454');
22 printf("... SELECT has returned %d row...\n", $stmt->rowCount());
41 $stmt = $db->query('SELECT a, b FROM test_44454');
42 printf("... SELECT has returned %d row...\n", $stmt->rowCount());
74 ... SELECT has returned 1 row...
82 ... SELECT has returned 1 row...
92 ... SELECT has returned 1 row...
100 ... SELECT has returned 1 row...
/php-src/ext/pdo_sqlite/tests/
H A Dpdo_fetch_func_001.phpt14 $st = $db->query('SELECT * FROM test_fetch_func_001');
22 $st = $db->query('SELECT name FROM test_fetch_func_001');
26 $st = $db->query('SELECT * FROM test_fetch_func_001');
33 $st = $db->query('SELECT * FROM test_fetch_func_001');
40 $st = $db->query('SELECT * FROM test_fetch_func_001');
47 $st = $db->query('SELECT * FROM test_fetch_func_001');
54 $st = $db->query('SELECT * FROM test_fetch_func_001');
86 $st = $db->query('SELECT * FROM test_fetch_func_001');
90 $st = $db->query('SELECT * FROM test_fetch_func_001');
114 string(33) "SELECT * FROM test_fetch_func_001"
[all …]
/php-src/ext/pdo_firebird/tests/
H A Dgh10908.phpt43 query_and_dump($dbh, "SELECT CODE FROM gh10908"); // works fine
44 query_and_dump($dbh, "SELECT ID FROM gh10908"); // Used to "bus error"
45 query_and_dump($dbh, "SELECT NUM FROM gh10908"); // Used to "bus error"
46 query_and_dump($dbh, "SELECT DBL FROM gh10908"); // Used to "bus error"
47 query_and_dump($dbh, "SELECT TS FROM gh10908"); // Used to "bus error"
48 query_and_dump($dbh, "SELECT MYBLOB FROM gh10908"); // Used to "bus error"
49 query_and_dump($dbh, "SELECT * FROM gh10908"); // Used to "bus error"
51 query_and_dump($dbh, "SELECT CAST(NUM AS NUMERIC(9, 3)) FROM gh10908"); // works fine
52 query_and_dump($dbh, "SELECT CAST(ID AS INTEGER) FROM gh10908"); // works fine
53 query_and_dump($dbh, "SELECT CAST(ID AS BIGINT) FROM gh10908"); // Used to "bus error"
/php-src/ext/pdo/tests/
H A Dpdo_020.phpt23 foreach (array('SELECT id, val FROM test020', 'SELECT id, val, val2 FROM test020', 'SELECT COUNT(*)…
39 Counted 2 columns after SELECT id, val FROM test020.
40 Counted 3 columns after SELECT id, val, val2 FROM test020.
41 Counted 1 columns after SELECT COUNT(*) FROM test020.
H A Dbug_65946.phpt22 $sql = 'SELECT TOP :limit * FROM test65946';
25 $sql = 'SELECT TOP (:limit) * FROM test65946';
28 $sql = 'SELECT FIRST :limit * FROM test65946';
31 //$sql = 'SELECT * FROM test65946 FETCH FIRST :limit ROWS ONLY'; // Oracle 12c syntax
32 …$sql = "select id from (select a.*, rownum rnum from (SELECT * FROM test65946) a where rownum <= :…
35 $sql = 'SELECT * FROM test65946 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-src/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-src/ext/pcre/tests/
H A Dbug41050.phpt9 $sql = 'SELECT * FROM #__components';
20 [0] => SELECT * FROM #__components
21 [1] => SELECT
/php-src/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")'));

Completed in 83 milliseconds

12345678910>>...30