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

<title>Video Galeri | <?php echo $ayar['site_baslik']?></title>
<meta name="description" content="<?php echo"$ayar[site_desc]" ?>">
<meta name="keywords" content="<?php echo"$ayar[site_tags]" ?>">
<meta name="news_keywords" content="<?php echo"$ayar[site_tags]" ?>">
<meta name="author" content="<?php echo"$ayar[site_baslik]" ?>" />
<meta itemprop="author" content="<?php echo"$ayar[site_baslik]" ?>" />
<meta name="robots" content="index follow">
<meta name="googlebot" content="index follow">
<meta property="og:type" content="website" />

<section class="page-title">
<div class="outer-container">
<div class="image">
<img src="images/background/21.jpg" alt="" />
</div>
</div>
</section>

<section class="page-breadcrumb">
<div class="image-layer" style="background-image:url(images/background/1.png)"></div>
<div class="container">
<div class="clearfix">
<div class="pull-left">
<h2>Video Galeri</h2>
</div>
<div class="pull-right">
<ul class="breadcrumbs">
<li class="left-curves"></li>
<li class="right-curves"></li>
<li><a href="index.html">Anasayfa -</a></li>
<li>Video Galeri</li>
</ul>
</div>
</div>
</div>
</section>

<section class="services-page-section">
<div class="container">
<div class="row">
<?php
$sayfada = 9; // sayfada gösterilecek içerik miktarını belirtiyoruz.
$sorgu=$db->prepare("select * from video where durum='1' and dil='$_SESSION[dil]'");
$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 video where durum='1' and dil='$_SESSION[dil]' order by sira ASC limit $limit,$sayfada");
$refsor->execute();
if ($refsor->rowCount()){
while ($galeri=$refsor->fetch(PDO::FETCH_ASSOC)) {
?>
<div class="services-block-three col-lg-4 col-md-6 col-sm-12">
<div class="inner-box">
<div class="image">
<a href="video/<?=$galeri['id']?>/<?=seo($galeri['baslik'])?>"><img style="height: 250px;object-fit: cover;" class="img-fluid w-100" src="images/videos/<?=$galeri['gorsel']?>" alt="<?=$galeri['baslik']?>"></a>
</div>
<div class="lower-content">
<h3><a href="video/<?=$galeri['id']?>/<?=seo($galeri['baslik'])?>"><?=$galeri['baslik']?></a></h3>
</div>
</div>
</div>
<?php }?>

<?php }else{?>
<div class="col-lg-12 col-md-12">
<h1>Henüz içerik eklenmedi...</h1>
</div>
<?php }?>
</div>
<div class="pagination" style="display: flex;justify-content: center;">
<?php $s=0; while ($s < $toplam_sayfa) { $s++; ?>
<?php if ($s==$sayfa) {?>
<a class="active"><?php echo $s; ?></a>
<?php } else {?>
<a href="video-galeri?k=<?php echo $katid; ?>&sayfa=<?php echo $s ?>"><?php echo $s; ?></a>
<?php } } ?>
</div>
</div>
</section>

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