prepare(" REPLACE INTO lang SET language = :language, hash = :hash, description = :description");
$sorgu->execute(array(
"language"=> $language,
"hash"=> $hash,
"description"=> $value
));
}
function cevir( $tablo,$kayit,$language){
global $dbh;
$id=$kayit["id"];
foreach($kayit as $hucreanahtar=>$hucreveri){
$hash=dilhash($language,$tablo,$hucreanahtar,$id);
$sorgu = $dbh->prepare("SELECT * FROM lang Where hash=:id");
$sorgu->execute(array(
"id"=> $hash
));
$sonuc = $sorgu->fetch();
if(isset($sonuc["description"])){
$kayit[$hucreanahtar]=$sonuc["description"];
}
}
return $kayit;
}prepare($sql);
$f ->execute();
$_SESSION["current_page"] = $current_page;
}
} else {
//set a session variable so we know that this visitor is being tracked
//insert a new row into the database for this person
$sql = "INSERT INTO visitor_tracking
(ip_address, page_name, query_string)
VALUES ('$ip_address', '$page_name', '$query_string')";
$f = $dbh->prepare($sql);
$f ->execute();
//find the next available visitor_id for the database
//to assign to this person
$_SESSION["tracking"] = true;
$entry_id = $dbh->lastInsertId();
$lowest_sql = ($dbh->prepare("SELECT MAX(visitor_id) as next FROM visitor_tracking"));
$lowest_sql->execute();
$lowest_sql = $lowest_sql->fetch(PDO::FETCH_ASSOC);
$lowest = $lowest_sql["next"];
if(!isset($lowest))
$lowest = 1;
else
$lowest++;
//update the visitor entry with the new visitor id
//Note, that we do it in this way to prevent a "race condition"
($dbh->prepare("UPDATE visitor_tracking SET visitor_id = '$lowest' WHERE entry_id = '$entry_id'"))->execute();
//place the current visitor_id into the session so we can use it on
//subsequent visits to track this person
$_SESSION["visitor_id"] = $lowest;
//save the current page to session so we don't track if someone just refreshes the page
$_SESSION["current_page"] = $current_page;
}
