Home
last modified time | relevance | path

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

12345

/php-src/ext/pgsql/tests/
H A D16pg_result_status.phpt15 $sql = "SELECT * FROM ".$table_name." WHERE num = -2";
/php-src/ext/mysqli/tests/
H A Dmysqli_fork.phpt89 …$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 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_all_oo.phpt95 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 Dmysqli_fetch_array_oo.phpt79 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 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 Dmysqli_get_charset.phpt25 …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 DREADME.md4 ```sql
H A Dbug51647.phpt56 /* 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 Dmysqli_fetch_array.phpt71 …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 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)) {
/php-src/ext/pdo_mysql/tests/
H A Dpdo_mysql_prepare_native_anonymous_placeholder.phpt215 …$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 Dpdo_mysql_prepare_native_myisam.phpt133 …$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 Dpdo_mysql_stmt_getcolumnmeta.phpt61 …$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 Dpdo_mysql_prepare_native_dup_named_placeholder.phpt63 …$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 Dpdo_mysql_exec.phpt12 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 Dbug54929.phpt2 Bug #54929 (Parse error with single quote in sql comment (pdo-mysql))
/php-src/ext/pdo/tests/
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-src/.github/actions/setup-windows/
H A Daction.yml13 …choco install sql-server-express -y --no-progress --install-arguments="/SECURITYMODE=SQL /SAPWD=Pa…
/php-src/ext/pdo_pgsql/tests/
H A Dbug75402.phpt49 $sql = "SELECT
64 $stmt = $db->prepare($sql,
/php-src/ext/pdo_firebird/tests/
H A Dbug_77863.phpt15 $sql = <<<SQL
28 $query = $dbh->prepare($sql);
/php-src/ext/odbc/
H A Dconfig.w328 && CHECK_HEADER_ADD_INCLUDE("sql.h", "CFLAGS_ODBC")
/php-src/ext/pdo_sqlite/
H A Dsqlite_driver.c175 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 Dmysqli_fetch_all_data_types_variation.phpt26 …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…

Completed in 71 milliseconds

12345