PHP Dosya Yöneticisi

<?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");
$page = $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 } ?>

<div class="breadcrumb-area">
                <div class="container">
                    <div class="breadcrumb-content">
                        <ul>
                            <li><a href="<?php echo $url;?>">Anasayfa</a></li>
                            <li class="active"><?php echo $page['adi']; ?></li>
                        </ul>
                    </div>
                </div>
            </div>
 
  <div class="content-wraper pt-10 pb-60">
   <div class="container">
      <div class="row">
         <div class="col-lg-12">
         
            
            
            <div class="shop-top-bar mt-30">
               <div class="shop-bar-inner">
                  <div class="product-view-mode">
                     
                     <ul class="nav shop-item-filter-list" role="tablist">
                        <li class="active" role="presentation"><a aria-selected="true" class="active show" data-bs-toggle="tab" role="tab" aria-controls="grid-view" href="#grid-view"><i class="fa fa-th"></i></a></li>
                        <li role="presentation"><a data-bs-toggle="tab" role="tab" aria-controls="list-view" href="#list-view" aria-selected="false" tabindex="-1"><i class="fa fa-th-list"></i></a></li>
                     </ul>
                     
                  </div>
                  <div class="toolbar-amount">
                     <span>Toplam <?php echo $katsay;?> ürün bulundu</span>
                  </div>
               </div>
               
               <div class="product-select-box">
			   	   <form action="" method="GET">

<?php

if (isset($_GET["filtreleme"]) && $_GET["filtreleme"] != "") {

$fitregelenveri = temizle($_GET["filtreleme"]);

foreach($fitregelenveri as $filtreverisi){?>

<?php  }}?>

<?php

if (isset($_GET["markalar"]) && $_GET["markalar"] != "") {

$markagelenveri = temizle($_GET["markalar"]);

foreach($markagelenveri as $markaverisi){?>

<?php  }}?>

<div class="product-short">
                     <p>Sıralama:</p>
   
					 
					            <select class="nice-select" 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>
					 
					 
                 
                  </div>
				 </form>
               </div>
               
            </div>
            
            
            <div class="shop-products-wrapper">
               <div class="tab-content">
                  <div id="grid-view" class="tab-pane fade active show" role="tabpanel">
                     <div class="product-area shop-product-area">
                        <div class="row">
                     
					 <?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;

?>						   
		
		
		<div class="col-lg-3 col-md-6 col-sm-6 mt-10 urunum">
         
           
                                        <div class="single-product-wrap">
                                            <div class="product-image">
                                                <a href="urun/<?php echo $katurunler['seo']; ?>">
                                                    <img src="resimler/urunler/<?php echo $katurunler['resim']; ?>" alt="<?php echo $katurunler['adi']; ?>">
                                                </a>
												<?php if($katurunler['yeni']=='1'){?>
                                                <span class="sticker">Yeni</span>
												<?php } ?>
                                            </div>
                                            <div class="product_desc">
                                                <div class="product_desc_info">
                                                    <div class="product-review">
                                                        <h5 class="manufacturer">
                                                            <a href="urun/<?php echo $katurunler['seo']; ?>"><?php echo $katurunler['urunkodu']; ?></a>
                                                        </h5>
                                                        <div class="rating-box">
                                                            <ul class="rating">
                                                                <li><i class="fa fa-star-o"></i></li>
                                                                <li><i class="fa fa-star-o"></i></li>
                                                                <li><i class="fa fa-star-o"></i></li>
                                                                <li><i class="fa fa-star-o"></i></li>
                                                                <li><i class="fa fa-star-o"></i></li>
                                                            </ul>
                                                        </div>
                                                    </div>
                                                    <h4><a class="product_name" href="urun/<?php echo $katurunler['seo']; ?>"><?php echo $katurunler['adi']; ?></a></h4>
                                                    <div class="price-box">
                                                         <?php echo urunfiyatbelirle($katurunler['kdv'],$katurunler['idurum'],$katurunler['fiyat'],$katurunler['ifiyat']);?>
				
                                                    </div>
                                                </div>
												
                                                <div class="add-actions">
                                                    <ul class="add-actions-link">
													 <form method="POST" action="">
					                                 <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" class="butonum">Sepete Ekle</button>';
} else {
    echo '<button type="button" onclick="alert(\'Ürünü satın almak için bayi girişi yapmalısınız.\')" class="butonum">Sepete Ekle</button>';
}
?>
                                                        <li><a class="links-details" href="?favoriekle=<?php echo $katurunler['id']; ?>"><i class="fa fa-heart-o"></i></a></li>
                                                        <li><a href="?karsilastir=<?php echo $katurunler['id']; ?>" class="quick-view-btn"><i class="fa fa-random"></i></a></li>
                                                    </ul>
													</form>
                                                </div>
												
                                            </div>
                                        </div>
                                        
      </div>
	  
	  
	  	<?php }

if (!$__URUN__){

echo "<b style='font-weight: 500;background: #fafafa;padding: 10px;width: 100%;text-align: center;border: 1px solid #ededed;'>Üzgünüm Böyle bir ürün bulunamadı</b>";

}

?>	 
			   
			 
					 
					 
					 
					 
					 
					 
                        </div>
                     </div>
                  </div>
                  <div id="list-view" class="tab-pane product-list-view fade" role="tabpanel">
                     <div class="row">
                        <div class="col">
						
						
									
		<?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')){

} 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')) {

} 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')) {

} 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;

