Schedule

[ensnare]

Currently, I have a database that stores a course schedule. For
example:

Course Title, Start Time (datetime), End Time (datetime), Mon (T/F),
Tues (T/F), Wed (T/F) Thurs (T/F), Fri (T/F)

I want to take this data and graph it as a visual calendar using
tables.

For example:

Time Monday Tuesday Wednes ...
10:00AM WS1093
10:30AM WS1093
11:00AM WS1093
11:30AM
12:00PM EH2312
12:30PM EH2312
1:00PM EH2312

Something like that. What's the best way to do this? Clearly, I
could make a an html calendar and load it up with a bunch of if
statements but is there a more elegant way to fill in the calendar?

Are there any classes available to easily do this?

Code examples are very much welcomed!

Thanks!

[Michael Austin]

Re: Schedule

ensnare wrote:
[color=blue]
> Currently, I have a database that stores a course schedule. For
> example:
>
> Course Title, Start Time (datetime), End Time (datetime), Mon (T/F),
> Tues (T/F), Wed (T/F) Thurs (T/F), Fri (T/F)
>
> I want to take this data and graph it as a visual calendar using
> tables.
>
> For example:
>
> Time Monday Tuesday Wednes ...
> 10:00AM WS1093
> 10:30AM WS1093
> 11:00AM WS1093
> 11:30AM
> 12:00PM EH2312
> 12:30PM EH2312
> 1:00PM EH2312
>
> Something like that. What's the best way to do this? Clearly, I
> could make a an html calendar and load it up with a bunch of if
> statements but is there a more elegant way to fill in the calendar?
>
> Are there any classes available to easily do this?
>
> Code examples are very much welcomed!
>
> Thanks![/color]


hmmmmm.. sounds like a school homework project to me... if not, my
apologies.. There are numerous examples of calendaring in PHP, you need
only to look... Or a novel approach would be to figure it out by
reading the docs like the rest of us...

Coding the forms/tables is a no-brainer, getting the data out of the db
in a manner you can use will be a bit more challenging.

Michael Austin.

[ensnare]

Re: Schedule

> hmmmmm.. sounds like a school homework project to me... if not, my[color=blue]
> apologies.. There are numerous examples of calendaring in PHP, you need
> only to look... Or a novel approach would be to figure it out by
> reading the docs like the rest of us...
>[/color]

Yes, for school but not a homework project. I'm trying to create a
utility for students to automagically display their schedules.
[color=blue]
> Coding the forms/tables is a no-brainer, getting the data out of the db
> in a manner you can use will be a bit more challenging.[/color]

Yes, what is the best strategy to go about this in the most efficient
manner. Retriving from the DB isn't so bad it's displaying the data
that is complicated.

Thanks in advance.

[Manuel Lemos]

Re: Schedule

Hello,

On 07/08/2004 08:52 PM, ensnare wrote:[color=blue]
> Currently, I have a database that stores a course schedule. For
> example:
>
> Course Title, Start Time (datetime), End Time (datetime), Mon (T/F),
> Tues (T/F), Wed (T/F) Thurs (T/F), Fri (T/F)
>
> I want to take this data and graph it as a visual calendar using
> tables.[/color]

Try this class that does exactly what you ask:

Class: Schedule

http://www.phpclasses.org/schedule

--

Regards,
Manuel Lemos

PHP Classes - Free ready to use OOP components written in PHP

http://www.phpclasses.org/

PHP Reviews - Reviews of PHP books and other products

http://www.phpclasses.org/reviews/

Metastorage - Data object relational mapping layer generator

http://www.meta-language.net/metastorage.html