[RESOLVED] [PHP] time since < 4 hours

[snapbackz]

Trying to check if a user was logged in less 4 hours prior to current time based of a mysql DATETIME column. Can anyone suggest a better way? I'm having a hard time wrapping my head around all the date functions.

	function isOnline($lasLogin){
		$curTime = date("Ymdhi", strtotime(date("Y-m-d h:i:s")));
		$lasLogin = date("Ymdhi", strtotime($lasLogin));
		$diff = $curTime - $lasLogin;
		if($diff < 9220){
			return true;
		}	else {
			return false;
		}
	} 

Thanks 🙂

[Weedpacket]

I don't know where the 9220 comes from, but there are 14400 seconds in four hours.

function isOnline($lasLogin)
{
    return time() - strtotime($lasLogin) < 14400;
}

Of course, you could probably do this in the database.

[bretticus]

I agree with weedpacket. You can just return the MySQL records you need via a query. Check out the "last 30 days" example on the manual. You could easily alter that for 4 hours.

[snapbackz]

Thanks guys!! It was more of a function just to know if the user im pulling has logged in within x amount of time.. so I don't want to restrict mysql based off time. Thanks again! Really helped

[Weedpacket]

snapbackz wrote:

if the user im pulling has logged in within x amount of time..

You can do it and return the result with the other information you're selecting about the user; you can use functions and formulas on the left of a Select's WHERE clause, too (the bit where in the example bretticus linked to it says something).