Visitors:
//1 idPrimary int(11) AUTO_INCREMENT
//2 count int(11)
//3 ip varchar(50) latin2_czech_cs
//4 date date
//5 datetime datetime
$Count = 0;
$Ipr = $_SERVER['REMOTE_ADDR'];
$DateTime = new DateTime('NOW');
$DateTimeShow = date_format($DateTime, 'Y-m-d H:i:s'); // '1900-01-01 00:00:00'
$DateShow = date_format($DateTime, 'Y-m-d');
$DBIpr = "";
$DBCount = 0;
$DBDate = '1900-01-01';
$sql = "SELECT * FROM counter WHERE id=(SELECT max(id) FROM counter)";
if (!$res = mysql_query($sql))
echo "Error: SQL query: $sql";
else
{
$rec = mysql_fetch_array($res);
$DBCount = $rec['count'];
$DBIpr = $rec['ip'];
$DBDate = $rec['date'];
//echo $rec['datetime'];
}
$TheSameIp = 0;
$TheSameDate = 0;
if($DBIpr == $Ipr)
$TheSameIp = 1;
if($DBDate == $DateShow)
$TheSameDate = 1;
if($TheSameIp && $TheSameDate)
$Count = $DBCount;
else
$Count = $DBCount + 1;
echo $Count;
$sql = "insert into counter values (0, $Count, '$Ipr', '$DateShow', '$DateTimeShow')";
if ($res = mysql_query($sql)) {}
//echo "OK\n";
else
echo "Data insert error." . $sql;
/*
if (!($_SERVER['SERVER_NAME']=="office2"))
{?>
}
*/
?>