Hi need some help.I am creating a small hotel booking system.I have a mysql Db whith
tables rooms, clients, bookings,prices,supplements, supplements booked.
I have a search form. Clicking on a calendar img will display a calendar.Clicking on the calendar
will insert the date in the box.Also I can select n.persons, nights,adults,children etc.
Here I am stuck.I need some php code that will process this data and retrieve available rooms
from the rooms table, for a specified arr/dep date. Thank you
Jump to Post
I would suggest you start writing some code and post here if you face problem in the same.
Follow the following:
1. get all input values
2. execute a SELECT query to find rooms which are avaailable in the selected dates (apply inner join on Room table and room_booking table)
All 2 Replies
We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.