帮助为我们的论文建立预约系统 [英] Help on making a reservation system for our thesis

问题描述

我目前在获取空闲时隙方面遇到问题，我有一个表格，用于每段时间8:00-22:00(timeTB)1行，并记录了一天中的占用时间

I''m currently having a problem on getting the vacant time slots, I have a table for the timeslots 8:00-22:00(timeTB) 1 row per time, and a record for occupied time for the day in the other table(CustomerTimeTB), how can i remove to the list the occupied time on timeTB?

推荐答案

timeTB和CustomerTimeTB之间必须存在一定的关系.您将需要使用该名称，以便可以获取与时隙相关的特定条目.

查看您设计的数据库，然后尝试一下.

或

尽管上述方法很容易，但是如果您做不到，也可以执行以下操作(不推荐！)，例如先从timeTB获取所有需要的记录，然后再从CustomerTimeTB获取所有记录.然后比较并过滤所需的内容.

There must be certain relationg between the timeTB & CustomerTimeTB. You would need to use that such that you can get specific entries related to a timeslot.

Looks into your database designed and try that out.

OR

Though the above approach would be easy, in case you fail to do it, you can also do something like (not recommended!) get all the needed records from timeTB first and then from CustomerTimeTB. Then compare and filter the needed ones.

这篇关于帮助为我们的论文建立预约系统的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！