mysql当前时间加10分钟,从mysql datetime向日期添加10分钟并将其与现在的时间进行比较...

I can't figure out how to add 10 minutes to a time I am getting from mysql database the field structure is datetime.

Current code

$nowtime = date('Y-m-d h:i:s');

$timeoflastlogin = $db->gettime();

//ADD 10 MINS TO TIME LAST ATTEMPTED

$endtime = strtotime('+ 10 minutes', $timeoflastlogin );

//$endtime = date('Y-m-d h:i:s', strtotime('+ 10 minutes', $timeoflastlogin );

This displays "

2011-09-07 13:53:43 < time of last login

2011-09-07 03:56:15 < now time

2611< endtime - this is supposed to be time of last +10 mins "

I cannot work out how to add 10 mins to the time/date from mysql, I need to do this and then set a command to compare the time now and of last login so if it has been 10 minutes I can stop the user trying to login again!

Thanks for your help

解决方案

$timeoflastlogin is not a Unix timestamp but a string - so you can't use that as a $now parameter for strtotime. This should work:

$endtime = strtotime('+ 10 minutes', strtotime( $timeoflastlogin ) );

or easier:

$endtime = strtotime( $timeoflastlogin ) + 600; // 10 minutes == 600 seconds