login  Naam:   Wachtwoord: 
Registreer je!
 Forum

mijn teller stopt bij 1

Offline keesgerbers - 23/01/2006 19:09
Avatar van keesgerbersLid ik heb een teller (met hulp) gemaakt en hij telt alleen 1 bezoeker en daarna doet hij niets meer
hier staat de teller http://www.vvmaasbracht.nl/vierkant.php
(database wachwoorden heb ik weggelaten)
ik zet de codes er ook bij hier staan ze

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


bezoekers/stats.php
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?php
  2.  include("config.php");
  3.  
  4.  mysql_connect('localhost','prive','prive');
  5.  mysql_select_db('prive');
  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. ?>


bezoekers.php

php code - Bekijk de code zonder highlighting - Klap code in 
  1. <html>
  2. <head>
  3. <title>Untitled Document</title>
  4. <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
  5. </head>
  6.  
  7. <body>
  8. <?php
  10.  
  12.  
  13.  include("bezoekers/config.php");
  14.  
  15.  mysql_connect($conf['MysqlHost'], $conf['MysqlUser'], $conf['MysqlPass']);
  16.  mysql_select_db($conf['MysqlDb']);
  17. ?>
  18. <html>
  19.  
  20. <head>
  21. <title>Statistieken :: <?php echo $conf['Titel']; ?></title>
  22. <style>
  23. body, td { font-family: Verdana; font-size: x-small; }
  24. </style>
  25. </head>
  26.  
  27. <body>
  28.  
  29. <center>
  30. <?php
  31.  if($conf['Totaal']) {
  32.   $query = mysql_query("SELECT * FROM stats GROUP BY ip") or die(mysql_error());
  33.   $uhits = mysql_num_rows($query);
  34.  
  35.   $hits = mysql_result(mysql_query("SELECT sum(hits) as total FROM stats"), 0, "total");
  36.  
  37.   $query = mysql_query("SELECT * FROM stats GROUP BY datum") or die(mysql_error());
  38.   $delen = mysql_num_rows($query);
  39.  
  40.   $total = $uhits + $hits;
  41.  
  42.   $bar1 = round($hits / $total * 100);
  43.   $bar2 = round($uhits / $total * 100);
  44. ?>
  45. aantal bezoekers vanaf 21-12-05: <font color="#00FF00"><br><?php echo $uhits; ?></font>
  46. <br>
  47. <?php
  48.  }
  49.  
  50.  $select1 = mysql_query("SELECT * FROM stats GROUP BY datum ORDER BY datum DESC LIMIT 0,".$conf['Limit']) or die (mysql_error());
  51.  
  52.  while($get = mysql_fetch_object($select1)) {
  53.   $select = mysql_query("SELECT * FROM stats WHERE datum = '".$get->datum."'") or die (mysql_error());
  54.   $uhits = mysql_num_rows($select);
  55.  
  56.   $hits = mysql_result(mysql_query("SELECT sum(hits) as total FROM stats WHERE datum = '".$get->datum."'"), 0, "total");
  57.  
  58.   $total = $uhits + $hits;
  59.  
  60.   $bar1 = $hits / $total * 100;
  61.   $bar2 = $uhits / $total * 100;
  62.  
  63.   $date = explode("-", $get->datum);
  64. ?>
  65. <?php
  66.  }
  67. ?>
  68. </center>
  69.  
  70. </body>
  71.  
  72. </html>


bezoekers/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'] = "prive"; // Mysql gebruiker
  4.  $conf['MysqlPass'] = "prive"; // Mysql wachtwoord
  5.  $conf['MysqlDb'] = "prive"; // Mysql database
  6.  
  7.  ###########################################
  8.  
  9.  $conf['Titel'] = "RKVV Maasbracht"; // 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. ?>

3 antwoorden

Gesponsorde links
Offline webstab - 23/01/2006 19:12 (laatste wijziging 23/01/2006 19:12)
Avatar van webstab PHP ver gevorderde Kijk even wat er in je database staat. Dan kan je ziet of het aan het ingeven ligt of aan het weergeven.

PS: Je kan misschien volgende keer je codes ergens anders posten of de html eruit knippen, dit is niet bepaald handig werken.
Offline nathanael - 23/01/2006 20:16
Avatar van nathanael Gouden medaille

HTML gevorderde		 het ligt aan dit stukje code in stats.php

php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?php
  2. } else {
  3.   $obj = mysql_fetch_object($query);
  4.   $hits = $obj->hits + 1;
  5.   $query = "UPDATE stats SET hits = '".$hits."' WHERE ip = '".$_SERVER['REMOTE_ADDR']."' AND datum = '".date("Y-m-d")."'";
  6.  }
  7. ?>

Je kan simpel alleen de var $query uitvoeren zonder eerst te fetchen.
dan wordt het
php code - Bekijk de code zonder highlighting - Klap code in 
  1. $query = "UPDATE stats SET hits = hits +1 WHERE ip = '".$_SERVER['REMOTE_ADDR']."' AND datum = '".date("Y-m-d")."'";

ik denk dat ie het zo wel doet
Offline keesgerbers - 23/01/2006 21:38
Avatar van keesgerbers Lid hij werkt nu

heel erg bedankt
Gesponsorde links
Dit onderwerp is gesloten.
Actieve forumberichten
© 2002-2024 Sitemasters.be - Regels - Laadtijd: 0.312s