Hi,
I run a high school website that uses a MySQL and PHP to display our sports calendar. I was wondering if it is possible to export the data from the MySQL database, so that visitors could sync to their Google calendars (our students all have Google accounts).

Example, a player/parent wants to upload the Varsity Volleyball schedule to their Google calendar. I'd like for them to be able to click a link to either directly upload the calendar, or download a file they can save and upload to Google.

  • fall_sports (table)
    Fields
  • event_date
  • event_time
  • sport
  • gender
  • level
  • location

Thanks in advance!

    If you specifically want to target Google Calendars, looks like Google has (once again) made it pretty simple; Google Calendar is able to understand certain CSV files and import the entries into the user's calendar.

    Otherwise, you'll have to figure out what format (e.g. iCal) you'll want to export the data as (and then figure out if there's an existing PHP class/application that can do this for you - there most likely is).

      Thank you so much! I was able to make a basic CSV file that I was successfully able to import to Google Calendar! Your link provided the needed Column names, and this link provided a structure for the PHP.

        Write a Reply...