How php know when users has logout?

carnt

Hi ,

I have a PHP script that store into a Mysql database informations about users accounts and when users are online .
Well i note that when a users click on logout button , my php successfull erase the data in the loggedin database , then when he's back to login in system the program know that he is now online then leave he's in if the login/pass is corret .

But when the user are online and just (close) the browser , he has not beed erased from my loggedin database .
Then when he back and try login the system still think that he is online and don't accept his login/pass .

My question is :

How can i put my php to inform MYSQL to erase that data in loggedin when the users is not more online and just close the browser without leave correctly ??

???????????

Thanks .

Carlos .

mkarabulut

You should specify a time limit for each login. If the user doesn't call any page in that limit his info will be automatically deleted from database, and he will be logged out by destroying the session data.
Inspect the classic 'how many visitors are online' scripts -without login- to do this.
Good luck

scoppc

Probably, instead of storing it inside MySQL database, you can try using session.
(I haven't started to use session yet).

Currently, I'm using cookie. Even though the same problem can happen (also) but you can set the cookie expiry time to probably 3 or 4 hours assuming no body will login into the system for that duration.
if let say it has expired and the user is still using the system, he/she has to login again. Not flexible enough, though.

Well, I guess session could help.

vijay17877

Hi,
You can do this with a simple coding. You call a javascript function in the body onblur event of the page. In the javascript call a php file like logout.php in which u destroy the session value and make the user erased from your logged in database.

Hope this helps in getting the solution.

vijay

Carlos Arnt wrote:

Hi ,

My question is :

How can i put my php to inform MYSQL to erase that data in loggedin when the users is not more online and just close the browser without leave correctly ??

???????????

Thanks .

Carlos .

carnt

Yeak Ok .

But how the system will logoff a user without know him ??

Like, if i put the javascript to call one logout.php , to kill the user from my mysql , how could my system know who erase ?

I mean and if others users are been erased too .

Thanks for helping =)

[deleted]

You can't use javascript to log people out, becuase javascript is not reliable.

The only way to do it is by updating a 'last-action' date in the database everytime a loggedin user requests a page, and having some cron-job check that every X minutes. if the last action was more than X minutes ago, the user has timed out and you can log him out.

A forum, a FAQ, email notification, what else do you need?