Pdo yardim

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

mysql_query("Delete From ip_tablom where zaman < ".$zamanasimi);

$sonuc = mysql_query("Select Count(ip) From ip_tablom where ip='$ip'");
$sayi = mysql_result($sonuc,0);

if($sayi ==0){
mysql_query("Insert Into ip_tablom (ip, zaman) Values ('$ip', '$tarih')");
mysql_query("Update sayac_tablom Set tekil_hit=(tekil_hit+1), cogul_hit=(cogul_hit+1) where id=1");
}else{
mysql_query("Update sayac_tablom Set cogul_hit=(cogul_hit+1) where id=1");
}

$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");
}