login  Naam:   Wachtwoord: 
Registreer je!
 Scripts:
Scripts > PHP > Statistieken > Statistieken script

Statistieken script

Auteur: XenoX - 26 augustus 2004 - 15:02 - Gekeurd door: Dennisvb - Hits: 11737 - Aantal punten: 3.88 (8 stemmen)




Dit script laat een totaal van de statistieken zien en per dag de hits en unieke hits.

Deze tabel heb je nodig:
php code - Bekijk de code zonder highlighting - Klap code in 
  1. CREATE TABLE `stats` (
  2.   `ip` varchar(20) NOT NULL default '',
  3.   `datum` date NOT NULL default '0000-00-00',
  4.   `hits` int(10) NOT NULL default '1'
  5. ) TYPE=MyISAM;



Voorbeeld:
Include stats.php in bijvoorbeeld index.php

En zet index.php in de map stats/

De plaatjes kun je hier downloaden:
http://www.xenox-designs.net/other/stats.zip

Code:
config.php:
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?php
  2.  $conf['MysqlHost'] = "localhost"; // Mysql host (meestal localhost)
  3.  $conf['MysqlUser'] = "root"; // Mysql gebruiker
  4.  $conf['MysqlPass'] = ""; // Mysql wachtwoord
  5.  $conf['MysqlDb'] = ""; // Mysql database
  6.  
  7.  ###########################################
  8.  
  9.  $conf['Titel'] = "you site.com"; // Titel van je site
  10.  $conf['Totaal'] = TRUE; // TRUE als hij het totaal moet laten zien en FALSE als dat niet moet
  11.  $conf['Limit'] = 30; // Van hoeveel dagen moet hij de statistieken laten zien
  12. ?>


stats.php
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?php
  2.  include("config.php");
  3.  
  4.  mysql_connect($conf['MysqlHost'], $conf['MysqlUser'], $conf['MysqlPass']);
  5.  mysql_select_db($conf['MysqlDb']);
  6.  
  7.  $query = mysql_query("SELECT * FROM stats WHERE ip = '".$_SERVER['REMOTE_ADDR']."' AND datum = '".date("Y-m-d")."'") or die(mysql_error());
  8.  $count = mysql_num_rows($query);
  9.  
  10.  if($count == 0) {
  11.   $query = "INSERT INTO stats (ip, datum, hits) VALUES ('".$_SERVER['REMOTE_ADDR']."', '".date("Y-m-d")."', '1')";
  12.  } else {
  13.   $obj = mysql_fetch_object($query);
  14.   $hits = $obj->hits + 1;
  15.   $query = "UPDATE stats SET hits = '".$hits."' WHERE ip = '".$_SERVER['REMOTE_ADDR']."' AND datum = '".date("Y-m-d")."'";
  16.  }
  17.  
  18.  mysql_query($query) or die(mysql_error());
  19. ?>


