Jump to content

check time from logged in to now


deepson2

Recommended Posts

Hello,

 

I want to check user's log in time with he/she logged in to Now(). it seems not working for me. here is my code

 

$result            = $op->runsql("SELECT TIMESTAMPDIFF(MINUTE, a.last_access, NOW()) AS MinsSinceLastLogin FROM ".tbl_author." a WHERE a.id = '$blogdata->author'");

if(mysql_num_rows($result)>0){

while($row = $op->select($result)){

$minutes_dif = $row1['MinsSinceLastLogin'];

$last= NOW() - $minute_dif;

if($last <600){ // considering here 10 min, but not sure about it
echo "online";
}else{
echo "offline";
}

}}

 

and the second question is how many minutes equals to 20 minutes? brcause when i tried this query in to sql. have got this

MinsSinceLastLogin

717

 

thanks in advance.

Link to comment
https://forums.phpfreaks.com/topic/159255-check-time-from-logged-in-to-now/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.