Calendar solution

Submitted by mokenke (315 points) on Tue, 2007-05-08 07:01

Member's Forum

I need advice about a current challenge I have.

I work with a huge mall in Claremont, ca that has around 25 lofts. 10 art galleries, 3 restaurants and a few other businesses. I have been asked to provide a solution so every owner of every shop can post current events directly into a calendar, so they don't have to go through me for that to keep that part of the website fresh.

First thing I could think of was Adobe Contribute, but I am sure some sort of open source solution will be better. Something simple that can be handled intuitively via web browser.

thanks!

mokenke

database?

Submitted by harrison (172 points) on Tue, 2007-05-08 08:13.

what about a simple database solution?

set up a database with the following fields:

event_id
event_date_day
event_date_month
event_date_year
event_store
event_description

write a simple web script in php or whatever with drop down boxes and such, and let them add the event.

then you just need to write another script that pulls that info from the database and displays it sorted by date [or by store etc]. That's just a matter of organising the information, and should be pretty straight forward to find a tutorial for online.

you can also add a username/password system into it, which would allow you to control who is able to add information.

andrew harrison
http://andrew.harrison.org