MySQL Counter

<?php
$filename=$SCRIPT_FILENAME;
$counter_start="1";
function counter() {
   global $filename;
   $cnt = 1;
   $result = dbquery("SELECT count FROM zaehler WHERE file='$filename'");
   $num = mysql_num_rows($result);
   if ($num > 0) {
      $cnt = mysql_result($result, 0, 'count');
      if ($counter_start > 1) { $cnt = $counter_start; }
      $cnt++;
      $result=dbquery("UPDATE zaehler SET count='$cnt' WHERE file='$filename'")\
;
   }
   else {
      $result=dbquery("INSERT INTO zaehler (file,count) VALUES ('$filename','$c\
nt')");
   }
   return $cnt;
}

function dbquery($sql) {
     mysql_connect('localhost','user','passwort');
     mysql_select_db('datenbank');
     $result=@mysql_query($sql);
     if (mysql_error()) {
        print "<b>MySQL ERROR:</b> " . mysql_error() . "<br>\n";
        $result = "";
     }
     mysql_close();
     return $result;
}
?>
<html>
<head>
<title>Eine Seite mit MySQL Counter</title>
</head>
<body bgcolor="white">
<h1>Hallo von der Seite mit MySQL Counter</h1>
<?php
  print "<h3>MySQL Counter: </h3>\n";
  print "<h3>" . counter() . " Zugriffe</h3>\n";
?>
</body>
</html>

© Universität Mannheim, Rechenzentrum, 1998-2003.

Last modified: Sat Jun 5 14:52:43 CEST 2004