{"id":2695,"date":"2016-06-21T12:00:40","date_gmt":"2016-06-21T11:00:40","guid":{"rendered":"https:\/\/www.bronco.co.uk\/our-ideas\/?p=2695"},"modified":"2020-07-02T11:44:09","modified_gmt":"2020-07-02T10:44:09","slug":"integrating-ical","status":"publish","type":"post","link":"https:\/\/www.bronco.co.uk\/our-ideas\/integrating-ical\/","title":{"rendered":"Integrating iCal in PHP"},"content":{"rendered":"\n

iCal is a file format which allows the sharing of generic calendar information. A lot of sites such as HomeAway and AirBnB generate iCal files so you can synchronise bookings across platforms on which your properties may be advertised.<\/p>\n\n\n\n

If one of these platforms is your own website, you may need to read the external files (from HomeAway etc) and enter the information into your database to keep it up to date. Reading and\/or writing these files is actually pretty straightforward – you just need to know the correct format.<\/p>\n\n\n\n

First of all, let’s take a look at what a basic iCal file looks like:<\/p>\n\n\n\n

BEGIN:VCALENDAR\nVERSION:2.0\nPRODID:-\/\/UniqueID, Inc.\/\/EN\nBEGIN:VEVENT\nUID:3093bdc35333dafc24a4e9ffad352f6f\nDTSTAMP:20160615T110419Z\nDTSTART:20170811\nDTEND:20170818\nSUMMARY:Booking for John Smith\nEND:VEVENT\nBEGIN:VEVENT\nUID:6c5e65585905ee04d06df38aa2245319\nDTSTAMP:20160615T110419Z\nDTSTART:20170804\nDTEND:20170811\nSUMMARY:Booking for Joe Bloggs\nEND:VEVENT\nEND:VCALENDAR<\/code><\/pre><\/div>\n\n\n\n
(A handy guide to the specification of each attribute is here http:\/\/www.kanzaki.com\/docs\/ical\/<\/a>)<\/p>\n\n\n\n
Writing<\/h2>\n\n\n\n
To create this, simply loop through the data you wish to include (i.e. each of the bookings for your property) and build a string to iCal specification. Don’t forget to set the correct headers before you echo out the string; these tell the program reading your file that it is in iCal format.<\/p>\n\n\n\n
$ical = "BEGIN:VCALENDAR\nVERSION:2.0\nPRODID:-\/\/[YOUR WEBSITE], Inc.\/\/EN";\n\n$query = mysqli_query("SELECT * FROM booking_dates");\nwhile($row = mysqli_fetch_object($query)){\n    $ical .= "\nBEGIN:VEVENT\nUID:" .md5(uniqid(mt_rand(), true))\nDTSTAMP:".gmdate("Ymd")."T".gmdate("His")."Z\nDTSTART:".date("Ymd", strtotime($row->start_date))."\nDTEND:".date("Ymd", strtotime($row->end_date))."\nSUMMARY:Booking for $row->name\nEND:VEVENT";\n}\n\n$ical .= "\nEND:VCALENDAR";\n\nheader("Content-type: text\/calendar; charset=utf-8");\nheader("Content-Disposition: inline; filename=calendar.ics");\necho $ical;<\/code><\/pre><\/div>\n\n\n\n
Reading<\/h2>\n\n\n\n
A very useful function I found (thanks Steffen Behn http:\/\/stackoverflow.com\/a\/13844260<\/a>) simplifies this immensely.<\/p>\n\n\n\n
function icsToArray($paramUrl){\n    $icsFile = file_get_contents($paramUrl);\n\n    $icsData = explode("BEGIN:", $icsFile);\n\n    foreach($icsData as $key => $value){\n        $icsDatesMeta[$key] = explode("\\n", $value);\n    }\n\n    foreach($icsDatesMeta as $key => $value){\n        foreach($value as $subKey => $subValue){\n            if($subValue != ""){\n                if($key != 0 && $subKey == 0){\n                    $icsDates[$key]["BEGIN"] = trim($subValue);\n                }else{\n                    $subValueArr = explode(":", $subValue, 2);\n                    $icsDates[$key][$subValueArr[0]] = trim($subValueArr[1]);\n                }\n            }\n        }\n    }\n\n    return $icsDates;\n}<\/code><\/pre><\/div>\n\n\n\n
Use the above function as such:<\/p>\n\n\n\n
$icspath = "http:\/\/path-to-file.ics";\n$ics = icsToArray($icspath);\nforeach($ics as $a){\n    if($a['BEGIN'] == "VEVENT"){\n        $start_date = date("Y-m-d", strtotime($a['DTSTART']));\n        $end_date = date("Y-m-d", strtotime($a['DTEND']));\n        $summary = $a['SUMMARY'];\n    }\n}<\/code><\/pre><\/div>\n\n\n\n
Then you can do with the data as you wish. In the above example I’ve converted the dates to standard “Y-m-d” format and assigned the various data to variables. You would then most likely input this into your database in order to keep your calendar up to date with the source of the ics file.<\/p>\n\n\n\n
And that’s it!<\/p>\n\n\n\n
This code is free to use at your own discretion. It comes without warranty. Please feel free to feedback any edits.<\/p>\n","protected":false},"excerpt":{"rendered":"
iCal is a file format which allows the sharing of generic calendar information. A lot of sites such as HomeAway and AirBnB generate iCal files so you can synchronise bookings across platforms on which your properties may be advertised. If one of these platforms is your own website, you may need to read the external […]<\/p>\n","protected":false},"author":12,"featured_media":2705,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2],"class_list":["post-2695","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-web-and-ux"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.bronco.co.uk\/our-ideas\/wp-json\/wp\/v2\/posts\/2695","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bronco.co.uk\/our-ideas\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bronco.co.uk\/our-ideas\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bronco.co.uk\/our-ideas\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bronco.co.uk\/our-ideas\/wp-json\/wp\/v2\/comments?post=2695"}],"version-history":[{"count":0,"href":"https:\/\/www.bronco.co.uk\/our-ideas\/wp-json\/wp\/v2\/posts\/2695\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bronco.co.uk\/our-ideas\/wp-json\/wp\/v2\/media\/2705"}],"wp:attachment":[{"href":"https:\/\/www.bronco.co.uk\/our-ideas\/wp-json\/wp\/v2\/media?parent=2695"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bronco.co.uk\/our-ideas\/wp-json\/wp\/v2\/categories?post=2695"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}