Jump to content

Archived

This topic is now archived and is closed to further replies.

jlange

Making a MySQL-based Calendar System

Recommended Posts

Here's the rundown: I'm making a checkout system for my school for signing out iBook carts and computer labs, etc.

I'm trying to figure out how to implement the calendar into a MySQL table. I need to have
A) A daily calendar for each thing (eg, Cart A Cart B Cart C Lab A)
B) Nine spots for information on the object, one for each period of the day.

I've been racking my brain on how to do this, and I've come up blank. It just seems to me that the database structure doesn't go deep enough for the levels of information I'm trying to display.

I'm using PHP and MySQL on Apache, generic installation on Mac OS X. Any help would be appreciated

Share this post


Link to post
Share on other sites
Well, any calendering application needs to have time slots, and then a way to assign items to these blocks.  I'm not sure what you mean by "deep" enough.

Share this post


Link to post
Share on other sites
I'm relatively new to MySQL and the whole database-style of thinking..but I need a database that would contain the calendar, then a table for each day, then a cell for each hour, and another thing inside of that for each object (iBook cart, LCD Projector, etc) that is changeable from php on whether it is already signed out or not.

Share this post


Link to post
Share on other sites
Try not to think of the DB design in terms of the output, but rather in terms of the smallest pieces of information that you need to store.  That is, while you might have a cell for each hour, you won't have a record for each hour, because a) nothing may be scheduled and b) it may span 2.5 hours.  Does that make sense?

Share this post


Link to post
Share on other sites
Actually, it only has to be 9 class periods out of the day, this is a school environment.
I'm currently using a folder heirarchy using PHP includes and stuff. It works fine, but I would like to migrate to MySQL at one point or another.

Thanks for all the input, fenway

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.