php - 如何在 codeigniter 中使用开始时间和结束时间检查行程开始日期和结束日期

Question

我正在开发预订系统，用户可以在其中预订汽车，在向数据库/表格中添加任何行程之前，我想检查日期和时间之间是否已经存在该行程。这是我在模型中的查询。

$this->db->select('trId')
->from('trips')              
->where('carId',$data['carId'])//car Id
 ->where('tripStart <=',$data['tripStart'])//trip start date
->where('tripEnd >= ',$data['tripEnd'])//trip end date
->where('tripStartTime <= ',$data['tripStartTime'])//trip start time
->where('tripStartEnd >=',$data['tripStartEnd'])//trip end time
->get();

我将值存储在我的行程表中是

tripStart = '2018-03-01'
tripEnd = '2018-03-03'
tripStartTime = '09:00:00'
tripStartEnd = '13:00:00'

Answer 1

select trId from trips 
where carId = value AND 
      (Between tripStart = "value" AND tripEnd = "value") AND
      (Between tripsStartTime = "value" AND tripStartEnd = "value");

这就是你想要的