Guest Statistics

CREATE TABLE `guests` (
  `id` int(11) NOT NULL auto_increment,
  `remoteip` varchar(25) NOT NULL default '',
  `browser` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3;

<?
//DB CONNECTION HERE
//include your database connection script here ^^^
 
$array = get_browser(null, true); //get browser info into an array
$agent = $array['browser']; //get only the browser name from the get_browser array
$remoteip = $_SERVER['REMOTE_ADDR']; //get the guests ip.
 
$query = mysql_query("SELECT * FROM `guests` WHERE `remoteip` = '" . $remoteip . "'");
//query for checking to see if the users visited before
 
if (mysql_num_rows($query) == 0){ //if they have not already visited the site/this page
mysql_query("INSERT INTO `guests` (`remoteip`, `browser`) VALUES ('" . $remoteip . "', '" . $agent . "')"); //insert guest info into db
//done!
} //end of visited check
?>
<!-- Just a html seperator ;) please read php code below and also remove this html comment ;) -->
<?
/*
PLEASE NOTE! ALL THE BELOW CODE CAN BE PUT ON ANOTHER PAGE. DOES NOT NESSESARILY NEED TO BE ON THIS PAGE. HOWEVER WHEREVER YOU PUT IT YOU MUST REMEMBER TO INCLUDE YOUR DATABASE CONNECTION SCRIPT.
WASIM ILYAS.
*/
?>
 
Guests:
<?
$guests = mysql_query("SELECT * FROM `guests`"); //make a query for all the guests in guest table
 
if (mysql_num_rows($guests) == "0"){ echo "No guests"; }else{ //if no guest records, echo appropriatley
//otherwise do the stuff below
?>
<table width=95% cellpadding="0" cellspacing="2" bgcolor="#CCCCCC">
<tr>
<td><center>Ip</center></td>
<td><center>Browser</center></td>
</tr>
<? while($the = mysql_fetch_object($guests)){ //while loop for all records in $guests query ?>
<tr>
<td><center><? echo $the->remoteip; //echo remoteip column from record ?></center></td>
<td><center><? echo $the->browser; //echo browser column from record ?></center></td>
</tr>
<? } //end of while loop ?>
</table>
<? } //end of guest records check ?>

$array = get_browser(null, true); //get browser info into an array
$agent = $array['browser']; //get only the browser name from the get_browser array

$agent = $_SERVER['HTTP_USER_AGENT'];
$agent = substr($agent, 0, 15);