<?php require('ust.php');?>
<?php
$id = htmlspecialchars(trim($_GET['id']));
$query = $DB->prepare("UPDATE haberler SET hit = (hit+1) WHERE seo=?");
$update = $query->execute(array(
$id
));
if ( $update ){
echo "";
}


?>
<?php
$id = htmlspecialchars(trim($_GET['id']));
$qq = $DB->prepare("SELECT * FROM haberler WHERE seo=:id and dil=:dil");
$sayfa = $qq->execute([':id' => $id,':dil' => $dilim]);
$sayfa = $qq->fetch(PDO::FETCH_ASSOC);
?>
<?php if($sayfa['sdurum']=='1'){?>
<title><?php echo $sayfa['stitle']; ?></title>
<meta name="keywords" content="<?php echo $sayfa['sseo']; ?>" />
<?php } else { ?>
<title><?php echo $sayfa['baslik']; ?> - <?php echo $ayar['siteadi']; ?></title>
<?php } ?>
<meta name="description" content="<?php echo $ayar['des']; ?>">
<?php require('menu.php');?>

<div class="page-banner bg-2">
<div class="d-table">
<div class="d-table-cell">
<div class="container">
<div class="page-content">
<h2><?php echo $sayfa['baslik']; ?></h2>
<ul>
<li><a href="<?php $ayar['url'];?>"><?php echo $diller['anasayfa']; ?></a></li>
<li><?php echo $diller['haberler']; ?></li>
</ul>
</div>
</div>
</div>
</div>
</div>
<div class="single-services-area ptb-100">
<div class="container">
<div class="row">
<div class="col-lg-8">
<div class="service-details-text">
<div class="service-image">
<a class="example-image-link" href="images/haberler/<?php echo $sayfa['resim']; ?>" data-lightbox="example-1">

<img src="images/haberler/<?php echo $sayfa['resim']; ?>" alt="image">
</a>
<?php $diger = $sayfa['id'];?>

<?php $tr = $DB->query("select * from sayfa_resim where konu='haberler' and resim_id='$diger' order by id desc")->fetchAll(PDO::FETCH_ASSOC);
foreach($tr as $dr){
?>
<div class="col-lg-3" style="float:left;margin-top:10px;">

<a class="example-image-link" href="images/diger/<?php echo $dr['sayfaresim'];?>" data-lightbox="example-1">
<img class="img-fluid" src="images/diger/<?php echo $dr['sayfaresim'];?>" alt="single-img-eleven">
</a>

</div>
<?php } ?>
</div>

<?php echo $sayfa['metin']; ?>

</div>
<div class="sharethis-inline-share-buttons" style="margin-top: 30px;"></div>
</div>

<div class="col-lg-4">
<div class="service-sidebar">
<h3 class="title"><?php echo $diller['benzerhaberler']; ?></h3>
<ul>

<?php $hzmetler = $DB->query("select * from haberler where durum='1' and dil='$dilim' order by sira desc limit 16")->fetchAll(PDO::FETCH_ASSOC);
foreach($hzmetler as $hizmetler){
$current_page = $sayfa['seo'];
?>
<li><a <?php if($current_page==$hizmetler['seo']){echo 'style="background: #392444;color:white;"';}?> href="haberler/<?php echo $hizmetler['seo']; ?>"><i class="bx bx-news"></i> <?php echo $hizmetler['baslik']; ?></a></li>

<?php } ?>





</ul>
</div>
</div>
</div>
</div>
</div>

<link rel="stylesheet" href="lightbox/lightbox.min.css">
<script src="lightbox/lightbox-plus-jquery.min.js"></script>
<?php require('footer.php');?>