PHP time elapsed with MySQL DateTime

Question

I am writing a login system in PHP and would like a to implement a function that checks if the 15 minutes has elapsed since the last failed login attempt.

In the MySQL database in my users table there is a column called last_login_datetime which is defined as SQL's DATETIME format, ex. 2018-02-24 21:12:57.

This is the code I am using to check if 15 minutes has elapsed since the last login fail

$dateTime = date("Y-m-d H:i:s");

if($row['user_locked']==$statusY AND $dateTime - strtotime($row['last_loginfail_datetime'] > 15 * 60))
{
.....
}

This does not seem to work for me at the moment and was hoping if someone could point out where I am going wrong?

Thanks in advance.

Explain to us the exact error you are getting, or the output you are getting. — Abiud Orina
– Abiud Orina, Commented Feb 24, 2018 at 20:30
Not getting any errors, it is just that it always returns as true — James
– James, Commented Feb 24, 2018 at 20:32

man0v · Accepted Answer · 2018-02-24 20:31:54Z

4

It doesn't work because you are substracting unix time from a string date. What you need to do is to get $dateTime as unix time.

$dateTime = strtotime("now");

answered Feb 24, 2018 at 20:31

man0v

6743 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Istiaque Ahmed · Accepted Answer · 2018-02-24 20:37:00Z

1

Just use strtotime($dateTime) instead of $dateTime in the if condition. strtotime returns a UNIX tiemstamp i.e: the number of seconds since January 1 1970 00:00:00 GMT $dateTime = date("Y-m-d H:i:s");

if($row['user_locked']==$statusY AND strtotime($dateTime) - strtotime($row['last_loginfail_datetime'] > 15 * 60))
{
.....
}

answered Feb 24, 2018 at 20:37

Istiaque Ahmed

6,53626 gold badges83 silver badges145 bronze badges

Comments

Abiud Orina · Accepted Answer · 2018-02-24 20:33:18Z

0

Your code won't work because your date will be read as a string. Try this instead:

$dateTime = strtotime("now");

if($row['user_locked']==$statusY AND $dateTime - strtotime($row['last_loginfail_datetime'] > 15 * 60))
{
.....
}

answered Feb 24, 2018 at 20:33

Abiud Orina

1,2429 silver badges19 bronze badges

Collectives™ on Stack Overflow

PHP time elapsed with MySQL DateTime

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related