index.php
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?php
  3.  
  5.  
  6.  include("config.php");
  7.  
  8.  mysql_connect($conf['MysqlHost'], $conf['MysqlUser'], $conf['MysqlPass']);
  9.  mysql_select_db($conf['MysqlDb']);
  10. ?>
  11. <html>
  12.  
  13. <head>
  14. <title>Statistieken :: <?php echo $conf['Titel']; ?></title>
  15. <style>
  16. body, td { font-family: Verdana; font-size: x-small; }
  17. </style>
  18. </head>
  19.  
  20. <body>
  21.  
  22. <center>
  23. <?php
  24.  if($conf['Totaal']) {
  25.   $query = mysql_query("SELECT * FROM stats GROUP BY ip") or die(mysql_error());
  26.   $uhits = mysql_num_rows($query);
  27.  
  28.   $hits = mysql_result(mysql_query("SELECT sum(hits) as total FROM stats"), 0, "total");
  29.  
  30.   $query = mysql_query("SELECT * FROM stats GROUP BY datum") or die(mysql_error());
  31.   $delen = mysql_num_rows($query);
  32.  
  33.   $total = $uhits + $hits;
  34.  
  35.   $bar1 = round($hits / $total * 100);
  36.   $bar2 = round($uhits / $total * 100);
  37. ?>
  38. <table border="0" cellpadding="5" cellspacing="0" width="100%" style="border: 1px solid #DDDDDD;">
  39.  <tr>
  40.   <td colspan="2" style="border-bottom: 1px dashed #DDDDDD;" bgcolor="#EFEFEF"><b>Totaal</b></td>
  41.  </tr>
  42.  <tr>
  43.   <td width="140">Hits: (<?php echo $hits; ?>)</td>
  44.   <td><img src="bar_line.gif" width="1" height="15"><img src="bar_1.gif" width="<?php echo $bar1; ?>%" height="15"><img src="bar_line.gif" width="1" height="15"><img src="bar_2.gif" width="<?php echo $bar2 - 1; ?>%" height="15"><img src="bar_line.gif" width="1" height="15"></td>
  45.  </tr>
  46.  <tr>
  47.   <td width="140" bgcolor="#EFEFEF">Unieke hits: (<?php echo $uhits; ?>)</td>
  48.   <td bgcolor="#EFEFEF"><img src="bar_line.gif" width="1" height="15"><img src="bar_1.gif" width="<?php echo $bar2; ?>%" height="15"><img src="bar_line.gif" width="1" height="15"><img src="bar_2.gif" width="<?php echo $bar1 - 1; ?>%" height="15"><img src="bar_line.gif" width="1" height="15"></td>
  49.  </tr>
  50. </table>
  51. <br>
  52. <?php
  53.  }
  54.  
  55.  $select1 = mysql_query("SELECT * FROM stats GROUP BY datum ORDER BY datum DESC LIMIT 0,".$conf['Limit']) or die (mysql_error());
  56.  
  57.  while($get = mysql_fetch_object($select1)) {
  58.   $select = mysql_query("SELECT * FROM stats WHERE datum = '".$get->datum."'") or die (mysql_error());
  59.   $uhits = mysql_num_rows($select);
  60.  
  61.   $hits = mysql_result(mysql_query("SELECT sum(hits) as total FROM stats WHERE datum = '".$get->datum."'"), 0, "total");
  62.  
  63.   $total = $uhits + $hits;
  64.  
  65.   $bar1 = $hits / $total * 100;
  66.   $bar2 = $uhits / $total * 100;
  67.  
  68.   $date = explode("-", $get->datum);
  69. ?>
  70. <table border="0" cellpadding="5" cellspacing="0" width="100%" style="border: 1px solid #DDDDDD;">
  71.  <tr>
  72.   <td colspan="2" style="border-bottom: 1px dashed #DDDDDD;" bgcolor="#EFEFEF"><b><?php echo $date[2]."-".$date[1]."-".$date[0]; ?></b></td>
  73.  </tr>
  74.  <tr>
  75.   <td width="140">Hits: (<?php echo $hits; ?>)</td>
  76.   <td><img src="bar_line.gif" width="1" height="15"><img src="bar_1.gif" width="<?php echo $bar1; ?>%" height="15"><img src="bar_line.gif" width="1" height="15"><img src="bar_2.gif" width="<?php echo $bar2 - 1; ?>%" height="15"><img src="bar_line.gif" width="1" height="15"></td>
  77.  </tr>
  78.  <tr>
  79.   <td width="140" bgcolor="#EFEFEF">Unieke hits: (<?php echo $uhits; ?>)</td>
  80.   <td bgcolor="#EFEFEF"><img src="bar_line.gif" width="1" height="15"><img src="bar_1.gif" width="<?php echo $bar2; ?>%" height="15"><img src="bar_line.gif" width="1" height="15"><img src="bar_2.gif" width="<?php echo $bar1 - 1; ?>%" height="15"><img src="bar_line.gif" width="1" height="15"></td>
  81.  </tr>
  82. </table>
  83. <br>
  84. <?php
  85.  }
  86. ?>
  87. Statistieken script gemaakt door: XenoX Designs
  88. </center>
  89.  
  90. </body>
  91.  
  92. </html>
Download code! Download code (.txt)

 Stemmen
Niet ingelogd.

 Reacties
Post een reactie
Lees de reacties (9)
© 2002-2024 Sitemasters.be - Regels - Laadtijd: 0.059s