Alter Time

Use DateTime Stamp Appropriately in PHP/MySQLi

Submitted by Yorkiebar on
Introduction: This tutorial is on how to use timestamps properly in PHP and MySQLi to sort information from databases in to the correct order. What's a Timestamp? A timestamp is a data type in PHP and MySQL(i) which is used to hold the correct format of a specified date, time, or date and time together. Database: To enable a database table to hold a timestamp we can first create a database, named 'fln', then create a table named 'test', and give it the following column structure... id, int, 5 length, primary key, auto increment date, dateti