MYSQL

Practical Date/Time examples with PHP and MySQL

In this article Mauricio shows us some examples of how to use the date/time features with MySQL and PHP including the UNIX timestamp and the PHP date_diff() function.

Author Info:

By: Mauricio Cuenca

Poor Best

Rating:

/ 35

January 12, 2003

TABLE OF CONTENTS:

· Practical Date/Time examples with PHP and MySQL
· The UNIX timestamp
· How old are you? (exactly)
· Dates with MySQL
· Date Addition and Subtraction
· Conclusion

Practical Date/Time examples with PHP and MySQL
(Page 1 of 6 )

Some time ago working with dates and times was a pain for me. In several of my projects I had to calculate a person's age based on their birth date. I created a members area that allowed the administrators to set the maximum amount of time users can have a password before they must change it and remind each one how many days left before the change. I also had to create time-bomb accounts that worked for several days after its creation and then became useless.

Digging into the PHP and MySQL documentation I found and then worked with several functions that made my life easier. Now I want to share some code tips that allow better manipulation of the time and date in your projects and everyday needs.

Next: The UNIX timestamp >>