Converting TIMESTAMP to unix time in PHP?
Getting a unixtimestamp:
$unixTimestamp = time();Converting to mysql datetime format:
$mysqlTimestamp = date("Y-m-d H:i:s", $unixTimestamp);Getting some mysql timestamp:
$mysqlTimestamp = '2013-01-10 12:13:37';Converting it to a unixtimestamp:
$unixTimestamp = strtotime('2010-05-17 19:13:37');...comparing it with one or a range of times, to see if the user entered a realistic time:
if($unixTimestamp > strtotime("1999-12-15") && $unixTimestamp < strtotime("2025-12-15")){...}Unix timestamps are safer too. You can do the following to check if a url passed variable is valid, before checking (for example) the previous range check:
if(ctype_digit($_GET["UpdateTimestamp"])){...}