问题描述
大家好.我真的被一件事卡住了.我实际上正在开发一个在线预订的小型住宿网站.我有个问题.我需要sql代码来显示可用的房间.
这是场景:
我们在主页上.用户选择入住和退房日期，然后选择搜索可用的房间.我想在另一个页面中加载可用的房间.
任何帮助都将受到欢迎
这是我的桌子
预订表:
reservId
clientId
employeeId
roomNumb
dateIn
dateOut
房间表:
roomNumb
roomtypeID
roomRate
地板
房间类型表
roomtypeId
roomType
numberOfPersons
Hello guys. I got really stucked on one thing. I am actually developing an online website booking for a small accommodation. I have a problem. i need the sql code to display the rooms available.
here is the scenario:
we are on the home page. the user select the checkin and checkout date and then he clic search for the room available. I want to load the available rooms in another page.
Any help would be the welcome
here are my tables
reservation table:
reservId
clientId
employeeId
roomNumb
dateIn
dateOut
room table:
roomNumb
roomtypeID
roomRate
floor
roomtype table
roomtypeId
roomType
numberOfPersons
推荐答案
这篇关于在线预订系统，将信息从一页加载到另一页的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！