What alternative approach can be used to prevent the bug of displaying users as online when they are not active?

The issue of displaying users as online when they are not active can be solved by implementing a last activity timestamp for each user. This timestamp can be updated whenever a user performs an action on the website. By checking the time difference between the current time and the last activity timestamp, we can accurately determine if a user is currently active or not. 

// Update last activity timestamp for the current user
function update_last_activity($user_id) {
    $current_time = time();
    // Update last_activity field in the database for the user
    // Assuming $db is the database connection
    $query = "UPDATE users SET last_activity = $current_time WHERE id = $user_id";
    mysqli_query($db, $query);
}

// Check if a user is currently active
function is_user_active($user_id, $timeout = 300) { // Timeout in seconds (5 minutes)
    $current_time = time();
    // Retrieve last_activity timestamp from the database for the user
    // Assuming $db is the database connection
    $query = "SELECT last_activity FROM users WHERE id = $user_id";
    $result = mysqli_query($db, $query);
    $row = mysqli_fetch_assoc($result);
    
    if ($current_time - $row['last_activity'] <= $timeout) {
        return true;
    } else {
        return false;
    }
}

Keywords

Session management timestamp last activity idle timeout user status.

Related Questions