if ($_GET['page'] == ""){ $sql = $db->query("SELECT * FROM metalar WHERE Id = '1'"); $a = $sql->fetch(PDO::FETCH_ASSOC); $title = $a["title"]; $description = $a["description"]; } elseif ($_GET["page"] == "acil"){ $sql = $db->query("SELECT * FROM metalar WHERE Id = '2'"); $a = $sql->fetch(PDO::FETCH_ASSOC); $title = $a["title"]; $description = $a["description"]; } elseif ($_GET["page"] == "magazalar"){ $sql = $db->query("SELECT * FROM metalar WHERE Id = '3'"); $a = $sql->fetch(PDO::FETCH_ASSOC); $title = $a["title"]; $description = $a["description"]; } elseif ($_GET["page"] == "sayfa"){ $id = $_GET["id"]; $sql = $db->query("SELECT * FROM sayfalar WHERE slug = '$id'"); $a = $sql->fetch(PDO::FETCH_ASSOC); $title = $a["sayfaadi"]; $description = $a["sayfaadi"]; } elseif ($_GET["page"] == "category"){ $id = $_GET["id"]; $sql = $db->query("SELECT * FROM category WHERE Id = '$id'"); $a = $sql->fetch(PDO::FETCH_ASSOC); $title = $a["title"]; $description = $a["description"]; } elseif ($_GET["page"] == "magazagir"){ $id = $_GET["id"]; $sql = $db->query("SELECT * FROM magazalar WHERE uyeId = '$id'"); $a = $sql->fetch(PDO::FETCH_ASSOC); $title = $a["magazaadi"]." - Mağaza Sayfası"; $description2 = $a["aciklama"]; } elseif ($_GET["page"] == "blog"){ $id = $_GET["id"]; $sql = $db->query("SELECT * FROM bkategoriler WHERE Id = '$id'"); $a = $sql->fetch(PDO::FETCH_ASSOC); $title = $a["title"]; $description = $a["title"]; if ($id == ""){ $title = "Blog"; $description = "Blog"; } } elseif ($_GET["page"] == "yazi"){ $id = $_GET["id"]; $sql = $db->query("SELECT * FROM byazilar WHERE Id = '$id'"); $a = $sql->fetch(PDO::FETCH_ASSOC); $title = $a["title"]; $description = $a["title"]; } elseif ($_GET["page"] == "ilan"){ $id = $_GET["id"]; $sql = $db->query("SELECT * FROM ilanlar WHERE Id = '$id'"); $a = $sql->fetch(PDO::FETCH_ASSOC); $title = $a["title"]; $description = strip_tags(html_entity_decode($a["content"])); } else { $sql = $db->query("SELECT * FROM metalar WHERE Id = '12'"); $a = $sql->fetch(PDO::FETCH_ASSOC); $title = $a["title"]; $description = $a["description"]; } $sql = $db->query("SELECT * FROM genel"); $a22 = $sql->fetch(PDO::FETCH_ASSOC); $keywords2 = $a22["keywords"]; $description2 = $a22["description"]; ?>