Home
last modified time | relevance | path

Searched refs:sql (Results 51 – 75 of 140) sorted by relevance

123456

/PHP-8.2/ext/mysqli/tests/
H A Dmysqli_fetch_assoc_bit.phpt44 …!mysqli_query($link, $sql = sprintf('CREATE TABLE test(id BIGINT, bit_value BIT(%d) NOT NULL, bit_…
69 $sql = sprintf("INSERT INTO test(id, bit_value) VALUES (%s, b'%s')", $value, $bin);
74 if (!mysqli_query($link, $sql))
77 …$sql = sprintf("SELECT id, BIN(bit_value) AS _bin, bit_value + 0 AS _bit_value0, bit_value, bit_nu…
78 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);
131 $format, $sql);
233 …$sql = sprintf('INSERT INTO test(targetport, current_targets, maxreports, trend) VALUES (%d, %f, %…
[all …]
H A Dmysqli_stmt_get_result_bit.phpt51 …!mysqli_query($link, $sql = sprintf('CREATE TABLE test(id BIGINT UNSIGNED, bit_value BIT(%d) NOT N…
79 $sql = sprintf("INSERT INTO test(id, bit_value) VALUES (%s, b'%s')", $value, $bin);
84 if (!mysqli_stmt_prepare($stmt, $sql) ||
88 …$sql = sprintf("SELECT bin(bit_value) AS _bin, id, bit_value, bit_null FROM test WHERE id = %s", $…
89 if (!mysqli_stmt_prepare($stmt, $sql) ||
H A Dbug70949.phpt18 $sql = "select * from bug70949";
20 if ($stmt = $mysql->prepare($sql))
H A Dmysqli_stmt_bind_param_references.phpt15 $sql = sprintf("SELECT id, label FROM test WHERE id = '%d' AND label = '%s'",
17 if (!$res = mysqli_query($link, $sql)) {
19 $offset, $sql, mysqli_errno($link), mysqli_error($link));
24 $offset, $sql, mysqli_errno($link), mysqli_error($link));
45 $sql = sprintf("DELETE FROM test WHERE id = '%d' AND label = '%s'",
47 if (!mysqli_query($link, $sql)) {
49 $offset, $sql, mysqli_errno($link), mysqli_error($link));
H A Dmysqli_fetch_field_types.phpt28 $sql = sprintf("INSERT INTO test(id) VALUES ('%s')", $php_value);
30 $sql = sprintf("INSERT INTO test(id) VALUES (%s)", $php_value);
32 if (!mysqli_query($link, $sql)) {
33 printf("[003] '%s' - '%s' - '%s', [%d] %s\n", $sql_type, $create, $sql,
H A Dmysqli_real_query.phpt18 if (false !== ($tmp = mysqli_real_query($link, "SELECT 'this is sql but with backslash g'\g")))
24 if (!mysqli_real_query($link, "SELECT 'this is sql but with semicolon' AS valid ; "))
33 …if (false !== ($res = mysqli_real_query($link, "SELECT 'this is sql but with semicolon' AS valid ;…
101 string(30) "this is sql but with semicolon"
H A Dgh12107.phpt15 $sql = <<<SQL
21 $mysqli->query($sql);
/PHP-8.2/ext/pgsql/tests/
H A D17result.phpt15 $sql = "SELECT * FROM $table_name ORDER BY num";
16 $result = pg_query($db, $sql) or die('Cannot query db');
H A D22pg_fetch_object.phpt21 $sql = "SELECT * FROM $table_name WHERE num = 0";
22 $result = pg_query($db, $sql) or die('Cannot query db');
H A Dbug37100.phpt29 $sql = "BEGIN; DECLARE mycursor BINARY CURSOR FOR SELECT binfield FROM test_bug; FETCH ALL IN mycur…
31 $data = pg_query($sql);
H A Dbug37100_9.phpt28 $sql = "BEGIN; DECLARE mycursor BINARY CURSOR FOR SELECT binfield FROM test_bug; FETCH ALL IN mycur…
30 $data = pg_query($db, $sql);
/PHP-8.2/ext/oci8/tests/
H A Dbug32325.phpt27 $sql = "begin
31 $stmt = oci_parse($c, $sql);
H A Dstatement_type.phpt26 foreach ($sqls as $sql) {
27 $s = oci_parse($c, $sql);
H A Dbug71600.phpt29 $sql = "select col1,col2,col3,col4,col5,col6,col7,col8,col9 from bug71600_tab";
32 $stmt = oci_parse($c, $sql);
53 $stmt = oci_parse($c, $sql);
H A Dbug42841.phpt51 $sql = "BEGIN bug42841_proc(:cursor); END;";
52 $stmt = oci_parse($c, $sql);
69 $sql = "BEGIN bug42841_proc(:cursor); END;";
70 $stmt = oci_parse($c, $sql);
H A Dcursor_bind.phpt27 $sql = "
37 $stmt = oci_parse($c, $sql);
H A Dcursor_bind_err.phpt29 $sql = "select cursor(select * from cursor_bind_err_tab) into :cursor from dual";
30 $stmt = oci_parse($c, $sql);
H A Derror_bind_3.phpt23 $sql = "begin
28 $s = oci_parse($c, $sql);
H A Dcursors.phpt32 $sql = "select CURSOR(select * from ".$schema.$table_name.") as curs FROM dual";
33 $stmt = oci_parse($c, $sql);
/PHP-8.2/ext/pdo_mysql/tests/
H A Dpdo_mysql_exec_select.phpt12 function exec_and_count($offset, &$db, $sql, $exp) {
16 $ret = $db->exec($sql);
19 $offset, $exp, gettype($exp), $ret, gettype($ret), $sql,
26 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo()));
H A Dpdo_mysql_prepare_emulated.phpt186 $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = :placeholder)",
188 $stmt = prepex(39, $db, $sql, array('placeholder' => -1));
193 $sql = sprintf("SELECT id, label FROM test WHERE (id = :placeholder) OR (label LIKE %s)",
195 $stmt = prepex(41, $db, $sql, array('placeholder' => 1));
200 $stmt = prepex(43, $db, $sql, array('placeholder' => 1));
295 $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = ?)",
297 $stmt = prepex(79, $db, $sql, array(-1));
302 $sql = sprintf("SELECT id, label FROM test WHERE (id = ?) OR (label LIKE %s)",
304 $stmt = prepex(81, $db, $sql, array(1));
309 $stmt = prepex(83, $db, $sql, array(1, 1));
[all …]
/PHP-8.2/ext/pdo_firebird/tests/
H A Dbug_62024.phpt22 $sql = "insert into test_insert (id, text) values (?, ?)";
23 $sttmt = $dbh->prepare($sql);
/PHP-8.2/ext/pdo_firebird/
H A Dfirebird_driver.c296 int preprocess(const zend_string* sql, char* sql_out, HashTable* named_params) in preprocess() argument
302 const char* p = ZSTR_VAL(sql), * end = ZSTR_VAL(sql) + ZSTR_LEN(sql); in preprocess()
368 strcpy(sql_out, ZSTR_VAL(sql)); in preprocess()
509 static bool firebird_handle_preparer(pdo_dbh_t *dbh, zend_string *sql, /* {{{ */ in firebird_handle_preparer() argument
529 if (!firebird_alloc_prepare_stmt(dbh, sql, &num_sqlda, &s, np)) { in firebird_handle_preparer()
594 static zend_long firebird_handle_doer(pdo_dbh_t *dbh, const zend_string *sql) /* {{{ */ in firebird_handle_doer() argument
609 if (!firebird_alloc_prepare_stmt(dbh, sql, &out_sqlda, &stmt, 0)) { in firebird_handle_doer()
783 static int firebird_alloc_prepare_stmt(pdo_dbh_t *dbh, const zend_string *sql, in firebird_alloc_prepare_stmt() argument
790 if (ZSTR_LEN(sql) > 65536) { in firebird_alloc_prepare_stmt()
813 new_sql = emalloc(ZSTR_LEN(sql)+1); in firebird_alloc_prepare_stmt()
[all …]
/PHP-8.2/ext/sqlite3/
H A Dsqlite3.c208 zend_string *sql; in PHP_METHOD() local
476 zend_string *sql; in PHP_METHOD() local
483 if (ZSTR_LEN(sql)) { in PHP_METHOD()
501 zend_string *sql; in PHP_METHOD() local
513 if (!ZSTR_LEN(sql)) { in PHP_METHOD()
547 zend_string *sql; in PHP_METHOD() local
558 if (!ZSTR_LEN(sql)) { in PHP_METHOD()
661 zend_string *sql; in PHP_METHOD() local
674 if (!ZSTR_LEN(sql)) { in PHP_METHOD()
1624 sqlite3_free(sql); in PHP_METHOD()
[all …]

Completed in 53 milliseconds

123456