users online

[ki]

ok, I already got the users online script, but I want to show the users that are online like, "ki, user, die", like that I got the usernames too

[trq]

When users login you would need to store there usernames along with a timestamp in a table in the database, for each page hit you would need to update the timestamp.

You then need another script that would clear out older entries.

[ki]

yea i got that script, but i need it to display the users like on a regular forum like

Users online:
ki, user, user2

[trq]

I understood your question, read my answer.

[JP128]

when I got helped, It only showed that some users were online... but then I modified it so it showed each one...


here is the script
make sure your users table has a column named online...

ALTER TABLE `tablename` ADD online TIMESTAMP;


Have this in another page called showusers.php

[code]
<?php
session_start();
//Connect to the database
if (isset($_SESSION['username'])) { // checking to see if there is a user logged in
// user logged in so update current time in 'online' column of 'user' table
$query = "UPDATE users SET online = now() WHERE username = \"".$_SESSION['username']."\"";
$result = mysql_query($query);
}
$query = "SELECT username,online FROM users WHERE now() - online<=500";
$result = mysql_query($query);
echo "Users online: ";
while ($row = mysql_fetch_assoc($result)){
if($row['diff'] < 500) {
// user has been online within the last 5 minutes
echo $row['username'] . " ";
}
}
?>
[/code]

After you modify the script to work the way you need... put this on pages that you want to show who is online:

include "showusers.php";

if you have any questions, just reply or send me a PM

[ki]

thats kinda what im looking for, but with commas but it doesnt end with one like
ki, user, user2,

but i want it like how it shows the users viewing the current page like, Users Viewing Forum: ki, user, user2

[trq]

Were not here to write if for you. A few people have explained how it is done, now go and make it.

[JasonLewis]

thats what this forum is for, help... not people making scripts. people here give you a push in the right direction, its up to you to follow that direction...

[JP128]

Here... If you make another column called current_page... make it a varchar(50)...

then on all of the pages include a script that updates the current_page to $_SERVER['PHP_SELF']... after it 'SETS' that value, then select all of the users that have the current_page to = $_SERVER['PHP_SELF']... and if it equals echo their username...

if that isnt hint enough, I dont know what is.