Ok so im looking to create a simple booking system as part of my Final Year Project. I have a locally hosted mySQL database created and linked to using php. I have created a databse called reservations with 3 tablels (Available, reserves and confirms). Basically what I am looking to achieve is that a user can reserve a room from a list of say 6, and confirm the reservation with payment (just for asthetics, will not be functional) but if they dont confirm within a set amount of time the reservation is cancelled and that room is once again available to any other user looking to make a booking. Any help would be appreciated.
FWIW, the php.net web site has very extensive reference documentation, and some decent examples of usage of the language. In my efforts at Nokia, I found it invaluable. Decent search capabilities included.
maybe the schema could take a tweak:
rooms (id | descriptions etc)
reservations (id | room_id | date_from | date_to | reservation_datetime | confirmed etc)
payments (id | reservation_id | pay_date | pay_amount | pay_method etc)
Dunno, up to you.