Home
last modified time | relevance | path

Searched refs:sql (Results 1 – 25 of 140) sorted by relevance

123456

/PHP-8.3/ext/mysqli/tests/
H A Dbug75018.phpt16 $sql = "DROP TABLE IF EXISTS $tbl";
17 $mysqli->query($sql);
19 $sql = "CREATE TABLE $tbl (bit_column_1 bit(16) NOT NULL) DEFAULT CHARSET=utf8";
20 $mysqli->query($sql);
22 $sql = "INSERT INTO $tbl (bit_column_1) VALUES (0)";
23 $mysqli->query($sql);
24 $sql = "INSERT INTO $tbl (bit_column_1) VALUES (0b10101010101)";
25 $mysqli->query($sql);
27 $sql = "SELECT bit_column_1 FROM $tbl";
28 $result = $mysqli->query($sql);
H A Dbug79084_collision.phpt12 $sql = "SELECT 11111 as `1`, 22222 as `2`";
16 $link->real_query($sql);
25 $res = $link->query($sql);
33 $res = $link->query($sql);
H A Dmysqli_stmt_result_metadata_sqltests.phpt19 $offset, $sql,
32 $offset + 1, $sql);
36 $offset + 2, $sql);
42 $offset + 3, $sql,
79 $offset + 5, $sql);
90 $offset + 6, $sql,
98 $offset + 7, $sql,
103 $offset + 8, $sql,
110 $offset + 9, $sql,
116 $offset + 10, $sql,
[all …]
H A Dbug79084.phpt12 $sql = "SELECT 0 as `2007`, 0 as `2008`, 0 as `2020`";
16 $link->real_query($sql);
25 $res = $link->query($sql);
33 $res = $link->query($sql);
/PHP-8.3/ext/pdo_firebird/tests/
H A Ddialect_1.phpt2 PDO_Firebird: support 1 sql dialect
20 $sql =
27 $query = $dbh->prepare($sql);
38 $sql='INSERT INTO test_d1(K, DT) values(?, ?)';
39 $query = $dbh->prepare($sql);
43 $sql='SELECT * FROM test_d1';
44 $query = $dbh->prepare($sql);
H A Dignore_parammarks.phpt16 $sql = '
22 $query = $dbh->prepare($sql);
28 $sql = '
33 $query = $dbh->prepare($sql);
/PHP-8.3/ext/oci8/tests/
H A Dlob_prefetch_ini.phpt49 function get_clob_loc($c, $sql, $pfl) {
50 $stid = oci_parse($c, $sql);
63 function get_clob_inline($c, $sql, $pfl) {
64 $stid = oci_parse($c, $sql);
90 function get_blob_loc($c, $sql, $pfl) {
91 $stid = oci_parse($c, $sql);
113 $locarr = get_clob_loc($c, $sql, -1);
122 $locarr = get_clob_loc($c, $sql, 0);
123 $inlinearr = get_clob_inline($c, $sql, 0);
131 $locarr = get_clob_loc($c, $sql, 1000);
[all …]
H A Dbind_boolean_1.phpt27 $sql = "begin
32 $s = oci_parse($c, $sql);
42 $sql = "begin :b := true; end;";
43 $s = oci_parse($c, $sql);
51 $sql =
59 $s = oci_parse($c, $sql);
69 $sql =
77 $s = oci_parse($c, $sql);
87 $sql =
95 $s = oci_parse($c, $sql);
H A Dlob_prefetch.phpt48 function get_clob_loc($c, $sql, $pfl) {
49 $stid = oci_parse($c, $sql);
62 function get_clob_inline($c, $sql, $pfl) {
63 $stid = oci_parse($c, $sql);
89 function get_blob_loc($c, $sql, $pfl) {
90 $stid = oci_parse($c, $sql);
124 $locarr = get_clob_loc($c, $sql, 100000);
125 $inlinearr = get_clob_inline($c, $sql, 100000);
133 $locarr = get_clob_loc($c, $sql, 100);
134 $inlinearr = get_clob_inline($c, $sql, 100);
[all …]
H A Dbug71148.phpt43 $sql = "select :var1, :var2 from dual";
48 $stmt = oci_parse($c, $sql);
60 $sql = "begin :output1 := 'OUTSTR1'; :output2 := 'OUTSTR2'; end;";
65 $stmt = oci_parse($c, $sql);
83 $stmt = oci_parse($c, $sql);
96 $sql= "begin :output := bindfunc(:var1, :var2); end;";
101 $stmt = oci_parse($c, $sql);
113 $sql = "call bindproc(:var1, :var2, :var3)";
119 $stmt = oci_parse($c, $sql);
135 $sql = "call bindproc(:var1, :var2, :var3)";
[all …]
H A Ddefine6.phpt28 $sql =
39 $s1 = oci_parse($c, $sql);
52 $s2 = oci_parse($c, $sql);
66 $s3 = oci_parse($c, $sql);
79 $s4 = oci_parse($c, $sql);
92 $s5 = oci_parse($c, $sql);
105 $s6 = oci_parse($c, $sql);
/PHP-8.3/ext/odbc/tests/
H A Dbug47803.phpt55 $sql = "UPDATE bug47803
58 $result = odbc_prepare($link, $sql);
60 print ('[sql] prep: '.$sql);
65 print ('[sql] exec: '."array({$k['name']}, {$k['id']})");
71 $sql = "SELECT * FROM bug47803 WHERE [PAR_ID] = ?";
72 $result = odbc_prepare($link, $sql);
74 print ('[sql] prep: '.$sql);
79 print ('[sql] exec: '."array({$k['id']})");
/PHP-8.3/ext/pdo/tests/
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';
38 $stmt = $db->prepare($sql);
H A Dbug_71885.phpt24 $sql = "SELECT * FROM test WHERE a ?? 1";
27 $db->exec($sql);
33 $stmt = $db->prepare($sql);
44 $stmt = $db->prepare($sql);
H A Dbug_72368.phpt20 $sql = "SELECT 1";
24 $stmt = $db->prepare($sql);
33 $stmt = $db->prepare($sql);
/PHP-8.3/ext/pdo_dblib/tests/
H A Ddatetime_convert.phpt13 $sql = "SELECT convert(datetime, '20171027 10:22:44.135') AS [d]";
17 $stmt = $db->query($sql);
23 $stmt = $db->query($sql);
H A Ddatetime2.phpt14 $sql = "SELECT convert(datetime2, '10231017 10:22:44.1355318') AS [d]";
18 $stmt = $db->query($sql);
23 $stmt = $db->query($sql);
H A Dtimeout.phpt14 $sql = 'WAITFOR DELAY \'00:00:02\'';
20 $stmt = $db->prepare($sql);
34 $stmt = $db->prepare($sql);
46 $stmt = $db->prepare($sql);
58 $stmt = $db->prepare($sql);
H A Dbug_69592.phpt13 $sql = '
20 $stmt = $db->query($sql);
30 $stmt = $db->query($sql);
H A Dstringify_uniqueidentifier.phpt18 $sql = "SELECT CAST('$testGUID' as uniqueidentifier) as [guid]";
32 $stmt = $db->query($sql);
42 $stmt = $db->query($sql);
56 $stmt = $db->query($sql);
/PHP-8.3/ext/pdo_mysql/tests/
H A Dbug66878.phpt16 $sql = 'SELECT 123; SELECT 42; SELECT 999';
18 $stmt = $pdo->query($sql);
24 $stmt = $pdo->query($sql);
H A Dpdo_mysql_local_infile_directory_denied.phpt16 function exec_and_count($offset, &$db, $sql, $exp) {
18 $ret = $db->exec($sql);
21 $offset, $exp, gettype($exp), $ret, gettype($ret), $sql,
27 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo()));
48 …$sql = sprintf("LOAD DATA LOCAL INFILE %s INTO TABLE test FIELDS TERMINATED BY ';' LINES TERMINATE…
49 if (exec_and_count(3, $db, $sql, false)) {
H A Dpdo_mysql_local_infile_directory_allowed.phpt16 function exec_and_count($offset, &$db, $sql, $exp) {
18 $ret = $db->exec($sql);
21 $offset, $exp, gettype($exp), $ret, gettype($ret), $sql,
27 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo()));
48 …$sql = sprintf("LOAD DATA LOCAL INFILE %s INTO TABLE test FIELDS TERMINATED BY ';' LINES TERMINATE…
49 if (exec_and_count(3, $db, $sql, 3)) {
H A Dpdo_mysql_local_infile_overrides_local_infile_directory.phpt16 function exec_and_count($offset, &$db, $sql, $exp) {
18 $ret = $db->exec($sql);
21 $offset, $exp, gettype($exp), $ret, gettype($ret), $sql,
27 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo()));
48 …$sql = sprintf("LOAD DATA LOCAL INFILE %s INTO TABLE test FIELDS TERMINATED BY ';' LINES TERMINATE…
49 if (exec_and_count(3, $db, $sql, 3)) {
/PHP-8.3/ext/pcre/tests/
H A Dbug41050.phpt9 $sql = 'SELECT * FROM #__components';
11 if (preg_match($regex,$sql, $m)) echo 'matched';

Completed in 28 milliseconds

123456