PHP | 有时间的数组

Question

I need to compare bentween a time taken from a database to the current time.

$DBtime = "2013-10-29 17:38:55";

this is the format of the arrays in the database.

How can I compare it with the current time?

Im not sure how, but maybe converting DBtime to Unixtime then:

(CurrentUnixTime - dbUnixTime) = x

Or maybe, we can take the 17:38 and compare it somehow with date("G:i");

Thank you! I hope you understand what I mean.

Answer 1

You can transform it into a UNIX timestamp using strtotime and then subtract the current timestamp by it.

$DBtime = "2013-10-29 17:38:55";
$db_timestamp = strtotime($DBtime);
$now = time();
$difference = $now - $db_timestamp;
echo $difference;

This will give you the difference in seconds.