/php-src/ext/mysqli/tests/ |
H A D | mysqli_stmt_fetch_bit.phpt | 29 …!mysqli_query($link, $sql = sprintf('CREATE TABLE test(id INT, label BIT(%d)) ENGINE="%s"', $bits,… 38 … $sql = sprintf("INSERT INTO test(id, label) VALUES (%d, b'%s')", $value, decbin($value)); 40 if (!mysqli_stmt_prepare($stmt, $sql) || 45 … $sql = sprintf("SELECT id, label + 0 AS _label0, label FROM test WHERE id = %d", $value); 46 if (!mysqli_stmt_prepare($stmt, $sql) ||
|
H A D | mysqli_fetch_array_large.phpt | 22 $sql = "INSERT INTO test(label) VALUES "; 24 while (strlen($sql) < ($package_size - 259)) 25 $sql .= sprintf("('%s'), ", $random_char); 27 $sql = substr($sql, 0, -2); 28 $len = strlen($sql); 31 if (!@mysqli_query($link, $sql)) {
|
H A D | mysqli_fetch_assoc_bit.phpt | 42 …!mysqli_query($link, $sql = sprintf('CREATE TABLE test(id BIGINT, bit_value BIT(%d) NOT NULL, bit_… 67 $sql = sprintf("INSERT INTO test(id, bit_value) VALUES (%s, b'%s')", $value, $bin); 72 if (!mysqli_query($link, $sql)) 75 …$sql = sprintf("SELECT id, BIN(bit_value) AS _bin, bit_value + 0 AS _bit_value0, bit_value, bit_nu… 76 if (!$res = mysqli_query($link, $sql))
|
H A D | mysqli_stmt_bind_result_format.phpt | 24 $sql = sprintf("CREATE TABLE test(id INT AUTO_INCREMENT PRIMARY KEY, col1 %s) ENGINE=%s", 26 if (!mysqli_query($link, $sql)) { 37 $sql = sprintf("INSERT INTO test(id, col1) VALUES (%d, %f)", 39 if (!mysqli_query($link, $sql)) { 60 $sql = sprintf('SELECT %s AS _format FROM %s ORDER BY %s', $format, $from, $order_by); 62 $sql = sprintf('SELECT %s AS _format FROM %s', $format, $from); 64 if (!mysqli_stmt_prepare($stmt, $sql)) { 107 $format, $sql); 131 $format, $sql); 233 …$sql = sprintf('INSERT INTO test(targetport, current_targets, maxreports, trend) VALUES (%d, %f, %… [all …]
|
H A D | mysqli_stmt_get_result_bit.phpt | 47 …!mysqli_query($link, $sql = sprintf('CREATE TABLE test(id BIGINT UNSIGNED, bit_value BIT(%d) NOT N… 75 $sql = sprintf("INSERT INTO test(id, bit_value) VALUES (%s, b'%s')", $value, $bin); 80 if (!mysqli_stmt_prepare($stmt, $sql) || 84 …$sql = sprintf("SELECT bin(bit_value) AS _bin, id, bit_value, bit_null FROM test WHERE id = %s", $… 85 if (!mysqli_stmt_prepare($stmt, $sql) ||
|
H A D | bug70949.phpt | 18 $sql = "select * from bug70949"; 20 if ($stmt = $mysql->prepare($sql))
|
/php-src/ext/pgsql/tests/ |
H A D | 08escape.phpt | 52 $sql = "INSERT INTO ".$table_name." (num, bin) VALUES (10000, CAST ('".$escaped_data."' AS BYTEA));… 53 pg_query($db, $sql); 57 $sql = "SELECT bin::bytea FROM ".$table_name." WHERE num = 10000"; 58 $result = pg_query($db, $sql); 70 $result = pg_query($db, $sql);
|
H A D | bug37100_9.phpt | 27 $sql = "BEGIN; DECLARE mycursor BINARY CURSOR FOR SELECT binfield FROM {$table_name}; FETCH ALL IN … 29 $data = pg_query($db, $sql);
|
/php-src/ext/pdo_odbc/tests/ |
H A D | bug44643.phpt | 14 $sql = "SELECT * FROM (SELECT 'test' = :id1) a WHERE a.test = :id2"; 15 $stmt = $db->prepare($sql);
|
/php-src/ext/pdo/tests/ |
H A D | pdo_020.phpt | 23 … val FROM test020', 'SELECT id, val, val2 FROM test020', 'SELECT COUNT(*) FROM test020') as $sql) { 25 $stmt = $db->query($sql); 27 echo "Counted $res columns after $sql.\n";
|
H A D | bug_73234.phpt | 28 $sql = 'CREATE TABLE test73234(id INT NULL)'; 31 $sql = 'CREATE TABLE test73234(id INT)'; 34 $db->exec($sql);
|
H A D | pdo_024.phpt | 22 $sql = 'create table test024 (id int, name varchar(10) null)'; 25 $sql = 'create table test024 (id int, name varchar(10))'; 28 $db->exec($sql);
|
/php-src/ext/pdo_dblib/tests/ |
H A D | bug_69757.phpt | 16 $sql = " 22 $stmt = $db->query($sql);
|
H A D | types.phpt | 32 $sql = " 44 $stmt = $db->query($sql); 57 $stmt = $db->query($sql);
|
/php-src/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_prepare_emulated_myisam_index.phpt | 131 …$sql = sprintf("SELECT id, label FROM test_prepare_emulated_myisam_index WHERE (label LIKE %s) AND… 133 $stmt = prepex(14, $db, $sql, array(-1)); 138 …$sql = sprintf("SELECT id, label FROM test_prepare_emulated_myisam_index WHERE (id = ?) OR (label… 140 $stmt = prepex(15, $db, $sql, array(1)); 144 …$sql = "SELECT id, label FROM test_prepare_emulated_myisam_index WHERE id = ? AND label = (SELECT … 145 $stmt = prepex(16, $db, $sql, array(1, 1)); 149 …$sql = "SELECT id, label FROM test_prepare_emulated_myisam_index WHERE id = :placeholder AND label… 150 … $stmt = prepex(17, $db, $sql, array(1, 1), array('execute' => array('sqlstate' => 'HY093')));
|
H A D | pdo_mysql_exec_select.phpt | 12 function exec_and_count($offset, &$db, $sql, $exp) { 14 $ret = $db->exec($sql); 17 $offset, $exp, gettype($exp), $ret, gettype($ret), $sql, 24 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo()));
|
H A D | bug81037.phpt | 21 $sql = "SELECT id FROM {$table} WHERE label = :par"; 22 $stmt = $pdo->prepare($sql);
|
H A D | bug_41125.phpt | 18 $sql = <<<SQL 25 $stmt = $db->query($sql);
|
/php-src/ext/pdo_firebird/tests/ |
H A D | gh10908.phpt | 15 $sql = <<<EOT 33 $dbh->exec($sql); 36 function query_and_dump($dbh, $sql) { 37 foreach ($dbh->query($sql) as $row) {
|
H A D | bug_76450.phpt | 21 $sql = "EXECUTE PROCEDURE test_proc 123"; 22 $query = $dbh->prepare($sql);
|
H A D | bug_76488.phpt | 14 $sql = ' 28 $sth = $dbh->prepare($sql);
|
H A D | execute_block.phpt | 18 $sql = ' 34 $query = $dbh->prepare($sql);
|
H A D | bug_62024.phpt | 21 $sql = "insert into test62024 (id, text) values (?, ?)"; 22 $sttmt = $dbh->prepare($sql);
|
/php-src/ext/pdo_pgsql/tests/ |
H A D | bug62479.phpt | 50 $sql = sprintf($template, 'my password'); 51 $pdo->query($sql); 61 $sql = sprintf($template, "my pass''word"); 62 $pdo->query($sql);
|
/php-src/ext/pgsql/ |
H A D | php_pgsql.h | 73 …insert(PGconn *pg_link, const zend_string *table, zval *values, zend_ulong opt, zend_string **sql); 74 …n *pg_link, const zend_string *table, zval *values, zval *ids, zend_ulong opt , zend_string **sql); 75 …ql_delete(PGconn *pg_link, const zend_string *table, zval *ids, zend_ulong opt, zend_string **sql); 76 …_string *table, zval *ids, zval *ret_array, zend_ulong opt, long fetch_option, zend_string **sql );
|