Home
last modified time | relevance | path

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

12345

/php-src/ext/mysqli/tests/
H A Dmysqli_stmt_fetch_bit.phpt29 …!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 Dmysqli_fetch_array_large.phpt22 $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 Dmysqli_fetch_assoc_bit.phpt42 …!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 Dmysqli_stmt_bind_result_format.phpt24 $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 Dmysqli_stmt_get_result_bit.phpt47 …!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 Dbug70949.phpt18 $sql = "select * from bug70949";
20 if ($stmt = $mysql->prepare($sql))
/php-src/ext/pgsql/tests/
H A D08escape.phpt52 $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 Dbug37100_9.phpt27 $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 Dbug44643.phpt14 $sql = "SELECT * FROM (SELECT 'test' = :id1) a WHERE a.test = :id2";
15 $stmt = $db->prepare($sql);
/php-src/ext/pdo/tests/
H A Dpdo_020.phpt23 … 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 Dbug_73234.phpt28 $sql = 'CREATE TABLE test73234(id INT NULL)';
31 $sql = 'CREATE TABLE test73234(id INT)';
34 $db->exec($sql);
H A Dpdo_024.phpt22 $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 Dbug_69757.phpt16 $sql = "
22 $stmt = $db->query($sql);
H A Dtypes.phpt32 $sql = "
44 $stmt = $db->query($sql);
57 $stmt = $db->query($sql);
/php-src/ext/pdo_mysql/tests/
H A Dpdo_mysql_prepare_emulated_myisam_index.phpt131 …$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 Dpdo_mysql_exec_select.phpt12 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 Dbug81037.phpt21 $sql = "SELECT id FROM {$table} WHERE label = :par";
22 $stmt = $pdo->prepare($sql);
H A Dbug_41125.phpt18 $sql = <<<SQL
25 $stmt = $db->query($sql);
/php-src/ext/pdo_firebird/tests/
H A Dgh10908.phpt15 $sql = <<<EOT
33 $dbh->exec($sql);
36 function query_and_dump($dbh, $sql) {
37 foreach ($dbh->query($sql) as $row) {
H A Dbug_76450.phpt21 $sql = "EXECUTE PROCEDURE test_proc 123";
22 $query = $dbh->prepare($sql);
H A Dbug_76488.phpt14 $sql = '
28 $sth = $dbh->prepare($sql);
H A Dexecute_block.phpt18 $sql = '
34 $query = $dbh->prepare($sql);
H A Dbug_62024.phpt21 $sql = "insert into test62024 (id, text) values (?, ?)";
22 $sttmt = $dbh->prepare($sql);
/php-src/ext/pdo_pgsql/tests/
H A Dbug62479.phpt50 $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 Dphp_pgsql.h73 …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 );

Completed in 965 milliseconds

12345