users online question

[janim]

hi guys

how can i know the online logged in users ??

let's say when login update table set log = '1'

and when logout update it to '0'

so how can i know if he closed the browser or not ?

couse the people don't click logout they just close the browser

 

thank for any suggestion

[Northern Flame]

they show you how on this post

 

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

[pocobueno1388]

You need to make a datetime field in your users table called something like "last_active". Then on your header page (so the code is called every time they click) you need to put a query that updates that field to the current date/time (you can use the function NOW() to do that).

 

Now to get the current users that have been active in the last 5 minutes, your query would look like this.

 

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