Whats the easiest way to determine if a user is online? (PHP/MYSQL)

by

Don’t bother with figuring out the differences between timezones. That’s not necessary.

Whenever the user accesses a page, update a field in their record of the Users table last-updated-time. Then do a query for all users having a last-updated-time within the last 5 minutes. Anything more than this, and they are considered “offline.”

If you use your server-time, via the NOW() function in MySQL, you’ll side-step calculating differences between timezones.

This is the standard way of tracking how many users are presently online (Meaning, active within the last couple of minutes).

Constantly Updated

If you would like to know they are still active even when they’re not jumping from page to page, include a bit of javascript to ping your server every 60 seconds or so to let you know they are still alive. It’ll work the same way as my original suggestion, but it will update your records without requiring them to be frantically browsing your site at least once every five minutes.

var stillAlive = setInterval(function () {
    /* XHR back to server
       Example uses jQuery */
    $.get("stillAlive.php");
}, 60000);

More Related Contents:

  1. Is the following code valid? [closed]
  2. The holy grail of cleaning input and output in php?
  3. Can’t insert Chinese character into MySQL
  4. Javascript function post and call php script
  5. onbeforeprint() and onafterprint() equivalent for non IE browsers
  6. Call php function from JavaScript
  7. Fixing broken UTF-8 encoding
  8. Send array with Ajax to PHP script
  9. How to pass data from Javascript to PHP and vice versa? [duplicate]
  10. Export MySQL data to Excel in PHP
  11. MySQL – ignore insert error: duplicate entry
  12. “slash before every quote” problem [duplicate]
  13. Call to a member function execute() on boolean in [duplicate]
  14. SQLSTATE[HY000] [1045] Access denied for user ‘username’@’localhost’ using CakePHP
  15. How to store the data in unicode in hindi language
  16. Force Browser to download Image with Javascript window.open?
  17. Developing a tracking pixel
  18. PDO + MySQL and broken UTF-8 encoding
  19. Find Point in polygon PHP
  20. phpmyadmin automatic logout time
  21. unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING error [duplicate]
  22. Setting a connect timeout with PDO
  23. Is there a JavaScript way to do file_get_contents()?
  24. mysql_connect(): No connection could be made because the target machine actively refused it
  25. Join two tables with comma separated values
  26. json parse error with double quotes
  27. Remotely connecting to a MySQL database
  28. How to check if a value already exists to avoid duplicates?
  29. How to use MySQL Found_Rows() in PHP?
  30. How to detect the screen DPI using JavaScript

Leave a Comment