who is online?

[gandalf65]

I want to add a "who is online" feature to my site.
It it possible to write a delayed entry into a MysQl database? So if a user logges on my page his name is shown for 10 minutes or so.
Or is there any other way to manage this?
thanks, dk

[Anon]

It took me quite sometime to figure this one out. This will display who is currently on-line. I'm using this in my personals program I'm currently writing.

$timeoutseconds=300; // Timeout value in seconds
$timestamp=time();
$timeout=$timestamp-$timeoutseconds;
mysql_connect($server, $db_user, $db_pass) or die ("Useronline Database CONNECT Error");
mysql_db_query($db_name, "INSERT INTO useronline VALUES ('$timestamp','$REMOTE_ADDR','$PHP_SELF','$username','$id')") or die("Useronline Database INSERT Error");
mysql_db_query($db_name, "DELETE FROM useronline WHERE timestamp<$timeout") or die("Useronline Database DELETE Error");
$result=mysql_db_query($db_name, "SELECT id, username FROM useronline WHERE file='$PHP_SELF'") or die("Useronline Database SELECT Error");

THIS DISPLAYS WHO IS ON-LINE
$on_string =" ";

while ($geton_now = mysql_fetch_array($result))

{

$online_id = $geton_now['id'];

$contact_username2 = $geton_now['username'];

$on_string .="<a href=\"show_contact.php?id=$id\">$contact_username2</a>   ";

}

The show_contact.php is what I use in my personals program to show their contact information. Just call $on_string and it will display who they are.

The user_online database has the following:

timestamp int(15) allow null NO Primary
ip varchar(40) allow null NO Indexed
file varchar(100) allow null NO Indexed
username text allow null NO
id text allow null NO

Hope this helps.

Michael

[gandalf65]

Thank you very much for this! It works now..
but I had the problem that when you reload the site the username is shown twice.

You can avoid this by adding:

mysql_db_query("dgk15", "DELETE FROM user_online WHERE username='$username'");

BEFORE the insert tag... this deletes all duplicate entries before adding a new one for this user.