// bezoeker.php 

<?php 

$mysql_host = "localhost"; //mysql host 
$mysql_username = "root"; //mysql username 
$mysql_pass = ""; //mysql password 
$mysql_db = "stats"; //name of database 

//connect to mysql 
$con = mysql_connect($mysql_host, $mysql_username, $mysql_pass); 
mysql_select_db($mysql_db, $con); 

//set user vars 
$ip = $_SERVER['REMOTE_ADDR'];
$host = gethostbyaddr($_SERVER['REMOTE_ADDR']);
$browers = $_SERVER['HTTP_USER_AGENT']; 

//see if the user has been on today 
$today_date = mktime(0,0,0,date("n"),date("j"),date("Y")); 
$iplog = mysql_query("SELECT * FROM site_stats WHERE ip='$ip' AND date >=
'$today_date'"); 

//if they havent visited before 
If(mysql_num_rows($iplog) == 0) { 
    //insert user into db 
    $query = mysql_query("INSERT INTO site_stats (date, ip, host, browser) VALUES
('".time()."', '$ip', '$host', '$browser')"); 
}  
else {  

echo exit(); 
} 
?>





// stats.php 


<?php 
$mysql_host = "localhost"; //mysql host 
$mysql_username = "root"; //mysql username 
$mysql_pass = ""; //mysql password 
$mysql_db = "stats"; //name of database 

//connect to mysql 
$con = mysql_connect($mysql_host, $mysql_username, $mysql_pass); 
mysql_select_db($mysql_db, $con); 


//total hits 
$hits_total = mysql_num_rows(mysql_query("SELECT * FROM site_stats")); 

//hits today 
$today_date = mktime(0,0,0,date("n"),date("j"),date("Y")); 
$hits_today = mysql_num_rows(mysql_query("SELECT * FROM site_stats WHERE date >
".$today_date."")); 

//hits this month 
$this_month = mktime(0,0,0,date("n"),0,date("Y")); 
$hits_month = mysql_num_rows(mysql_query("SELECT * FROM site_stats WHERE date >
".$this_month."")); 

//hits last month 
If((date("n")) != 1) $lastmonth = date("n") - 1; Else $lastmonth = 12; 
$last_month = mktime(0,0,0,$lastmonth,1,date("Y")); 
$hits_lastmonth = mysql_num_rows(mysql_query("SELECT * FROM site_stats WHERE
date >= ".$last_month." AND date < ".$this_month."")); 

//hits yesterday 
If((date("j")) != 1) $yesterday = date("j") - 1; Else $yesterday = date("t",
$last_month); 
$yest_date = mktime(0,0,0,date("n"),$yesterday,date("Y")); 
$hits_yest = mysql_num_rows(mysql_query("SELECT * FROM site_stats WHERE date >
".$yest_date." AND date < ".$today_date."")); 

//print output 
echo " 
<HTML> 
<HEAD> 

</HEAD> 
<BODY> 
<CENTER> 
<table width=500 border=0 cellspacing=0 cellpadding=0> 
<tr> 
<td width=253><font face=Arial, Helvetica, sans-serif size=2>Datum
Vandaag</font></td> 
<td width=247><font face=Arial, Helvetica, sans-serif
size=2>".date("j/n/Y")."</font></td> 
</tr> 
<tr> 
                                 
<td width=253><font face=Arial, Helvetica, sans-serif
size=2>&nbsp;</font></td> 
<td width=247><font face=Arial, Helvetica, sans-serif
size=2>&nbsp;</font></td> 
</tr> 
<tr> 
                                 
<td width=253><font face=Arial, Helvetica, sans-serif
size=2>&nbsp;</font></td> 
<td width=247><font face=Arial, Helvetica, sans-serif
size=2>&nbsp;</font></td> 
</tr> 
<tr> 
<td width=253><font face=Arial, Helvetica, sans-serif size=2>Bezoekers
vandaag</font></td> 
<td width=247><font face=Arial, Helvetica, sans-serif
size=2>$hits_today</font></td> 
</tr> 
<tr> 
<td width=253><font face=Arial, Helvetica, sans-serif size=2>Bezoekers
gister</font></td> 
<td width=247><font face=Arial, Helvetica, sans-serif
size=2>$hits_yest</font></td> 
</tr> 
<tr> 
<td width=253><font face=Arial, Helvetica, sans-serif size=2>Bezoekers deze
maand</font></td> 
<td width=247><font face=Arial, Helvetica, sans-serif
size=2>$hits_month</font></td> 
</tr> 
<tr> 
<td width=253><font face=Arial, Helvetica, sans-serif size=2>Bezoekers laatste
maand</font></td> 
<td width=247><font face=Arial, Helvetica, sans-serif
size=2>$hits_lastmonth</font></td> 
</tr> 
<tr> 
                                 
<td width=253><font face=Arial, Helvetica, sans-serif
size=2>&nbsp;</font></td> 
<td width=247><font face=Arial, Helvetica, sans-serif
size=2>&nbsp;</font></td> 
</tr> 
<tr> 
<td width=253><font face=Arial, Helvetica, sans-serif size=2>Totale
Bezoekers</font></td> 
<td width=247><font face=Arial, Helvetica, sans-serif
size=2>$hits_total</font></td> 
</tr> 
<tr> 
                                 
<td width=253><font face=Arial, Helvetica, sans-serif
size=2>&nbsp;</font></td> 
<td width=247><font face=Arial, Helvetica, sans-serif
size=2>&nbsp;</font></td> 
</tr> 
<tr> 
<br><BR> 
                                 
<td width=253><font face=Arial, Helvetica, sans-serif size=2><BR>Laatste 10
bezoekers</font></td>                            
      <td width=247><font face=Arial, Helvetica, sans-serif
size=2>&nbsp;</font></td> 
</tr> 
</table> 
<BR> 
                             
                             
</CENTER> 
</BODY> 
</HTML> 

"; 

   
   $sql = "SELECT * FROM site_stats ORDER by statid desc LIMIT 0,10"; 
   $resultaat = mysql_query($sql);  
   while ($record = mysql_fetch_object($resultaat)) {  
      echo "         
<table align=center width=500 border=0 cellspacing=0 cellpadding=0> 
  <tr> 
    <td width=89> 
      <div align=left><font face=Arial, Helvetica, sans-serif
size=1><b>$record->statid .</font></b></div> 
    </td> 
    <td width=150> 
      <div align=left><font face=Arial, Helvetica, sans-serif
size=1>$record->ip</font></div> 
    </td> 
    <td width=261> 
      <div align=left><font face=Arial, Helvetica, sans-serif
size=1>$record->host</font></div> 
    </td> 
  </tr> 
</table>\n"; 
         
   }  
?>