📁 PHP Dosya Yöneticisi
/
/
home
/
demodesigncom
/
b2be-ticaretscripti.demodesign.com.tr
/
ninico
📝
kategoridetay.php
← Geri Dön
<?php $id = temizle($_GET['id']); $query = $ozy->prepare("UPDATE kategoriler SET hit = (hit+1) WHERE seo=?"); $update = $query->execute(array($id)); ?> <?php $id = temizle($_GET['id']); $durum = "1"; $sayfaqq = $ozy->prepare("SELECT * FROM kategoriler WHERE seo=:id and durum=:durum"); $katurunler = $sayfaqq->execute([':id' => $id,':durum' => $durum]); $page = $sayfaqq->fetch(PDO::FETCH_ASSOC); $katid = $page['id']; $katsorgu = $ozy->prepare("SELECT COUNT(*) FROM urunler where durum='1' and FIND_IN_SET($katid,kategori)"); $katsorgu->execute(); $katsay = $katsorgu->fetchColumn(); ?> <?php if($page['seodurum']=='1'){ ?> <title><?php echo $page['stitle']; ?></title> <meta name="keywords" content="<?php echo $page['skey']; ?>"> <meta name="description" content="<?php echo $page['sdesc']; ?>"> <meta property="og:url" content="<?php echo $url; ?>"/> <meta property="og:title" content="<?php echo $ayar['stitle']; ?>"/> <meta property="og:description" content="<?php echo $page['sdesc']; ?>"/> <?php } else { ?> <title><?php echo $page['adi']; ?></title> <meta name="keywords" content="<?php echo $ayar['sitekey']; ?>"> <meta name="description" content="<?php echo $ayar['sitedesc']; ?>"> <meta property="og:url" content="<?php echo $url; ?>"/> <meta property="og:title" content="<?php echo $page['adi']; ?>"/> <meta property="og:description" content="<?php echo $ayar['sitedesc']; ?>"/> <?php } ?> <style> .tpproduct__action button { font-size: 16px; color: var(--tp-text-body); height: 50px; width: 50px; text-align: center; line-height: 50px; background-color: var(--tp-common-white); border-radius: 6px; display: inline-block; box-shadow: 0px 10px 20px 0px rgba(0, 0, 0, 0.04); } .nice-select.open .list { z-index: 1000 !important; } </style> <main> <section class="breadcrumb__area pt-60 pb-60 tp-breadcrumb__bg" data-background="<?php echo $sitetemasi; ?>/img/banner/breadcrumb-01.jpg"> <div class="container"> <div class="row align-items-center"> <div class="col-xl-7 col-lg-12 col-md-12 col-12"> <div class="tp-breadcrumb"> <div class="tp-breadcrumb__link mb-10"> <span class="breadcrumb-item-active"><a href="<?php echo $url;?>">AnaSayfa</a></span> <span><?php echo $page['adi']; ?></span> </div> <h2 class="tp-breadcrumb__title"><?php echo $page['adi']; ?></h2> </div> </div> </div> </div> </section> <div class="product-filter-area pt-65 pb-80"> <div class="container"> <div class="product-filter-content mb-40"> <div class="row align-items-center"> <div class="col-sm-6"> <div class="product-item-count"> <span>Toplam <b><?= $katsay ?></b> adet ürün bulundu.</span> </div> </div> <div class="col-sm-6"> <div class="product-navtabs d-flex justify-content-end align-items-center"> <div class="tp-shop-selector"> <form action="" method="GET"> <?php if (isset($_GET["filtreleme"]) && $_GET["filtreleme"] != "") { $fitregelenveri = temizle($_GET["filtreleme"]); foreach ($fitregelenveri as $filtreverisi) { ?> <input type="hidden" name="filtreleme[]" value="<?php echo $filtreverisi; ?>" /> <?php } } ?> <?php if (isset($_GET["markalar"]) && $_GET["markalar"] != "") { $markagelenveri = temizle($_GET["markalar"]); foreach ($markagelenveri as $markaverisi) { ?> <input type="hidden" name="markalar[]" value="<?php echo $markaverisi; ?>" /> <?php } } ?> <input type="hidden" name="pages" value="<?php echo temizle($_GET["pages"]); ?>" /> <input type="hidden" name="fiyatfiltre" value="<?php echo temizle($_GET["fiyatfiltre"]); ?>" /> <select id="input-sort" class="form-control" name="siralama" onchange='this.form.submit()'> <option <?php echo $_GET["siralama"] == "onerilen" ? 'selected="selected"' : null; ?> value="onerilen">Önerilen Sıralama</option> <option <?php echo $_GET["siralama"] == "dusukfiyat" ? 'selected="selected"' : null; ?> value="dusukfiyat">Önce En Düşük Fiyat</option> <option <?php echo $_GET["siralama"] == "yuksekfiyat" ? 'selected="selected"' : null; ?> value="yuksekfiyat">Önce En Yüksek Fiyat</option> <option <?php echo $_GET["siralama"] == "encokyorum" ? 'selected="selected"' : null; ?> value="encokyorum">En Çok Yorum Alan</option> <option <?php echo $_GET["siralama"] == "enbegenilen" ? 'selected="selected"' : null; ?> value="enbegenilen">En Çok Beğenilen</option> <option <?php echo $_GET["siralama"] == "eskitarih" ? 'selected="selected"' : null; ?> value="eskitarih">En Eski Tarihe Göre</option> <option <?php echo $_GET["siralama"] == "yenitarih" ? 'selected="selected"' : null; ?> value="yenitarih">En Yeni Tariha Göre</option> </select> </form> </div> <div class="tpproductnav tpnavbar product-filter-nav"> <nav> <div class="nav nav-tabs" id="nav-tab" role="tablist"> <button class="nav-link" id="nav-all-tab" data-bs-toggle="tab" data-bs-target="#nav-all" type="button" role="tab" aria-controls="nav-all" aria-selected="true"><i class="fal fa-list-ul"></i></button> <button class="nav-link active" id="nav-popular-tab" data-bs-toggle="tab" data-bs-target="#nav-popular" type="button" role="tab" aria-controls="nav-popular" aria-selected="false"><i class="fal fa-th"></i></button> </div> </nav> </div> </div> </div> </div> </div> <div class="row mb-50"> <div class="col-lg-12"> <div class="tab-content" id="nav-tabContent"> <div class="tab-pane fade" id="nav-all" role="tabpanel" aria-labelledby="nav-all-tab"> <?php $pages = intval(@$_GET['pages']); if (!$pages) { $pages = 1; } $bak = $ozy->prepare("select * from urunler where durum='1' and FIND_IN_SET($katid,kategori)"); $bak->execute(array()); $toplam= $bak->rowCount(); $limit = 40; $goster = $pages*$limit-$limit; $sayfasayisi = ceil($toplam/$limit); $forlimit = 10; $where = " "; $marka = " "; $wherex = " "; if (isset($_GET["filtreleme"]) && $_GET["filtreleme"] != "") { $fitregelenveri = temizle($_GET["filtreleme"]); foreach($fitregelenveri as $filtreverisi){ $where .= " and FIND_IN_SET('".$filtreverisi."', filtre)"; } } if (isset($_GET["fiyatfiltre"]) && $_GET["fiyatfiltre"] != "") { $gelenfiyat = temizle($_GET["fiyatfiltre"]); $fiyatexp=explode("-",$gelenfiyat); $wherex = " and if(idurum=1,ifiyat,fiyat)>=".intval($fiyatexp[0])." and if(idurum=1,ifiyat,fiyat)<=".intval($fiyatexp[1]); } if (isset($_GET["markalar"]) && $_GET["markalar"] != "") { $markagelenveri = temizle($_GET["markalar"]); foreach($markagelenveri as $markaverisi){ if($markaverisi==''){ $newid = "0"; }else{ $newid = $markaverisi; } $markammmmm.="".$newid.","; } $markammmmm = mb_substr($markammmmm,0,-1); $marka = " AND marka IN (".$markammmmm.") "; } if (isset($_GET["siralama"]) && $_GET["siralama"] != "") { if(temizle($_GET["siralama"]=='dusukfiyat')){ $pageoku = $ozy->query("select *, if( idurum=1,ifiyat,fiyat) AS simdikifiyat from urunler where durum='1' and FIND_IN_SET($katid,kategori) ".$where." ".$wherex." ".$marka." order by simdikifiyat ASC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC); } elseif (temizle($_GET["siralama"]=='yuksekfiyat')) { $pageoku = $ozy->query("select *, if( idurum=1,ifiyat,fiyat) AS simdikifiyat from urunler where durum='1' and FIND_IN_SET($katid,kategori) ".$where." ".$wherex." ".$marka." order by simdikifiyat DESC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC); } elseif (temizle($_GET["siralama"]=='encokyorum')) { $pageoku = $ozy->query("select * from urunler where durum='1' and FIND_IN_SET($katid,kategori) ".$where." ".$wherex." ".$marka." order by yorum DESC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC); } elseif (temizle($_GET["siralama"]=='enbegenilen')) { $pageoku = $ozy->query("select * from urunler where durum='1' and FIND_IN_SET($katid,kategori) ".$where." ".$wherex." ".$marka." order by hit DESC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC); } elseif (temizle($_GET["siralama"]=='eskitarih')) { $pageoku = $ozy->query("select * from urunler where durum='1' and FIND_IN_SET($katid,kategori) ".$where." ".$wherex." ".$marka." order by tarih ASC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC); } elseif (temizle($_GET["siralama"]=='yenitarih')) { $pageoku = $ozy->query("select * from urunler where durum='1' and FIND_IN_SET($katid,kategori) ".$where." ".$wherex." ".$marka." order by tarih DESC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC); } elseif (temizle($_GET["siralama"]=='onerilen')) { $pageoku = $ozy->query("select * from urunler where durum='1' and FIND_IN_SET($katid,kategori) ".$where." ".$wherex." ".$marka." order by sira DESC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC); } } else { $pageoku = $ozy->query("select * from urunler where durum='1' and FIND_IN_SET($katid,kategori) ".$where." ".$wherex." ".$marka." order by sira DESC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC); } $__URUN__ = false; foreach ($pageoku as $katurunler) { $__URUN__ = true; if ($katurunler['idurum'] == '1') { if ($katurunler['kdv'] > '0') { $eskifiyat = fiyatgoster(KdvDahil($katurunler['fiyat'], $katurunler['kdv'])); $yenifiyat = fiyatgoster(KdvDahil($katurunler['ifiyat'], $katurunler['kdv'])); } else { $eskifiyat = fiyatgoster(KdvDahil($katurunler['fiyat'], $system['kdv'])); $yenifiyat = fiyatgoster(KdvDahil($katurunler['ifiyat'], $system['kdv'])); } } else { if ($katurunler['kdv'] > '0') { $yenifiyat = fiyatgoster(KdvDahil($katurunler['fiyat'], $katurunler['kdv'])); } else { $yenifiyat = fiyatgoster(KdvDahil($katurunler['fiyat'], $system['kdv'])); } } ?> <div class="row mb-40"> <div class="col-lg-4 col-md-12"> <div class="tpproduct__thumb"> <div class="tpproduct__thumbitem p-relative"> <a href="urun/<?php echo $katurunler['seo']; ?>"> <img src="resimler/urunler/<?php echo $katurunler['resim']; ?>" alt="product-thumb"> <?php $sayfaresimi = $ozy->query("select * from tumresimler where sayfaid='$katurunler[id]' and alan='urunler' order by id desc")->fetchAll(PDO::FETCH_ASSOC); if (count($sayfaresimi) > 0 && isset($sayfaresimi)) { ?> <img class="thumbitem-secondary" src="resimler/genel/<?php echo $sayfaresimi[0]['sayfaresim'];?>" alt=""> <?php } else { ?> <img class="thumbitem-secondary" src="resimler/urunler/<?php echo $katurunler['resim']; ?>" alt=""> <?php } ?> </a> </div> </div> </div> <div class="col-lg-8 col-md-12"> <div class="filter-product ml-20 pt-30"> <h3 class="filter-product-title"><a href="urun/<?php echo $katurunler['seo']; ?>"><?php echo $katurunler['adi']; ?></a></h3> <div class="tpproduct__ammount"> <?php if($page['idurum']=='1'){?> <del><?php echo $eskifiyat;?></del> <span><?php echo $yenifiyat;?></span> <?php } else { ?> <span><?php echo $yenifiyat;?></span> <?php } ?> </div> <div class="tpproduct__rating mb-15"> <ul> <li> <a href="#"><i class="fas fa-star"></i></a> <a href="#"><i class="fas fa-star"></i></a> <a href="#"><i class="fas fa-star"></i></a> <a href="#"><i class="fas fa-star"></i></a> <a href="#"><i class="fas fa-star"></i></a> </li> <li> <span>(<?php echo $katurunler['hit']; ?>)</span> </li> </ul> </div> <p><?php echo $katurunler['aciklama'];?></p> <div class="tpproduct__action"> <form method="POST" action=""> <input type="hidden" name="urunid" value="<?php echo $katurunler['id']; ?>"> <input type="hidden" name="adet" value="1"> <a class="comphare" href="?karsilastir=<?php echo $katurunler['id']; ?>"><i class="fal fa-exchange"></i></a> <a class="quckview" href="urun/<?php echo $katurunler['seo']; ?>"><i class="fal fa-eye"></i></a> <a class="wishlist" href="?favoriekle=<?php echo $katurunler['id']; ?>"><i class="fal fa-heart"></i></a> <?php if ($_SESSION['uyegirisdurumu'] == 'true') { echo '<button type="submit" name="sepetekle" class="wishlist"><i class="fal fa-shopping-cart"></i></button>'; } else { echo '<button type="button" onclick="alert(\'Ürünü satın almak için bayi girişi yapmalısınız.\')" class="wishlist"><i class="fal fa-shopping-cart"></i></button>'; } ?> </form> </div> </div> </div> </div> <?php } ?> <?php if (!$__URUN__) { echo "Üzgünüm Böyle bir ürün bulunamadı."; } ?> </div> <div class="tab-pane fade show active" id="nav-popular" role="tabpanel" aria-labelledby="nav-popular-tab"> <div class="row row-cols-xxl-5 row-cols-xl-4 row-cols-lg-3 row-cols-md-3 row-cols-sm-2 row-cols-1 tpproduct"> <?php $pages = intval(@$_GET['pages']); if (!$pages) { $pages = 1; } $bak = $ozy->prepare("select * from urunler where durum='1' and FIND_IN_SET($katid,kategori)"); $bak->execute(array()); $toplam= $bak->rowCount(); $limit = 40; $goster = $pages*$limit-$limit; $sayfasayisi = ceil($toplam/$limit); $forlimit = 10; $where = " "; $marka = " "; $wherex = " "; if (isset($_GET["filtreleme"]) && $_GET["filtreleme"] != "") { $fitregelenveri = temizle($_GET["filtreleme"]); foreach($fitregelenveri as $filtreverisi){ $where .= " and FIND_IN_SET('".$filtreverisi."', filtre)"; } } if (isset($_GET["fiyatfiltre"]) && $_GET["fiyatfiltre"] != "") { $gelenfiyat = temizle($_GET["fiyatfiltre"]); $fiyatexp=explode("-",$gelenfiyat); $wherex = " and if(idurum=1,ifiyat,fiyat)>=".intval($fiyatexp[0])." and if(idurum=1,ifiyat,fiyat)<=".intval($fiyatexp[1]); } if (isset($_GET["markalar"]) && $_GET["markalar"] != "") { $markagelenveri = temizle($_GET["markalar"]); foreach($markagelenveri as $markaverisi){ if($markaverisi==''){ $newid = "0"; }else{ $newid = $markaverisi; } $markammmmm.="".$newid.","; } $markammmmm = mb_substr($markammmmm,0,-1); $marka = " AND marka IN (".$markammmmm.") "; } if (isset($_GET["siralama"]) && $_GET["siralama"] != "") { if(temizle($_GET["siralama"]=='dusukfiyat')){ $pageoku = $ozy->query("select *, if( idurum=1,ifiyat,fiyat) AS simdikifiyat from urunler where durum='1' and FIND_IN_SET($katid,kategori) ".$where." ".$wherex." ".$marka." order by simdikifiyat ASC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC); } elseif (temizle($_GET["siralama"]=='yuksekfiyat')) { $pageoku = $ozy->query("select *, if( idurum=1,ifiyat,fiyat) AS simdikifiyat from urunler where durum='1' and FIND_IN_SET($katid,kategori) ".$where." ".$wherex." ".$marka." order by simdikifiyat DESC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC); } elseif (temizle($_GET["siralama"]=='encokyorum')) { $pageoku = $ozy->query("select * from urunler where durum='1' and FIND_IN_SET($katid,kategori) ".$where." ".$wherex." ".$marka." order by yorum DESC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC); } elseif (temizle($_GET["siralama"]=='enbegenilen')) { $pageoku = $ozy->query("select * from urunler where durum='1' and FIND_IN_SET($katid,kategori) ".$where." ".$wherex." ".$marka." order by hit DESC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC); } elseif (temizle($_GET["siralama"]=='eskitarih')) { $pageoku = $ozy->query("select * from urunler where durum='1' and FIND_IN_SET($katid,kategori) ".$where." ".$wherex." ".$marka." order by tarih ASC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC); } elseif (temizle($_GET["siralama"]=='yenitarih')) { $pageoku = $ozy->query("select * from urunler where durum='1' and FIND_IN_SET($katid,kategori) ".$where." ".$wherex." ".$marka." order by tarih DESC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC); } elseif (temizle($_GET["siralama"]=='onerilen')) { $pageoku = $ozy->query("select * from urunler where durum='1' and FIND_IN_SET($katid,kategori) ".$where." ".$wherex." ".$marka." order by sira DESC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC); } } else { $pageoku = $ozy->query("select * from urunler where durum='1' and FIND_IN_SET($katid,kategori) ".$where." ".$wherex." ".$marka." order by sira DESC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC); } $__URUN__ = false; foreach ($pageoku as $katurunler) { $__URUN__ = true; if ($katurunler['idurum'] == '1') { if ($katurunler['kdv'] > '0') { $eskifiyat = fiyatgoster(KdvDahil($katurunler['fiyat'], $katurunler['kdv'])); $yenifiyat = fiyatgoster(KdvDahil($katurunler['ifiyat'], $katurunler['kdv'])); } else { $eskifiyat = fiyatgoster(KdvDahil($katurunler['fiyat'], $system['kdv'])); $yenifiyat = fiyatgoster(KdvDahil($katurunler['ifiyat'], $system['kdv'])); } } else { if ($katurunler['kdv'] > '0') { $yenifiyat = fiyatgoster(KdvDahil($katurunler['fiyat'], $katurunler['kdv'])); } else { $yenifiyat = fiyatgoster(KdvDahil($katurunler['fiyat'], $system['kdv'])); } } ?> <div class="col"> <div class="tpproduct tpproductitem mb-15 p-relative"> <div class="tpproduct__thumb"> <div class="tpproduct__thumbitem p-relative"> <a href="urun/<?php echo $katurunler['seo']; ?>"> <img src="resimler/urunler/<?php echo $katurunler['resim']; ?>" alt="product-thumb"> <?php $sayfaresimi = $ozy->query("select * from tumresimler where sayfaid='$katurunler[id]' and alan='urunler' order by id desc")->fetchAll(PDO::FETCH_ASSOC); if (count($sayfaresimi) > 0 && isset($sayfaresimi)) { ?> <img class="thumbitem-secondary" src="resimler/genel/<?php echo $sayfaresimi[0]['sayfaresim'];?>" alt=""> <?php } else { ?> <img class="thumbitem-secondary" src="resimler/urunler/<?php echo $katurunler['resim']; ?>" alt=""> <?php } ?> </a> <div class="tpproduct__thumb-bg"> <form method="POST" action=""> <div class="tpproductactionbg"> <input type="hidden" name="urunid" value="<?php echo $katurunler['id']; ?>"> <input type="hidden" name="adet" value="1"> <?php if ($_SESSION['uyegirisdurumu'] == 'true') { echo '<button type="submit" name="sepetekle"><i class="fal fa-shopping-cart"></i></button>'; } else { echo '<button type="button" onclick="alert(\'Ürünü satın almak için bayi girişi yapmalısınız.\')"><i class="fal fa-shopping-cart"></i></button>'; } ?> <a href="?karsilastir=<?php echo $katurunler['id']; ?>"><i class="fal fa-exchange"></i></a> <a href="urun/<?php echo $katurunler['seo']; ?>"><i class="fal fa-eye"></i></a> <a href="?favoriekle=<?php echo $katurunler['id']; ?>"><i class="fal fa-heart"></i></a> </div> </form> </div> </div> </div> <div class="tpproduct__content-area"> <h3 class="tpproduct__title mb-5"><a href="urun/<?php echo $katurunler['seo']; ?>"><?php echo $katurunler['adi']; ?></a></h3> <div class="tpproduct__priceinfo p-relative"> <div class="tpproduct__ammount"> <?php if($katurunler['idurum']=='1'){?> <del><?php echo $eskifiyat;?></del> <span><?php echo $yenifiyat;?></span> <?php } else { ?> <span><?php echo $yenifiyat;?></span> <?php } ?> </div> </div> </div> </div> </div> <? } ?> <?php if (!$__URUN__) { echo "Üzgünüm Böyle bir ürün bulunamadı."; } ?> </div> </div> </div> <div class="row"> <div class="col-xxl-12"> <div class="basic-pagination text-center"> <nav> <ul> <?php $geri = $_GET["pages"] - 1; ?> <?php $ileri = 1 + $_GET["pages"]; ?> <li class="<?php echo $_GET["pages"] == "1" ? "disabled" : null; ?>"> <a href="kategori/<?php echo $page['seo'];?>?pages=<?php echo $geri;?>"> <i class="fal fa-long-arrow-left"></i> </a> </li> <?php for ($i = $pages - $forlimit; $i < $pages + $forlimit + 1; $i++) { if ($i > 0 and $i <= $sayfasayisi) { if ($i == $pages) { echo "<li><span class='current'>" . $i . "</span></li>"; } else { echo "<li><a href='kategori/".$page['seo']."?pages=".$i.$eklenecekstr."' style='padding: 15px; font-size: 15px; font-weight: 600;'>" . $i . "</a></li>"; } } } ?> <li> <a href="kategori/<?php echo $page['seo'];?>?pages=<?php echo $ileri;?>"> <i class="fal fa-long-arrow-right"></i> </a> </li> </ul> </nav> </div> </div> </div> </div> </div> </div> </div> </main>
💾 Kaydet
İptal
📝 Yeniden Adlandır
İptal
Kaydet
🔐 Dosya İzinleri (chmod)
İzin Değeri:
Hızlı Seçim:
777
755
644
600
777
= Herkes okur/yazar/çalıştırır
755
= Sahip tam, diğerleri okur/çalıştırır
644
= Sahip okur/yazar, diğerleri okur
600
= Sadece sahip okur/yazar
İptal
Uygula