Avatar of sabecs
sabecs
 asked on

Check if users are currently online using PHP,JavaScript or MYSQL.

Hi,
I have a users table that gets updated with a users session id when they login to my website.

I then check the users table to see which users are currently online.

Is there a way to delete the session id from the users table if the users has been inactive after say 20 mins or if they have forgotton to logoff or have simply shut down their browser or PC?

Can this be done with PHP or JavaScript, should I add a timestamp for the last time the user did something and perhaps run a CRON job to delete users that have not done anything in the last 20 mins?

Thanks in advance for your feedback.
PHPJavaScript

Avatar of undefined
Last Comment
sapparod

8/22/2022 - Mon
Dave Baldwin

Are you talking about the 'session_id' in PHP sessions or a variable you're creating?  Like her: http://us3.php.net/manual/en/function.session-id.php ??
sabecs

ASKER
Hi Dave, I am talking about 'session_id' in PHP sessions .
ASKER CERTIFIED SOLUTION
Lukasz Chmielewski

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
sapparod

I think you have to config php.ini. This will remove inactive session from system.

session.gc_maxlifetime = 60
session.gc_probability = 100
Your help has saved me hundreds of hours of internet surfing.
fblack61