| /PHP-7.4/ext/pdo/tests/ |
| H A D | pdo_020.phpt | 22 …ELECT id, val FROM test', 'SELECT id, val, val2 FROM test', 'SELECT COUNT(*) FROM test') as $sql) {
24 $stmt = $db->query($sql);
26 echo "Counted $res columns after $sql.\n";
|
| H A D | pdo_024.phpt | 21 $sql = 'create table test (id int, name varchar(10) null)';
24 $sql = 'create table test (id int, name varchar(10))';
27 $db->exec($sql);
|
| /PHP-7.4/ext/oci8/tests/ |
| H A D | bug36096.phpt | 10 $sql = "SELECT 'ABC' FROM DUAL WHERE 1<>1";
11 $stmt = oci_parse($c, $sql);
|
| H A D | bug36010.phpt | 15 $sql = "begin :p_clob := 'lob string'; end;";
16 $stid = oci_parse($conn, $sql);
|
| H A D | bug32325.phpt | 25 $sql = "begin
29 $stmt = oci_parse($c, $sql);
|
| H A D | statement_type.phpt | 26 foreach ($sqls as $sql) {
27 $s = oci_parse($c, $sql);
|
| 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 | bug71600.phpt | 27 $sql = "select col1,col2,col3,col4,col5,col6,col7,col8,col9 from bug71600_tab";
30 $stmt = oci_parse($c, $sql);
51 $stmt = oci_parse($c, $sql);
|
| /PHP-7.4/ext/pgsql/tests/ |
| H A D | 22pg_fetch_object.phpt | 19 $sql = "SELECT * FROM $table_name WHERE num = 0";
20 $result = pg_query($db, $sql) or die('Cannot query db');
|
| H A D | 17result.phpt | 13 $sql = "SELECT * FROM $table_name ORDER BY num";
14 $result = pg_query($db, $sql) or die('Cannot query db');
|
| H A D | bug37100_9.phpt | 26 $sql = "BEGIN; DECLARE mycursor BINARY CURSOR FOR SELECT binfield FROM test_bug; FETCH ALL IN mycur…
28 $data = pg_query($sql);
|
| H A D | bug37100.phpt | 27 $sql = "BEGIN; DECLARE mycursor BINARY CURSOR FOR SELECT binfield FROM test_bug; FETCH ALL IN mycur…
29 $data = pg_query($sql);
|
| /PHP-7.4/ext/pdo_mysql/tests/ |
| H A D | pdo_mysql_exec_load_data.phpt | 33 function exec_and_count($offset, &$db, $sql, $exp) {
37 $ret = $db->exec($sql);
40 $offset, $exp, gettype($exp), $ret, gettype($ret), $sql,
54 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo()));
84 …$sql = sprintf("LOAD DATA LOCAL INFILE %s INTO TABLE test FIELDS TERMINATED BY ';' LINES TERMINATE…
86 if (exec_and_count(4, $db, $sql, 2)) {
|
| H A D | bug81037.phpt | 19 $sql = "SELECT id FROM test WHERE label = :par";
20 $stmt = $pdo->prepare($sql);
|
| H A D | pdo_mysql_exec_select.phpt | 11 function exec_and_count($offset, &$db, $sql, $exp) {
15 $ret = $db->exec($sql);
18 $offset, $exp, gettype($exp), $ret, gettype($ret), $sql,
25 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo()));
|
| /PHP-7.4/ext/mysqli/tests/ |
| H A D | mysqli_stmt_fetch_bit.phpt | 30 …!mysqli_query($link, $sql = sprintf('CREATE TABLE test(id INT, label BIT(%d)) ENGINE="%s"', $bits,…
39 … $sql = sprintf("INSERT INTO test(id, label) VALUES (%d, b'%s')", $value, decbin($value));
41 if (!mysqli_stmt_prepare($stmt, $sql) ||
46 … $sql = sprintf("SELECT id, label + 0 AS _label0, label FROM test WHERE id = %d", $value);
47 if (!mysqli_stmt_prepare($stmt, $sql) ||
|
| H A D | mysqli_fetch_array_large.phpt | 18 $sql = "INSERT INTO test(label) VALUES ";
20 while (strlen($sql) < ($package_size - 259))
21 $sql .= sprintf("('%s'), ", $random_char);
23 $sql = substr($sql, 0, -2);
24 $len = strlen($sql);
27 if (!@mysqli_query($link, $sql)) {
|
| H A D | mysqli_fetch_assoc_bit.phpt | 48 …!mysqli_query($link, $sql = sprintf('CREATE TABLE test(id BIGINT, bit_value BIT(%d) NOT NULL, bit_…
73 $sql = sprintf("INSERT INTO test(id, bit_value) VALUES (%s, b'%s')", $value, $bin);
78 if (!mysqli_query($link, $sql))
81 …$sql = sprintf("SELECT id, BIN(bit_value) AS _bin, bit_value + 0 AS _bit_value0, bit_value, bit_nu…
82 if (!$res = mysqli_query($link, $sql))
|
| /PHP-7.4/ext/pdo_dblib/tests/ |
| H A D | bug_69757.phpt | 12 $sql = "
18 $stmt = $db->query($sql);
|
| H A D | types.phpt | 28 $sql = "
40 $stmt = $db->query($sql);
53 $stmt = $db->query($sql);
|
| /PHP-7.4/ext/pdo_odbc/tests/ |
| H A D | bug44643.phpt | 13 $sql = "SELECT * FROM (SELECT 'test' = :id1) a WHERE a.test = :id2";
14 $stmt = $db->prepare($sql);
|
| /PHP-7.4/ext/pdo_firebird/tests/ |
| H A D | bug_76488.phpt | 11 $sql = '
23 $sth = $dbh->prepare($sql);
|
| H A D | bug_76450.phpt | 20 $sql = "EXECUTE PROCEDURE test_proc 123";
21 $query = $dbh->prepare($sql);
|
| H A D | bug_62024.phpt | 20 $sql = "insert into test_insert (id, text) values (?, ?)";
21 $sttmt = $dbh->prepare($sql);
|
| /PHP-7.4/ext/pdo_pgsql/tests/ |
| H A D | bug62479.phpt | 51 $sql = sprintf($template, 'my password');
52 $pdo->query($sql);
62 $sql = sprintf($template, "my pass''word");
63 $pdo->query($sql);
|
