Home
last modified time | relevance | path

Searched refs:sql (Results 26 – 50 of 114) sorted by relevance

12345

/PHP-5.5/ext/mysqli/tests/
H A Dmysqli_stmt_get_result_bit.phpt51 …!mysqli_query($link, $sql = sprintf('CREATE TABLE test(id BIGINT UNSIGNED, bit_value BIT(%d) NOT N…
79 $sql = sprintf("INSERT INTO test(id, bit_value) VALUES (%s, b'%s')", $value, $bin);
84 if (!mysqli_stmt_prepare($stmt, $sql) ||
88 …$sql = sprintf("SELECT bin(bit_value) AS _bin, id, bit_value, bit_null FROM test WHERE id = %s", $…
89 if (!mysqli_stmt_prepare($stmt, $sql) ||
H A Dmysqli_stmt_bind_param_references.phpt15 $sql = sprintf("SELECT id, label FROM test WHERE id = '%d' AND label = '%s'",
17 if (!$res = mysqli_query($link, $sql)) {
19 $offset, $sql, mysqli_errno($link), mysqli_error($link));
24 $offset, $sql, mysqli_errno($link), mysqli_error($link));
45 $sql = sprintf("DELETE FROM test WHERE id = '%d' AND label = '%s'",
47 if (!mysqli_query($link, $sql)) {
49 $offset, $sql, mysqli_errno($link), mysqli_error($link));
H A Dmysqli_fetch_field_types.phpt28 $sql = sprintf("INSERT INTO test(id) VALUES ('%s')", $php_value);
30 $sql = sprintf("INSERT INTO test(id) VALUES (%s)", $php_value);
32 if (!mysqli_query($link, $sql)) {
33 printf("[003] '%s' - '%s' - '%s', [%d] %s\n", $sql_type, $create, $sql,
H A Dmysqli_real_query.phpt29 if (false !== ($tmp = mysqli_real_query($link, "SELECT 'this is sql but with backslash g'\g")))
35 if (!mysqli_real_query($link, "SELECT 'this is sql but with semicolon' AS valid ; "))
44 …if (false !== ($res = mysqli_real_query($link, "SELECT 'this is sql but with semicolon' AS valid ;…
109 %unicode|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)) {
/PHP-5.5/ext/pdo_firebird/tests/
H A Dbug_62024.phpt21 $sql = "insert into test_insert (id, text) values (?, ?)";
22 $sttmt = $dbh->prepare($sql);
/PHP-5.5/ext/oci8/tests/
H A Dbug42841.phpt49 $sql = "BEGIN bug42841_proc(:cursor); END;";
50 $stmt = oci_parse($c, $sql);
67 $sql = "BEGIN bug42841_proc(:cursor); END;";
68 $stmt = oci_parse($c, $sql);
H A Dcursor_bind_err.phpt27 $sql = "select cursor(select * from cursor_bind_err_tab) into :cursor from dual";
28 $stmt = oci_parse($c, $sql);
H A Dstatement_type_old.phpt33 foreach ($sqls as $sql) {
34 $s = ociparse($c, $sql);
H A Dcursor_bind.phpt25 $sql = "
35 $stmt = oci_parse($c, $sql);
H A Dcursors.phpt30 $sql = "select CURSOR(select * from ".$schema.$table_name.") as curs FROM dual";
31 $stmt = oci_parse($c, $sql);
H A Dcursors_old.phpt27 $sql = "select cursor(select * from cursors_old_tab) as curs from dual";
28 $stmt = ociparse($c, $sql);
/PHP-5.5/ext/pdo_mysql/tests/
H A Dbug41125.phpt18 $sql = "SELECT 1 FROM DUAL WHERE 'o''riley' LIKE " . $db->quote('%' . $search . '%');
19 $stmt = $db->prepare($sql);
43 $sql = "SELECT upper(:id) FROM DUAL WHERE '1'";
44 $stmt = $db->prepare($sql);
49 printf("Query: [[%s]]\n", $sql);
H A Dpdo_mysql_prepare_emulated.phpt182 $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = :placeholder)",
184 $stmt = prepex(39, $db, $sql, array('placeholder' => -1));
189 $sql = sprintf("SELECT id, label FROM test WHERE (id = :placeholder) OR (label LIKE %s)",
191 $stmt = prepex(41, $db, $sql, array('placeholder' => 1));
196 $stmt = prepex(43, $db, $sql, array('placeholder' => 1));
291 $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = ?)",
293 $stmt = prepex(79, $db, $sql, array(-1));
298 $sql = sprintf("SELECT id, label FROM test WHERE (id = ?) OR (label LIKE %s)",
300 $stmt = prepex(81, $db, $sql, array(1));
305 $stmt = prepex(83, $db, $sql, array(1, 1));
[all …]
H A Dbug53551.phpt25 $sql = 'UPDATE bug53551 SET `count` = :count';
26 $stmt = $db->prepare($sql);
H A Dpdo_mysql_prepare_load_data.phpt22 function exec_and_count($offset, &$db, $sql, $exp) {
26 $ret = $db->exec($sql);
29 $offset, $exp, gettype($exp), $ret, gettype($ret), $sql,
43 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo()));
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));
/PHP-5.5/ext/interbase/tests/
H A Dbug45373.phpt13 $sql = "select * from test1 where i = ? and c = ?";
15 $q = ibase_prepare($db, $sql);
/PHP-5.5/ext/pgsql/
H A Dphp_pgsql.h203 …hp_pgsql_insert(PGconn *pg_link, const char *table, zval *values, ulong opt, char **sql TSRMLS_DC);
204 …ate(PGconn *pg_link, const char *table, zval *values, zval *ids, ulong opt , char **sql TSRMLS_DC);
205 …t php_pgsql_delete(PGconn *pg_link, const char *table, zval *ids, ulong opt, char **sql TSRMLS_DC);
206 …(PGconn *pg_link, const char *table, zval *ids, zval *ret_array, ulong opt, char **sql TSRMLS_DC);
/PHP-5.5/ext/mysql/tests/
H A Dmysql_field_flags.phpt100 $sql = sprintf("CREATE TABLE test(id INT, %s) ENGINE = %s", $columns, $engine);
101 if (!@mysql_query($sql, $link)) {
108 $sql = sprintf("INSERT INTO test(id, %s) VALUES (1, %s)", $values[0], $values[1]);
109 if (!mysql_query($sql, $link)) {
110 printf("[011/%s] '%s', [%d] %s\n", $columns, $sql, mysql_errno($link), mysql_error($link));
H A Dmysql_query_load_data_openbasedir.phpt80 $sql = sprintf("LOAD DATA LOCAL INFILE '%s'
86 if (!mysql_query($sql, $link))
100 $sql = "LOAD DATA LOCAL INFILE '/tmp/idonotexist'
105 if (!mysql_query($sql, $link))
H A Dmysql_unbuffered_query.phpt26 if (false !== ($tmp = mysql_unbuffered_query("SELECT 'this is sql but with backslash g'\g", $link)))
32 if (!$res = mysql_unbuffered_query("SELECT 'this is sql but with semicolon' AS valid ; ", $link))
38 if (false !== ($res = mysql_unbuffered_query("SELECT 'this is sql but with semicolon' AS valid ; SH…
113 %unicode|string%(30) "this is sql but with semicolon"
H A Dmysql_query.phpt29 if (false !== ($tmp = mysql_query("SELECT 'this is sql but with backslash g'\g", $link)))
35 if (!$res = mysql_query("SELECT 'this is sql but with semicolon' AS valid ; ", $link))
48 if (false !== ($res = mysql_query("SELECT 'this is sql but with semicolon' AS valid ; SHOW VARIABLE…
119 %unicode|string%(30) "this is sql but with semicolon"
/PHP-5.5/ext/pgsql/tests/
H A D16pg_result_status.phpt11 $sql = "SELECT * FROM ".$table_name." WHERE num = -2";
/PHP-5.5/ext/pdo_odbc/
H A Dodbc_driver.c145 static int odbc_handle_preparer(pdo_dbh_t *dbh, const char *sql, long sql_len, pdo_stmt_t *stmt, zv… in odbc_handle_preparer() argument
161 ret = pdo_parse_params(stmt, (char*)sql, sql_len, &nsql, &nsql_len TSRMLS_CC); in odbc_handle_preparer()
165 sql = nsql; in odbc_handle_preparer()
197 rc = SQLPrepare(S->stmt, (char*)sql, SQL_NTS); in odbc_handle_preparer()
223 static long odbc_handle_doer(pdo_dbh_t *dbh, const char *sql, long sql_len TSRMLS_DC) in odbc_handle_doer() argument
236 rc = SQLExecDirect(stmt, (char *)sql, sql_len); in odbc_handle_doer()

Completed in 78 milliseconds

12345