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'];

?>  
<main id="content" role="main">
    
    <div class="bg-gray-13 bg-md-transparent">
        <div class="container">
            
            <div class="my-md-3">
                <nav aria-label="breadcrumb">
                    <ol class="breadcrumb mb-3 flex-nowrap flex-xl-wrap overflow-auto overflow-xl-visble">
                        <li class="breadcrumb-item flex-shrink-0 flex-xl-shrink-1"><a href="index.php">Anasayfa</a></li>
                        <li class="breadcrumb-item flex-shrink-0 flex-xl-shrink-1 active" aria-current="page"><?php echo $kategori['baslik']; ?></li>
                    </ol>
                </nav>
            </div>
            
        </div>
    </div>

<div class="container">
        <div class="row mb-8">
            <div class="d-none d-xl-block col-xl-3 col-wd-2gdot5">
                <div class="mb-6 border border-width-2 border-color-3 borders-radius-6">
                    
                    <ul id="sidebarNav" class="list-unstyled mb-0 sidebar-navbar view-all">
                        <li><div class="dropdown-title">Kategoriler</div></li>
                        <?php
                          $bir_ust = $db->query("SELECT * FROM kategori WHERE id = '{$kategori['ust_kategori']}' LIMIT 1")->fetch(PDO::FETCH_ASSOC);
                          if($bir_ust){
                            echo '<li class="dropdown-toggle dropdown-toggle-collapse"><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 class="dropdown-toggle dropdown-toggle-collapse"><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 class="dropdown-toggle dropdown-toggle-collapse"><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-xl-9 col-wd-9gdot5">
                
                <div class="flex-center-between mb-3">
                    <h3 class="font-size-25 mb-0"><?php echo $kategori['baslik']; ?> Ürünleri</h3>
                </div>
                
                
                
                <div class="tab-content" id="pills-tabContent">
                    <div class="tab-pane fade pt-2 show active" id="pills-one-example1" role="tabpanel" aria-labelledby="pills-one-example1-tab" data-target-group="groups">
                        <ul class="row list-unstyled products-group no-gutters">
                            <?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 ){
                              ?>
                            <li class="col-6 col-md-3 product-item">
                                <?php include 'inc/urun-sabit.php'; ?>
                            </li>
                            <?php } } ?>
                        </ul>
                    </div>
                </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>
    </div>
</main>

İptal

📁 PHP Dosya Yöneticisi

📝 kategori.php

📝 kategori.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)