<?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