PHP Dosya Yöneticisi

<?php

if (isset($_GET['temizle'])) {
    $id = temizle($_GET['temizle']);
    $bakresim = $ozy->query("select * from urunler where id='$id'")->fetch(PDO::FETCH_ASSOC);
    $sayfasil = $ozy->prepare("delete from urunler where id='$id'");
    $sayfasil->execute([$id]);

if ($sayfasil) {
        if ($bakresim['resim'] == 'resimyok.jpg') {
        } else {
            $silresim = "../resimler/urunler/" . $bakresim['resim'] . "";
            $sil = @unlink("$silresim");
        }

echo '<script type="text/javascript">$(document).ready(function(){toastr["success"]("Başarıyla veri silindi.", "Başarılı");});</script>';
    }
}

?>
<div class="container-fluid">
	<div class="row page-title">
		<div class="col-sm-6">
			<h3>Tüm Ürünler</h3>
		</div>
		<div class="col-sm-6">
			<nav>
				<ol class="breadcrumb justify-content-sm-end align-items-center">
					<li class="breadcrumb-item">
					    <a href="/boss/anasayfa.php">
							<svg class="svg-color">
								<use href="datas/svg/iconly-sprite.svg#Home"></use>
							</svg>
						</a>
					</li>
					<li class="breadcrumb-item active">Tüm Ürünler</li>
				</ol>
			</nav>
		</div>
	</div>
