Online users

[dean7]

Hi all, I have a user online script witch my friend helped me with but it only counts the ammount of users online.

 

<?
session_start();
$session=session_id();
$time=time();
$time_check=$time-600; //SET TIME 10 Minute

$host="***************"; // Host name
$username="**********"; // Mysql username
$password="********"; // Mysql password
$db_name="*********"; // Database name
$tbl_name="online_users"; // Table name

// Connect to server and select databse
mysql_connect("$host", "$username", "$password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name WHERE session='$session'";
$result=mysql_query($sql);

$count=mysql_num_rows($result);

if($count=="0"){
$sql1="INSERT INTO $tbl_name(session, time)VALUES('$session', '$time')";
$result1=mysql_query($sql1);
}
else {
"$sql2=UPDATE $tbl_name SET time='$time' WHERE session = '$session'";
$result2=mysql_query($sql2);
}

$sql3="SELECT * FROM $tbl_name";
$result3=mysql_query($sql3);

$count_user_online=mysql_num_rows($result3);

echo "User online : $count_user_online "; 

// if over 10 minute, delete session 
$sql4="DELETE FROM $tbl_name WHERE time<$time_check";
$result4=mysql_query($sql4);

mysql_close();

?>

But how would i make it so it would show the users that are online and count them at the same time?

 

Thanks for your help.

[MadTechie]

kinda need to know whats in the 'online_users' table,

if you have usernames then a simple loop would work

ie

$sql3="SELECT * FROM $tbl_name";
$result3=mysql_query($sql3);
//start add 
$users = array();
while($rows = mysql_fetch_array($result3))
{
$users[] = $rows['user'];
}
var_dump($users); //output
//end add
$count_user_online=mysql_num_rows($result3);

[dean7]

In the user online table it has session and time. thats it.

[MadTechie]

Your need to add UserName or UserID, then insert the UserName on logon

[dean7]

Do you know a way i could do that?

[MasterACE14]

INSERT or UPDATE a record in the table filling in the users, username and ID upon logon.

Just throw in 1 extra query in your login script.

[MadTechie]

Your need to add the fields to the table first

 

Find the code that inserts into the online_users table and post that here