$ip = $_SERVER['REMOTE_ADDR'];
$tarih = time();
$zamanasimi = time()-86400;

$verisil = $conn->query("DELETE FROM ip_tablom WHERE zaman < '{$zamanasimi}'");

$sonuc = $conn->query("SELECT COUNT(ip) From ip_tablom where ip='{$ip}'");

if($sonuc){
$conn->query("UPDATE sayac_tablom SET cogul_hit=(cogul_hit+1) where id=1");
}else{
$veriekle = $conn->prepare("INSERT INTO ip_tablom SET ip = :ip, zaman = :zaman");
$ekleveri = $veriekle->execute(array(
"ip" => $ip,
"zaman" => $tarih
));
$conn->query("UPDATE sayac_tablom SET tekil_hit=(tekil_hit+1), cogul_hit=(cogul_hit+1) where id=1");
}