News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

PHPit.net:
Handling dates and times in PHP & MySQL
April 10, 2006 @ 07:40:02

Handling date and time information in PHP can sometimes get a little tricky. Toss MySQL into the mix and any beginning programmer out there might get a bit lost. Well, that's why there's tutorials, and if this is your situation, PHPit.net has posted just what you need.

Whenever you create a PHP script, there's a big chance it'll involve handling dates and times, when for example you need to create a content management system or an event tracker. Handling dates and times in your scripts doesn't sound so hard, after all, it's just a few numbers to track, but in reality this is actually much harder than you think. In fact, using dates and times can be one of the most challenging tasks to do, especially if you want to do it properly.

That's why in this article I'm going to take you through the necessary steps to properly handle dates and times. First we'll have a look at the problem, and after that we'll go through the steps necessary to solve it.

They walk you through a sample of using a GMT timestamp, how to store the timestamps in the MySQL database, and a wrap-up that includes a class with the date/time handling code they've built up in the course of the article.

0 comments voice your opinion now!
date time mysql handling tutorial date time mysql handling tutorial


blog comments powered by Disqus

Similar Posts

Zend: Roll Your Own Search Engine with Zend_Search_Lucene

IBM developerWorks: Ajax and XML: Ajax for chat

Bill Staples' Blog: IIS7 in the Community

DevShed: Building a Search Engine with MySQL and PHP 5

Ulrich Kautz: PHP Validation & Sanitization


Community Events





Don't see your event here?
Let us know!


voicesoftheelephpant install symfony opinion series introduction podcast community version configure unittest language extension api list conference laravel interview release composer

All content copyright, 2015 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework