AllSyntax.com: » Code » PHP » 38 » Users Online » Index


	I start where the last man left off. - Thomas A. Edison

[login] | [Register]

Users Online

by: bs0d

Description:

First, you will need to create a table `users_online` in your database (and have access to one). Also, create at least 3 columns (id, ip and time) set as: int(11), varchar(15) and varchar(11).

Next, you need the code to appear in your page_header, you can save the code as a file, and include it; or just paste the code directly in your header.

Finally, you can add alot to this code, and use the table to show "who" is online as well.

Code:


<?



//REMEMBER TO CONNECT TO THE DATABASE!!



$ip =            $_SERVER['REMOTE_ADDR'];

$time =             time();



$ip_check = 'SELECT ip FROM `users_online` WHERE ip = \''.$_SERVER['REMOTE_ADDR'].'\'';

$ip_query = mysql_query($ip_check);

$num_rows = mysql_num_rows($ip_query);



if(!$num_rows) { //if no rows, meaning no ip's in db matched theirs, we will add them.

   $insert_new = mysql_query("INSERT INTO `users_online` (ip, time) VALUES ('$ip', '$time')");  

} //end if NOT THERE



//this means that they're already in there, so we update info.

   if($num_rows > 0) {

      $update = mysql_query('UPDATE `users_online` SET time=\''.time().'\' WHERE ip = \''.$_SERVER['REMOTE_ADDR'].'\'');

       if(!$update) die(mysql_error());

} // end UPDATE



//if time now - start time > 300 then its been 5 minutes, so we delete

   $delete_old = mysql_query("DELETE FROM `users_online` WHERE ((".time()."-time) > 300)");

     if(!$delete_old) die(mysql_error());



//show the number of people online now.... 

$id_query = @mysql_query("SELECT * FROM `users_online`");

$users_online = mysql_num_rows($id_query);



echo("<BR>The number of people here are : $users_online<BR>");

//users online is done....

?>

Comments:

Subject: "awesome" Date: Jun 10 2007 at 12:52 pm

Qucik Easy, Effective, nice little added feature to my website took about 3 minutes to do....

Subject: "Online Users" Date: Dec 20 2007 at 5:00 am

Finally, you can add alot to this code, and use the table to show "who" is online as well.

Hi - would love some help on how to add this facility to the above code. Thanks a mil !!!!

Also, I need to add a facility to my page where I can delete users (don't want to use phpmyadmin if possible) - would prefer a script of sorts ! Any help will be greatly appreciated !

Subject: "Show Who is Online" Date: Dec 20 2007 at 2:25 pm

You would first need to implement a Members System. Then, once that is in place you can detect if they're signed in like this:
if($_SESSION['logged_in'] == 1) If they are, insert their name in the users online table, if not - insert "guest"

Being able to delete users is the same. Build a script that shows all users from your members table. Then, add a check box next to each user. Have that within an HTML form, and when you submit the form, have it call upon a delete_user script that will delete based on the check boxes that were checked from the form.

You Must be signed in or a member to comment.

	Code Stats
21,701	Views
3	Total Comments
4.5	Rating of 5 ( Votes)

	Code Options
· Login to Rate This Code
· Login to Post a Comment
· Read more by this author

	Related
· pear database connection implmentation
· IdealMySQL Class for PHP 5.0
· CAPTCHA Image
· view php source
· Database Connection
· Pagination

Flights - Mobile Phones - Loans - Scottsdale Landscaping

"AllSyntax.com" Copyright © 2002-2007; All rights lefted, all lefts righted.
Privacy Policy | Internet Rank