/PHP-5.5/ext/mysqli/tests/ |
H A D | mysqli_stmt_get_result_bit.phpt | 51 …!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 D | mysqli_stmt_bind_param_references.phpt | 15 $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 D | mysqli_fetch_field_types.phpt | 28 $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 D | mysqli_real_query.phpt | 29 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 D | mysqli_fetch_assoc_zerofill.phpt | 17 $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 D | bug_62024.phpt | 21 $sql = "insert into test_insert (id, text) values (?, ?)"; 22 $sttmt = $dbh->prepare($sql);
|
/PHP-5.5/ext/oci8/tests/ |
H A D | bug42841.phpt | 49 $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 D | cursor_bind_err.phpt | 27 $sql = "select cursor(select * from cursor_bind_err_tab) into :cursor from dual"; 28 $stmt = oci_parse($c, $sql);
|
H A D | statement_type_old.phpt | 33 foreach ($sqls as $sql) { 34 $s = ociparse($c, $sql);
|
H A D | cursor_bind.phpt | 25 $sql = " 35 $stmt = oci_parse($c, $sql);
|
H A D | cursors.phpt | 30 $sql = "select CURSOR(select * from ".$schema.$table_name.") as curs FROM dual"; 31 $stmt = oci_parse($c, $sql);
|
H A D | cursors_old.phpt | 27 $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 D | bug41125.phpt | 18 $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 D | pdo_mysql_prepare_emulated.phpt | 182 $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 D | bug53551.phpt | 25 $sql = 'UPDATE bug53551 SET `count` = :count'; 26 $stmt = $db->prepare($sql);
|
H A D | pdo_mysql_prepare_load_data.phpt | 22 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 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));
|
/PHP-5.5/ext/interbase/tests/ |
H A D | bug45373.phpt | 13 $sql = "select * from test1 where i = ? and c = ?"; 15 $q = ibase_prepare($db, $sql);
|
/PHP-5.5/ext/pgsql/ |
H A D | php_pgsql.h | 203 …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 D | mysql_field_flags.phpt | 100 $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 D | mysql_query_load_data_openbasedir.phpt | 80 $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 D | mysql_unbuffered_query.phpt | 26 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 D | mysql_query.phpt | 29 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 D | 16pg_result_status.phpt | 11 $sql = "SELECT * FROM ".$table_name." WHERE num = -2";
|
/PHP-5.5/ext/pdo_odbc/ |
H A D | odbc_driver.c | 145 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()
|