CREATE TABLE count (hits TEXT, number TEXT);
INSERT INTO count (hits, number) VALUES ('0', '1') ;
CREATE TABLE date (id TEXT, counterdate TEXT);
CREATE TABLE ip (ip TEXT, number TEXT);

<?php

mysql_connect("localhost", "USERNAME", "PASSWORD") or die(mysql_error()); //Put database username

where it says USERNAME and your database password where it says PASSWORD

mysql_select_db("DATABASE") or die(mysql_error()); //Put your database name where it says DATABASE

//You don't need to edit anything below this.


$offset = '-3';
$now = time() + (60 * 60 * $offset);



$ip = $_SERVER['REMOTE_ADDR'];

$get_date = mysql_query("SELECT counterdate FROM date");
while($data_date = mysql_fetch_array($get_date)) {
$date_current = $data_date['counterdate'];
}


$current = date("zY", $now);

if ($date_current == '') {
mysql_query("INSERT INTO date
(id, counterdate) VALUES('1', '$current')");
}


$get_date = mysql_query("SELECT counterdate FROM date");
while($data_date = mysql_fetch_array($get_date)) {
$date_current = $data_date['counterdate'];
}

if (date("zY", $now) != $date_current) {
mysql_query("DELETE FROM ip WHERE number='1'") or die(mysql_error());
mysql_query("UPDATE date SET counterdate = '$current' WHERE id='1'") or die(mysql_error());
}

$query = mysql_query("SELECT ip FROM ip WHERE ip='$ip'");
$query2 = mysql_num_rows($query);


if ($query2 == 0) {
$number = "1";
mysql_query("UPDATE count SET hits = hits + 1") or die(mysql_error());
mysql_query("INSERT INTO ip
(ip, number) VALUES('$ip', '$number')") or die(mysql_error());
}

$database = mysql_query("SELECT hits FROM count");
while($counter = mysql_fetch_array($database)) {

$total_count = $counter['hits'];

}

echo "$total_count hits";


?>

<?php
include('DIRECTORY');
?>

UPDATE count SET hits='Number Here' WHERE number='1';