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
Fiorentino01^
0
Newbie Poster
Recommended Answers
Jump to PostI 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
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.