php - 检查用户输入是否在时间之间

Question

我有一个系统功能，用户可以向官员发送邀请。为了说明这一点，这位官员在他的日历中安排了为期 3 天的静修。在数据库中，它看起来像这样:

+---------+------------+------------+--------+----------+
|  name   | date_start |  date_end  |  time  | time_end |
+---------+------------+------------+--------+----------+
| Retreat | 2018-01-16 | 2018-01-18 | 9:00AM | 12:00PM  |
| Retreat | 2018-01-17 | 2018-01-18 | 9:00AM | 12:00PM  |
| Retreat | 2018-01-18 | 2018-01-18 | 9:00AM | 12:00PM  |
+---------+------------+------------+--------+----------+

用户希望向官方发送2018-01-17至2018-01-1910:00AM至11:00AM为期两天的事件邀请> 那些日子。如果他建议的日期和时间位于数据库中当前日期和时间之间的任何位置，我如何拒绝他的输入？

到目前为止，这就是我所使用的

$q_date = mysqli_query($con, "SELECT * FROM `events` WHERE `date_start` = '$date' AND `time` = '$time_f' AND `pastor_id` = '$id'");
$count_date = mysqli_num_rows($q_date);
if ($count_date > 0) {
    echo "<p>Sorry, this time is occupied. Please select another schedule</p>";
}

如有任何帮助，我们将不胜感激

Answer 1

MySQL 有一个 BETWEEN 条件:

SELECT * FROM `events` 
WHERE 
('$date' BETWEEN `date_start` AND `date_end`)
AND
('$time_f' BETWEEN `time` AND `time_end`)
AND `pastor_id` = '$id'

假设查询之前有效，这将找到您要查找的内容。