Total login time

[abdfahim]

How can I know that when a user is logged in? Like I want to store each login and logout time of each user in a database.

[Aureole]

Create a timestamp when they log in and another when they log out. When they log out subtract the first timestamp from the second, giving you the amount of seconds they were logged in for then update the database with that. You could then use date() (I think) it may be time(), to change the timestamp into something more readable.

 

I'm not sure if it's date() or time() or maybe even something else, working with dates and times in PHP is something I've not entirely grasped myself yet, someone else could probably help you more...

[cmgmyr]

What I usually do is have a "last_login" (date_time) in my users table. When the user logs in I just update this with NOW(). If you want to calculate how long your users have been logged into your site check this out:

http://www.bytemycode.com/snippets/snippet/736/

I wrote that for a few of my sites and it works well.

 

Hope that helps!

-Chris

[abdfahim]

Well .. when user login or log out manually, then its very easy to collect time. But my problem is, if any one cross the browser window instead of clicking on logout button, then what happens? How can I catch the timestamp of that moment?

[phpQuestioner]

create a session that creates your timestamp and if the user closes the window, the session will be destroyed and then create a timestamp once the session is destroyed.

[abdfahim]

can you plz tell me how can I create a timestamp when session is destroyed due to closing of window?

[phpQuestioner]

create an ajax script that will be queried on unload

[abdfahim]

thanx man ... I am now searching on Ajax script. I didnt hear it before !!! thanx again.

[abdfahim]

I can't make it .... plz give me some sample code or helpful link.. I want to detect when (the time) an user leave my website either by closing window or typing another address in address bar.

[nuxy]

AjaxFreaks.com has allot of helpfull tutorials on ajax.

And Aureole  gave you a good example, aswell as cmgmyr.