Tracking Log In and Log Out Times of Users

From: iholder (iholder_at_discussions.microsoft.com)
Date: 02/14/05 

Date: Mon, 14 Feb 2005 14:55:03 -0800

I need to tracking log in and log out time of users.

My approach is to set up Public variable that store the [UserId],
[LogDate],[LogInTime] at the time of intial log in.

Add store the [LogOutTime] info at logoff time

How can I append this info to another table call "tblLogInTracking".

Do I use reecordsets and how?
Also will setup Public variables for user info conflict is a multiuser
application.

Relevant Pages

  • Re: Display a public variable value in a text box....
    ... for a single post. ... "Nikos Yannacopoulos" wrote: ... >>>Public variables can only be referenced in code. ... Therefore it is safer to use controls on forms to store ...
    (microsoft.public.access.formscoding)
  • RE: Public variable named from field content
    ... store the variable name and value in a collection, ... calculations in the project and they represent default conditions. ... to assign values from the default table to public variables that could ... Looping through the recordset and using a SELECT CASE ...
    (microsoft.public.access.formscoding)
  • Re: Display a public variable value in a text box....
    ... UserName, and UserLevel, so I know what the user is allowed to do. ... Public variables can only be referenced in code. ... Therefore it is safer to use controls on forms to store ... display the public variable in a text box on the main menu, ...
    (microsoft.public.access.formscoding)
  • Re: Display a public variable value in a text box....
    ... I support your position on Public variables. ... Therefore it is safer to use controls on forms to store ... >> display the public variable in a text box on the main menu, ...
    (microsoft.public.access.formscoding)
  • Re: simple login script issue
    ... IMHO it's not good to store passwords in a session, the session can be readable for the wrong persons on the web server and those someone can get the passwords. ... $result=mysql_query("select userid from users ... login did work, then the password was right and you get the userid value, store that into the session instead of the password and next time you need to fetch something that has to do with the current user, you use the $_SESSIONin your sql query. ...
    (alt.php)
Loading