Online Members

[Ads]

I am trying to make an .php page that shows the members that are currently online, But i really have no idea how to make this, Well i had a few ideas But they all suck . So if anyone can help me

[pocobueno1388]

1) Make a datetime field in your users table called something along the lines of "last_active"

 

2) On your header page (so it is called on every click) put an update query that will put the current date/time in the last_active field (this can be done using NOW()).

 

3) Your query to pull the users who have been active within the last 5 minutes will look something like this:

SELECT username FROM users WHERE last_active > (NOW() - INTERVAL 5 MINUTE)

[Northern Flame]

heres a function that someone previously created that works fine

 

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

[pocobueno1388]

heres a function that someone previously created that works fine

 

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

 

This code will count every user that is online, including "guests". I'm assuming from the OP using the word "member" they are wanting logged in users only.

[Ads]

I would like it to Display The Number of Users online, and also there Usernames and such.

[pocobueno1388]

Okay, so you are wanting ONLY logged in members. Give the method I supplied above a shot, post if you have any problems implementing it.

[Ads]

Okay, so you are wanting ONLY logged in members. Give the method I supplied above a shot, post if you have any problems implementing it.

 

How do you use the NOW() Function, i have never used it before :S

[pocobueno1388]

How do you use the NOW() Function, i have never used it before :S

 

UPDATE users SET last_active=NOW() WHERE userID='$id'