annoying php thing...

[phpSensei]

I looked through every single little page and forum files, and i still don't know how to show how many guests are viewing your site.

 

how does it damn thing work..

 

I keep thinking its all about registered an ip.

 

Please, help.

[Caesar]

Use MYSQL. Create a sessions table and update it every time the page is viewed.

[phpSensei]

Edit: what do you mean sessions table?

[akitchin]

update people's last action time in a table, and pull everyone whose last action was, for example, less than 5 minutes ago.  consider a page view an "action."

 

if you want to save on some resources, set a minimum time interval between table updates, otherwise you'll be running an UPDATE on every single page visit for every single user.

[phpSensei]

Can you show me an example of the interval...

[phpSensei]

K i understand now...

 

I insert the ip's registered in a session table, then 5 minutes later, I re-run the script to see how many sessions are left. Then I update the table again.

 

Or you can just post the example if your kind enough.

 

 

[akitchin]

i'm going to link you to four threads that cover exactly this topic:

 

http://www.phpfreaks.com/forums/index.php/topic,101955.0.html

 

http://www.phpfreaks.com/forums/index.php/topic,148226.0.html

 

http://www.phpfreaks.com/forums/index.php/topic,95397.0.html

 

http://www.phpfreaks.com/forums/index.php/topic,100488.0.html

 

i'm not going to post an example, simply because there's plenty of code and discussion in these threads (more than enough to get you on your way).

[phpSensei]

thankyou, for your help.

[phpSensei]

I understood everthing and I even added some of my own stuff...

 

One thing I don't understand. How would you attempt to do this with an ip adress. I you register the ip then update the mysql database, then you count the number of ip registered within the last 5 minutes, then 5 minutes later, how do you delete all the previous record at once?

[akitchin]

i'm not sure why you'd feel the need to delete them after 5 minutes, but:

 

DELETE FROM some_table WHERE timestamp < DATE_SUB(NOW(), INTERVAL 5 MINUTE)

[phpSensei]

See what I want to do, is register all the ip's that are viewing my site, then set the UNIX TIME thing, then count the number of registered ip's that keep coming in within 5 minutes, then if 5 minutes is passed, the time is reseted and the previous ip's are deleted.