Jump to content

[SOLVED] members online list


richiec

Recommended Posts

All i am trying to do right now is add a members online list at the bottom of the page.. I have that all working however if someone views the page and is not loged in it will still put them into the db.. heres the code..

 

$activeuser = $_SESSION["myusername"];
if ($activeuser = true) {
$lastactive = time();
$activeuser = $_SESSION["myusername"];
$query = "SELECT onlineid FROM online WHERE username = '$activeuser'";
$result=mysql_query($query) or die(mysql_error());
$num = mysql_num_rows($result);

if ($num == 0) {
        // Insert new visitor
        $query = "INSERT INTO online (username, lastactive) VALUES ('$activeuser', $lastactive)";
	$result=mysql_query($query) or die(mysql_error());
} else {
        // Update exisiting visitor
        $query = "UPDATE online SET lastactive = $lastactive WHERE username = '$activeuser'";
	$result=mysql_query($query) or die(mysql_error());
}
}
else {
echo ""; }

 

the if ($activeuser = true) part was just something i tried but still didnt work.. is there anyway to do it so that you have to be loged in for it to work and not put a blank username into the db?

Link to comment
https://forums.phpfreaks.com/topic/119720-solved-members-online-list/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.