谁在线会话统计

Question

I have a MySQL table called "sessions", that contains a session_id, user_id, ip_address, and last_updated field.

I have the following questions:

1. What's the best way of updating the "sessions" table if the user has not visited the site before, or if the user navigates to a different page?

2. If a users navigates to a page that requires them to be logged in, what's the best way of remembering the page that they were viewing, prior to them being redirected to the login page, so that they can be returned to it after logging in?

3. How do I calculate the total number of members/guests currently online, and the total members/guests for the day, even if users of the same computer use different web browsers?

4. I want to display how many users/guests are viewing a certain page. What's the best way of keeping track on what page the user is currently on.

Any help is greatly appreciated. I've been scratching my head about the above for some time!!! ;)

Answer 1

1. any way that suit you. Personlly I prefer SQL query
2. Show login form in place, with no redirects
3. • a trivial SQL query with count(*)
   • noway with session stats table
   • doesn't matter. 2 browsers means 2 clients
4. Another field in your sessions table.