<?php require 'include/header.php';
$Id=htmlspecialchars(strip_tags(trim($_GET['kategori_id'])));

$kategorisor=$db->prepare("SELECT * from kategorilerp where kategori_id=:SorguId");
$kategorisor->execute(array('SorguId' => $Id));
$kategoricek=$kategorisor->fetch(PDO::FETCH_ASSOC);
$meta = [
'title' => $kategoricek['kategori_title'],
'keywords' => $kategoricek['kategori_keyword'],
'description' => $kategoricek['kategori_descr']
]; require 'include/menu.php'; ?>
<div class="theme-inner-banner section-spacing">
<div class="overlay">
<div class="container">
<div class="row">
<div class="col-md-8 col-sm-8 col-12 center-holder-xs">
<h1><?php echo $widgetprint[ 'widget_bproje' ]; ?></h1>
</div>
<div class="col-md-4 col-sm-4 col-12 right-holder center-holder-xs" style="display: flex;flex-wrap: wrap;justify-content: flex-end;align-items: center;">
<ul>
<li><a href="javascript:void(0)"><?php echo $widgetprint[ 'widget_bproje' ]; ?></a></li>
<li><a href="<?php echo $settingsprint['ayar_siteurl'] ?>">Anasayfa</a><i class="fa fa-angle-double-right"></i></li>
</ul>
</div>
</div>
</div>
</div>
</div>
<div class="our-case our-project section-spacing">
<div class="container">
<div class="row">
<div class="col-xl-9 col-lg-8 col-12 our-blog">
<div class="row">
<?php
$projesor=$db->prepare("SELECT * from projeler where proje_kategori=:IDsoru order by proje_id DESC");
$projesor->execute(array('IDsoru' => $Id));
while ( $projearticleprint = $projesor->fetch( PDO::FETCH_ASSOC ) ) {

$kategorilerp = $db->prepare( "SELECT * from kategorilerp where kategori_id=:resim_urun" );
$kategorilerp->execute(
array(
'resim_urun' => $projearticleprint[ 'proje_kategori' ]
) );
$kategorip = $kategorilerp->fetch( PDO::FETCH_ASSOC ); ?>
<div class="col-lg-6 col-sm-6 col-12">
<div class="single-case-block">
<img src="trex/<?php echo $projearticleprint[ 'proje_resim' ]; ?>" alt="<?php echo $projearticleprint[ 'proje_baslik' ]; ?>">
<div class="hover-content">
<div class="text clearfix">
<div class="float-left">
<h5><a href="<?= seo( 'proje-' . $projearticleprint[ "proje_baslik" ] ) . '-' . $projearticleprint[ "proje_id" ] ?>"><?php echo $projearticleprint[ 'proje_baslik' ]; ?></a></h5>
<p><?=$kategorip['kategori_ad']?></p>
</div>
<a href="<?= seo( 'proje-' . $projearticleprint[ "proje_baslik" ] ) . '-' . $projearticleprint[ "proje_id" ] ?>" class="details float-right"><i class="fa fa-long-arrow-right" aria-hidden="true"></i></a>
</div>
</div>
</div>
</div>
<?php } ?>
</div>
</div>
<div class="col-xl-3 col-lg-4 col-md-6 col-sm-8 col-12 theme-sidebar-one">
<div class="sidebar-box service-categories">
<h5 class="title">Kategoriler</h5>
<ul>
<?php
$kategorisor=$db->prepare("SELECT * from kategorilerp order by kategori_sira ASC");
$kategorisor->execute(array(0));
while ($kategoricek=$kategorisor->fetch(PDO::FETCH_ASSOC)) {
?>
<li <?php if ($Id==$kategoricek[ "kategori_id" ]) { ?> class="active" <?php } ?>><a href="<?=seo('projeler-'.$kategoricek["kategori_ad"]).'-'.$kategoricek["kategori_id"]?>"><?php echo $kategoricek['kategori_ad']; ?></a></li>
<?php } ?>
<li><a href="projeler">Tüm Projeler</a></li>
</ul>
</div>
</div>
</div>
</div>
</div>
<?php include 'include/footer.php'; ?>