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. Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/52264-recurring-events/#findComment-257901 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.