retrive db data and display result on submit

Hewlett-packard / Cq61 notebook
August 22, 2013 at 05:32:11
Specs: Windows 7, AMD sempron 2 gb
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

See More: retrive db data and display result on submit

January 15, 2014 at 12:34:34
I use Tigra calendars, they are very powerful and give very details instructions on their use.

Once the form is submitted, you can look at the POST results and format it for your query as necessary.

It would be difficult to provide specific code for the POST page without more details about the database structure surrounding room availability; IE: are rooms presumed available unless booked in a "bookings" table, or is there a table containing dates and times that rooms are available, which then become flagged as booked, when a booking comes in, etc. lots of variables to consider.

I hope Tigra helps with the calendar portion!

Report •
Related Solutions

Ask Question