News Feed
Jobs 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

DevShed: Paginating Blog Entries with Code Igniter

Christian Schaefer's Blog: Using PHP Web Scraper Goutte in a Console Task in a Silex project

James Cohen's Blog: Working with Date and Time in PHP

DevShed: Moving Presentation Logic Out of Views with CodeIgniter

Maggie Nelson's Blog: NTILE() - easy way to generate tag clouds


Community Events











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


framework code application security hhvm threedevsandamaybe series symfony2 facebook install opinion release component unittest hack language composer package introduction podcast

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