<?php  
include("mysql.php");  
mysql_query("SET NAMES 'utf8'"); 

function url_cevir($yazi) { 
    $yazi = trim($yazi); 
    $yeni = array('ü','Ü','ö','Ö','ş','Ş','ç','Ç','ı','İ','ğ','Ğ',' '); 
    $eski = array('%C3%BC','%C3%9C','%C3%B6','%C3%96','%C5%9F','%C5%9E','%C3%A7','%C3%87','%C4%B1','%C4%B0','%C4%9F','%C4%9E','-'); 
    $yeni_yazi = str_replace($eski,$yeni,$yazi); 
    return $yeni_yazi; 
} 
$link = "http://".$_SERVER["HTTP_HOST"]."".$_SERVER["REQUEST_URI"].""; 
$link = url_cevir($link); 

$sqlsorgu = mysql_query("SELECT * FROM listurl where shorturl = '$link'"); 
while($yazdir=mysql_fetch_array($sqlsorgu)){ 
    $longurl = $yazdir["longurl"]; 
    $hit = $yazdir["hit"] + 1; 
    mysql_query("UPDATE listurl SET hit = '$hit' where shorturl = '$link'");         
    header("Location: $longurl"); 
} 
?>