Home
last modified time | relevance | path

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

12345

/PHP-5.5/ext/mysqli/tests/
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 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);
H A Dmysqli_stmt_fetch_bit.phpt30 …!mysqli_query($link, $sql = sprintf('CREATE TABLE test(id INT, label BIT(%d)) ENGINE="%s"', $bits,…
39 $sql = sprintf("INSERT INTO test(id, label) VALUES (%d, b'%s')", $value, decbin($value));
41 if (!mysqli_stmt_prepare($stmt, $sql) ||
46 $sql = sprintf("SELECT id, label + 0 AS _label0, label FROM test WHERE id = %d", $value);
47 if (!mysqli_stmt_prepare($stmt, $sql) ||
H A Dmysqli_fetch_array_large.phpt18 $sql = "INSERT INTO test(label) VALUES ";
20 while (strlen($sql) < ($package_size - 259))
21 $sql .= sprintf("('%s'), ", $random_char);
23 $sql = substr($sql, 0, -2);
24 $len = strlen($sql);
27 if (!@mysqli_query($link, $sql)) {
H A Dmysqli_fetch_assoc_bit.phpt48 …!mysqli_query($link, $sql = sprintf('CREATE TABLE test(id BIGINT, bit_value BIT(%d) NOT NULL, bit_…
73 $sql = sprintf("INSERT INTO test(id, bit_value) VALUES (%s, b'%s')", $value, $bin);
78 if (!mysqli_query($link, $sql))
81 …$sql = sprintf("SELECT id, BIN(bit_value) AS _bin, bit_value + 0 AS _bit_value0, bit_value, bit_nu…
82 if (!$res = mysqli_query($link, $sql))
H A Dmysqli_stmt_bind_result_format.phpt24 $sql = sprintf("CREATE TABLE test(id INT AUTO_INCREMENT PRIMARY KEY, col1 %s) ENGINE=%s",
26 if (!mysqli_query($link, $sql)) {
37 $sql = sprintf("INSERT INTO test(id, col1) VALUES (%d, %f)",
39 if (!mysqli_query($link, $sql)) {
60 $sql = sprintf('SELECT %s AS _format FROM %s ORDER BY %s', $format, $from, $order_by);
62 $sql = sprintf('SELECT %s AS _format FROM %s', $format, $from);
64 if (!mysqli_stmt_prepare($stmt, $sql)) {
107 $format, $sql);
129 $format, $sql);
231 …$sql = sprintf('INSERT INTO test(targetport, current_targets, maxreports, trend) VALUES (%d, %f, %…
[all …]
/PHP-5.5/ext/oci8/tests/
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);
H A Dbug36096.phpt10 $sql = "SELECT 'ABC' FROM DUAL WHERE 1<>1";
11 $stmt = oci_parse($c, $sql);
H A Dbug36010.phpt15 $sql = "begin :p_clob := 'lob string'; end;";
16 $stid = oci_parse($conn, $sql);
H A Dbug32325.phpt25 $sql = "begin
29 $stmt = oci_parse($c, $sql);
H A Dstatement_type.phpt26 foreach ($sqls as $sql) {
27 $s = oci_parse($c, $sql);
/PHP-5.5/ext/pdo_firebird/
H A Dfirebird_driver.c135 static int firebird_handle_preparer(pdo_dbh_t *dbh, const char *sql, long sql_len, /* {{{ */ in firebird_handle_preparer() argument
155 if (!firebird_alloc_prepare_stmt(dbh, sql, sql_len, &num_sqlda, &s, np TSRMLS_CC)) { in firebird_handle_preparer()
236 if (!firebird_alloc_prepare_stmt(dbh, sql, sql_len, &out_sqlda, &stmt, 0 TSRMLS_CC)) { in firebird_handle_doer()
394 static int firebird_alloc_prepare_stmt(pdo_dbh_t *dbh, const char *sql, long sql_len, /* {{{ */ in firebird_alloc_prepare_stmt() argument
428 if ( !(in_quote ^= (sql[l] == '\''))) { in firebird_alloc_prepare_stmt()
430 switch (sql[l]) { in firebird_alloc_prepare_stmt()
434 *ppname++ = sql[l]; in firebird_alloc_prepare_stmt()
441 … if ((in_param &= ((sql[l] >= 'A' && sql[l] <= 'Z') || (sql[l] >= 'a' && sql[l] <= 'z') in firebird_alloc_prepare_stmt()
442 … || (sql[l] >= '0' && sql[l] <= '9') || sql[l] == '_' || sql[l] == '-'))) { in firebird_alloc_prepare_stmt()
445 *ppname++ = sql[l]; in firebird_alloc_prepare_stmt()
[all …]
/PHP-5.5/ext/pcre/tests/
H A Dbug41050.phpt9 $sql = 'SELECT * FROM #__components';
11 if (preg_match($regex,$sql, $m)) echo 'matched';
/PHP-5.5/ext/pgsql/tests/
H A D08escape.phpt47 $sql = "INSERT INTO ".$table_name." (num, bin) VALUES (-9999, CAST ('".$escaped_data."' AS BYTEA));…
48 pg_query($db, $sql);
52 $sql = "SELECT bin::bytea FROM ".$table_name." WHERE num = -9999";
53 $result = pg_query($db, $sql);
65 $result = pg_query($db, $sql);
H A D22pg_fetch_object.phpt19 $sql = "SELECT * FROM $table_name WHERE num = 0";
20 $result = pg_query($db, $sql) or die('Cannot qeury db');
H A D17result.phpt13 $sql = "SELECT * FROM $table_name";
14 $result = pg_query($db, $sql) or die('Cannot qeury db');
H A Dbug37100_9.phpt26 $sql = "BEGIN; DECLARE mycursor BINARY CURSOR FOR SELECT binfield FROM test_bug; FETCH ALL IN mycur…
28 $data = pg_query($sql);
H A Dbug37100.phpt27 $sql = "BEGIN; DECLARE mycursor BINARY CURSOR FOR SELECT binfield FROM test_bug; FETCH ALL IN mycur…
29 $data = pg_query($sql);
/PHP-5.5/ext/pdo_mysql/tests/
H A Dpdo_mysql_exec_load_data.phpt22 function exec_and_count($offset, &$db, $sql, $exp) {
26 $ret = $db->exec($sql);
29 $offset, $exp, gettype($exp), $ret, gettype($ret), $sql,
43 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo()));
73 …$sql = sprintf("LOAD DATA LOCAL INFILE %s INTO TABLE test FIELDS TERMINATED BY ';' LINES TERMINATE…
75 if (exec_and_count(4, $db, $sql, 2)) {
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()));
H A Dpdo_mysql_exec_select.phpt11 function exec_and_count($offset, &$db, $sql, $exp) {
15 $ret = $db->exec($sql);
18 $offset, $exp, gettype($exp), $ret, gettype($ret), $sql,
25 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo()));
/PHP-5.5/ext/soap/interop/
H A Dclient_round2_interop.php196 $sql = "select * from endpoints ";
198 $sql .= "where class='$base' ";
199 if (!$all) $sql .= "and status=1";
201 if (!$all) $sql .= "where status=1";
202 $sql .= " order by endpointName";
205 $db_ep = $this->dbc->getAll($sql,NULL, DB_FETCHMODE_ASSOC );
207 echo $sql."\n";
274 $sql = "delete from results where endpoint=$endpoint_id ".
279 $res = $this->dbc->query($sql);
293 $res = $this->dbc->query($sql);
[all …]
/PHP-5.5/ext/pdo/tests/
H A Dpdo_020.phpt22 …ELECT id, val FROM test', 'SELECT id, val, val2 FROM test', 'SELECT COUNT(*) FROM test') as $sql) {
24 $stmt = $db->query($sql);
26 echo "Counted $res columns after $sql.\n";
/PHP-5.5/ext/pdo_pgsql/tests/
H A Dbug62479.phpt50 $sql = sprintf($template, 'my password');
51 $pdo->query($sql);
61 $sql = sprintf($template, "my pass''word");
62 $pdo->query($sql);

Completed in 74 milliseconds

12345