calendar

[monasa]

HI,

In my database I have a file which containt the reservation date of each room, (from .. to ..).

For Each room I want to build a calendar of the current a month, which show for each day if the room is available or not.

Thanks in advance.

M.N

 

[ericbrunson]

Try google. "php calendar" turns up quite a few nice implimentation.

 

[Olavxxx]

Why not make a script which works like a guestbook?

First table, is for orders:
You have the visitor name, phone number, email adress, adress, unique user_id, and a field for room_number You also have one field "from_dt" and one "to_dt" (from and to-date which it is reserved). Maybe a discount field is also to be implemented?

Then you have another table for rooms, which has unique_id, room-number, room-key-number, room-notes, etc.

You might also then have a third order:
room_enqueries

the room_enqueris could handle things like: if they order pizza, if something is wrong in the room, is something missing? Do they want a wakeup-call? etc.

You then make it clean and simple, with natural joins.
You select where the date is correct.

Olav Alexander Mjelde

http://www.volvo-power.net

Admin & Webmaster