Home
last modified time | relevance | path

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

12345

/PHP-7.4/ext/mysqli/tests/
H A Dbug75018.phpt15 $sql = "DROP TABLE IF EXISTS $tbl";
16 $mysqli->query($sql);
18 $sql = "CREATE TABLE $tbl (bit_column_1 bit(16) NOT NULL) DEFAULT CHARSET=utf8";
19 $mysqli->query($sql);
21 $sql = "INSERT INTO $tbl (bit_column_1) VALUES (0)";
22 $mysqli->query($sql);
23 $sql = "INSERT INTO $tbl (bit_column_1) VALUES (0b10101010101)";
24 $mysqli->query($sql);
26 $sql = "SELECT bit_column_1 FROM $tbl";
27 $result = $mysqli->query($sql);
H A Dbug79084_collision.phpt11 $sql = "SELECT 11111 as `1`, 22222 as `2`";
15 $link->real_query($sql);
24 $res = $link->query($sql);
32 $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.phpt11 $sql = "SELECT 0 as `2007`, 0 as `2008`, 0 as `2020`";
15 $link->real_query($sql);
24 $res = $link->query($sql);
32 $res = $link->query($sql);
H A Dbug42378.phpt25 $sql = sprintf("CREATE TABLE test(id INT AUTO_INCREMENT PRIMARY KEY, col1 %s) ENGINE=%s",
27 if (!mysqli_query($link, $sql)) {
38 $sql = sprintf("INSERT INTO test(id, col1) VALUES (%d, %f)",
40 if (!mysqli_query($link, $sql)) {
62 $sql = sprintf('SELECT %s AS _format FROM %s ORDER BY %s', $format, $from, $order_by);
64 $sql = sprintf('SELECT %s AS _format FROM %s', $format, $from);
66 if (!mysqli_stmt_prepare($stmt, $sql)) {
109 $format, $sql);
142 $format, $sql);
/PHP-7.4/ext/pdo_firebird/tests/
H A Ddialect_1.phpt2 PDO_Firebird: support 1 sql dialect
18 $sql =
25 $query = $dbh->prepare($sql);
36 $sql='INSERT INTO test_d1(K, DT) values(?, ?)';
37 $query = $dbh->prepare($sql);
41 $sql='SELECT * FROM test_d1';
42 $query = $dbh->prepare($sql);
/PHP-7.4/ext/pdo/tests/
H A Dbug_65946.phpt21 $sql = 'SELECT TOP :limit * FROM test';
24 $sql = 'SELECT TOP (:limit) * FROM test';
27 $sql = 'SELECT FIRST :limit * FROM test';
30 //$sql = 'SELECT * FROM test FETCH FIRST :limit ROWS ONLY'; // Oracle 12c syntax
31 …$sql = "select id from (select a.*, rownum rnum from (SELECT * FROM test) a where rownum <= :limit…
34 $sql = 'SELECT * FROM test LIMIT :limit';
37 $stmt = $db->prepare($sql);
H A Dbug_71885.phpt22 $sql = "SELECT * FROM test WHERE a ?? 1";
25 $db->exec($sql);
31 $stmt = $db->prepare($sql);
42 $stmt = $db->prepare($sql);
/PHP-7.4/ext/odbc/tests/
H A Dbug47803.phpt54 $sql = "UPDATE FOO
57 $result = odbc_prepare($link, $sql);
59 print ('[sql] prep: '.$sql);
64 print ('[sql] exec: '."array({$k['name']}, {$k['id']})");
70 $sql = "SELECT * FROM FOO WHERE [PAR_ID] = ?";
71 $result = odbc_prepare($link, $sql);
73 print ('[sql] prep: '.$sql);
78 print ('[sql] exec: '."array({$k['id']})");
H A Dbug73448.phpt21 foreach ($sqlCommandList as $exampleNumber => $sql) {
22 $r = @odbc_exec($conn, $sql);
28 var_dump($sql, $n, $e);
/PHP-7.4/ext/oci8/tests/
H A Dbind_boolean_1.phpt25 $sql = "begin
30 $s = oci_parse($c, $sql);
40 $sql = "begin :b := true; end;";
41 $s = oci_parse($c, $sql);
49 $sql =
57 $s = oci_parse($c, $sql);
67 $sql =
75 $s = oci_parse($c, $sql);
85 $sql =
93 $s = oci_parse($c, $sql);
H A Dbug71148.phpt40 $sql = "select :var1, :var2 from dual";
45 $stmt = oci_parse($c, $sql);
57 $sql = "begin :output1 := 'OUTSTR1'; :output2 := 'OUTSTR2'; end;";
62 $stmt = oci_parse($c, $sql);
80 $stmt = oci_parse($c, $sql);
93 $sql= "begin :output := bindfunc(:var1, :var2); end;";
98 $stmt = oci_parse($c, $sql);
110 $sql = "call bindproc(:var1, :var2, :var3)";
116 $stmt = oci_parse($c, $sql);
132 $sql = "call bindproc(:var1, :var2, :var3)";
[all …]
H A Ddefine6.phpt25 $sql =
36 $s1 = oci_parse($c, $sql);
49 $s2 = oci_parse($c, $sql);
63 $s3 = oci_parse($c, $sql);
76 $s4 = oci_parse($c, $sql);
89 $s5 = oci_parse($c, $sql);
102 $s6 = oci_parse($c, $sql);
H A Dexec_fetch.phpt10 $sql = "select 2 from nonex_dual";
11 $stmt = oci_parse($c, $sql);
/PHP-7.4/ext/pdo_dblib/tests/
H A Dtimeout.phpt13 $sql = 'WAITFOR DELAY \'00:00:02\'';
16 $stmt = $db->prepare($sql);
24 $stmt = $db->prepare($sql);
37 $stmt = $db->prepare($sql);
49 $stmt = $db->prepare($sql);
61 $stmt = $db->prepare($sql);
H A Ddatetime_convert.phpt12 $sql = "SELECT convert(datetime, '20171027 10:22:44.135') AS [d]";
16 $stmt = $db->query($sql);
22 $stmt = $db->query($sql);
H A Ddatetime2.phpt13 $sql = "SELECT convert(datetime2, '10231017 10:22:44.1355318') AS [d]";
17 $stmt = $db->query($sql);
22 $stmt = $db->query($sql);
H A Dbug_69592.phpt12 $sql = '
19 $stmt = $db->query($sql);
29 $stmt = $db->query($sql);
H A Dstringify_uniqueidentifier.phpt17 $sql = "SELECT CAST('$testGUID' as uniqueidentifier) as [guid]";
31 $stmt = $db->query($sql);
41 $stmt = $db->query($sql);
55 $stmt = $db->query($sql);
/PHP-7.4/ext/pcre/tests/
H A Dbug41050.phpt9 $sql = 'SELECT * FROM #__components';
11 if (preg_match($regex,$sql, $m)) echo 'matched';
/PHP-7.4/ext/pdo_firebird/
H A Dfirebird_driver.c86 static int firebird_handle_preparer(pdo_dbh_t *dbh, const char *sql, size_t sql_len, /* {{{ */ in firebird_handle_preparer() argument
106 if (!firebird_alloc_prepare_stmt(dbh, sql, sql_len, &num_sqlda, &s, np)) { in firebird_handle_preparer()
172 static zend_long firebird_handle_doer(pdo_dbh_t *dbh, const char *sql, size_t sql_len) /* {{{ */ in firebird_handle_doer() argument
187 if (!firebird_alloc_prepare_stmt(dbh, sql, sql_len, &out_sqlda, &stmt, 0)) { in firebird_handle_doer()
396 if ( !(in_quote ^= (sql[l] == '\''))) { in firebird_alloc_prepare_stmt()
398 switch (sql[l]) { in firebird_alloc_prepare_stmt()
402 *ppname++ = sql[l]; in firebird_alloc_prepare_stmt()
409 … if ((in_param &= ((sql[l] >= 'A' && sql[l] <= 'Z') || (sql[l] >= 'a' && sql[l] <= 'z') in firebird_alloc_prepare_stmt()
410 … || (sql[l] >= '0' && sql[l] <= '9') || sql[l] == '_' || sql[l] == '-'))) { in firebird_alloc_prepare_stmt()
413 *ppname++ = sql[l]; in firebird_alloc_prepare_stmt()
[all …]
/PHP-7.4/ext/pgsql/tests/
H A Dbug72028.phpt17 $sql = "INSERT INTO $table (value, details) VALUES ($1, $2)";
20 $result = pg_query_params($conn, $sql, $params);
28 $result = pg_query_params($conn, $sql, $params2);
H A D08escape.phpt47 $sql = "INSERT INTO ".$table_name." (num, bin) VALUES (10000, CAST ('".$escaped_data."' AS BYTEA));…
48 pg_query($db, $sql);
52 $sql = "SELECT bin::bytea FROM ".$table_name." WHERE num = 10000";
53 $result = pg_query($db, $sql);
65 $result = pg_query($db, $sql);
/PHP-7.4/ext/pdo_pgsql/tests/
H A Dbug72294.phpt100 public function prepare( $pdo, $sql )
102 //return $pdo->prepare( $sql );
103 $this->cached_statements[$sql] = $pdo->prepare( $sql );
105 return $this->cached_statements[$sql];
/PHP-7.4/ext/pdo_mysql/tests/
H A Dpdo_mysql_exec_ddl.phpt11 function exec_and_count($offset, &$db, $sql, $exp, $suppress_warning = false) {
16 $ret = @$db->exec($sql);
18 $ret = $db->exec($sql);
22 $offset, $exp, gettype($exp), $ret, gettype($ret), $sql,
29 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo()));

Completed in 41 milliseconds

12345