PHP Dosya Yöneticisi

<?php

$query = $db->prepare("SELECT * FROM kategori where sef=:sef LIMIT 1");
$kategori = $query->execute(array(":sef"=>$_GET['sef']));
$kategori = $query->fetch(PDO::FETCH_ASSOC);

if(!$kategori){
  echo '<meta http-equiv="refresh" content="0;URL=index.php">';
}

$_title         =  $kategori['baslik'];
$_description   =  $kategori['kisa_aciklama'];

?>
<div class="container">
	<div class="row mt-10 mb-20">
		<div class="col-md-12">
			<ul class="adres_cubugu">
				<li><a href="index.php"><i class="las la-home"></i> Anasayfa</a> <span><i class="las la-angle-right"></i></span></li>
				<li><a href="kategori/<?php echo $kategori['sef']; ?>"><?php echo $kategori['baslik']; ?></a></li>
			</ul>
		</div>
	</div>

<div class="col-md-3 bg2 kategori_sol border">
		<div class="row p10 border-b">
			<h2><?php echo $kategori['baslik']; ?></h2>
		</div>
		<div class="row p10 border-b">
			<ul class="kategoriler">
				<?php
                  $bir_ust = $db->query("SELECT * FROM kategori WHERE id = '{$kategori['ust_kategori']}' LIMIT 1")->fetch(PDO::FETCH_ASSOC);
                  if($bir_ust){
                    echo '<li><a href="kategori/'.$bir_ust['sef'].'" title="" style="font-weight: bold;color: green;"><i class="las la-angle-right"></i> Üst Kategoriye Dön</a></li>';
                  }

$query = $db->query("SELECT * FROM kategori WHERE ust_kategori = '{$kategori['id']}' ORDER BY sira ASC", PDO::FETCH_ASSOC);
                  if($query->rowCount()){
                      foreach($query as $row){
                        echo '<li><i class="las la-angle-right"></i><a href="kategori/'.$row['sef'].'" title="'.$row['baslik'].'">'.$row['baslik'].'</a></li>';
                      }
                  }else{
                    $query = $db->query("SELECT * FROM kategori WHERE ust_kategori = '{$kategori['ust_kategori']}' ORDER BY sira ASC", PDO::FETCH_ASSOC);
                    if($query->rowCount()){
                        foreach($query as $row){
                          echo '<li><i class="las la-angle-right"></i><a href="kategori/'.$row['sef'].'" title="'.$row['baslik'].'">'.$row['baslik'].'</a></li>';
                        }
                    }
                  }
                ?>
			</ul>
		</div>
	</div>
	<div class="col-md-9 urunler_dis">
		<div class="row">
		  <?php
		  $baslangic = ($_GET['no'] * 12) - 12;
		  $kataegori_idleri = alt_kategori_bul($kategori['id']).'0';
	      $query = $db->query("SELECT
						urun.baslik,
						urun.sef,
						urun.eski_fiyat,
						urun.fiyat,
						urun.id,
						urun_img.img
						FROM
						urun_kategori
						INNER JOIN urun ON urun_kategori.urun_id = urun.id
						INNER JOIN urun_img ON urun.id = urun_img.urun_id
						WHERE
						urun_kategori.kategori_id IN ({$kataegori_idleri})
						GROUP BY
						urun_img.urun_id
						LIMIT {$baslangic},12", PDO::FETCH_ASSOC);
	      if($query->rowCount()){
	        foreach( $query as $row ){
	      ?>
          <div class="col-md-3 col-xs-6">
            <div class="urun mb-15">
                <div class="kontrol">
                  <span data-toggle="tooltip" data-placement="bottom" title="Sepete Ekle"><a href="urun/<?php echo $row['sef']; ?>" title="<?php echo $row['baslik']; ?>"><i class="las la-shopping-cart"></i></a></span>
                  <span data-toggle="tooltip" data-placement="bottom" title="Favorilerime Ekle" data-favori-ekle="<?php echo $row['id']; ?>"><i class="las la-heart"></i></span>                </div>
                <a href="urun/<?php echo $row['sef']; ?>" title="<?php echo $row['baslik']; ?>"><img src="upload/<?php echo $row['img']; ?>" alt="<?php echo $row['baslik']; ?>" title="<?php echo $row['baslik']; ?>"></a>
                <a href="urun/<?php echo $row['sef']; ?>" class="link"><?php echo $row['baslik']; ?></a>
                <div class="fiyat">
                  <?php if(!empty($row['eski_fiyat'])){ ?>
                    <div class="eski">
                      <span><?php echo fiyat($row['eski_fiyat']); ?> TL</span>
                      <span>%<?php echo ceil((($row['eski_fiyat'] - $row['fiyat']) / $row['eski_fiyat']) * 100);  ?></span>
                    </div>
                  <?php } ?>
                      <span class="guncel"><?php echo fiyat($row['fiyat']); ?> TL</span>
                </div>
              </div>
          </div>
          <?php } } ?>
		</div>
		<?php
        $say = $db->query("SELECT
						urun.id
						FROM
						urun_kategori
						INNER JOIN urun ON urun_kategori.urun_id = urun.id
						INNER JOIN urun_img ON urun.id = urun_img.urun_id
						WHERE
						urun_kategori.kategori_id IN ({$kataegori_idleri})
						GROUP BY
						urun_img.urun_id")->fetchAll();

$top_sayfa = count($say);
        $page      = $_GET['no'];
        $limit     = 12;
        $page_url  = 'kategori/'.$kategori['sef'].'/';
        $baslangic = ($page * $limit) - $limit;
        ?>
		<div class="row">
			<div class="col-md-12">
				<div class="pagination-wrapper pull-right">
					<nav aria-label="Page navigation">
						<ul class="pagination mb-0">
							<?php Sayfala($top_sayfa,$page,$limit,$page_url); ?>
						</ul>
					</nav>
				</div>
			</div>
		</div>
	</div>
</div>
<style type="text/css">
.urunler_dis .col-md-3:nth-child(4n+1){clear: left;}
@media only screen and (max-width:600px){
.urunler_dis .col-md-3:nth-child(2n+1){clear: left;}
}
</style>

İptal

📁 PHP Dosya Yöneticisi

📝 kategori.php

📝 kategori.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)