Search
Left Quote    Choose a job you love, and you will never have to work a day in your life.
- Confucius    
Right Quote
 
[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....
?>


 


No Comments for this page.

You Must be signed in or a member to comment.


Code Stats

Code Stats

50,348 Views
3 Total Comments
4.5 Rating of 5 ( Votes)

Options

Code Options

· Login to Rate This Code
· Login to Post a Comment
· Read more by this author
Digg This Code! Del.icio.us: Bookmark This Code Reddit: Bookmark This Code! BlinkList: Blink This Code! YahooMyWeb BlogMarks: Add This Mark! Furl: Save This Code Spurl: Mark This Code!

Code Samples

Related    

· Database Connection
· Pagination
· Comments Script
· CAPTCHA Image
· IdealMySQL Class for PHP 5.0





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