</div>
<div class="container-fluid ecommerce-dashboard">
	<div class="row">
		<div class="col-12">
		    <div class="card m-b-30">
                <div class="card-body table-responsive">
                    <p class="sub-title" style="text-align:right;">
					    <a href="urun-ekle" style="width: 100%;" class="btn btn-success waves-effect waves-lightt">Ürün Ekle</a>
                    </p>
                    <div class="col-lg-12" style="background: #f9f9f9;padding: 10px !important;margin-bottom: 20px !important">
                    	<form action="" method="GET">
                    		<label style="width: 95%;">Ürün Sıralama:</label>
                    		<input type="hidden" name="pages" value="<?php echo temizle($_GET["pages"]); ?>" />
                    		<select name="siralama" style="width: 50%;" class="form-control" onchange='this.form.submit()'>
                    			<option <?php echo $_GET["siralama"] == "onerilen"? 'selected="selected"': null; ?> value="onerilen">Önerilen Sıralama</option>
                    			<option <?php echo $_GET["siralama"] == "azstok"? 'selected="selected"': null; ?> value="azstok">Stoğu Azanlar</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 style="margin-left: 53% !important;margin-top: -53px !important;">
                    			<label style="width: 100%;">Ürün Arama:
                    				<input type="search" class="form-control" name="urunara" placeholder="Ürün Adı veya kodu giriniz" aria-controls="datatable">
                    			</label>
                    		</div>
                    		<button type="submit" style="width: 100%;" class="btn btn-warning waves-effect waves-lightt">
                    			Arama Yap
                    		</button>
                    	</form>
                    </div>
                    <table class="table" id="table_gets">
                    	<thead>
                    		<tr>
                    			<th>Ürün Sırası</th>
								<th>Ürün Kodu</th>
                                <th>Ürün Adı</th>
								<th>Ürün Kategori</th>
                                <th>Ürün Resmi</th>
                                <th>Durumu</th>
								<th>Hit</th>
                                <th>İşlem</th>
                    		</tr>
                    	</thead>
                    	<tbody>
		                    <?php
                                $pages = intval(@$_GET['pages']);
                                if (!$pages) {
                                    $pages = 1;
                                }
                                
                                $urunarama = " ";
                                if (isset($_GET["urunara"]) && $_GET["urunara"] != "") {
                                    $urunarax = temizle($_GET["urunara"]);
                                    $urunarama .= " where adi like '%{$urunarax}%' or urunkodu like '%{$urunarax}%'";
                                }
                                
                                $bak = $ozy->prepare("select * from urunler " . $urunarama . "");
                                $bak->execute([]);
                                $toplam = $bak->rowCount();
                                $limit = 30;
                                $goster = $pages * $limit - $limit;
                                $sayfasayisi = ceil($toplam / $limit);
                                $forlimit = 15;
                                
                                if (isset($_GET["siralama"]) && $_GET["siralama"] != "") {
                                    if (temizle($_GET["siralama"] == 'dusukfiyat')) {
                                        $pageoku = $ozy->query("select *, if( idurum=1,ifiyat,fiyat) AS simdikifiyat from urunler  " . $urunarama . " 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 " . $urunarama . "  order by simdikifiyat DESC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC);
                                    } elseif (temizle($_GET["siralama"] == 'encokyorum')) {
                                        $pageoku = $ozy->query("select * from urunler " . $urunarama . "  order by yorum DESC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC);
                                    } elseif (temizle($_GET["siralama"] == 'enbegenilen')) {
                                        $pageoku = $ozy->query("select * from urunler " . $urunarama . "  order by hit DESC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC);
                                    } elseif (temizle($_GET["siralama"] == 'eskitarih')) {
                                        $pageoku = $ozy->query("select * from urunler " . $urunarama . " order by tarih DESC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC);
                                    } elseif (temizle($_GET["siralama"] == 'yenitarih')) {
                                        $pageoku = $ozy->query("select * from urunler " . $urunarama . "  order by tarih ASC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC);
                                    } elseif (temizle($_GET["siralama"] == 'azstok')) {
                                        $pageoku = $ozy->query("select * from urunler " . $urunarama . " order by stok ASC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC);
                                    } elseif (temizle($_GET["siralama"] == 'onerilen')) {
                                        $pageoku = $ozy->query("select * from urunler " . $urunarama . " order by sira DESC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC);
                                    }
                                } else {
                                    $pageoku = $ozy->query("select * from urunler  " . $urunarama . "  order by sira DESC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC);
                                }
                                
                                $__URUN__ = false;
                                foreach ($pageoku as $tr) {
                                    $__URUN__ = true;
                            ?>					
                                <tr>
                                    <td><?php echo $tr['sira']; ?></td>
									<td style="width: 50px !important;"><?php echo $tr['urunkodu']; ?></td>
                                    <td><a target="_blank" href="../urun/<?php echo $tr['seo']; ?>"><?php echo mb_substr($tr['adi'], 0, 30); ?> ...</a></td>
									<td>
									<?php
                                        $katidler = $tr['kategori'];
                                        $katidler = explode(',', $katidler);
                                        foreach ($katidler as $anahtar => $katdeger) {
                                    ?>
                                        <?php
                                            $kat = $ozy->query("select * from kategoriler where id='$katdeger'")->fetchAll(PDO::FETCH_ASSOC);
                                            foreach ($kat as $de) {
                                        ?>
    									    <a target="_blank" href="../kategori/<?php echo $de['seo']; ?>"><?php echo mb_substr($de['adi'], 0, 30); ?>...</a>
    									<?php } ?>
    									</br>
                                    <?php } ?>
									</td>
                                    <td>
                                        <a class="image-popup-no-margins" href="../resimler/urunler/<?php echo $tr['resim']; ?>">
									        <img class="lazyload" height="30px" width="30px" data-src="../resimler/urunler/<?php echo $tr['resim']; ?>">
									    </a>
									</td>
                                    <td>
    									<?php if ($tr['durum'] == '1') { ?>
    									    <span style="font-size: 13px;" class="badge badge-success">Aktif</span>
                                        <?php } else { ?>
    									    <span style="font-size: 13px;" class="badge badge-pill badge-danger">Pasif</span>
                                        <?php } ?>
									</td>
									<td><?php echo $tr['hit']; ?></td>
                                    <td>
									    <a href="tum-urunler?temizle=<?php echo $tr['id']; ?>" onclick="return confirm('Silmek istediğinize emin misiniz ?')" class="btn btn-sm btn-danger" data-toggle="tooltip" data-original-title="Sil"><i class="fas fa-trash" aria-hidden="true"></i></a>									 
			                            <a href="urun/duzenle/<?php echo $tr['id']; ?>" class="btn btn-sm btn-success" data-toggle="tooltip" data-original-title="Düzenle"><i class="fa fa-edit" aria-hidden="true"></i></a>					
									</td>
                                </tr>       
            		        <?php
                                }
                                
                                if (!$__URUN__) {
                                    echo " Henüz eklenmiş bir ürün bulunamadı.";
                                }
                                
                            ?>
                    	</tbody>
                    </table>
                    <div class="dataTables_paginate paging_simple_numbers" id="datatable_paginate">
                    	<b>Toplam : <?php echo $toplam; ?> adet ürün bulundu.</b>
                    	<ul class="pagination">
                    		<?php
                    		    for ($i = $pages - $forlimit; $i < $pages + $forlimit + 1; $i++) {
                                    if ($i > 0 and $i <= $sayfasayisi) {
                                        if ($i == $pages) {
                                            echo '<li class="paginate_button page-item active"><a href="" aria-controls="datatable" data-dt-idx="1" tabindex="0" class="page-link">' .$i .'</a></li>';
                                        } else {
                                            echo '<li class="paginate_button page-item "><a href="tum-urunler?pages=' .$i ."&siralama=" .$_GET["siralama"] ."&urunara=" .$_GET["urunara"] .'" aria-controls="datatable" data-dt-idx="' .$i .'" tabindex="0" class="page-link">' .$i .'</a></li>';
                                        }
                                    }
                                }
                            ?>
                    		<li class="paginate_button page-item ">
                    			<?php $ileri = $i; ?>
                    			<a href="tum-urunler?pages=<?php echo $i; ?>&siralama=<?php echo $_GET["siralama"]; ?>&urunara=<?php echo $_GET["urunara"]; ?>" aria-controls="datatable" data-dt-idx="<?php echo $ileri; ?>" tabindex="0" class="page-link">>></a>
                    		</li>
                    	</ul>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

İptal

📁 PHP Dosya Yöneticisi

📝 tumurunler.php

📝 tumurunler.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)