/PHP-8.2/ext/mysqli/tests/ |
H A D | mysqli_fetch_assoc_bit.phpt | 44 …!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 D | mysqli_stmt_bind_result_format.phpt | 24 $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 D | mysqli_stmt_get_result_bit.phpt | 51 …!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 D | bug70949.phpt | 18 $sql = "select * from bug70949"; 20 if ($stmt = $mysql->prepare($sql))
|
H A D | mysqli_stmt_bind_param_references.phpt | 15 $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 D | mysqli_fetch_field_types.phpt | 28 $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 D | mysqli_real_query.phpt | 18 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 D | gh12107.phpt | 15 $sql = <<<SQL 21 $mysqli->query($sql);
|
/PHP-8.2/ext/pgsql/tests/ |
H A D | 17result.phpt | 15 $sql = "SELECT * FROM $table_name ORDER BY num"; 16 $result = pg_query($db, $sql) or die('Cannot query db');
|
H A D | 22pg_fetch_object.phpt | 21 $sql = "SELECT * FROM $table_name WHERE num = 0"; 22 $result = pg_query($db, $sql) or die('Cannot query db');
|
H A D | bug37100.phpt | 29 $sql = "BEGIN; DECLARE mycursor BINARY CURSOR FOR SELECT binfield FROM test_bug; FETCH ALL IN mycur… 31 $data = pg_query($sql);
|
H A D | bug37100_9.phpt | 28 $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 D | bug32325.phpt | 27 $sql = "begin 31 $stmt = oci_parse($c, $sql);
|
H A D | statement_type.phpt | 26 foreach ($sqls as $sql) { 27 $s = oci_parse($c, $sql);
|
H A D | bug71600.phpt | 29 $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 D | bug42841.phpt | 51 $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 D | cursor_bind.phpt | 27 $sql = " 37 $stmt = oci_parse($c, $sql);
|
H A D | cursor_bind_err.phpt | 29 $sql = "select cursor(select * from cursor_bind_err_tab) into :cursor from dual"; 30 $stmt = oci_parse($c, $sql);
|
H A D | error_bind_3.phpt | 23 $sql = "begin 28 $s = oci_parse($c, $sql);
|
H A D | cursors.phpt | 32 $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 D | pdo_mysql_exec_select.phpt | 12 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 D | pdo_mysql_prepare_emulated.phpt | 186 $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 D | bug_62024.phpt | 22 $sql = "insert into test_insert (id, text) values (?, ?)"; 23 $sttmt = $dbh->prepare($sql);
|
/PHP-8.2/ext/pdo_firebird/ |
H A D | firebird_driver.c | 296 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 D | sqlite3.c | 208 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 …]
|