[FONT=courier new]Working with PHP and Mysql.
Im playing around with creating an Events/Reservation Calendar, and I can get the "month" view down, but I can't find anything to show how to do "view by week" or "view by day". I've looked over several tutorial sites and even at PHP.net and Mysql.com for any information regarding how to create a calendar system and be able to select different views for it.
Can anyone provide links or faqs/tutorials/hints on how to construct a page so that it pulls information from a database containing events or reserve information ( title, desc, begin time, end time, etc) and be able to view the events/reservations by week and then by (or for) that day?
Im looking for answers on how to display:
For Week View:
Days of that week across the top
and HOURs of the day on the left side
Ie
Monday (m/day) | Tuesday (m/day)| Wed (m/day) | Thurs (m/day) | Fri (m/day)
9
9:30
10
10:30
For Day view:
(Weekday/m/day)
9
9:30
10
10:30
And for each if an event happens between a certain time, it will display it (highlighted or colored etc) between those hours
Ie
Meeting for Team 1 on XX/XX between 9 am - 12 pm for both Day and Week view
XX/XX
9 Team 1 Meeting
9:30 |
10 |
10:30 |
11 |
11:30 |
12 |
If someoen can understand what Im looking for, Im just in search of any online tutorials/hints that can show exactly how these can be achieved. ]
Thanks for your time
Dani[/FONT]