| /PHP-8.2/ext/mysqli/tests/ |
| H A D | bug42378.phpt | 25 $sql = sprintf("CREATE TABLE test(id INT AUTO_INCREMENT PRIMARY KEY, col1 %s) ENGINE=%s",
27 if (!mysqli_query($link, $sql)) {
38 $sql = sprintf("INSERT INTO test(id, col1) VALUES (%d, %f)",
40 if (!mysqli_query($link, $sql)) {
62 $sql = sprintf('SELECT %s AS _format FROM %s ORDER BY %s', $format, $from, $order_by);
64 $sql = sprintf('SELECT %s AS _format FROM %s', $format, $from);
66 if (!mysqli_stmt_prepare($stmt, $sql)) {
109 $format, $sql);
142 $format, $sql);
|
| 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)) {
|
| /PHP-8.2/ext/pgsql/tests/ |
| H A D | bug72028.phpt | 19 $sql = "INSERT INTO $table (value, details) VALUES ($1, $2)";
22 $result = pg_query_params($conn, $sql, $params);
30 $result = pg_query_params($conn, $sql, $params2);
|
| H A D | 08escape.phpt | 49 $sql = "INSERT INTO ".$table_name." (num, bin) VALUES (10000, CAST ('".$escaped_data."' AS BYTEA));…
50 pg_query($db, $sql);
54 $sql = "SELECT bin::bytea FROM ".$table_name." WHERE num = 10000";
55 $result = pg_query($db, $sql);
67 $result = pg_query($db, $sql);
|
| /PHP-8.2/ext/pdo_pgsql/tests/ |
| H A D | bug72294.phpt | 104 public function prepare( $pdo, $sql )
106 //return $pdo->prepare( $sql );
107 $this->cached_statements[$sql] = $pdo->prepare( $sql );
109 return $this->cached_statements[$sql];
|
| H A D | bug62479.phpt | 53 $sql = sprintf($template, 'my password');
54 $pdo->query($sql);
64 $sql = sprintf($template, "my pass''word");
65 $pdo->query($sql);
|
| /PHP-8.2/ext/oci8/tests/ |
| H A D | exec_fetch.phpt | 10 $sql = "select 2 from nonex_dual";
11 $stmt = oci_parse($c, $sql);
|
| 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 | 17 $sql = "begin :p_clob := 'lob string'; end;";
18 $stid = oci_parse($conn, $sql);
|
| /PHP-8.2/ext/pdo_mysql/tests/ |
| H A D | pdo_mysql_exec_ddl.phpt | 12 function exec_and_count($offset, &$db, $sql, $exp, $suppress_warning = false) {
17 $ret = @$db->exec($sql);
19 $ret = $db->exec($sql);
23 $offset, $exp, gettype($exp), $ret, gettype($ret), $sql,
30 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo()));
|
| H A D | pdo_mysql_exec_load_data.phpt | 34 function exec_and_count($offset, &$db, $sql, $exp) {
38 $ret = $db->exec($sql);
41 $offset, $exp, gettype($exp), $ret, gettype($ret), $sql,
55 $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 | 20 $sql = "SELECT id FROM test WHERE label = :par";
21 $stmt = $pdo->prepare($sql);
|
| /PHP-8.2/ext/pdo/tests/ |
| H A D | pdo_020.phpt | 23 …ELECT id, val FROM test', 'SELECT id, val, val2 FROM test', 'SELECT COUNT(*) FROM test') 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 test(id INT NULL)';
31 $sql = 'CREATE TABLE test(id INT)';
34 $db->exec($sql);
|
| H A D | pdo_024.phpt | 22 $sql = 'create table test (id int, name varchar(10) null)';
25 $sql = 'create table test (id int, name varchar(10))';
28 $db->exec($sql);
|
| /PHP-8.2/ext/odbc/tests/ |
| H A D | bug73448.phpt | 23 foreach ($sqlCommandList as $exampleNumber => $sql) {
24 $r = @odbc_exec($conn, $sql);
30 var_dump($sql, $n, $e);
|
| /PHP-8.2/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-8.2/ext/pdo_dblib/tests/ |
| H A D | bug_69757.phpt | 13 $sql = "
19 $stmt = $db->query($sql);
|
| H A D | types.phpt | 29 $sql = "
41 $stmt = $db->query($sql);
54 $stmt = $db->query($sql);
|
| /PHP-8.2/ext/pdo_firebird/tests/ |
| H A D | bug_76450.phpt | 20 $sql = "EXECUTE PROCEDURE test_proc 123";
21 $query = $dbh->prepare($sql);
|
| H A D | gh10908.phpt | 14 $sql = <<<EOT
31 $dbh->exec($sql);
34 function query_and_dump($dbh, $sql) {
35 foreach ($dbh->query($sql) as $row) {
|
| H A D | bug_76488.phpt | 13 $sql = '
25 $sth = $dbh->prepare($sql);
|
| H A D | execute_block.phpt | 16 $sql = '
31 $query = $dbh->prepare($sql);
|
| /PHP-8.2/ext/pgsql/ |
| H A D | php_pgsql.h | 79 …insert(PGconn *pg_link, const zend_string *table, zval *values, zend_ulong opt, zend_string **sql);
80 …n *pg_link, const zend_string *table, zval *values, zval *ids, zend_ulong opt , zend_string **sql);
81 …ql_delete(PGconn *pg_link, const zend_string *table, zval *ids, zend_ulong opt, zend_string **sql);
82 …_string *table, zval *ids, zval *ret_array, zend_ulong opt, long fetch_option, zend_string **sql );
|
