How many seconds from mysql time format to now

I use this function to set a time date("Y-m-d H:i:s", strtotime("+2 minutes"). Now开发者_JAVA百科 I want to compare that value with the current time to find the amount of seconds it's left.

For example compare: $next_action = 2011-01-16 18:03:00 and $now = 2011-01-16 18:01:23. To find the amount of seconds.

strtotime can convert mysql timestamps to unix timestamps. so you just convert both of them to UNIX timestamps and subtract one from other, and you'll get the difference in seconds.

$next_action = "2011-01-16 18:03:00";
$now = "2011-01-16 18:01:23";

echo strtotime($next_action)-strtotime($now);

Why did you convert them to "Y-m-d H:i:s" in the first place? Unix timestamps are much easier to work with.

$start_time = date("Y-m-d H:i:s", strtotime("+2 minutes"));
$time_diff = (time() - strtotime($start_time)); // difference in seconds

$seconds = $time_diff % 60;
$minutes = ($time_diff - $seconds) % (60 * 60);
$hours = ($time_diff - ($minutes * 60) - $seconds) / (24 * 60 * 60);

Untested, but it would probably go something like this.