Show users logged into MySQL database

[Xtreamerthaneve]

I have a user system that I made, and I was wondering if anyone knew a PHP code that I could use to display all of the people logged into the MySQL database.

[Trigs]

Username hook?

[HabbDance]

you mean like a 'Who's Online' type thing?

[D-Man22]

On every login, use the

<? if ($date_logged_online==('(date(D:M:Y - H:M-15))')-->%){ 

$database --> $array ==> 

$rowselect['user_name_varible'];

$online_usr = $rowselect['user_nmae_varible'];

echo "'.$online_usr.' is ONLINE! <br>";

 } else { echo "Your the only one online!"; ?>

typa thing? I' poor at PHP, but it works on myne (yes I'm making a usersystem...) I'm assuming your connected to a table and a database... Right?
It should work, Happy PHP! change "$rowselect" to the variable your using to get info from the database table... . It should show logged in people from the last 15 minutes, enjoy!


EDIT: $array is the editible variable to the variable ur connecting to table!

[Dentafrice]

In your users table, have a lastUpdated field.. on each page in the config.php (which should be called on most pages..) have a checkLogin() function which returns true/false.

if(checkLogin() == true) {
    updateUser( $username );
} 

updateUser can just update that field with time(), then just calculate everyone with a lastUpdated field in a period of say.. 15 minutes.

That should calculate your "users online"

[Suspective]

Sorry Don't Know about MySQL!

[Hypertext]

In your users table, have a lastUpdated field.. on each page in the config.php (which should be called on most pages..) have a checkLogin() function which returns true/false.

if(checkLogin() == true) {
    updateUser( $username );
} 

updateUser can just update that field with time(), then just calculate everyone with a lastUpdated field in a period of say.. 15 minutes.

That should calculate your "users online"

Exactly how I do it, thanks to you! I remember back in the day, when I used a boolean to represent on and off. Horrifically, illogical.

@OP: If you mean actual MySQL, as Fazon said use a user login/logout hook.

Btw, a hook is a script that is run on a specific event.

Use it to update a text file, as I'm guessing that would be the best way to retrieve it.

Then your whos online? code should just read off of that text file.

[Calon]

Sorry Don't Know about MySQL!

Now you're just spamming, don't post if you can't contribute.

Just use a session, and on every page it updates the user status with something like Dentafrice said.

[Dentafrice]

Exactly how I do it, thanks to you! I remember back in the day, when I used a boolean to represent on and off. Horrifically, illogical.

@OP: If you mean actual MySQL, as Fazon said use a user login/logout hook.

Btw, a hook is a script that is run on a specific event.

Use it to update a text file, as I'm guessing that would be the best way to retrieve it.

Then your whos online? code should just read off of that text file.

Why the hell write it to a text file? That's pretty illogical, and hooking it on the login/logout.. that's not going to make an accurate "who's online" if you don't update the last activity they did.. that's just going to make it on the login timestamp.

Sounds pretty "illogical" to me.

[Source]

The only "accurate" way todo it would be with the timestamp within a database, or make the sessions save to a directory (which can be set in php) then use some PHP code to count all sessions which have been active within a certain time, still uses timestamp but it grabs it from the php session files directly.

I have always done it with a timestamp in a user database, so my second thought could be completly useless.