function dilhash( $language,$table,$col,$recordid ){
return md5($table.$col.$recordid.$language);
}
function dilguncelle($language,$table,$recordid,$col,$value){
global $dbh;
$hash=dilhash($language,$table,$col,$recordid);
$sorgu = $dbh->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;
}
$ip_address = $_SERVER["REMOTE_ADDR"];
$page_name = $_SERVER["SCRIPT_NAME"];
$query_string = $_SERVER["QUERY_STRING"];
$current_page = $page_name."?".$query_string;
/** @var PDO $dbh */
if(isset($_SESSION["tracking"])){
//update the visitor log in the database, based on the current visitor
//id held in $_SESSION["visitor_id"]
$visitor_id = isset($_SESSION["visitor_id"])?$_SESSION["visitor_id"]:0;
if($_SESSION["current_page"] != $current_page)
{
$sql = "INSERT INTO visitor_tracking
(ip_address, page_name, query_string, visitor_id)
VALUES ('$ip_address', '$page_name', '$query_string', '$visitor_id')";
$f = $dbh->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;
}
İşletmemizin menülerine kategori yardımı ile rahatlıkla erişebilirsiniz.
Fatal error: Uncaught Error: Call to undefined function cevir() in C:\xampp\htdocs\kategori.php:42
Stack trace:
#0 {main}
thrown in C:\xampp\htdocs\kategori.php on line 42