Home
last modified time | relevance | path

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

12345

/php-src/ext/pgsql/tests/
H A D22pg_fetch_object.phpt24 $sql = "SELECT * FROM $table_name WHERE num = 0";
25 $result = pg_query($db, $sql) or die('Cannot query db');
H A D17result.phpt19 $sql = "SELECT * FROM $table_name ORDER BY num";
20 $result = pg_query($db, $sql) or die('Cannot query db');
H A Dbug37100.phpt28 $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 Dpdo_mysql_prepare_emulated_myisam.phpt124 …$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 Dpdo_mysql_prepare_native_myisam_index.phpt147 …$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 Dbug53551.phpt24 $sql = 'UPDATE bug53551 SET `count` = :count';
25 $stmt = $db->prepare($sql);
H A Dbug41125.phpt16 $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 Dpdo_mysql_bit.phpt18 …$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 Dsqlite3.c215 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 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_real_query.phpt16 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 Dgh12107.phpt15 $sql = <<<SQL
21 $mysqli->query($sql);
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', [%d] %s\n", $sql_type, $sql,
H A Dmysqli_query.phpt22 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 Dmysqli_fetch_assoc_zerofill.phpt17 $sql = sprintf('ALTER TABLE test ADD zero %s UNSIGNED ZEROFILL', $datatype);
18 if (!mysqli_query($link, $sql)) {
/php-src/ext/pdo_mysql/
H A Dmysql_driver.c170 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 Dfirebird_driver.c298 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 Dfb4_datatypes.phpt25 $sql = <<<'SQL'
42 $stmt = $dbh->prepare($sql);
H A Dfb4_datatypes_params.phpt25 $sql = <<<'SQL'
39 $stmt = $dbh->prepare($sql);
/php-src/ext/pdo_odbc/
H A Dconfig.w327 && CHECK_HEADER_ADD_INCLUDE('sql.h', 'CFLAGS_PDO_ODBC')
H A Dodbc_driver.c139 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 Dbug69362.phpt50 $sql = sprintf($template, "''mypassword");
51 $pdo->query($sql);
/php-src/ext/mysqli/tests/functions/
H A Dmysqli_set_charset.phpt41 …$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 Dpdo_026.phpt46 function query($sql, ...$rest): PDOStatement|false
49 …$stmt = $this->prepare($sql, array(PDO::ATTR_STATEMENT_CLASS=>array('PDOStatementx', array($this))…
H A Dpdo_023.phpt53 function query($sql, ...$rest): PDOStatement|false
56 $stmt = parent::prepare($sql, array(PDO::ATTR_STATEMENT_CLASS=>array('PDOStatementx')));

Completed in 90 milliseconds

12345