Scripts

Stats scriptje

Door JeFF -05-01-2003 00:00 -7.944 views

Stats script, houd de bezoekers per dag bij, elk ip kan maar een keer komen, als er meerderen computers op 1 ip staan is dit dan maar pech hebben, maar anders krijg je weer van dat gespam van die trieste gasten. Ik had dit script nog leggen, toen ik net begon had ik dit gemaakt met een beetje hulp, mischien dat jullie er wat aan hebben en zeik het niet zo af Include bezoeker.php ff op je index site, daar word hij gecount.. dit is de table : CREATE TABLE site_stats ( statid int(15) unsigned NOT NULL auto_increment, date int(15) default NULL, ip varchar(150) default NULL, host varchar(150) default NULL, browser varchar(150) default NULL, PRIMARY KEY (statid), UNIQUE KEY statid (statid), KEY statid_2 (statid) ) TYPE=MyISAM;

Download alle bestanden als ZIP

stats-scriptje

// 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"; 
         
   }  
?>