setting an expiry time

chrislive

basically I have a datetime field in a DB using

date('Y-m-d H:i:s');

basically i need:

$time = $timefromdb;
$expiretime = date('Y-m-d H:i:s'); (- 2 minutes)

what i want to do is check if a user is still active with a time of 2 minutes. So if the user hasnt updated the DB in the last 2 minutes it will remove them from the list.

so i need to conpare

if($time < $expiretime)

but not sure how to get that $expiretime value as I need it.

I looked in manual for time() and mktime() but could not really understand it 😐 just cant get my head around it

thanks in advance

Shrike

I think you would need to say

if TimeFromDB + ExpiryTime < CurrentTime
  UserHasTimedOut()
endif

I'll leave you to write the PHP code 🙂

chrislive

it is getting the times to a format i can compare them that im having problems...

mrhappiness

use [man]strtotime[/man]

or use mysql and check this in your SELECT: http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html

chrislive

hey thanks for that. i hadnt even thought to use the SQL.

I have gone for this:
SELECT ADDTIME('$time_from_db', '0 0:2:0');

Thanks

chrislive

actually i went with this in the end....

$check_time = strtotime("-2 minutes"); $check_time_old = strtotime("$time_from_db");

if($check_time_old > $check_time){
do my stuff }