By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,278 Members | 1,357 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,278 IT Pros & Developers. It's quick & easy.

Schedule

P: n/a
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!
Jul 17 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
ensnare wrote:
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!

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.
Jul 17 '05 #2

P: n/a
> 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...

Yes, for school but not a homework project. I'm trying to create a
utility for students to automagically display their schedules.
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.


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.
Jul 17 '05 #3

P: n/a
Hello,

On 07/08/2004 08:52 PM, ensnare wrote:
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.


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
Jul 17 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.