PHPBuilder - WHOS ONLINE?



RSS Twitter
Snippets Algorithms

WHOS ONLINE?

by: Ridwan Karsadarma
|
July 9, 2003

Version: 1

Type: Full Script

Category: Algorithms

License: GNU General Public License

Description: This script is for tracking online user by IP/Host. its very simple, no cookies or session need.



<!--

Please dump these MySQL query into your PHPadmin:
-------------------------------------------------

CREATE TABLE online (
  id int(11) NOT NULL auto_increment,
  visitor varchar(100) default NULL,
  timevisit int(11) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

-->
    
<! -- DATABASE CONNECTION -->
<?
     $conn=mysql_connect("localhost","myuser","12345") or die ("can't connect to server");
     @mysql_select_db("mydata") or die ("can't select database");
?>

<! -- UPDATING ONLINE USER DATABASE (add these line below on top of your webpage) -->
<?

$uvisitor=$REMOTE_ADDR;
$uvisitor.="|".gethostbyaddr($uvisitor);
$utime=time();
$exptime=$utime-600; // (in seconds)

@mysql_query("delete from online where timevisit<$exptime");
$uexists=@mysql_num_rows(@mysql_query("select id from online where visitor='$uvisitor'"));

if ($uexists>0){
   @mysql_query("update online set timevisit='$utime' where visitor='$uvisitor'");
} else {
   @mysql_query("insert into online (visitor,timevisit) values ('$uvisitor','$utime')");
}

?>

<!-- DISPLAYING ONLINE USER DATABASE -->
<?
$rs=@mysql_query("select * from online");
echo "<style><!--\n";
echo "body {font-family:verdana;font-size:10pt}\n";
echo "td {font-family:verdana;font-size:10pt}\n";
echo "--></style>\n";
echo "<div align=center><table><tr bgcolor=#CCCCCC><td><b>Visitor IP/Host<td><b>Last visit</tr>";
while ($ro=@mysql_fetch_array($rs)){
   echo "<tr><td>".$ro[visitor]."<td>".date('j M Y - H:i',$ro[timevisit])."</tr>";
}
echo "</table></div>";
$jmlonline=@mysql_num_rows(@mysql_query("select id from online"));
echo "<div align=center><b>There are $jmlonline user online</b></div>";
?>

Comment and Contribute

Your comment has been submitted and is pending approval.

Author:
Ridwan Karsadarma

Comment:



Comment:

(Maximum characters: 1200). You have characters left.