[SOLVED] show users online

[alohatofu]

I have a script that multiple users can logged in.

is there a way I can show the current users that are logged in?

[taith]

in  your database, make a column for online=0/1... when they login, it switches to 1, when they logout, it switches to 0.

 

then you just...

 

mysql_query("SELECT * FROM `users` WHERE `online`='1'");
.
.
.

 

you'd want to set a timer... just in case they close the browser, without loging out...

[alohatofu]

could someone please elaborate a little more?

 

How would I set the timer? and how would I set 1 and 0 in the datatype in mysql? I'm using phpmyadmin

 

thanks

[taith]

in your login...

mysql_query("UPDATE `user` SET online='1' WHERE id='$id' LIMIT 1"); 

 

in your logout...

mysql_query("UPDATE `user` SET online='0' WHERE id='$id' LIMIT 1");

 

then on every page...

$time=time();
$timeout=time()+(60*60); #now+1hour
mysql_query("UPDATE `user` SET timestamp='$time' WHERE id='$id' LIMIT 1"); 
$query=mysql_query("SELECT * FROM `user` WHERE `online`='1' AND `timestamp`>='$timeout'");
while($row=mysql_fetch_array($query)){
mysql_query("UPDATE `user` SET online='0' WHERE id='$row[id]' LIMIT 1"); 
}

 

code not tested... but it should work 

[alohatofu]

thanks will try

[saint959]

hi alohatofu,

 

could you please post your comments on wether the code works and what you think. i am actually looking for a very similiar thing to happen on one of my sites.

 

thanks in advance

[alohatofu]

This does not seem to work.  Can you please write the code for me to put in the phpmyadmin? I think I didn't create the table correctly. thanks!

[shaunrigby]

There is no table creation involved, you have to add the column yourself, dude, GOOGLE IS YOUR FRIEND

[alohatofu]

Ok,

 

further help is appreciated.

I've altered the table with

ALTER TABLE `surv_member` ADD `online` BINARY NOT NULL ;

 

<?php

$server = "localhost"; // usually localhost
$db_user = "username"; 
$db_pass = "password"; 
$database = "task"; 
mysql_connect($server, $db_user, $db_pass); 

$time=time();
$timeout=time()+(60*60); #now+1hour
mysql_query("UPDATE `username` SET timestamp='$time' WHERE id='$id' LIMIT 1"); 
$query=mysql_query("SELECT * FROM `surv_member` WHERE `online`='1' AND `timestamp`>='$timeout'");
while($row=mysql_fetch_array($query)){
mysql_query("UPDATE `username` SET online='0' WHERE id='$row[id]' LIMIT 1"); 
}

?>

 

but still getting error of

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\sb\index.php on line 531

 

 

Where did I go wrong? Thank you thank you!

[shaunrigby]

what have you put in line 531?

[alohatofu]

527 $time=time();

528 $timeout=time()+(60*60); #now+1hour

529 mysql_query("UPDATE `username` SET timestamp='$time' WHERE id='$id' LIMIT 1");

530 $query=mysql_query("SELECT * FROM `surv_member` WHERE `online`='1' AND `timestamp`>='$timeout'");

531 while($row=mysql_fetch_array($query)){

532  mysql_query("UPDATE `username` SET online='0' WHERE id='$row[id]' LIMIT 1");

533 }

534

535 ?>

 

[alohatofu]

my database is survtask

i have a table surv_member

in that table i have username

and I just created a column for online with the above table alter

[shaunrigby]

change:

$query=mysql_query("SELECT * FROM `surv_member` WHERE `online`='1' AND `timestamp`>='$timeout'");

 

to:

 

$query=mysql_query("SELECT * FROM `surv_member` WHERE `online`='1' AND `timestamp`>='$timeout'")
or die(mysql_error());

 

This will halt your script and print the mysql error message, report back with the message

[alohatofu]

Ok so the error is

Unknown column 'timestamp' in 'where clause'

 

so I did

 

ALTER TABLE `surv_member` ADD `timestamp` TIMESTAMP NOT NULL ;

 

now there is no error.

[shaunrigby]

TADA!

[alohatofu]

thanks that took care of the error but how do I print the username?

 

I did

 

mysql_close();

print ("$username");

 

 

but it's not showing anything.

 

help!! almost there

[shaunrigby]

in your while() statement:

 

 print $row['username']; 

 

Because you are selecting every column and fetching them as an array you would use:

$row['columnName']

 

Please mark your thread as resolved if you have no more questions

 

TA!

[MadTechie]

try

<?php
mysql_close();
print "{$row['username']}";

?>

 

D'oh shaunrigby wins

[shaunrigby]

Because i am GOD! LOL OJ

[alohatofu]

Ok guys I would really appreicate this if we can get this done.

 

I still unable to print the result

<?php

$server = "localhost"; // usually localhost
$db_user = "username"; 
$db_pass = "password"; 
$database = "survtask"; 
mysql_connect($server, $db_user, $db_pass); 

$time=time();
$timeout=time()+(60*60); #now+1hour
mysql_query("UPDATE `username` SET timestamp='$time' WHERE memberId='$id' LIMIT 1"); 
$query=mysql_query("SELECT * FROM `surv_member` WHERE `online`='1' AND `timestamp`>='$timeout'")
or die(mysql_error());
while($row=mysql_fetch_array($query)){
mysql_query("UPDATE `username` SET online='0' WHERE memberId='$row[id]' LIMIT 1"); 
$row['online'];
}

//spit out the results
mysql_close();
print "{$row['username']}";

?>

 

It didn't give any error or any result

[shaunrigby]

add

 

mysql_select_db($database);

 

Underneath your MySQL_Connect function

[alohatofu]

That still didn't change anything. :-(

[alohatofu]

 

that's my database

[shaunrigby]

in your while statement put

 

print "UPDATE `username` SET online='0' WHERE memberId='$row[id]' LIMIT 1";

 

and check that against your database

 

Google "MYSQL UPDATE STATEMENT" (minus the " 's) for what Syntax to use for UPDATE statements

[alohatofu]

That did not print out anything.

 

I checked the UPDATE syntax and they seem to be correct. I guess it does not update the user with a '0' or a '1" correct?