Jump to content

Making a MySQL-based Calendar System


jlange

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
Link to comment
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.
Link to comment
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?
Link to comment
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
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.