How to check if the user has not login for a particular number of days

[piano0011]

How would you check to see if the user has not login for more than 2 weeks? I have a table collumn called session and stored the date when the user registered but can’t figure out how to check it in a query to see if they have not login for a particular number of days

[anon19508339]

is the date column type timestamp or anything related to time?( like it’s not integer or string like xxxx,xx,xx)

if it is. then you can use this. although i don’t know your codes
let me find more

$now = time(); // or your date as well
$your_date = $row['user_login_date'];/*strtotime("2010-01-31")*/
$datediff = $now - $your_date;

[piano0011]

ah… so you do have to subtract the different in time

[anon19508339]

like subtract user login date from another date (instead of current date)?

confused

[piano0011]

then how would I use $datediff? would i use it in my squery?

[piano0011]

how would you convert hours to seconds? I know that to convert mins to seconds = 15mins X 60 but to convert hours? how would you convert 4 hours into seconds? 46060? sounds too much

[anon19508339]

maybe?:

hours_to_seconds(date("h"));
function hours_to_seconds($hour){
$convert= $hour * 60 * 60;
return $convert;
}

[Ergastolator1]

My function works best:

function hoursToSeconds($hour = date("H")) {
$convertedValue = $hour * (60 * 60);
return $convertedValue;
}

[anon19508339]

so how it’ll work for function inputs? i get this error :

Fatal error: Constant expression contains invalid operations in /wwwoKXR48 on line 7

[Ergastolator1]

I will correct the code straight away:

function hoursToSeconds($hour = date("H")){
$convertedValue = $hour * 3600; // did 60 * 60 before
return $convertedValue;
}

[anon19508339]

@Ergastolator1

function hoursToSeconds($hour = date(“H”)){ $convertedValue = $hour * 3600; // did 60 * 60 before return $convertedValue; }

not again :c
i got same error too

line seven is where function declares not convertion

[Ergastolator1]

Then:

function hoursToSeconds ($hour) {
$convertedValue = $hour * 3600;
return $convertedValue;
}

We should then define $hour as a integer (e.g. 4) and use that function.

[Admin]

Maybe DateInterval would help? Or better yet, use Carbon, which is an even easier way to do date and time things in PHP.