如何计算用户在PHP中连续登录的次数

Question

I am just getting back into PHP after about 7 years away so am very rusty.

I am wanting to add a feature to my site whereby it tracks the users logins daily and then prints their logins visually on the website. I want it to record consecutive logins and when the user misses a day, return the value to zero.

Any help would be much appreciated!

Cheers!

Answer 1

You should add a consecutiveDayCounter and a lastDayConnected row in your user table.

In your SELECT query to check if the user and password matches, you should also SELECT these row. Verify if lastDayConnected == than yesterday timestamp.

Then, do an UPDATE query with today timestamp for the lastDayConnected , and if the check for lastDayConnected == yesterday timestamp, add +1 to consecutiveDayCounter. If not, update it to 0.

EDIT :

As asked, here's some example code to get today - yesterday stamp :

<?php
// Today
$today = new DateTime();                 // Create new date object (today date)
echo $today->format('Y-m-d');            // Format the date 'YYYY-MM-DD'


// Yesterday 
$yesterday = new DateTime();               // Create new date object (today date)
$yesterday->sub(new DateInterval('P1D'));  // Substract 1 day to it
echo $yesterday->format('Y-m-d');          //Format the date 'YYYY-MM-DD'
?>