Simplest way to add timestamp with PHP MYSQL

Posted under » PHP » MySQL on 10 October 2012

Without writing any code. All you have to do is alter your MySQL table structure.

• type : timestamp
• Attributes : on update CURRENT_TIMESTAMP ; works just like auto increment

So whenever you do an insert or an update, the timestamp is updated automatically without a single PHP code.