www.webdeveloper.com
Results 1 to 3 of 3

Thread: Statistics

  1. #1
    Join Date
    Apr 2007
    Posts
    395

    Statistics

    What is the best way to determine:

    1. Number of Users Logged in at any point in time
    Im using forms authentication can that be used in any way to count the logged in Users,

    2. Number of Visits to any Page in the Site. So that it does not count the same User twice "or not".

    Would be nice to have the most accurate data as possible.

    Anything Considered not sure where to start?

  2. #2
    Join Date
    Aug 2007
    Posts
    85
    dear you can make a field in user table "Login" and when user logged in to you site then update "Login" with 1 and when logged out then update with 0 and use this query to count

    $query=Select COUNT(users) form userstable WHERE Login=1
    if any problem then ask me

  3. #3
    Join Date
    Apr 2007
    Posts
    395
    yeah thought about it, but it wouldn't it be the same as creating a single record in a table and updating it when someone logs in and logs out.

    The User table would also need to be updated for automatic Logouts, I'm guessing the query would take longer to count the records than a single select statement?

    User
    Name Logged In
    Steve T
    John T
    Bob F
    Grant T

    Or Just

    UsersOnline
    3

    Why do it the long way round? (I'm using Cookies for Forms Authentication)

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles