Normally for this, I'd simply download an open-source PHP calendar and look at how they did it, but they all seem to want me to pay for them...
Database design - recurring events
Moderator: General Moderators
Database design - recurring events
I'm giving my event calendar application a pretty major overhaul. I want to allow for recurring events, but I'm not sure how to go about this in my database design. How would you guys go about it? Any ideas would be great.
Normally for this, I'd simply download an open-source PHP calendar and look at how they did it, but they all seem to want me to pay for them...
Normally for this, I'd simply download an open-source PHP calendar and look at how they did it, but they all seem to want me to pay for them...
- Kieran Huggins
- DevNet Master
- Posts: 3635
- Joined: Wed Dec 06, 2006 4:14 pm
- Location: Toronto, Canada
- Contact:
the iCal standard has recurring events built in - and it would probably be the most convenient method to implement for compatibility reasons.
You can download Mozilla Sunbird and create various recurring events to test what it does in iCal format, but I'm sure there's a spec on the net somewhere as well.
You can download Mozilla Sunbird and create various recurring events to test what it does in iCal format, but I'm sure there's a spec on the net somewhere as well.
- Kieran Huggins
- DevNet Master
- Posts: 3635
- Joined: Wed Dec 06, 2006 4:14 pm
- Location: Toronto, Canada
- Contact:
- Kieran Huggins
- DevNet Master
- Posts: 3635
- Joined: Wed Dec 06, 2006 4:14 pm
- Location: Toronto, Canada
- Contact:
Maybe http://microformats.org/wiki/hcalendar will help? Just aiming to include the info in iCal in your scheme would make it iCal compliant.