php - 使用 PHP-MySQLi-Database-Class 的 SQL 查询 rawQuery

Question

我正在使用 PHP-MySQLi-Database-Class (MysqliDb.php)。

我收到了那个查询，但是 Wamp 说:

fatal error :准备查询时出现问题

 SELECT car_id FROM gm_cars WHERE car_id NOT IN 
( 
  SELECT reserve_car_id FROM gm_reservations 
 WHERE reserve_dropOff > ? AND reserve_dropOff = ? AND reserve_pickUp ) 

Erreur de syntaxe près de '' à la ligne 1 in C:\wamp\www\work\libs\PHP-MySQLi-Database-Class-master\MysqliDb.php 第 823 行

查询:连接到数据库

>$carsBetweenDates = $db->rawQuery
('SELECT car_id FROM gm_cars WHERE car_id NOT IN 
   (SELECT reserve_car_id FROM gm_reservations 
     WHERE reserve_dropOff > ? AND reserve_dropOff <= ? 
     UNION 
     DISTINCT SELECT reserve_car_id FROM gm_reservations 
      WHERE reserve_pickUp >= ? AND reserve_pickUp < ?)', 
      Array('2014-12-20 20:00:00', '2014-12-22 20:00:00', 
      '2014-12-20 20:00:00', '2014-12-22 20:00:00'));

我没有看到错误。非常感谢。对不起我的英语。

Answer 1

你能试试这样调用函数吗:

$db->rawQuery('QUERY', array(), FALSE);

我认为清理会损坏您的查询(它可能会删除 html 字符，在您的情况下是 < > 条件)

假设这是类: https://github.com/joshcam/PHP-MySQLi-Database-Class/blob/master/MysqliDb.php