/php-src/ext/pgsql/tests/ |
H A D | 16pg_result_status.phpt | 15 $sql = "SELECT * FROM ".$table_name." WHERE num = -2";
|
/php-src/ext/mysqli/tests/ |
H A D | mysqli_fork.phpt | 89 …$sql = sprintf("INSERT INTO messages(pid, sender, msg) VALUES (%d, 'child', '%%s')", posix_getpid(… 90 if (!mysqli_query($plink, sprintf($sql, 'start'))) 101 if (!mysqli_query($plink, sprintf($sql, $tmp))) 123 if (!mysqli_query($plink, sprintf($sql, 'stop')) || !mysqli_commit($link)) 136 …$sql = sprintf("SELECT msg_id, msg_time, msg FROM messages WHERE pid = %d AND sender = 'child' ORD… 142 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_all_oo.phpt | 95 if (!$link->query($sql = sprintf("INSERT INTO test(id, label) VALUES (1, NULL)"))) { 96 printf("[%04d] [%d] %s - %s\n", $offset + 1, $link->errno, $link->error, $sql); 101 … if (!$link->query($sql = "INSERT INTO test(id, label) VALUES (1, '" . $sql_value . "')")) { 102 printf("[%04ds] [%d] %s - %s\n", $offset + 1, $link->errno, $link->error, $sql); 106 … if (!$link->query($sql = sprintf("INSERT INTO test(id, label) VALUES (1, '%d')", $sql_value))) { 107 printf("[%04di] [%d] %s - %s\n", $offset + 1, $link->errno, $link->error, $sql);
|
H A D | mysqli_fetch_array_oo.phpt | 79 if (!$mysqli->query($sql = sprintf("INSERT INTO test(id, label) VALUES (1, NULL)"))) { 80 printf("[%04d] [%d] %s - %s\n", $offset + 1, $mysqli->errno, $mysqli->error, $sql); 85 … if (!$mysqli->query($sql = "INSERT INTO test(id, label) VALUES (1, '" . $sql_value . "')")) { 86 … printf("[%04ds] [%d] %s - %s\n", $offset + 1, $mysqli->errno, $mysqli->error, $sql); 90 … if (!$mysqli->query($sql = sprintf("INSERT INTO test(id, label) VALUES (1, '%d')", $sql_value))) { 91 … printf("[%04di] [%d] %s - %s\n", $offset + 1, $mysqli->errno, $mysqli->error, $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 | mysqli_get_charset.phpt | 25 …if (!$res = mysqli_query($link, $sql = sprintf("SHOW CHARACTER SET LIKE '%s'", $character_set_conn… 28 printf("[010] Cannot fetch Maxlen and/or Comment, test will fail: $sql\n");
|
H A D | README.md | 4 ```sql
|
H A D | bug51647.phpt | 56 /* ERROR 1064 (42000): You have an error in your SQL syntax; = sql strict mode */ 86 /* ERROR 1064 (42000): You have an error in your SQL syntax; = sql strict mode */
|
H A D | mysqli_fetch_array.phpt | 71 …if (!mysqli_query($link, $sql = sprintf("CREATE TABLE test(id INT NOT NULL, label %s, PRIMARY KEY(… 77 … if (!mysqli_query($link, $sql = sprintf("INSERT INTO test(id, label) VALUES (1, NULL)"))) { 83 … if (!mysqli_query($link, $sql = "INSERT INTO test(id, label) VALUES (1, '" . $sql_value . "')")) { 84 … printf("[%04ds] [%d] %s - %s\n", $offset + 1, mysqli_errno($link), mysqli_error($link), $sql); 88 …if (!mysqli_query($link, $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)) {
|
/php-src/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_prepare_native_anonymous_placeholder.phpt | 215 …$sql = sprintf("SELECT id, label FROM test_prepare_native_anonymous_placeholder WHERE (label LIKE … 217 $stmt = prepex(30, $db, $sql, array(-1)); 221 …$sql = sprintf("SELECT id, label FROM test_prepare_native_anonymous_placeholder WHERE (id = ?) OR… 223 $stmt = prepex(31, $db, $sql, array(1)); 227 …$sql = "SELECT id, label FROM test_prepare_native_anonymous_placeholder WHERE id = ? AND label = (… 228 $stmt = prepex(33, $db, $sql, array(1, 1));
|
H A D | pdo_mysql_prepare_native_myisam.phpt | 133 …$sql = sprintf("SELECT id, label FROM test_prepare_native_myisam WHERE (label LIKE %s) AND (id = :… 135 $stmt = prepex(10, $db, $sql, array('placeholder' => -1)); 139 …$sql = sprintf("SELECT id, label FROM test_prepare_native_myisam WHERE (id = :placeholder) OR (la… 141 $stmt = prepex(11, $db, $sql, array('placeholder' => 1));
|
H A D | pdo_mysql_stmt_getcolumnmeta.phpt | 61 …$sql = sprintf('CREATE TABLE test_stmt_getcolumnmeta(id INT, label %s) ENGINE=%s', $sql_type, MySQ… 62 if (!($stmt = @$db->prepare($sql)) || (!@$stmt->execute())) { 224 …$sql = sprintf('CREATE TABLE test_stmt_getcolumnmeta(id INT, label INT UNIQUE) ENGINE = %s', MySQL… 225 if (($stmt = @$db->prepare($sql)) && @$stmt->execute()) { 245 …$sql = sprintf('CREATE TABLE test_stmt_getcolumnmeta(id INT PRIMARY KEY NOT NULL AUTO_INCREMENT) E… 246 if (($stmt = @$db->prepare($sql)) && @$stmt->execute()) { 266 …$sql = sprintf('CREATE TABLE test_stmt_getcolumnmeta(id INT, label1 INT, label2 INT, INDEX idx1(la… 267 if (($stmt = @$db->prepare($sql)) && @$stmt->execute()) {
|
H A D | pdo_mysql_prepare_native_dup_named_placeholder.phpt | 63 …$sql = "SELECT id, label1 FROM test_prepare_native_dup_named WHERE id = :placeholder AND label1 = … 66 $stmt = $db->prepare($sql); 80 $stmt = $db->prepare($sql);
|
H A D | pdo_mysql_exec.phpt | 12 function exec_and_count($offset, &$db, $sql, $exp = NULL) { 14 $ret = $db->exec($sql); 17 $offset, $exp, gettype($exp), $ret, gettype($ret), $sql, 23 $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-src/ext/pdo/tests/ |
H A D | pdo_029.phpt | 52 function query($sql, ...$rest): PDOStatement|false 55 …$stmt = $this->prepare($sql, array(PDO::ATTR_STATEMENT_CLASS=>array('PDOStatementx', array($this))…
|
H A D | pdo_030.phpt | 53 function query($sql, ...$rest): PDOStatement|false 56 return parent::query($sql);
|
/php-src/.github/actions/setup-windows/ |
H A D | action.yml | 13 …choco install sql-server-express -y --no-progress --install-arguments="/SECURITYMODE=SQL /SAPWD=Pa…
|
/php-src/ext/pdo_pgsql/tests/ |
H A D | bug75402.phpt | 49 $sql = "SELECT 64 $stmt = $db->prepare($sql,
|
/php-src/ext/pdo_firebird/tests/ |
H A D | bug_77863.phpt | 15 $sql = <<<SQL 28 $query = $dbh->prepare($sql);
|
/php-src/ext/odbc/ |
H A D | config.w32 | 8 && CHECK_HEADER_ADD_INCLUDE("sql.h", "CFLAGS_ODBC")
|
/php-src/ext/pdo_sqlite/ |
H A D | sqlite_driver.c | 175 static bool sqlite_handle_preparer(pdo_dbh_t *dbh, zend_string *sql, pdo_stmt_t *stmt, zval *driver… in sqlite_handle_preparer() argument 193 i = sqlite3_prepare_v2(H->db, ZSTR_VAL(sql), ZSTR_LEN(sql), &S->stmt, &tail); in sqlite_handle_preparer() 203 static zend_long sqlite_handle_doer(pdo_dbh_t *dbh, const zend_string *sql) in sqlite_handle_doer() argument 207 if (sqlite3_exec(H->db, ZSTR_VAL(sql), NULL, NULL, NULL) != SQLITE_OK) { in sqlite_handle_doer()
|
/php-src/ext/mysqli/tests/fetch/ |
H A D | mysqli_fetch_all_data_types_variation.phpt | 26 …mysqli_query($link, $sql = sprintf("CREATE TABLE test_mysqli_fetch_all_data_types_variation(id INT… 34 …mysqli_query($link, $sql = sprintf("INSERT INTO test_mysqli_fetch_all_data_types_variation(id, lab… 37 …mysqli_query($link, $sql = "INSERT INTO test_mysqli_fetch_all_data_types_variation(id, label) VALU… 39 …mysqli_query($link, $sql = sprintf("INSERT INTO test_mysqli_fetch_all_data_types_variation(id, lab…
|