Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.
Solved
Check if users are currently online using PHP,JavaScript or MYSQL.
Posted on 2011-03-06
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.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4 Comments
Active today
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 ??
http://www.phpeasystep.com/phptu/9.html
Maybe this will help
Maybe this will help
Featured Post
![[Webinar] Lessons on Recovering from Petya](https://filedb.experts-exchange.com/files/public/2017/7/11/dcb3272a-62a8-4274-a34e-d1771610ec3b.png)
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
JavaScript can be used in a browser to change parts of a webpage dynamically. It begins with the following pattern: If condition W is true, do thing X to target Y after event Z. Below are some tips and tricks to help you get started with JavaScript …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The viewer will learn how to count occurrences of each item in an array.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Suggested Courses
Course of the Month9 days, 14 hours left to enroll
722 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.