blocks|key|45990|text|您需要更改重叠的逻辑。试试这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|45991|SELECT+serverip+
FROM++server+
WHERE+serverip+NOT+IN+(SELECT+serverip+
+++++++++++++++++++++++FROM+booking+
+++++++++++++++++++++++WHERE+startat+<=+USEREXPIREDATE+AND
+++++++++++++++++++++++++++++expiresat+>=+USERSTARTDATE
++++++++++++++++++++++)+
LIMIT++1;+|code-block|syntax|javascript|45992|当插槽在期望的用户到期日期之前开始并且在期望的用户开始日期之后结束时，它被占用。|45993|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You need to change the logic for the overlap. Try this:

<pre><code>SELECT serverip 
FROM server 
WHERE serverip NOT IN (SELECT serverip 
 FROM booking 
 WHERE startat &lt;= USEREXPIREDATE AND
 expiresat &gt;= USERSTARTDATE
 ) 
LIMIT 1; 
</code></pre>

A slot is occupied when it starts before the desired user expire date and ends after the desired user start date.

blocks|key|2521585|text|SELECT+*
FROM+server
WHERE+serverip+NOT+IN
(SELECT+serverip+
+FROM+booking
+WHERE
+++(startat+<=+'2013-01-30+08:00:00'+AND+expiresat+>=+'2013-01-30+08:00:00')+OR
+++(startat+<=+'2013-01-30+09:00:00'+AND+expiresat+>=+'2013-01-30+09:00:00')+OR
+++(startat+>=+'2013-01-30+08:00:00'+AND+expiresat+<=+'2013-01-30+09:00:00'))|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2521586|其中8:00是开始时间，9:00是到期时间。|unstyled|2521587|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>SELECT *
FROM server
WHERE serverip NOT IN
(SELECT serverip 
 FROM booking
 WHERE
 (startat &lt;= '2013-01-30 08:00:00' AND expiresat &gt;= '2013-01-30 08:00:00') OR
 (startat &lt;= '2013-01-30 09:00:00' AND expiresat &gt;= '2013-01-30 09:00:00') OR
 (startat &gt;= '2013-01-30 08:00:00' AND expiresat &lt;= '2013-01-30 09:00:00'))
</code></pre>

Where 8:00 is start time and 9:00 is expire.

blocks|key|2731317|text|time+as+this+pic+says+有四种可能性，图片中表示的代码是|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2731318|SELECT+Id+FROM+reservations+
WHERE+
((start_at+<+@start_at+AND+start_at+<+@end_at)+AND+(end_at+>+@start_at+AND+end_at+<+@end_at))
OR((start_at+>+@start_at+AND+start_at+<+@end_at)+AND+(end_at+>+@start_at+AND+end_at+>+@end_at))
OR((start_at+<=+@start_at+AND+start_at+<=+@end_at)+AND+(end_at+>=+@start_at+AND+end_at+>=+@end_at))
OR((start_at+>=+@start_at+AND+start_at+<=+@end_at)+AND+(end_at+>=+@start_at+AND+end_at+<=+@end_at))|code-block|syntax|javascript|2731319|entityMap|0|LINK|mutability|MUTABLE|url|https://i.stack.imgur.com/2UCeR.png^0|5|H|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

There are four possibilities for time <a href="https://i.stack.imgur.com/2UCeR.png" rel="nofollow noreferrer">as this pic says </a> and the code for what represent in the picture is 

<pre><code>SELECT Id FROM reservations 
WHERE 
((start_at &lt; @start_at AND start_at &lt; @end_at) AND (end_at &gt; @start_at AND end_at &lt; @end_at))
OR((start_at &gt; @start_at AND start_at &lt; @end_at) AND (end_at &gt; @start_at AND end_at &gt; @end_at))
OR((start_at &lt;= @start_at AND start_at &lt;= @end_at) AND (end_at &gt;= @start_at AND end_at &gt;= @end_at))
OR((start_at &gt;= @start_at AND start_at &lt;= @end_at) AND (end_at &gt;= @start_at AND end_at &lt;= @end_at))
</code></pre>

EDIT: The query Gordon posted appears to have a problem. If I have a booking from 10-12 it seems to consider all bookings past 12 pm invalid, but all bookings before 10am valid.

Some quick and simple thinking ended up in me creating the following query:

<pre><code>SELECT serverip 
 FROM server 
 WHERE serverip NOT IN (SELECT serverip 
 FROM booking 
 WHERE startat &gt;= datehere 
 AND expiresat &lt;= datehere) 
 LIMIT 1; 
</code></pre>

Suppose the booking table stores the following:

<pre><code>+-----------+-----------+----------+----------+-----------+
| bookingid | serverip | username | startat | expiresat |
+-----------+-----------+----------+----------+-----------+
| 1 | 127.0.0.1 | testuser | 10:00 | 12:00 |
+-----------+-----------+----------+----------+-----------+
</code></pre>

If the user was to input the following data for a booking:

<pre><code>startat = 9:59
expiresat = 12:01
</code></pre>

They could easily bypass my check to see if the booking time is available based on previous bookings stored.

Any advice on how I could better solve this problem? 

I would prefer NOT to limit the users input and would like to avoid hard coding specific time slots, if that wasn't a problem however I would stick with what I've got.

Thanks for your time.

Checking if a timeslot/booking is taken

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

编辑:戈登发布的查询似乎有问题。如果我有一个10-12的预订，它似乎认为下午12点以后的所有预订都无效，但上午10点之前的所有预订都是有效的。一些快速而简单的想法最终使我创建了以下查询：SELECT serverip         FROM   server         WHERE  serverip NOT I...

问检查是否进行了时隙/预订
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问检查是否进行了时隙/预订EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问检查是否进行了时隙/预订
EN