Show users currently logged onto site

Question

0.00/5 (No votes)

See more:

Hi all. I have a website that has members log in. I store the members/users in a users table in a MySQL database. How can i on my website show a table with all the users currently logged in. The way i wanted to do it is have an extra table in the database that would store the currently logged in users but i am not allowed to do that. Does anyone know how to achieve this? Any help or links would be much appreciated. Thanking you in advance.

Posted 16-May-13 23:42pm

Ruwaldo

Add a Solution

Comments

Thanks7872 17-May-13 5:49am

You can alter your existing users table with adding column named ONLINE.by default make it false,when user logs in,make it true.Whenever user logs in,in table display all the users with ONLINE="true".When he logs out update the table with ONLINE="false".

Ruwaldo 17-May-13 5:51am

Thanks for the comment. Will ask my IT head if i can do this. Is there no other way to do it without altering the database?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Answer 1 · 2013-05-17T00:14:00

There are built in methods for determining who is logged onto a MySql database - if you leave your users logged onto the database whilst they are on the site then you can use those tools

Have a look at these posts for further information

List of users accessing database[^]

How to see users logged into mysql[^]