urunler.php

<?php 
include 'include/menu.php'; 
$metakey=$db->prepare("SELECT * from meta where meta_id=1");
$metakey->execute(array(0));
$metakeyprint=$metakey->fetch(PDO::FETCH_ASSOC);
?>
<title><?php echo $metakeyprint['meta_title'] ?></title>
<meta name="description" content="<?php echo $metakeyprint['meta_descr'] ?>">
<meta name="keywords" content="<?php echo $metakeyprint['meta_keyword'] ?>">
</head>
<?php 
$sayfada = 8; // sayfada gösterilecek içerik miktarını belirtiyoruz.
$sorgu=$db->prepare("SELECT * from urunler where urun_paket='0'");
$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;
$urunsor=$db->prepare("SELECT * from urunler where urun_paket='0' order by urun_id DESC limit $limit,$sayfada");
$urunsor->execute();



?>




<!-- Page title -->
<section class="p-t-100 p-b-50 text-light" id="page-title" data-parallax-image="admin/assets/img/genel/data.jpg">
  <div id="particles-js" class="particles text-light"></div>
  <div class="container">
    <div class="breadcrumb">
      <ul>
        <li><a href="<?php echo $settingsprint['ayar_siteurl']; ?>">AnaSayfa</a> </li>
        <li class="active">Ürünler</li>
      </ul>
    </div>
    <div class="page-title">
      <h1>Ürünler</h1>
    </div>
  </div>
</section>
<!-- end: Page title -->
<!-- ÜRÜNLER -->

<!-- Shop products -->
<section>
  <div class="container">

    <div class="content col-md-9">
      <!--Product list-->
      <div class="shop">
        <div class="grid-layout grid-2-columns" data-item="grid-item">
         <?php 
         
         while($uruncek=$urunsor->fetch(PDO::FETCH_ASSOC)) { 

          $resimsor=$db->prepare("SELECT * from resim where resim_urun=:resim_urun Limit 1");
          $resimsor->execute(array(
           'resim_urun' => $uruncek['urun_id']
         ));

         ?>
         <div class="grid-item">
          <div class="product">
           <div class="product-image">
            <?php while($resimcek=$resimsor->fetch(PDO::FETCH_ASSOC)) {  ?>
              <a style="min-height: 250px;" href="<?=seo('urunler-'.$uruncek["urun_baslik"]).'-'.$uruncek["urun_id"]?>" title="<?php echo $uruncek['urun_baslik']; ?>"><img alt="<?php echo $uruncek['urun_baslik']; ?>" src="admin/<?php echo $resimcek['resim_link'] ?>">
              </a>
            <?php } if ($widgetprint['widget_ufiyat']==1) { ?>
               <span style="border-radius: 2%;
              color: #ffffff;
              font-size: 20px;
              font-weight: 600;
              height: 43px;
              right: 0;
              line-height: 42px;
              position: absolute;
              text-align: center;
              text-shadow: 1px 2px 1px rgba(0, 0, 0, 0.14);
              top: 20px;
              width: 90px;
              opacity: .9;
              z-index: 5;" class="background-colored" ><i class="fa fa-try"></i><?php echo $uruncek['urun_fiyat']; ?></span>
            <?php } ?>
            <div class="col-md-6">
              <div class="product-overlay">
                <a target="_blank" href="<?php echo $uruncek['urun_demo']; ?>" title="<?php echo $uruncek['urun_baslik']; ?>" ><i class="fa fa-eye"></i> DEMO</a>
              </div>
            </div> 
            <div class="col-md-6">
              <div class="product-overlay">
                <a href="<?=seo('urunler-'.$uruncek["urun_baslik"]).'-'.$uruncek["urun_id"]?>" ><i class="fa fa-search"></i> DETAY</a>
              </div>
            </div>
          </div>

          <div class="product-description">
            <div class="product-category"><hr></div>
            <div class="product-title">
              <h4><a href="<?=seo('urunler-'.$uruncek["urun_baslik"]).'-'.$uruncek["urun_id"]?>" title="<?php echo $uruncek['urun_baslik']; ?>"><?php 
              $urunkarakter = strlen( $uruncek['urun_baslik'] );
              if ( $urunkarakter > 30 )
              {
                echo mb_substr($uruncek['urun_baslik'], 0,30, 'UTF-8');
              } else {
                echo $uruncek['urun_baslik']; 
              } ?></a></h4>
            </div>


          </div>
        </div>
      </div>
    <?php } ?>

  </div>
  <!-- Pagination -->
  <div class="pagination pagination-simple">
    <ul>
     <?php
     $s=0;
     while ($s < $toplam_sayfa) {
      $s++; ?>
      <?php 
      if ($s==$sayfa) {?>
        <li class="active">
          <a href="urunler?sayfa=<?php echo $s; ?>"><?php echo $s; ?></a>
        </li>
      <?php } else {?>
        <li>
          <a href="urunler?sayfa=<?php echo $s; ?>"><?php echo $s; ?></a>
        </li>
      <?php   }
    }
    ?>

  </ul>
