php中的当前时间戳生成和mysql中的更新

Question

i want to create a timestamp by which i can know which post is modified when and all. in mysql databse, i made a coloumn called lastmodified, with type as timestamp. now, when i am updating the data in db, i want to update the current timestamp in last modified. how to do so? also could anyone please tell me, if any function exits for comparing these timestamps.

$now = time();

$query = "update storydb set lastmodified = '$now' where story_id = '$story_id'";
mysqli_query($con, $query);

Answer 1

time() returns UNIX Timetamp in integer format e.g. 1223485636.

You want it in 2014-12-10 02:02:36

Use MySQL now() function instead of $now

$query = "update storydb set lastmodified = now() where story_id = '$story_id'";

now() is a MySQL function that returns current Time Stamp (including date).