<?php
$sayfa= (( isset($_GET["sayfa"]) )? $_GET["sayfa"] : 'anasayfa');
$realPage = explode('/', $sayfa);
if (isset($realPage[1])) {
$seourl=$realPage[1];
}

if (!isset($seourl)) {
include 'parts/header.php'; ?>



<div class="page-title animatedBackground">
<div class="container">
<h3>Blog</h3>
<ul>
<li><a href="../">Anasayfa</a></li>
<li class="dot-divider"></li>
<li>Blog</li>
</ul>
</div>
<div class="bg-pattern"><img src="assets/img/bg-pattern-2.png" alt="pattern"></div>
</div>


<section class="blog-area ptb-100">
<div class="container">
<div class="row">
<div class="col-lg-12 col-md-12">
<div class="row">





<?php
$sorguposts = $db_conn->query("SELECT * FROM posts ORDER BY id LIMIT 6 ");
while($rowsposts = $sorguposts->fetch()){
echo '<div class="col-lg-4 col-md-4">
<div class="single-blog-post">
<a href="blog/'.$rowsposts["seourl"].'" class="blog-image"><img src="uploads/post/image/'.$rowsposts["image"].'" alt="'.$rowsposts["title"].'"></a>
<div class="blog-post-content">
<h4><a href="blog/'.$rowsposts["seourl"].'">'.$rowsposts["title"].'</a></h4>
<p>'.kisalt($rowsposts["description"],120).'</p>
<a href="blog/'.$rowsposts["seourl"].'" class="read-more-btn">Devamını Oku</a>
</div>
</div>
</div>';
}
?>



</div>
</div>
</div>
</div>
</section>

















<?php
}else{
$sorguposts = $db_conn->query("SELECT * FROM posts WHERE seourl='$seourl'");
$rowsposts= $sorguposts->fetch(PDO::FETCH_ASSOC);
$title= $rowsposts['title'];
$keywords= $rowsposts['keywords'];
$description= $rowsposts['description'];
define("TITLE",$title);
define("KEYWORDS",$keywords);
define("DESCRIPTION",$description);
if ($rowsposts) {
include 'parts/alt-header.php'; ?>






<div class="page-title animatedBackground">
<div class="container">
<h3><?php echo $rowsposts['title'] ?></h3>
<ul>
<li><a href="<?php echo $rows['site_url'] ?>">Anasayfa</a></li>
<li class="dot-divider"></li>
<li><?php echo $rowsposts['title'] ?></li>
</ul>
</div>
</div>

<section class="blog-details-area ptb-100">
<div class="container">
<div class="row">
<div class="col-lg-12 col-md-12">
<div class="blog-details">
<div class="thumb">
<img src="../uploads/post/image/<?php echo $rowsposts['image']; ?>" alt="details">
<div class="date">
<span><?php echo $rowsposts['created_date']; ?></span>
</div>
</div>

<div class="blog-details-content">
<?php echo $rowsposts['content']; ?>

</div>
</div>
</div>
</div>
</div>
</section>






<?php
}else{
header("location:".$url."/404");
}

}


?>