How can i add a count users online feature??

MobiTec

Hi, im wanting to add a count users online feature to my site but
im not sure how to bo it...

This is what i have so far but it doesnt seem to work...

Can someone help me please??? (PS, if you dont notice, this is a WAP site not WE😎

Usercount.php

<?PHP
	function countUserOnline(&$CountUser)
{
	include("config.php");
	$sqlCount="select user from login where user like '%<b>Welcome ".$var["user"]."</b>%'";
	$result=mysql_query($sqlCount) or die(mysql_error());
	$CountUser=mysql_num_rows($result);
}
?>

Enter.php

<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN" "http://www.wapforum.org/DTD/wml_1.1.xml">
<wml>
<card id="card1" title="login" newcontext="true">
<p align="center">
<?
    require("config.php");
	include("usercount.php");
    mysql_connect($server,$user,$pass);
    mysql_select_db($dbname);
    $sql = mysql_query("SELECT * FROM login WHERE pass='$password' AND user='$username' ")
or die(mysql_error());

if (mysql_numrows($sql)) {
$var = mysql_fetch_array($sql);
    if ($var["pass"] == $password && $var["user"] == $username) {
        echo "Welcome ".$var["user"]." ";
		echo "<br/><a title=\"Enter\" href=\"../wapindex.wml\">Enter Here</a><br/>\n";
		countUserOnline(&$CountUser);
		echo "Members Online:".$CountUser."<br/>";

} else {
    echo "Incorrect Login<br/>Please Login Correctly<br/><a title=\"Login\" href=\"login.php\">Here</a><br/>\n";
}
} else {
	echo "You are not in our database<br/>Please Register<br/><a title=\"Register\" href=\"apply.php\">Here</a><br/>\n";
}
    ?>
</p>
</card>
</wml>

steadyguy

This is what I'd do: add 2 columns to the db: last_access and logged_out (or something like that), both of which hold timestamps.

Everytime a user accesses a page, their username/password is checked, so each time I check the password, I'd add the current timestamp to last_access. And if a user explicitly logs out, then I'd add the current timestamp to logged_out.

To get your list of users who are online, create a query to generate a list of online users based on a) whether the the logged out timestamp is newer than last password check, and b) if the last password check was within that last 20 minutes (or whatever you think is a reasonable time to assume the user is no longer at the page) .
Something like:

SELECT username FROM users
WHERE last_access > logged_out
AND last_access > (UNIX_TIMESTAMP() - 1200)

(20 min. = 1200 sec.)

Like I said, this is what I'd do ... I'm sure there are other solutions.

MobiTec

OK, im still new to this.. But i get what you mean and understand you..
the thing is i dont no how to actually do this..

could you describe what to do to (Step by Step), for me to achieve this. 🙂
(please say where abouts to put thing too)

Thanx 🙂

steadyguy

Step #1: Add the columns to the appropriate table with ALTER TABLE commands. Add two columns last_access and logged_out, both of type TIMESTAMP (you can call them whatever you want, really, as long as you know what they are and mean.) Do this with phpMyAdmin, or whatever program you use to interact with the database.

Step #2: Add UPDATE query to login script which INSERTs the current timestamp into the last_access column once a user has validated. This goes with the stuff you do after the username password check. Don't forget to use a WHERE clause to indicate which user's data to update. Otherwise, it will affect all the users.

Step #3: Add UPDATE query to lougout script which INSERTs the current timestamp into the logged_out column when a user logs out explicitly. Again, be sure to add the WHERE clause, or you'll log everybody out.

Step #4: Use the SELECT query I posted earlier (or something like it) to find out who has accessed the database recently, and print out that list in whatever manner, and wherever you choose. If you are so inclined, you could use an ORDER BY clause to list them alphabetically.

MobiTec

Right ive added the 2 new lines (last access, Logged out) to my db, but now you've lost me.. lol (sorry)

i'm not quite sure what to do here -------->

Step #2: Add UPDATE query to login script which INSERTs the current timestamp into the last_access column once a user has validated. This goes with the stuff you do after the username password check. Don't forget to use a WHERE clause to indicate which user's data to update. Otherwise, it will affect all the users.

Step #3: Add UPDATE query to lougout script which INSERTs the current timestamp into the logged_out column when a user logs out explicitly. Again, be sure to add the WHERE clause, or you'll log everybody out.

Would it be possable for you to show me the code 🙂 Please
and say where to put it please (eg usercount.php or enter.php)

Thank you, your help will be much appreaciated 🙂

steadyguy

Alright ... just give me a few, eh? I just had a daughter yesterday morning, so I'm a bit preoccupied, not to mention tired.

MobiTec

Ok mate... keep ya hair on, i'm not in no massive rush...

just sort out ya things, and get back to me when you can... please

thanks 🙂