How can PHP be used to display the online/offline status of a user?

To display the online/offline status of a user in PHP, you can use a combination of server-side and client-side techniques. One common approach is to update a user's status in the database when they log in or log out, and then query this status to display it on the user's profile page. 

// Assuming you have a users table with a column for online status (1 for online, 0 for offline)
// Update the user's status when they log in
$user_id = 123; // User's ID
$query = "UPDATE users SET online_status = 1 WHERE id = $user_id";
mysqli_query($connection, $query);

// Update the user's status when they log out
$query = "UPDATE users SET online_status = 0 WHERE id = $user_id";
mysqli_query($connection, $query);

// Display the user's online/offline status on their profile page
$query = "SELECT online_status FROM users WHERE id = $user_id";
$result = mysqli_query($connection, $query);
$row = mysqli_fetch_assoc($result);
$online_status = $row['online_status'];

if($online_status == 1){
    echo "User is online";
} else {
    echo "User is offline";
}

Keywords

PHP online status user display status indicator

Related Questions