Users Online

Kudose

Could some one please explain to me how to display the number users online in a table. I think I have a rough idea on how to do it, I am just..well..lost on how to do it 🙂

Basically I am asking how to add the IP into the DB, and when they leave it deletes thier ip from the DB. And it would count the number of IPs in the DB and convert that to a number. Any ideas? THANKS!

PyroX

Recipe for MySQL based user online status indicator.

Step 1, go to google search for "php get ip address of user"

Step 2, read it until you understand it.

Step 3, go to google, search for "php and mysql tutorial"

Step 4, read it until you understand it.

Step 5, go to google, search for "php date and time example"

Step 6, read it until you understand it.

Step 7, combine all of the knowledge gained to: insert ip's and a timestamp if they are not already in the table.

Step 8, combine all of the knowledge gained to: locate and delete ip addresses older than 15 - 30 minutes.

Step 9, add some code to update the ip if it already exists so that the count does not change if they were viewing pages 5 minutes ago, but initially visited the site 17 minutes ago.

Work through steps 1 - 9 in order, let cool before serving.

Kudose

Try this one for a descent, but lacking flavor recipe.

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10230689

PyroX

Mmm tasty, but not as good.

What is in your table after you hit refresh many times?

Kudose

TIMESTAMP fails to update, but keeps the one from when I first ran this script, and IP lacks to post. As if the $_SERVER['REMOTE_ADDR']; does diddly squat.

PyroX

Have you just tried to echo the ip out to make sure that you can read that value?

Kudose

Yes, it reads the IP properly when I echo it. It just doesnt post to the DB right. It updates the TIMESTAMP properly, but then leave the IP column blank. It is set as VARCHAR(15).

PyroX

Try changing it to Char(25).

Be sure you double check the $ip that is being inserted.

( it looks fine in the example you have posted )