PHP Dosya Yöneticisi

<?php
$kategori = $db->query("SELECT * FROM kategori WHERE dil = '{$dil}' AND aktif = 1 AND link = '{$_GET['link']}' LIMIT 1")->fetch(PDO::FETCH_ASSOC);
if(!$kategori){
    die('<meta http-equiv="refresh" content="0;URL='.$site.'404">');
}

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

if(strtolower($dil) == 'tr'){
    $_canonical     = $site.strtolower($sayfa).'/'.$kategori['link'];
}else{
    $_canonical     = $site.strtolower($dil).'/'.strtolower($sayfa).'/'.$kategori['link'];
}

$alt_kategoriler = alt_kategori_id_bul($kategori['id']);
$urun_sayisi = $db->query("SELECT count(id) as toplam FROM urun WHERE dil = '{$dil}' AND durum = 1 AND kategori_id in({$alt_kategoriler})")->fetch(PDO::FETCH_ASSOC);
?>
<main class="main">
    <div class="container mb-30 mt-30">
        <div class="row">
            <div class="col-lg-1-5 primary-sidebar sticky-sidebar">
                <div class="sidebar-widget widget-category-2 mb-30">
                    <h5 class="section-title style-1 mb-30"><?php echo $dil_sabit[108]; ?></h5>
                    <ul>
                        <?php
                          $bir_ust = $db->query("SELECT link, baslik FROM kategori WHERE id = '{$kategori['ust_kategori']}' AND dil = '{$dil}' AND aktif = 1 LIMIT 1")->fetch(PDO::FETCH_ASSOC);
                          if($bir_ust){
                            echo '<li class="uste_don"><a href="kategori/'.$bir_ust['link'].'"><i class="las la-angle-left"></i> '.$dil_sabit[109].'</a></li>';
                          }

$query = $db->query("SELECT link, baslik FROM kategori WHERE ust_kategori = '{$kategori['id']}' AND dil = '{$dil}' AND aktif = 1 ORDER BY sira ASC", PDO::FETCH_ASSOC);
                          if($query->rowCount()){
                              foreach($query as $row){
                                echo '<li><a href="kategori/'.$row['link'].'" title="'.$row['baslik'].'">'.$row['baslik'].'</a></li>';
                              }
                          }else{
                            $query = $db->query("SELECT link, baslik FROM kategori WHERE ust_kategori = '{$kategori['ust_kategori']}' AND dil = '{$dil}' AND aktif = 1 ORDER BY sira ASC", PDO::FETCH_ASSOC);
                            if($query->rowCount()){
                                foreach($query as $row){
                                  echo '<li><a href="kategori/'.$row['link'].'" title="'.$row['baslik'].'">'.$row['baslik'].'</a></li>';
                                }
                            }
                          }
                        ?>
                    </ul>
                </div>
            </div>
            <div class="col-lg-4-5">
                <?php if($urun_sayisi['toplam']){ ?>
                <div class="shop-product-fillter">
                    <div class="totall-product">
                        <p><?php echo $dil_sabit[110]; ?> : <strong class="text-brand"><?php echo $urun_sayisi['toplam']; ?></strong></p>
                    </div>
                </div>
                <?php } ?>
                <div class="row product-grid">
                    <?php
                        $baslangic = ($_GET['no'] * 15) - 15;
                        $query = $db->query("SELECT id FROM urun WHERE dil = '{$dil}' AND durum = 1 AND kategori_id in({$alt_kategoriler}) LIMIT {$baslangic},15", PDO::FETCH_ASSOC);
                        if($query->rowCount()){
                            $urun_id = array();
                            foreach($query as $row){
                                $urun_id[] = $row['id'];
                            }
                            foreach($urun_id as $ui){
                                echo '<div class="col-lg-1-5 col-md-4 col-6 col-sm-6">';
                                include 'inc/urun-sabit-kod.php';
                                echo '</div>';
                            }
                        }else{
                            echo '<div class="col-lg-12 mb-24 text-center">
                                        <div class="featured-card">
                                            <img src="assets/images/icon-1.svg" alt="">
                                            <h4>'.$dil_sabit[111].'</h4>
                                            <p>'.$dil_sabit[66].'</p>
                                            <form action="ara" method="post">
                                                <input type="text" name="ara" style="text-align:center" placeholder="'.$dil_sabit[67].'" required><br><br>
                                                <button type="submit">'.$dil_sabit[68].'</button>
                                            </form>
                                        </div>
                                    </div>';
                        }
                    ?>
                </div>
                <div class="pagination-area mt-20 mb-20">
                    <nav aria-label="Page navigation example">
                        <ul class="pagination justify-content-start">
                            <?php Sayfala($urun_sayisi['toplam'],$_GET['no'],15,'kategori/'.$kategori['link'].'/'); ?>
                        </ul>
                    </nav>
                </div>
                <?php if(!empty($kategori['aciklama'])){ ?>
                <div class="row">
                    <div class="col-xl-12 col-lg-12 col-md-12 m-auto text-center">
                        <h1 class="title style-3" style="font-size: 30px"><?php echo $kategori['baslik']; ?></h1>
                        <p class="font-lg text-grey-700 mb-30"><?php echo $kategori['aciklama']; ?></p>
                    </div>
                </div>
                <?php } ?>
            </div>
        </div>
    </div>
</main>
<?php 
    if(!empty($kategori['popup_resim']) AND !isset($_SESSION['kategorireklami_'.$kategori['id']])){
        $_SESSION['kategorireklami_'.$kategori['id']] = 1;
?>
<script type="text/javascript">$(function(){ $('#popupreklam').modal('show');});</script>
<div class="modal fade custom-modal" id="popupreklam" tabindex="-1" aria-labelledby="popupreklamLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            <div class="modal-body">
                <div class="deal">
                    <div class="deal-bottom">
                        <img src="upload/<?php echo $kategori['popup_resim']; ?>" style="max-height: 400px;"><br>
                        <?php if(!empty($kategori['popup_resim'])){ ?>
                            <center><a href="<?php echo $kategori['popup_link']; ?>" class="btn"><?php echo $dil_sabit[112]; ?> <i class="fi-rs-arrow-right"></i></a></center>
                        <?php } ?>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
<?php } ?>

İptal

📁 PHP Dosya Yöneticisi

📝 kategori.php

📝 kategori.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)