Re: [PHP] hotel reservation system.

On Wednesday 27 September 2006 15:16, Faisal Sahar wrote:
hi to everyone,

i want to create a hotel reservation system. how can i keep track of
dates . suppose i have booked a room from 12/10/2006 till 14/10/2006 ( two
night ) how can i make a system that will check for room availability and
if it will find a room available from specified date till specified date
it will report me back.

i wish to find a suitable and technical answer ..

faisal
very tough and long question...

If I wrote that kind of system..
1-) I want to know rooms
2-) I want to knwo room occupation dates...

System have to mark roop occupation day basis...

for example...
room_occupation_table

roomId, occupationDate, customerId

room_table
roomId,roomName,roomType

get occupied rooms

select roomId
from room_occupation_table
where occupationDate >11/10/2006
and occupationDate < 15/10/2006


get rooms

selec roomId,roomName
from room_table

extract occupied rooms from rooms then show the unoccupied rooms at that time.
Then mark yoru newly occupied rooms...

Regards

Sancar.
.