PHP / MySQL for Recursive Calendar Appointments

Discussion in 'PHP' started by koolsamule, Jul 19, 2012.

  1. #1
    Hi Chaps,

    Apologies if this topic should be in MySQL...I wasn't sure.

    I'm trying to create a MS Outlook-style Appointment application with Recurrence for a PHP calendar.

    I've got all the same options that Outlook gives, e.g.:

    Daily - every DAY, or every WEEKDAY
    Weekly every X WEEK(S) on X DAYS
    Monthly - on DAY of every X month or Nth DAY of every X MONTH(s)
    Yearly - recur every X YEAR(S) on DAY of MONTH or Nth DAY of every X MONTH(s)

    My question is what is the best way to store the recursive appointment information in MySQL Database (Columns, etc), so I can then use a PHP algorithm to calculate whether an appointment is within a calendar view, or if reminders need to be sent.

    Any advice will be a great help.
     
    koolsamule, Jul 19, 2012 IP