/php-src/ext/mysqli/tests/ |
H A D | bug75018.phpt | 16 $sql = "DROP TABLE IF EXISTS $tbl"; 17 $mysqli->query($sql); 19 $sql = "CREATE TABLE $tbl (bit_column_1 bit(16) NOT NULL) DEFAULT CHARSET=utf8"; 20 $mysqli->query($sql); 22 $sql = "INSERT INTO $tbl (bit_column_1) VALUES (0)"; 23 $mysqli->query($sql); 24 $sql = "INSERT INTO $tbl (bit_column_1) VALUES (0b10101010101)"; 25 $mysqli->query($sql); 27 $sql = "SELECT bit_column_1 FROM $tbl"; 28 $result = $mysqli->query($sql);
|
H A D | bug79084_collision.phpt | 12 $sql = "SELECT 11111 as `1`, 22222 as `2`"; 16 $link->real_query($sql); 25 $res = $link->query($sql); 33 $res = $link->query($sql);
|
H A D | bug79084.phpt | 12 $sql = "SELECT 0 as `2007`, 0 as `2008`, 0 as `2020`"; 16 $link->real_query($sql); 25 $res = $link->query($sql); 33 $res = $link->query($sql);
|
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);
|
/php-src/ext/odbc/tests/ |
H A D | bug47803.phpt | 55 $sql = "UPDATE bug47803 58 $result = odbc_prepare($link, $sql); 60 print ('[sql] prep: '.$sql); 65 print ('[sql] exec: '."array({$k['name']}, {$k['id']})"); 71 $sql = "SELECT * FROM bug47803 WHERE [PAR_ID] = ?"; 72 $result = odbc_prepare($link, $sql); 74 print ('[sql] prep: '.$sql); 79 print ('[sql] exec: '."array({$k['id']})");
|
H A D | bug73448.phpt | 25 foreach ($sqlCommandList as $exampleNumber => $sql) { 26 $r = @odbc_exec($conn, $sql); 32 var_dump($sql, $n, $e);
|
/php-src/ext/pdo/tests/ |
H A D | bug_65946.phpt | 22 $sql = 'SELECT TOP :limit * FROM test65946'; 25 $sql = 'SELECT TOP (:limit) * FROM test65946'; 28 $sql = 'SELECT FIRST :limit * FROM test65946'; 31 //$sql = 'SELECT * FROM test65946 FETCH FIRST :limit ROWS ONLY'; // Oracle 12c syntax 32 …$sql = "select id from (select a.*, rownum rnum from (SELECT * FROM test65946) a where rownum <= :… 35 $sql = 'SELECT * FROM test65946 LIMIT :limit'; 38 $stmt = $db->prepare($sql);
|
H A D | bug_71885.phpt | 24 $sql = "SELECT * FROM test71885 WHERE a ?? 1"; 27 $db->exec($sql); 33 $stmt = $db->prepare($sql); 44 $stmt = $db->prepare($sql);
|
H A D | bug_72368.phpt | 20 $sql = "SELECT 1"; 24 $stmt = $db->prepare($sql); 33 $stmt = $db->prepare($sql);
|
/php-src/ext/pdo_firebird/tests/ |
H A D | dialect_1.phpt | 2 PDO_Firebird: support 1 sql dialect 22 $sql = 29 $query = $dbh->prepare($sql); 40 $sql='INSERT INTO test_dialect_1(K, DT) values(?, ?)'; 41 $query = $dbh->prepare($sql); 45 $sql='SELECT * FROM test_dialect_1'; 46 $query = $dbh->prepare($sql);
|
H A D | ignore_parammarks.phpt | 18 $sql = ' 24 $query = $dbh->prepare($sql); 30 $sql = ' 35 $query = $dbh->prepare($sql);
|
/php-src/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_local_infile_directory_denied.phpt | 16 function exec_and_count($offset, &$db, $sql, $exp) { 18 $ret = $db->exec($sql); 21 $offset, $exp, gettype($exp), $ret, gettype($ret), $sql, 27 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo())); 45 …$sql = sprintf("LOAD DATA LOCAL INFILE %s INTO TABLE test_local_inifile_dir_denied FIELDS TERMINAT… 46 if (exec_and_count(3, $db, $sql, false)) {
|
H A D | bug66878.phpt | 15 $sql = 'SELECT 123; SELECT 42; SELECT 999'; 17 $stmt = $pdo->query($sql); 23 $stmt = $pdo->query($sql);
|
H A D | pdo_mysql_local_infile_directory_allowed.phpt | 16 function exec_and_count($offset, &$db, $sql, $exp) { 18 $ret = $db->exec($sql); 21 $offset, $exp, gettype($exp), $ret, gettype($ret), $sql, 27 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo())); 45 …$sql = sprintf("LOAD DATA LOCAL INFILE %s INTO TABLE test_local_inifile_dir_allowed FIELDS TERMINA… 46 if (exec_and_count(3, $db, $sql, 3)) {
|
H A D | pdo_mysql_local_infile_overrides_local_infile_directory.phpt | 16 function exec_and_count($offset, &$db, $sql, $exp) { 18 $ret = $db->exec($sql); 21 $offset, $exp, gettype($exp), $ret, gettype($ret), $sql, 27 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo())); 45 …$sql = sprintf("LOAD DATA LOCAL INFILE %s INTO TABLE test_local_inifile_overrides FIELDS TERMINATE… 46 if (exec_and_count(3, $db, $sql, 3)) {
|
H A D | pdo_mysql_exec_ddl.phpt | 12 function exec_and_count($offset, &$db, $sql, $exp, $suppress_warning = false) { 15 $ret = @$db->exec($sql); 17 $ret = $db->exec($sql); 21 $offset, $exp, gettype($exp), $ret, gettype($ret), $sql, 28 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo()));
|
H A D | pdo_mysql_exec_load_data.phpt | 33 function exec_and_count($offset, &$db, $sql, $exp) { 35 $ret = $db->exec($sql); 38 $offset, $exp, gettype($exp), $ret, gettype($ret), $sql, 50 $offset, $sql, $db->errorCode(), implode(' ', $db->errorInfo())); 76 $sql = sprintf("LOAD DATA LOCAL INFILE %s INTO TABLE test_mysql_exec_load_data FIELDS TERMINATED BY… 78 if (exec_and_count(4, $db, $sql, 2)) {
|
/php-src/ext/pdo_dblib/tests/ |
H A D | datetime_convert.phpt | 16 $sql = "SELECT convert(datetime, '20171027 10:22:44.135') AS [d]"; 20 $stmt = $db->query($sql); 26 $stmt = $db->query($sql);
|
H A D | datetime2.phpt | 17 $sql = "SELECT convert(datetime2, '10231017 10:22:44.1355318') AS [d]"; 21 $stmt = $db->query($sql); 26 $stmt = $db->query($sql);
|
H A D | timeout.phpt | 17 $sql = 'WAITFOR DELAY \'00:00:02\''; 23 $stmt = $db->prepare($sql); 37 $stmt = $db->prepare($sql); 49 $stmt = $db->prepare($sql); 61 $stmt = $db->prepare($sql);
|
H A D | bug_69592.phpt | 16 $sql = ' 23 $stmt = $db->query($sql); 33 $stmt = $db->query($sql);
|
H A D | stringify_uniqueidentifier.phpt | 20 $sql = "SELECT CAST('$testGUID' as uniqueidentifier) as [guid]"; 34 $stmt = $db->query($sql); 44 $stmt = $db->query($sql); 58 $stmt = $db->query($sql);
|
/php-src/ext/pcre/tests/ |
H A D | bug41050.phpt | 9 $sql = 'SELECT * FROM #__components'; 11 if (preg_match($regex,$sql, $m)) echo 'matched';
|
/php-src/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];
|
/php-src/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);
|