<section class="section-padding-md bg-color-light position-relative">
<div class="container">
<div class="section-heading heading-dark heading-layout1 has-animation">
<?php $refsor2=$db->prepare("select * from baslik WHERE id=3");
$refsor2->execute();
while ($refcek2=$refsor2->fetch(PDO::FETCH_ASSOC)) { if ($refcek2['isActive']==1){ ?>
<div class="section-heading heading-dark heading-layout1">
<div class="heading-sub-title"><?php echo $refcek2['altbaslik']; ?></div>
<h2 class="heading-main-title"><?php echo $refcek2['isim']; ?></h2>
</div>
<?php }} ?>
<div class="heading-icon">
<svg class="dash-left" width="100" height="20">
<g fill="none" stroke-width="4">
<path class="dashed1" stroke="rgba(90, 73, 248, 0.5)" stroke-dasharray="5, 5" d="M5 20 l215 0" />
<path class="dashed2" stroke="white" stroke-dasharray="5, 5" d="M5 20 l215 0" />
</g>
</svg>
<i class="flaticon-rocket"></i>
<svg class="dash-right" width="100" height="20">
<g fill="none" stroke-width="4">
<path class="dashed1" stroke="rgba(90, 73, 248, 0.5)" stroke-dasharray="5, 5" d="M5 20 l215 0" />
<path class="dashed2" stroke="white" stroke-dasharray="5, 5" d="M5 20 l215 0" />
</g>
</svg>


</div>
</div>
<div class="row has-animation">
<?php
$sayfada = 100; // 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){
?>
<div class="col-lg-4 col-12">
<div class="translate-bottom-75 opacity-animation transition-150 transition-delay-100">
<div class="blog-box-layout1">
<div class="item-figure">
<a href="blog-icerik/<?=seo($refcek['title'])."-".$refcek['id']?>"><img src="<?php echo $site; ?>/panel/uploads/news_v/730x411/<?php echo $refcek['img_url']; ?>" alt="<?php echo $refcek['title'];?>"></a>
</div>
<div class="item-content">
<ul class="mb--5 entry-meta meta-color-accent justify-content-between">
<li><a href="#"><i class="far fa-calendar-alt"></i><?php echo date('d.m.Y H:i', strtotime($refcek['createdAt']));?></a></li>
</ul>
<h3 class="entry-title title-color-dark"><a href="blog-icerik/<?=seo($refcek['title'])."-".$refcek['id']?>"><?php echo $refcek['title'];?></a></h3>
<p><?php echo substr(strip_tags($refcek['description']),0,150); ?>...</p>
</div>
</div>
</div>
</div>
<?php }} ?>
</div>
</div>
</section>