php help!!

[Mohd]

how to show the number of the people who is viewing a page

for example ngmu home page

Like in psxfanatics http://www.psxfanatics.com

[Mohd]

No Answer Please I need this help . .

[Nezzar]

Nobody? OK, then I'll do it.
First you'll need something that stores the guys that are online. Preferrably a Database.
The structure of the DB-Table should go like the following
sessionid (primary key) -> char(32)
lastactivity (i use unix-timestamps for this) ->int(10)
Now, when the user comes to a new page you check if he's already in the table:

if(!mysql_query("SELECT lastactivity FROM sessions WHERE sessionid = '".session_id()."'") {
mysql_query("INSERT INTO sessions VALUES('".session_id()."','".time()."')");
} else {
mysql_query("UPDATE sessions SET lastactivity = '".time()."' WHERE sessionid = '".session_id()."'");
};


Somewhere at the end of the page you have to do a garbage collection to remove all the old sessions:

mysql_query("DELETE FROM sessions WHERE lastactivity > ".time() - 1800);//time() + 1800 = now - half an hour


To check the how many users are online u need this query:

$res = mysql_query("SELECT count(*) AS count FROM sessions");
list($count) = mysql_fetch_array($res);
echo "There are $count users online";

[Mohd]

Thanks Nezzar you finally back to here . . .

[Nezzar]

I just found a bug (it's emberrassing to make errors in only 5 lines of code :p):
The Second Query must look like this:

mysql_query("DELETE FROM sessions WHERE lastactivity > ".(time() - 1800));//<- notice the extra brackets around time() - 1800

[Mohd]

Thanks again done it now