PHP

php mysql insert date time

<?php $mysqltime = date('Y-m-d H:i:s'); // this will provide you current data ?>

php mysql insert timestamp now

$update_query = "UPDATE db.tablename SET insert_time=now() WHERE username='" .$somename . "'";