Link to home
Start Free TrialLog in
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.
Avatar of Dave Baldwin
Dave Baldwin
Flag of United States of America image

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 ??
Avatar of sabecs
sabecs

ASKER

Hi Dave, I am talking about 'session_id' in PHP sessions .
ASKER CERTIFIED SOLUTION
Avatar of Lukasz Chmielewski
Lukasz Chmielewski
Flag of Poland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I think you have to config php.ini. This will remove inactive session from system.

session.gc_maxlifetime = 60
session.gc_probability = 100