Compute Vacant Rooms for Hotel Booking System
Hi! I'm not a PHP guru. I'm developing a Hotel Booking System and I'm having problem computing the available rooms per hotel. On my website I have search engine for searching available rooms based on check -in and check-out date. The result rooms that should be displayed are the rooms that are not booked for that span of time. I have no idea how to do it but I'll give you how I built my table on DB for rooms, hotel, booking, and room booked. Each room has corresponding quantity, lets say for one hotel there are 10 types of rooms. Example, there is 10 Single Bed (room type) rooms.
Attached files are the screenshots of the tables used in my application:
Anyone who encounter also this issue. Any suggestion would be very much appreciated. Thank you very much in advance.