MySql 和 PHP 时间重叠 - MySql and PHP Time Overlapping

MySql and PHP Time Overlapping

本文关键字：时间重叠 PHP MySql | 更新日期: 2023-09-27

例如，我有以下时间要插入：

7 am to 12pm

我的数据库中的数据是：

8 am to 9 am ,
11 am to 1 pm ,
5 am to 7 am

我需要在我的'SELECT'语句中添加什么'WHERE'语句，以便如果它返回一个值，则意味着当前时间已经'RESERVED'如果不是，则它的' AVAILABLE '

我当前的代码是

select eventDate,timestart,timeend from eventcalendar where eventDate='$eventdate' and
 ((Cast('$timestart' as time) > timestart  and Cast('$timestart' as time) < timeend) or  
 (Cast('$timeend' as time) > timestart  and Cast('$timeend' as time) < timeend)) or 
((Cast('$timestart' as time) between timestart and timeend) or ((Cast('$timeend' as time) between timestart and timeend)))

>我终于通过添加和反转给定的来解决它

"select eventDate,timestart,timeend from eventcalendar where eventDate='$eventdate' and 
 ((Cast('$timestart' as time) > timestart  and Cast('$timestart' as time) < timeend) or  
 (Cast('$timeend' as time) > timestart  and Cast('$timeend' as time) < timeend)) or 
  (timestart >  Cast('$timestart' as time) and timestart < Cast('$timeend' as time))  or
(timeend >  Cast('$timestart' as time) and timeend < Cast('$timeend' as time))   "