2
Contributors
1
Reply
6
Views
2 Years
Discussion Span
Last Post by diafol
0

A number of us have created such apps in the past. Can't find mine at the mo, but here's a sample:

http://stevethomas.com.au/php/how-to-build-an-ical-calendar-with-php-and-mysql.html

but it's very basic without repeat events, etc.

A mysql table for the calendar "object"
A table for "events (fields = properties) possibly with related tables e.g. timezones, status etc
And a link table

You need to read up on the various icalendar "markup" elements to get the fields you may want to include.

e.g. events (FK could be ENUM instead, but better if got releated tables)

ID | CREATED_AT | UPDATED_AT | DTSTART | DTEND | SUMMARY | CLASS | TRANSP | UID | TZID (FK) | RRULE_FREQ (FK) | RRULE_COUNT (FK) | RRULE_UNTIL | ...

You could get away with having a 'combined' field for items such as RRULE, but then your DB table may not be as "searchable". Swings and roundabouts maybe.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.