FUDforum: comp.lang.php » User login status?

Home » Imported messages » comp.lang.php » User login status?

Show: Today's Messages :: Polls :: Message Navigator

Re: User login status? [message #174529 is a reply to message #174493]

Wed, 15 June 2011 18:33

Luuk
Messages: 329
Registered: September 2010

Karma:

Senior Member

On 15-06-2011 00:57, Jerry Stuckle wrote:
> On 6/14/2011 4:22 PM, Co wrote:
>> Hi All,
>>
>> I have this code that will change one field of the users record when
>> he logs in:
>>
>> mysql_query("UPDATE myMembers SET last_log_date=now(), logged='1'
>> WHERE id='$id' LIMIT 1");
>>
>> This way we can display all the users who are logged in on the main
>> page.
>> When the user logs of the record will be changed again:
>>
>> mysql_query("UPDATE myMembers SET logged='0' WHERE id='$id' LIMIT 1");
>>
>> However what if the user just forgets to log off, then he is gone but
>> his status is still logged=1.
>> Is there a way to make sure the user status is changed even when he
>> forgets to log off?
>>
>> Marco
>
> The web is stateless - there is no such concept as "logged in" or not.
> And there is no way to know if the user is still reading your page, has
> gone to coffee (or lunch), closed the browser or even shut off the
> computer. So there is no way to determine how many people are logged in
> or not - and sites which claim to do that are pretty much guessing.
>
> The best you can do is create your own custom session handler which
> stores the data in a database instead of the file system. Then you can
> assume as long as the session is active, the user is logged in. When
> the session expires, the user is logged out. Still not real accurate,
> but the best you can do.
>
> Just a warning - custom session handlers can be complex and pretty much
> beyond what you can do in a newsgroup.
>
> Otherwise, Luuk's response is as good as any. And it will be about as
> accurate as anything. You need a cron job to handle the deletion of rows.
>
>
>

You could also check if users are still logged on, just before gathering
the list of logged on users...
(and when someone logs in)

This way your database will not give the correct 'state' to you, but to
the web-users it will, because you put all the changes in there before
you show anything to the web-users...

--
Luuk

Report message to a moderator

[Message index]

		User login status? By: Co on Tue, 14 June 2011 20:22
		Re: User login status? By: Luuk on Tue, 14 June 2011 20:57
		Re: User login status? By: Luuk on Tue, 14 June 2011 21:00
		Re: User login status? By: Co on Tue, 14 June 2011 21:09
		Re: User login status? By: Jerry Stuckle on Tue, 14 June 2011 22:57
		Re: User login status? By: Co on Wed, 15 June 2011 05:02
		Re: User login status? By: Jerry Stuckle on Wed, 15 June 2011 10:02
		Re: User login status? By: Luuk on Wed, 15 June 2011 18:33
		Re: User login status? By: Co on Fri, 17 June 2011 11:25
		Re: User login status? By: Luuk on Fri, 17 June 2011 18:53
		Re: User login status? By: me on Fri, 17 June 2011 19:13
		Re: User login status? By: Luuk on Fri, 17 June 2011 20:06
		Re: User login status? By: me on Fri, 17 June 2011 20:39
		Re: User login status? By: Jerry Stuckle on Fri, 17 June 2011 20:47
		Re: User login status? By: me on Fri, 17 June 2011 21:07
		Re: User login status? By: Tim Streater on Fri, 17 June 2011 21:47
		Re: User login status? By: Jerry Stuckle on Sat, 18 June 2011 00:25
		Re: User login status? By: me on Sat, 18 June 2011 04:15
		Re: User login status? By: Luuk on Sat, 18 June 2011 11:37
		Re: User login status? By: me on Sat, 18 June 2011 15:46

Previous Topic:	radio button change after going to next page
Next Topic:	Stats comp.lang.php (last 7 days)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 10 12:44:11 GMT 2024

Total time taken to generate the page: 0.06577 seconds