Availability checking for hotel site

[Anon]

Hi guys,

I have been asked by the crowd where I am doing my work experience to look into a php script for checking the availability of rooms for a hotel. I have been instructed to use MS Access.

Basically they want the visitor to select his /her dates, type of room (Deluxe, Executive, Presidential etc)from a form and on submission a new screen is returned stating that those dates are available or they have already been booked.

As I am a beginner at this I am up to my neck and drowning in the deepend!! I only have about a week before I produce some results! Can anyone help?

Cheers,
Jamie

[Anon]

sorry this isnt helpful but sounds like an assignment i did at uni 2 years ago! Further programming in java! Hope all goes well! sorry but i'm pretty new to php as well! if i were u I would use a database such as MySQL or PostgreSQL not MS access. Get a book called php and mysql web development by Luke wilson and laura welling isbn no is 0672317842. this should put u in the right direction i hope.

[Anon]

This may give you somwhere to start

create a database

create tables:
rooms - room#,type ...
bookings - id,room#,startdate,enddate

=====Pseudo sql code======

select room# from bookings b, rooms r where
r.type = $type_requested
and b.startdate < $startdate_requested
and b.enddate < $enddate_requested
and b.room# = r.room#

=====End Pseudo SQL=========

Good Luck