<?php $page = 'blog'; include "includes/header.php"; ?>

<!-- CONTENT START -->

<!-- INNER PAGE BANNER -->
<div class="wt-bnr-inr overlay-wraper bg-center" style="background-image:url(images/banner/1.jpg);">
<div class="overlay-main site-bg-primary opacity-09"></div>
<div class="container">
<div class="wt-bnr-inr-entry">
<div class="banner-title-outer">
<div class="banner-title-name">
<h2 class="site-text-white">Bizden Haberler</h2>
</div>
</div>
<!-- BREADCRUMB ROW -->

<div>
<ul class="wt-breadcrumb breadcrumb-style-2">
<li><a href="<?=$site?>">Anasayfa</a></li>
<li>Bizden Haberler</li>
</ul>
</div>

<!-- BREADCRUMB ROW END -->
</div>
</div>
</div>
<!-- INNER PAGE BANNER END -->

<!-- OUR BLOG START -->
<div class="section-full p-t120 p-b120">

<div class="container">
<div class="section-content">
<div class="row d-flex justify-content-center blog-post-1-outer">

<?php
$sayfada = 6; // sayfada gösterilecek içerik miktarını belirtiyoruz.
$sorgu=$db->prepare("select * from news");
$sorgu->execute();
$toplam_icerik=$sorgu->rowCount();
$toplam_sayfa = ceil($toplam_icerik / $sayfada);
// eğer sayfa girilmemişse 1 varsayalım.
$sayfa = isset($_GET['sayfa']) ? (int) $_GET['sayfa'] : 1;
// eğer 1'den küçük bir sayfa sayısı girildiyse 1 yapalım.
if($sayfa < 1) $sayfa = 1;
// toplam sayfa sayımızdan fazla yazılırsa en son sayfayı varsayalım.
if($sayfa > $toplam_sayfa) $sayfa = $toplam_sayfa;
$limit = ($sayfa - 1) * $sayfada;
$refsor=$db->prepare("select * from news order by id DESC limit $limit,$sayfada");
$refsor->execute();
while ($refcek=$refsor->fetch(PDO::FETCH_ASSOC)) {
if ($refcek['isActive']==1){
?>

<!--Block-->
<div class="col-lg-4 col-md-6 col-sm-12">
<div class="blog-post date-style-1 latest-blog grid-style radius-md bg-white">
<div class="wt-post-media wt-img-effect zoom-slow">
<a href="blog-icerik/<?=seo($refcek['title'])."-".$refcek['id']?>"><img style="width: 100%;height: 270px;object-fit: cover;" src="<?php echo $site; ?>/panel/uploads/news_v/730x411/<?php echo $refcek['img_url']; ?>" alt="<?php echo $refcek['title'];?>"></a>
</div>
<div class="wt-post-info">
<div class="wt-post-meta ">
<ul>
<li class="post-date site-text-primary site-bg-secondry"><?php echo date('d.m.Y', strtotime($refcek['createdAt']));?></li>
</ul>
</div>
<a href="blog-icerik/<?=seo($refcek['title'])."-".$refcek['id']?>">
<div class="wt-post-title ">
<h3 class="post-title"><?php echo $refcek['title'];?> </h3>
</div>
</a>
<p><?php echo substr(strip_tags($refcek['description']),0,150); ?>...</p>

<div class="wt-post-readmore ">
<a href="blog-icerik/<?=seo($refcek['title'])."-".$refcek['id']?>" class="site-button-link site-text-primary">Devamını Oku</a>
</div>
</div>
</div>
</div>
<?php }} ?>
</div>

<ul class="pagination m-b0 p-b0">
<?php
$s=0;
while ($s < $toplam_sayfa) {
$s++; ?>
<?php
if ($s==$sayfa) {?>
<li class="page-item active"><a class="page-link" href="blog?k=<?php echo $katid ?>&sayfa=<?php echo $s ?>&"><?php echo $s; ?></a></li>
<?php } else {?>
<li class="page-item"><a class="page-link" href="blog?k=<?php echo $katid; ?>&sayfa=<?php echo $s ?>"><?php echo $s; ?></a></li>
<?php } } ?>
</ul>

</div>
</div>

</div>
<!-- OUR BLOG END -->


<!-- CONTENT END -->

<?php include "includes/footer.php"; ?>