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.
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
Last Comment
sapparod
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 ??
ASKER
Hi Dave, I am talking about 'session_id' in PHP sessions .
ASKER CERTIFIED SOLUTION
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.
I think you have to config php.ini. This will remove inactive session from system.
session.gc_maxlifetime = 60
session.gc_probability = 100
session.gc_maxlifetime = 60
session.gc_probability = 100