Home
last modified time | relevance | path

Searched refs:sql (Results 76 – 100 of 140) sorted by relevance

123456

/PHP-8.2/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-8.2/ext/pdo_mysql/tests/
H A Dbug53551.phpt26 $sql = 'UPDATE bug53551 SET `count` = :count';
27 $stmt = $db->prepare($sql);
H A Dbug41125.phpt19 $sql = "SELECT 1 FROM DUAL WHERE 'o''riley' LIKE " . $db->quote('%' . $search . '%');
20 $stmt = $db->prepare($sql);
44 $sql = "SELECT upper(:id) FROM DUAL WHERE '1'";
45 $stmt = $db->prepare($sql);
50 printf("Query: [[%s]]\n", $sql);
H A Dbug_41125.phpt30 $sql = "CREATE TABLE IF NOT EXISTS test(id INT); INSERT INTO test(id) VALUES (1); SELECT * FROM tes…
31 $stmt = $db->query($sql);
H A Dpdo_mysql_bit.phpt20 …$sql = sprintf('CREATE TABLE test(id INT, label %s) ENGINE=%s', $sql_type, MySQLPDOTest::getTableE…
21 @$db->exec($sql);
H A Dpdo_mysql_prepare_native.phpt192 $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = :placeholder)",
194 $stmt = prepex(29, $db, $sql, array('placeholder' => -1));
198 $sql = sprintf("SELECT id, label FROM test WHERE (id = :placeholder) OR (label LIKE %s)",
200 $stmt = prepex(31, $db, $sql, array('placeholder' => 1));
317 $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = ?)",
319 $stmt = prepex(60, $db, $sql, array(-1));
323 $sql = sprintf("SELECT id, label FROM test WHERE (id = ?) OR (label LIKE %s)",
325 $stmt = prepex(61, $db, $sql, array(1));
329 …$sql = "SELECT id, label FROM test WHERE id = ? AND label = (SELECT label AS 'SELECT' FROM test WH…
330 $stmt = prepex(63, $db, $sql, array(1, 1));
H A Dpdo_mysql_stmt_getcolumnmeta.phpt66 …$sql = sprintf('CREATE TABLE test(id INT, label %s) ENGINE=%s', $sql_type, MySQLPDOTest::getTableE…
67 if (!($stmt = @$db->prepare($sql)) || (!@$stmt->execute())) {
229 …$sql = sprintf('CREATE TABLE test(id INT, label INT UNIQUE) ENGINE = %s', MySQLPDOTest::getTableEn…
230 if (($stmt = @$db->prepare($sql)) && @$stmt->execute()) {
250 …$sql = sprintf('CREATE TABLE test(id INT PRIMARY KEY NOT NULL AUTO_INCREMENT) ENGINE = %s', MySQLP…
251 if (($stmt = @$db->prepare($sql)) && @$stmt->execute()) {
271 …$sql = sprintf('CREATE TABLE test(id INT, label1 INT, label2 INT, INDEX idx1(label1, label2)) ENGI…
272 if (($stmt = @$db->prepare($sql)) && @$stmt->execute()) {
H A Dpdo_mysql_prepare_native_dup_named_placeholder.phpt66 …$sql = "SELECT id, label1 FROM test WHERE id = :placeholder AND label1 = (SELECT label1 AS 'SELECT…
69 $stmt = $db->prepare($sql);
83 $stmt = $db->prepare($sql);
/PHP-8.2/ext/pgsql/tests/
H A D16pg_result_status.phpt13 $sql = "SELECT * FROM ".$table_name." WHERE num = -2";
/PHP-8.2/ext/mysqli/tests/
H A Dmysqli_query.phpt24 if (false !== ($tmp = mysqli_query($link, "SELECT 'this is sql but with backslash g'\g")))
30 if (!$res = mysqli_query($link, "SELECT 'this is sql but with semicolon' AS valid ; "))
43 …if (false !== ($res = mysqli_query($link, 'SELECT "this is sql but with semicolon" AS valid ; SHOW…
122 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)) {
H A Dmysqli_character_set.phpt56 …$sql = sprintf("CREATE TABLE test(id INT, label CHAR(1)) CHARACTER SET '%s' ", $charset['Charset']…
57 if (!mysqli_query($link, $sql)) {
58 printf("[007 + %s] %s [%d] %s\n", $k, $sql, mysqli_errno($link), mysqli_error($link));
H A Dmysqli_fork.phpt90 …$sql = sprintf("INSERT INTO messages(pid, sender, msg) VALUES (%d, 'child', '%%s')", posix_getpid(…
91 if (!mysqli_query($plink, sprintf($sql, 'start')))
102 if (!mysqli_query($plink, sprintf($sql, $tmp)))
124 if (!mysqli_query($plink, sprintf($sql, 'stop')) || !mysqli_commit($link))
137 …$sql = sprintf("SELECT msg_id, msg_time, msg FROM messages WHERE pid = %d AND sender = 'child' ORD…
143 if ($pres = mysqli_query($plink, $sql)) {
H A Dmysqli_stmt_bind_result_zerofill.phpt17 $sql = sprintf('ALTER TABLE test ADD zero %s UNSIGNED ZEROFILL', $datatype);
18 if (!mysqli_query($link, $sql)) {
/PHP-8.2/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-8.2/ext/pdo/tests/
H A Dpdo_023.phpt53 function query($sql, ...$rest): PDOStatement|false
56 $stmt = parent::prepare($sql, array(PDO::ATTR_STATEMENT_CLASS=>array('PDOStatementx')));
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_029.phpt52 function query($sql, ...$rest): PDOStatement|false
55 …$stmt = $this->prepare($sql, array(PDO::ATTR_STATEMENT_CLASS=>array('PDOStatementx', array($this))…
H A Dpdo_030.phpt53 function query($sql, ...$rest): PDOStatement|false
56 return parent::query($sql);
/PHP-8.2/ext/pdo_pgsql/tests/
H A Dbug69362.phpt53 $sql = sprintf($template, "''mypassword");
54 $pdo->query($sql);
/PHP-8.2/ext/oci8/
H A Doci8_dtrace.d26 probe oci8__sqltext(void *connection, char *client_id, void *statement, char *sql);
/PHP-8.2/ext/pdo_oci/
H A Doci_driver.c237 static bool oci_handle_preparer(pdo_dbh_t *dbh, zend_string *sql, pdo_stmt_t *stmt, zval *driver_op… in oci_handle_preparer() argument
255 ret = pdo_parse_params(stmt, sql, &nsql); in oci_handle_preparer()
259 sql = nsql; in oci_handle_preparer()
273 if (ZSTR_LEN(sql) != 0) { in oci_handle_preparer()
274 …H->last_err = OCIStmtPrepare(S->stmt, H->err, (text*) ZSTR_VAL(sql), (ub4) ZSTR_LEN(sql), OCI_NTV_… in oci_handle_preparer()
309 static zend_long oci_handle_doer(pdo_dbh_t *dbh, const zend_string *sql) /* {{{ */ in oci_handle_doer() argument
319 …H->last_err = OCIStmtPrepare(stmt, H->err, (text*)ZSTR_VAL(sql), (ub4) ZSTR_LEN(sql), OCI_NTV_SYNT… in oci_handle_doer()
/PHP-8.2/.github/actions/setup-windows/
H A Daction.yml13 …choco install sql-server-express -y --no-progress --install-arguments="/SECURITYMODE=SQL /SAPWD=Pa…
/PHP-8.2/ext/odbc/
H A Dconfig.w328 && CHECK_HEADER_ADD_INCLUDE("sql.h", "CFLAGS_ODBC")

Completed in 37 milliseconds

123456