how to maintain a time of login for individual user?

[jayanagi]

hai all,

   I have one question, We can maintain login time and logout time in php.

I have done it using the get date and time while the user is loging in AND get the time when the user logout THEN take the difference between them and stored it in database,

IF the user doesn't logged out properly (ex, without logout just close the browser) . In this situation how to calculate the time difference between login and logout??????

thanks in advance....

[laserlight]

You cannot be sure of when the user has "logged out" in that sense, so you cannot calculate the time difference other than from a manual log out.

[kbc1]

It's a bit of an overkill solution but you could update a third field for the user every minute or so which records the current server time, so if the logged_out field has no value (i.e. the user closed the browser) you can then just find the difference between the logged_in field and the new field which records the current time.

I guess it depends on how critical this functionality is to your system - is it worth running an update query every minute for every user?? :o/