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 #174493 is a reply to message #174488]

Tue, 14 June 2011 22:57

Jerry Stuckle
Messages: 2598
Registered: September 2010

Karma:

Senior Member

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.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================

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: Fri Sep 20 15:35:22 GMT 2024

Total time taken to generate the page: 0.04585 seconds