#HOW TO USE ICAL WITH PHP INSTALL#

Next step is to write the tail part of the ICS file and write whole stuff into a flat text file ( schedule.ics):

Next, loop through the results and write all the event details in ICS format, one at a time: First part is to connect to the database. Now that the events are stored in a database, the following PHP script will extract them and write them in ICS format, so that iCal can subscribe to it. ) ENGINE=MyISAM DEFAULT CHARSET utf8 COLLATE utf8_unicode_ci AUTO_INCREMENT=1 ДЄ few events, for example, would look like: `EndTime` time NOT NULL default '00:00:00',

`StartTime` time NOT NULL default '00:00:00', `Schedule` ( `ID` INT ( 11 ) NOT NULL AUTO_INCREMENT, `StartDate` DATE NOT NULL DEFAULT '', `StartTime` TIME NOT NULL DEFAULT '00:00:00', `EndDate` DATE NOT NULL DEFAULT '', `EndTime` TIME NOT NULL DEFAULT '00:00:00', `Category` VARCHAR ( 255 ) DEFAULT NULL, `Name` VARCHAR ( 254 ) NOT NULL DEFAULT '', `Location` VARCHAR ( 254 ) DEFAULT NULL, `Description` text DEFAULT NULL, UNIQUE KEY `ID` ( `ID` ) ) ENGINE =MyISAM DEFAULT CHARSET utf8 COLLATE utf8_unicode_ci AUTO_INCREMENT = 1 Storing Events In MySQL DatabaseДЄssuming that we would be working with a database called Library, the structure of the MySQL table to store the event details is as follows:Д¬REATE TABLE `Library`.

#HOW TO USE ICAL WITH PHP INSTALL#

I bet there are tons of documents online that you can refer and install them if you donвЂ™t already have them. It is my practice that I do a full/maximal installation of any linux distribution and that takes care of installing Apache (with all the required modules), PHP, MySQL, etc. The procedure follows, as usual, in detail: Apache, PHP, MySQL I have been working it for a while and I think I finally have got it to work.

But I also use Apple Macintosh computers (PowerBook G4 and MacBook Pro) quite extensively for a variety of purposes and would love to keep my powerful little iPhone synchronized as well. Please note that if you decide to use these instructions on your machine, you are doing so entirely at your very own discretion and that neither this site,, nor its author is responsible for any/all damage вЂ“ intellectual or otherwise.ДЇor whatever reason, I keep track of my schedule via a PHP-MySQL based web utility. It may very well work for you on Red Hat-like or other and Macintosh distributions. These instructions/steps worked for me in CentOS and MacBook Pro.

How to use ical with php