Home
last modified time | relevance | path

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

12345

/PHP-7.4/ext/pdo_mysql/tests/
H A Dbug_41125.phpt29 $sql = "CREATE TABLE IF NOT EXISTS test(id INT); INSERT INTO test(id) VALUES (1); SELECT * FROM tes…
34 $stmt = $db->query($sql);
H A Dpdo_mysql_prepare_native.phpt189 $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = :placeholder)",
191 $stmt = prepex(29, $db, $sql, array('placeholder' => -1));
195 $sql = sprintf("SELECT id, label FROM test WHERE (id = :placeholder) OR (label LIKE %s)",
197 $stmt = prepex(31, $db, $sql, array('placeholder' => 1));
314 $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = ?)",
316 $stmt = prepex(60, $db, $sql, array(-1));
320 $sql = sprintf("SELECT id, label FROM test WHERE (id = ?) OR (label LIKE %s)",
322 $stmt = prepex(61, $db, $sql, array(1));
326 …$sql = "SELECT id, label FROM test WHERE id = ? AND label = (SELECT label AS 'SELECT' FROM test WH…
327 $stmt = prepex(63, $db, $sql, array(1, 1));
H A Dpdo_mysql_stmt_getcolumnmeta.phpt73 …$sql = sprintf('CREATE TABLE test(id INT, label %s) ENGINE=%s', $sql_type, MySQLPDOTest::getTableE…
74 if (!($stmt = @$db->prepare($sql)) || (!@$stmt->execute())) {
237 …$sql = sprintf('CREATE TABLE test(id INT, label INT UNIQUE) ENGINE = %s', MySQLPDOTest::getTableEn…
238 if (($stmt = @$db->prepare($sql)) && @$stmt->execute()) {
258 …$sql = sprintf('CREATE TABLE test(id INT PRIMARY KEY NOT NULL AUTO_INCREMENT) ENGINE = %s', MySQLP…
259 if (($stmt = @$db->prepare($sql)) && @$stmt->execute()) {
279 …$sql = sprintf('CREATE TABLE test(id INT, label1 INT, label2 INT, INDEX idx1(label1, label2)) ENGI…
280 if (($stmt = @$db->prepare($sql)) && @$stmt->execute()) {
H A Dpdo_mysql_prepare_native_dup_named_placeholder.phpt64 …$sql = "SELECT id, label1 FROM test WHERE id = :placeholder AND label1 = (SELECT label1 AS 'SELECT…
67 $stmt = $db->prepare($sql);
81 $stmt = $db->prepare($sql);
H A Dpdo_mysql_exec.phpt11 function exec_and_count($offset, &$db, $sql, $exp = NULL) {
15 $ret = $db->exec($sql);
18 $offset, $exp, gettype($exp), $ret, gettype($ret), $sql,
25 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo()));
H A Dbug54929.phpt2 Bug #54929 (Parse error with single quote in sql comment (pdo-mysql))
/PHP-7.4/ext/mysqli/tests/
H A Dmysqli_character_set.phpt55 …$sql = sprintf("CREATE TABLE test(id INT, label CHAR(1)) CHARACTER SET '%s' ", $charset['Charset']…
56 if (!mysqli_query($link, $sql)) {
57 printf("[007 + %s] %s [%d] %s\n", $k, $sql, mysqli_errno($link), mysqli_error($link));
H A Dmysqli_query.phpt33 if (false !== ($tmp = mysqli_query($link, "SELECT 'this is sql but with backslash g'\g")))
39 if (!$res = mysqli_query($link, "SELECT 'this is sql but with semicolon' AS valid ; "))
52 …if (false !== ($res = mysqli_query($link, 'SELECT "this is sql but with semicolon" AS valid ; SHOW…
127 string(30) "this is sql but with semicolon"
H A Dmysqli_fork.phpt91 …$sql = sprintf("INSERT INTO messages(pid, sender, msg) VALUES (%d, 'child', '%%s')", posix_getpid(…
92 if (!mysqli_query($plink, sprintf($sql, 'start')))
103 if (!mysqli_query($plink, sprintf($sql, $tmp)))
125 if (!mysqli_query($plink, sprintf($sql, 'stop')) || !mysqli_commit($link))
138 …$sql = sprintf("SELECT msg_id, msg_time, msg FROM messages WHERE pid = %d AND sender = 'child' ORD…
144 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)) {
H A Dmysqli_fetch_array_many_rows.phpt16 if (!mysqli_query($link, $sql = sprintf("INSERT INTO test(id, label) VALUES (%d, '%s')",
18 … printf("[001] %s failed: [%d] %s\n", $sql, mysqli_errno($link), mysqli_error($link));
H A Dbug51647.phpt53 /* ERROR 1064 (42000): You have an error in your SQL syntax; = sql strict mode */
83 /* ERROR 1064 (42000): You have an error in your SQL syntax; = sql strict mode */
H A Dmysqli_fetch_array_oo.phpt78 …if (!$mysqli->query($sql = sprintf("CREATE TABLE test(id INT NOT NULL, label %s, PRIMARY KEY(id)) …
84 if (!$mysqli->query($sql = sprintf("INSERT INTO test(id, label) VALUES (1, NULL)"))) {
90 … if (!$mysqli->query($sql = "INSERT INTO test(id, label) VALUES (1, '" . $sql_value . "')")) {
91 … printf("[%04ds] [%d] %s - %s\n", $offset + 1, $mysqli->errno, $mysqli->error, $sql);
95 … if (!$mysqli->query($sql = sprintf("INSERT INTO test(id, label) VALUES (1, '%d')", $sql_value))) {
H A Dmysqli_stmt_bind_param_type_juggling.phpt21 … $sql = sprintf("CREATE TABLE test(col1 %s, col2 %s) ENGINE=%s", $sql_type1, $sql_type2, $engine);
22 if (!mysqli_query($link, $sql)) {
H A Dmysqli_fetch_all_oo.phpt102 …if (!$link->query($sql = sprintf("CREATE TABLE test(id INT NOT NULL, label %s, PRIMARY KEY(id)) EN…
108 if (!$link->query($sql = sprintf("INSERT INTO test(id, label) VALUES (1, NULL)"))) {
114 … if (!$link->query($sql = "INSERT INTO test(id, label) VALUES (1, '" . $sql_value . "')")) {
115 printf("[%04ds] [%d] %s - %s\n", $offset + 1, $link->errno, $link->error, $sql);
119 … if (!$link->query($sql = sprintf("INSERT INTO test(id, label) VALUES (1, '%d')", $sql_value))) {
/PHP-7.4/ext/oci8/
H A Doci8_dtrace.d26 probe oci8__sqltext(void *connection, char *client_id, void *statement, char *sql);
/PHP-7.4/ext/pdo/tests/
H A Dpdo_029.phpt51 function query($sql)
54 …$stmt = $this->prepare($sql, array(PDO::ATTR_STATEMENT_CLASS=>array('PDOStatementx', array($this))…
H A Dpdo_030.phpt52 function query($sql)
55 return parent::query($sql);
/PHP-7.4/ext/pdo_mysql/
H A Dmysql_driver.c163 static int mysql_handle_preparer(pdo_dbh_t *dbh, const char *sql, size_t sql_len, pdo_stmt_t *stmt,… in mysql_handle_preparer() argument
174 PDO_DBG_INF_FMT("sql=%.*s", (int)sql_len, sql); in mysql_handle_preparer()
189 ret = pdo_parse_params(stmt, (char*)sql, sql_len, &nsql, &nsql_len); in mysql_handle_preparer()
193 sql = nsql; in mysql_handle_preparer()
209 if (mysql_stmt_prepare(S->stmt, sql, sql_len)) { in mysql_handle_preparer()
254 static zend_long mysql_handle_doer(pdo_dbh_t *dbh, const char *sql, size_t sql_len) in mysql_handle_doer() argument
259 PDO_DBG_INF_FMT("sql=%.*s", (int)sql_len, sql); in mysql_handle_doer()
261 if (mysql_real_query(H->server, sql, sql_len)) { in mysql_handle_doer()
/PHP-7.4/ext/odbc/
H A Dconfig.w328 && CHECK_HEADER_ADD_INCLUDE("sql.h", "CFLAGS_ODBC")
/PHP-7.4/ext/pdo_pgsql/tests/
H A Dbug75402.phpt49 $sql = "SELECT
64 $stmt = $db->prepare($sql,
/PHP-7.4/ext/oci8/tests/
H A Dbug42173.phpt40 foreach ($stmts as $sql) {
41 $s = oci_parse($c, $sql);
H A Dbug72524.phpt23 $sql = "INSERT INTO mytable VALUES (:clob_col, :varchar2_col)";
26 $stmt = oci_parse($c, $sql);
/PHP-7.4/ext/pdo_firebird/tests/
H A Dbug_77863.phpt12 $sql = <<<SQL
24 $query = $dbh->prepare($sql);
/PHP-7.4/ext/pdo_oci/
H A Doci_driver.c243 static int oci_handle_preparer(pdo_dbh_t *dbh, const char *sql, size_t sql_len, pdo_stmt_t *stmt, z… in oci_handle_preparer() argument
262 ret = pdo_parse_params(stmt, (char*)sql, sql_len, &nsql, &nsql_len); in oci_handle_preparer()
266 sql = nsql; in oci_handle_preparer()
282 …H->last_err = OCIStmtPrepare(S->stmt, H->err, (text*)sql, (ub4) sql_len, OCI_NTV_SYNTAX, OCI_DEFAU… in oci_handle_preparer()
317 static zend_long oci_handle_doer(pdo_dbh_t *dbh, const char *sql, size_t sql_len) /* {{{ */ in oci_handle_doer() argument
327 H->last_err = OCIStmtPrepare(stmt, H->err, (text*)sql, (ub4) sql_len, OCI_NTV_SYNTAX, OCI_DEFAULT); in oci_handle_doer()

Completed in 32 milliseconds

12345