Glyde Posted May 20, 2007 Share Posted May 20, 2007 I'm currently working on a calendar which can be found here: http://24.2.61.27/projects/calendar/ In essence, I'm aiming to make a web-based Outlook 2007 calendar. Seeing as I have just finished getting the months to display correctly, I'm off to my next task which would be the ability to create events. I find it quite easy to make ranged and standard events, but trying to create recurring events has proven to be a little more tedious. I was wondering what your thoughts were about how I could make this work. Should I use UNIX timestamps or a DATETIME field. I figured DATETIME would be advantageous since MySQL has great date and time management functions, but it has poor built-in support for timezones. But even beyond that, what would be the best way to go about recurring events. I have been sitting here trying to think about the best way to go about it, but nothing really comes to mind. Link to comment https://forums.phpfreaks.com/topic/52264-recurring-events/ Share on other sites More sharing options...
Glyde Posted May 20, 2007 Author Share Posted May 20, 2007 Just as a note, I have tried using both UNIX timestamps and a DATETIME field, each with it's own issue. UNIX timestamps proved a lack of support within MySQL, and DATETIME provides a lack in PHP. I had a recurring event that recurred every week and started a month ago, but the problem was that I had to waste tons of while loops of virtually no code until I got to the start of the current month. It was like a waste of resources. Anyways, I'm just trying to discover the best way of doing this without killing resources. Link to comment https://forums.phpfreaks.com/topic/52264-recurring-events/#findComment-257901 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.