/php-src/ext/pgsql/tests/ |
H A D | 22pg_fetch_object.phpt | 24 $sql = "SELECT * FROM $table_name WHERE num = 0"; 25 $result = pg_query($db, $sql) or die('Cannot query db');
|
H A D | 17result.phpt | 19 $sql = "SELECT * FROM $table_name ORDER BY num"; 20 $result = pg_query($db, $sql) or die('Cannot query db');
|
H A D | bug37100.phpt | 28 $sql = "BEGIN; DECLARE mycursor BINARY CURSOR FOR SELECT binfield FROM {$table_name}; FETCH ALL IN … 30 $data = pg_query($sql);
|
/php-src/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_prepare_emulated_myisam.phpt | 124 …$sql = sprintf("SELECT id, label FROM test_prepare_emulated_myisam WHERE (label LIKE %s) AND (id =… 126 $stmt = prepex(14, $db, $sql, array('placeholder' => -1)); 131 …$sql = sprintf("SELECT id, label FROM test_prepare_emulated_myisam WHERE (id = :placeholder) OR (… 133 $stmt = prepex(15, $db, $sql, array('placeholder' => 1)); 137 …$sql = "SELECT id, label FROM test_prepare_emulated_myisam WHERE id = :placeholder AND label = (SE… 138 $stmt = prepex(16, $db, $sql, array('placeholder' => 1));
|
H A D | pdo_mysql_prepare_native_myisam_index.phpt | 147 …$sql = sprintf("SELECT id, label FROM test_prepare_native_myisam_index WHERE (label LIKE %s) AND (… 149 $stmt = prepex(13, $db, $sql, array(-1)); 153 …$sql = sprintf("SELECT id, label FROM test_prepare_native_myisam_index WHERE (id = ?) OR (label L… 155 $stmt = prepex(14, $db, $sql, array(1)); 159 …$sql = "SELECT id, label FROM test_prepare_native_myisam_index WHERE id = ? AND label = (SELECT la… 160 $stmt = prepex(15, $db, $sql, array(1, 1));
|
H A D | bug53551.phpt | 24 $sql = 'UPDATE bug53551 SET `count` = :count'; 25 $stmt = $db->prepare($sql);
|
H A D | bug41125.phpt | 16 $sql = "SELECT 1 FROM DUAL WHERE 'o''riley' LIKE " . $db->quote('%' . $search . '%'); 17 $stmt = $db->prepare($sql); 41 $sql = "SELECT upper(:id) FROM DUAL WHERE '1'"; 42 $stmt = $db->prepare($sql); 47 printf("Query: [[%s]]\n", $sql);
|
H A D | pdo_mysql_bit.phpt | 18 …$sql = sprintf('CREATE TABLE test_mysql_bit(id INT, label %s) ENGINE=%s', $sql_type, MySQLPDOTest:… 19 @$db->exec($sql);
|
/php-src/ext/sqlite3/ |
H A D | sqlite3.c | 215 zend_string *sql; in PHP_METHOD() local 485 zend_string *sql; in PHP_METHOD() local 492 if (ZSTR_LEN(sql)) { in PHP_METHOD() 510 zend_string *sql; in PHP_METHOD() local 522 if (!ZSTR_LEN(sql)) { in PHP_METHOD() 556 zend_string *sql; in PHP_METHOD() local 567 if (!ZSTR_LEN(sql)) { in PHP_METHOD() 672 zend_string *sql; in PHP_METHOD() local 685 if (!ZSTR_LEN(sql)) { in PHP_METHOD() 1628 sqlite3_free(sql); in PHP_METHOD() [all …]
|
/php-src/ext/mysqli/tests/ |
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_real_query.phpt | 16 if (false !== ($tmp = mysqli_real_query($link, "SELECT 'this is sql but with backslash g'\g"))) 22 if (!mysqli_real_query($link, "SELECT 'this is sql but with semicolon' AS valid ; ")) 31 …if (false !== ($res = mysqli_real_query($link, "SELECT 'this is sql but with semicolon' AS valid ;… 99 string(30) "this is sql but with semicolon"
|
H A D | gh12107.phpt | 15 $sql = <<<SQL 21 $mysqli->query($sql);
|
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', [%d] %s\n", $sql_type, $sql,
|
H A D | mysqli_query.phpt | 22 if (false !== ($tmp = mysqli_query($link, "SELECT 'this is sql but with backslash g'\g"))) 28 if (!$res = mysqli_query($link, "SELECT 'this is sql but with semicolon' AS valid ; ")) 41 …if (false !== ($res = mysqli_query($link, 'SELECT "this is sql but with semicolon" AS valid ; SHOW… 120 string(30) "this is sql but with semicolon"
|
H A D | mysqli_fetch_assoc_zerofill.phpt | 17 $sql = sprintf('ALTER TABLE test ADD zero %s UNSIGNED ZEROFILL', $datatype); 18 if (!mysqli_query($link, $sql)) {
|
/php-src/ext/pdo_mysql/ |
H A D | mysql_driver.c | 170 static bool mysql_handle_preparer(pdo_dbh_t *dbh, zend_string *sql, pdo_stmt_t *stmt, zval *driver_… in mysql_handle_preparer() argument 180 PDO_DBG_INF_FMT("sql=%.*s", (int) ZSTR_LEN(sql), ZSTR_VAL(sql)); in mysql_handle_preparer() 195 ret = pdo_parse_params(stmt, sql, &nsql); in mysql_handle_preparer() 199 sql = nsql; in mysql_handle_preparer() 214 if (mysql_stmt_prepare(S->stmt, ZSTR_VAL(sql), ZSTR_LEN(sql))) { in mysql_handle_preparer() 258 static zend_long mysql_handle_doer(pdo_dbh_t *dbh, const zend_string *sql) in mysql_handle_doer() argument 263 PDO_DBG_INF_FMT("sql=%.*s", (int)ZSTR_LEN(sql), ZSTR_VAL(sql)); in mysql_handle_doer() 265 if (mysql_real_query(H->server, ZSTR_VAL(sql), ZSTR_LEN(sql))) { in mysql_handle_doer()
|
/php-src/ext/pdo_firebird/ |
H A D | firebird_driver.c | 298 static int php_firebird_preprocess(const zend_string* sql, char* sql_out, HashTable* named_params) in php_firebird_preprocess() argument 304 const char* p = ZSTR_VAL(sql), * end = ZSTR_VAL(sql) + ZSTR_LEN(sql); in php_firebird_preprocess() 370 strcpy(sql_out, ZSTR_VAL(sql)); in php_firebird_preprocess() 621 static bool firebird_handle_preparer(pdo_dbh_t *dbh, zend_string *sql, /* {{{ */ in firebird_handle_preparer() argument 641 if (!php_firebird_alloc_prepare_stmt(dbh, sql, &num_sqlda, &s, np)) { in firebird_handle_preparer() 719 static zend_long firebird_handle_doer(pdo_dbh_t *dbh, const zend_string *sql) /* {{{ */ in firebird_handle_doer() argument 734 if (!php_firebird_alloc_prepare_stmt(dbh, sql, &out_sqlda, &stmt, 0)) { in firebird_handle_doer() 994 static int php_firebird_alloc_prepare_stmt(pdo_dbh_t *dbh, const zend_string *sql, in php_firebird_alloc_prepare_stmt() argument 1008 new_sql = emalloc(ZSTR_LEN(sql)+1); in php_firebird_alloc_prepare_stmt() 1010 if (!php_firebird_preprocess(sql, new_sql, named_params)) { in php_firebird_alloc_prepare_stmt()
|
/php-src/ext/pdo_firebird/tests/ |
H A D | fb4_datatypes.phpt | 25 $sql = <<<'SQL' 42 $stmt = $dbh->prepare($sql);
|
H A D | fb4_datatypes_params.phpt | 25 $sql = <<<'SQL' 39 $stmt = $dbh->prepare($sql);
|
/php-src/ext/pdo_odbc/ |
H A D | config.w32 | 7 && CHECK_HEADER_ADD_INCLUDE('sql.h', 'CFLAGS_PDO_ODBC')
|
H A D | odbc_driver.c | 139 static bool odbc_handle_preparer(pdo_dbh_t *dbh, zend_string *sql, pdo_stmt_t *stmt, zval *driver_o… in odbc_handle_preparer() argument 154 ret = pdo_parse_params(stmt, sql, &nsql); in odbc_handle_preparer() 158 sql = nsql; in odbc_handle_preparer() 192 rc = SQLPrepare(S->stmt, (SQLCHAR *) ZSTR_VAL(sql), SQL_NTS); in odbc_handle_preparer() 217 static zend_long odbc_handle_doer(pdo_dbh_t *dbh, const zend_string *sql) in odbc_handle_doer() argument 230 rc = SQLExecDirect(stmt, (SQLCHAR *) ZSTR_VAL(sql), ZSTR_LEN(sql)); in odbc_handle_doer()
|
/php-src/ext/pdo_pgsql/tests/ |
H A D | bug69362.phpt | 50 $sql = sprintf($template, "''mypassword"); 51 $pdo->query($sql);
|
/php-src/ext/mysqli/tests/functions/ |
H A D | mysqli_set_charset.phpt | 41 …$sql = sprintf("CREATE TABLE test_mysqli_set_charset(id INT, label CHAR(1)) CHARACTER SET '%s' ", … 42 mysqli_query($link, $sql);
|
/php-src/ext/pdo/tests/ |
H A D | pdo_026.phpt | 46 function query($sql, ...$rest): PDOStatement|false 49 …$stmt = $this->prepare($sql, array(PDO::ATTR_STATEMENT_CLASS=>array('PDOStatementx', array($this))…
|
H A D | pdo_023.phpt | 53 function query($sql, ...$rest): PDOStatement|false 56 $stmt = parent::prepare($sql, array(PDO::ATTR_STATEMENT_CLASS=>array('PDOStatementx')));
|