Spravne nastavenie php

 <table width="248" border="0" cellspacing="0" cellpadding="0" background="image/index_36b.gif">      <?php include "statistika.php"; ?>
      </table>

<?
$server = "mysql.kx.cz";
$login = "xxx";
$password = "xxx";
$databaze = "xxx";
$spojeni = MySQL_Connect($server, $login, $password);
MySQL_Select_DB($databaze);
$ipadresa = $REMOTE_ADDR;
$dnesnidatum = Date("Y-m-d");
$mesic = Date("m");
SetType($mesic, "integer");
$rok = Array(1=>"Januar","Februar","Marec","April","Maj","Jun","Jul","August","September","Oktober","November","December");
$result = Array();
$counter = Array();
$month = $rok[$mesic];
$result[0] = MySQL_Query("SELECT * FROM Host WHERE IP='".$ipadresa."'");
$host = MySQL_Fetch_Object($result[0]);
$poslednipristup = $host->Datum;
if ($poslednipristup==""):
   $pocitat=true;
   MySQL_Query("INSERT INTO Host VALUES('".$ipadresa."', '".$dnesnidatum."',1)");
else:
   if ($poslednipristup!=$dnesnidatum):
      $pocitat = true;
      MySQL_Query("UPDATE Host SET Datum = '".$dnesnidatum."', Pocet = Pocet+1 WHERE IP = '".$ipadresa."'");
   else:
      $pocitat=false;
      MySQL_Query("UPDATE Host SET Pocet = Pocet+1 WHERE IP = '".$ipadresa."'");
   endif;
endif;
if ($pocitat):
   $result[1] = MySQL_Query("SELECT * FROM Celkem");
   if (MySQL_Num_Rows($result[1])!=0):
      $counter[0] = MySQL_Result($result[1],0)+1;
      MySQL_Query("UPDATE Celkem SET Pocet = Pocet+1");
   else:
      $counter[0] = 1;
      MySQL_Query("INSERT INTO Celkem VALUES(1)");
   endif;
   $result[2] = MySQL_Query("SELECT * FROM Mesicni WHERE Mesic = '$month'");
   $aktmesic = MySQL_Fetch_Object($result[2]);
   $counter[1] = $aktmesic->Pocet+1;
   if ($counter[1]==1):
      MySQL_Query("INSERT INTO Mesicni VALUES('$month',1)");
   else:
      MySQL_Query("UPDATE Mesicni SET Pocet = Pocet+1 WHERE Mesic = '$month'");
   endif;
   $result[3] = MYSQL_Query("SELECT * FROM Dnes WHERE Datum='$dnesnidatum'");
   $zaznam = MySQL_Fetch_Object($result[3]);
   $counter[2] = $zaznam->Pocet+1;
   if ($counter[2] == 1):
      MySQL_Query("INSERT INTO Dnes  VALUES ('$dnesnidatum', 1)");
   else:
      MySQL_Query("UPDATE Dnes SET Pocet = Pocet+1 WHERE Datum = '$dnesnidatum'");
   endif;
else:
   $result[4] = MySQL_Query("SELECT * FROM Celkem");
   $counter[0] = MySQL_Result($result[4],0);
   $result[5] = MySQL_Query("SELECT * FROM Mesicni WHERE Mesic = '$month'");
   $tentom = MySQL_Fetch_Object($result[5]);
   $counter[1] = $tentom->Pocet;
   $result[6] = MYSQL_Query("SELECT * FROM Dnes WHERE Datum='$dnesnidatum'");
   $dnes = MySQL_Fetch_Object($result[6]);
   $counter[2] = $dnes->Pocet;
endif;
$result[7] = MySQL_Query("SELECT * FROM Host WHERE IP = '".$ipadresa."'");
$counter[3] = MySQL_Result($result[7],0,2);
echo "<tr><td width=\"248\" class=\"page\"><font class=\"nleft2\">";
echo "Informacie o pripojeňiach</font><br>";
echo "<font class=\"left\">";
echo "<b>Celkem:</b> $counter[0]<br>";
echo "<b>$month:</b> $counter[1]<br>";
echo "<b>Dnes:</b> $counter[2]<br>";
echo "<b>IP:</b> $counter[3]<br>";
$seconds = 120;
$time = Time();
$tolerance = $time-$seconds;
$ipadresa = $REMOTE_ADDR;
// nadeklarovani potrebnych promenych
$result = MySQL_Query("SELECT * FROM Online WHERE IP='".$ipadresa."'");
if (MySQL_Num_Rows($result)==0):
     MySQL_Query("INSERT INTO Online VALUES('".$ipadresa."', ".$time.")");
else:
     MySQL_Query("UPDATE Online SET Cas=".$time." WHERE IP='".$ipadresa."'");
endif;
// upraveni obsahu tabulky
MySQL_Query("DELETE FROM Online WHERE Cas<".$tolerance);
//smazani vsech nevyhovujicich casu
$result = MySQL_Query("SELECT * FROM Online");
$online = MySQL_Num_Rows($result);
$browser=getenv("HTTP_USER_AGENT");
// zjisteni poctu vyhovujicich casu
echo "<b>Prave online:</b> $online";
echo "</font></td></tr>";
echo "<tr><td width=\"248\" class=\"page\"><font class=\"nleft2\">";
echo "Informacie o použivateľovi</font><br>";
echo "<font class=\"left\">";
echo "<b>Vaša verejna IP:</b> $ipadresa<br>";
echo "<b>Browser:</b><br> $browser";
echo "</font></td></tr>";
// vypsani poctu ctenaru
MySQL_Close($spojeni);
//uzavreni spojeni s databasi
?>