用MySQL或PHP计算以分钟为单位的时差量？

Question

I save users sing-in information using the fields below:

user_id, login_date, login_time, status

After each attempting for sign-in, a record will insert into database using true or false status. I want to lock user if he/she has 3 failed logins in the last 3 minutes. So I need to use the current time and calculate its difference with 3 last records of table in minute format.

My questions are:
1- Which one is better to do this time calculation? PHP or MySQL?
2- Depends on your suggestion, which function is better for it?

Thank you.

Answer 1

Following query returns all User_Id's according your conditions:

select user_id from t 
where login_date= CURDATE() 
      and login_time>TIMESTAMPADD(MINUTE,-3,CURTIME())
      and status = 'f'
group by user_id 
having count(*)>3