?>						   
			
						
						
						
                           <div class="row product-layout-list">
                              <div class="col-lg-3 col-md-5 ">
                                   <div class="product-image">
                                                <a href="urun/<?php echo $katurunler['seo']; ?>">
                                                    <img src="resimler/urunler/<?php echo $katurunler['resim']; ?>" alt="<?php echo $katurunler['adi']; ?>">
                                                </a>
												<?php if($katurunler['yeni']=='1'){?>
                                                <span class="sticker">Yeni</span>
												<?php } ?>
                                            </div>
                              </div>
                              <div class="col-lg-5 col-md-7">
                                 <div class="product_desc">
                                    <div class="product_desc_info">
                                       <div class="product-review">
                                         <h5 class="manufacturer">
                                                            <a href="urun/<?php echo $katurunler['seo']; ?>"><?php echo $katurunler['urunkodu']; ?></a>
                                                        </h5>
                                          <div class="rating-box">
                                             <ul class="rating">
                                                                <li><i class="fa fa-star-o"></i></li>
                                                                <li><i class="fa fa-star-o"></i></li>
                                                                <li><i class="fa fa-star-o"></i></li>
                                                                <li><i class="fa fa-star-o"></i></li>
                                                                <li><i class="fa fa-star-o"></i></li>
                                                            </ul>
                                          </div>
                                       </div>
                                       <h4><a class="product_name" href="urun/<?php echo $katurunler['seo']; ?>"><?php echo $katurunler['adi']; ?></a></h4>
                                        <div class="price-box">
                                                         <?php echo urunfiyatbelirle($katurunler['kdv'],$katurunler['idurum'],$katurunler['fiyat'],$katurunler['ifiyat']);?>
				
                                                    </div>
                                       <p><?php echo strip_tags(mb_substr($katurunler['aciklama'],0,200));?>...</p>
                                    </div>
                                 </div>
                              </div>
                              <div class="col-lg-4">
                                 <div class="shop-add-action mb-xs-30">
								  <form method="POST" action="">
                                    <ul class="add-actions-link">
                                                                       <?php
if ($_SESSION['uyegirisdurumu'] == 'true') {
    echo ' <button type="submit" name="sepetekle" class="butonum">Sepete Ekle</button>';
} else {
    echo '<button type="button" onclick="alert(\'Ürünü satın almak için bayi girişi yapmalısınız.\')" class="butonum">Sepete Ekle</button>';
}
?>

<li class="wishlist"><a href="?favoriekle=<?php echo $katurunler['id']; ?>"><i class="fa fa-heart-o"></i>Favorilerime Ekle</a></li>
                                       <li><a class="quick-view" href="?karsilastir=<?php echo $katurunler['id']; ?>"><i class="fa fa-eye"></i>Karşılaştırma Listeme Ekle</a></li>
                                    </form>
									</ul>
                                 </div>
                              </div>
                           </div>
						   
						   
						    
	  	<?php }

if (!$__URUN__){

echo "<b style='font-weight: 500;background: #fafafa;padding: 10px;width: 100%;text-align: center;border: 1px solid #ededed;'>Üzgünüm Böyle bir ürün bulunamadı</b>";

}

?>	 
			    
						   
						   
						   
                        </div>
                     </div>
                  </div>
                  <div class="paginatoin-area">
                     <div class="row">
                        <div class="col-lg-6 col-md-6">
                           <p>Toplam <?php echo $katsay;?> ürün bulundu</p>
                        </div>
                        <div class="col-lg-6 col-md-6">
                           <ul class="pagination-box">
                            
							  	<?php $geri = $_GET['pages']-1;?>
                            <li class="page-item  <?php echo $_GET['pages'] == '1' ? 'disabled' : null; ?>">
                                <a class="page-link page-link-prev" href="kategori/<?php echo $page['seo'];?>?pages=<?php echo $geri;?>" aria-label="Previous" tabindex="-1" aria-disabled="true">
                                    <span aria-hidden="true"><i class="fa fa-chevron-left"></i></span> Geri
                                </a>
                            </li>
							  
                              <?php

for ($i= $pages - $forlimit ; $i < $pages + $forlimit + 1 ; $i++) {

if ($i>0 and $i<=$sayfasayisi) {

if ($i == $pages) {

echo "<li aria-current='page' class='active' aria-current='page'><a>".$i."</a></li>";

}else{

$eklenecekstr="";

foreach($_GET as $key=>$value) {

if($key!="pages" and $key!="oziywebs" and $key!="id") $eklenecekstr.=$key."=&".$value;

}

$eklenecekstr=$eklenecekstr!="" ? "&".$eklenecekstr : "";

echo "<li class='page-numbers'><a class='' href='kategori/".$page['seo']."?pages=".$i.$eklenecekstr."'>".$i."</a></li>";

}

<?php $ileri = 1+$_GET['pages'];?>
                            <li class="page-item">
                                <a class="page-link page-link-prev" href="kategori/<?php echo $page['seo'];?>?pages=<?php echo $ileri;?>" aria-label="Previous" tabindex="-1" aria-disabled="true">
                                   İleri   <span aria-hidden="true"><i class="fa fa-chevron-right"></i></span>
                                </a>
                            </li>
							  
							  
                           </ul>
                        </div>
                     </div>
                  </div>
               </div>
            </div>
            
         </div>
      </div>
   </div>
</div>

İptal

📁 PHP Dosya Yöneticisi

📝 kategoridetay.php

📝 kategoridetay.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)