SQL查询rawQuery与PHP-MySQLi-Database-Class

Question

I'm using PHP-MySQLi-Database-Class (MysqliDb.php).

I have got that query, but Wamp says:

Fatal error: Problem preparing query

 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 on line 823

Query: Connect to database

>$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'));

I don't see the error. Thanks so much. Sorry for my english.

Answer 1

Can you try calling the function like this:

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

I think the sanitizing damages your query ( it may strip html characters, in your case the < > conditions )

Assuming this is the class: https://github.com/joshcam/PHP-MySQLi-Database-Class/blob/master/MysqliDb.php