/PHP-7.4/ext/pdo_mysql/tests/ |
H A D | bug_41125.phpt | 29 $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 D | pdo_mysql_prepare_native.phpt | 189 $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 D | pdo_mysql_stmt_getcolumnmeta.phpt | 73 …$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 D | pdo_mysql_prepare_native_dup_named_placeholder.phpt | 64 …$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 D | pdo_mysql_exec.phpt | 11 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 D | bug54929.phpt | 2 Bug #54929 (Parse error with single quote in sql comment (pdo-mysql))
|
/PHP-7.4/ext/mysqli/tests/ |
H A D | mysqli_character_set.phpt | 55 …$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 D | mysqli_query.phpt | 33 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 D | mysqli_fork.phpt | 91 …$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 D | mysqli_stmt_bind_result_zerofill.phpt | 17 $sql = sprintf('ALTER TABLE test ADD zero %s UNSIGNED ZEROFILL', $datatype); 18 if (!mysqli_query($link, $sql)) {
|
H A D | mysqli_fetch_array_many_rows.phpt | 16 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 D | bug51647.phpt | 53 /* 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 D | mysqli_fetch_array_oo.phpt | 78 …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 D | mysqli_stmt_bind_param_type_juggling.phpt | 21 … $sql = sprintf("CREATE TABLE test(col1 %s, col2 %s) ENGINE=%s", $sql_type1, $sql_type2, $engine); 22 if (!mysqli_query($link, $sql)) {
|
H A D | mysqli_fetch_all_oo.phpt | 102 …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 D | oci8_dtrace.d | 26 probe oci8__sqltext(void *connection, char *client_id, void *statement, char *sql);
|
/PHP-7.4/ext/pdo/tests/ |
H A D | pdo_029.phpt | 51 function query($sql) 54 …$stmt = $this->prepare($sql, array(PDO::ATTR_STATEMENT_CLASS=>array('PDOStatementx', array($this))…
|
H A D | pdo_030.phpt | 52 function query($sql) 55 return parent::query($sql);
|
/PHP-7.4/ext/pdo_mysql/ |
H A D | mysql_driver.c | 163 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 D | config.w32 | 8 && CHECK_HEADER_ADD_INCLUDE("sql.h", "CFLAGS_ODBC")
|
/PHP-7.4/ext/pdo_pgsql/tests/ |
H A D | bug75402.phpt | 49 $sql = "SELECT 64 $stmt = $db->prepare($sql,
|
/PHP-7.4/ext/oci8/tests/ |
H A D | bug42173.phpt | 40 foreach ($stmts as $sql) { 41 $s = oci_parse($c, $sql);
|
H A D | bug72524.phpt | 23 $sql = "INSERT INTO mytable VALUES (:clob_col, :varchar2_col)"; 26 $stmt = oci_parse($c, $sql);
|
/PHP-7.4/ext/pdo_firebird/tests/ |
H A D | bug_77863.phpt | 12 $sql = <<<SQL 24 $query = $dbh->prepare($sql);
|
/PHP-7.4/ext/pdo_oci/ |
H A D | oci_driver.c | 243 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()
|