</div>
<!-- end: Pagination -->
</div>
</div>
<!-- Sidebar-->
<div class="sidebar col-md-3">


 <!--widget newsletter-->
 <div class="widget clearfix widget-archive">
  <h4 class="widget-title">ÜRÜN KATEGORİLERİ</h4>
  <ul class="list list-lines">
   <?php
   $kategorisor=$db->prepare("SELECT * from kategoriler");
   $kategorisor->execute(array(0));
   while ($kategoricek=$kategorisor->fetch(PDO::FETCH_ASSOC)) { ?>

    <li><a href="<?=seo('urun-kategori-'.$kategoricek["kategori_ad"]).'-'.$kategoricek["kategori_id"].''?>"><?php echo $kategoricek['kategori_ad']; ?></a> 
    </li>
  <?php } ?>  
  <li><a href="urunler">Tüm Ürünler</a> 
  </li>
</ul>
</div>
<?php if ($widgetprint['widget_twitter']==1) { ?>
  <!-- Twitter widget -->
  <div class="widget widget-tweeter" data-username="<?php echo $widgetprint['widget_btwitter']; ?>" data-limit="2">
    <h4 class="widget-title">Son Tweetler</h4>
  </div>
  <!-- end: Twitter widget-->
<?php } ?>
<div class="grid-item">
  <!--Contact us-->
  <div class="widget clearfix widget-contact-us" style="background-image: url('admin/assets/img/genel/world-map-dark.png'); background-position: 50% 20px; background-repeat: no-repeat">
    <h4 class="widget-title">İLETİŞİM BİLGİLERİ</h4>
    <ul class="list-icon">
      <strong>Adres:</strong>
      <li><i class="fa fa-map-marker"></i> <?php echo $settingsprint['ayar_adres']; ?> <br /> <?php echo $settingsprint['ayar_il']." / ".$settingsprint['ayar_ilce']; ?></li>
      <strong>Tel:</strong>
      <li><i class="fa fa-phone"></i> <a href="tel:<?php echo $settingsprint['ayar_tel']; ?>" title="<?php echo $settingsprint['ayar_tel']; ?>"><?php echo $settingsprint['ayar_tel']; ?></a> </li>
      <strong>Fax:</strong>
      <li><i class="fa fa-fax"></i> <?php echo $settingsprint['ayar_fax']; ?> </li>
      <strong>Eposta:</strong>
      <li><i class="fa fa-envelope"></i><a href="mailto:<?php echo $settingsprint['ayar_mail']; ?>" ><?php echo $settingsprint['ayar_mail']; ?></a></li>
    </ul>
  </div>
  <!--End: Contact us-->
</div>
</div>
<!-- end: sidebar-->

</div>
</section>
<!-- end: Shop products -->
<!-- end: ÜRÜNLER -->

<?php include 'include/footer.php'; ?>