PHP Dosya Yöneticisi

<div class="content-wrapper">
    
    <section class="content-header">
      <h1>
Anasayfa
        <small>Yönetim Paneli</small>
      </h1>
      <ol class="breadcrumb">
        <li class="breadcrumb-item"><a href="index.html"><i class="fa fa-dashboard"></i> Anasayfa</a></li>
        <li class="breadcrumb-item active">Yönetim Paneli</li>
      </ol>
    </section>
<?php

if (isset($_GET['sssill'])) {
	
$id = intval($_GET['sssill']);
$verisil = $DB->prepare("delete from siparisler where id='$id'");
$verisil->execute(array($id));

if ($verisil) {
    
    $not = ' <div class="alert alert-warning">
					                    <button class="close" data-dismiss="alert"><i class="pci-cross pci-circle"></i></button>
					                    <strong>Veri Silindi !</strong>
					                </div>' ;
}}

?>
    
    <section class="content">
		
		<div class="row">
		
		
         <div class="col-xl-3 col-md-6 col-12">
          	<div class="box box-body box-inverse bg-danger" style="background-color: #ed1010 !important;">
              <h6>
                <span class="text-uppercase">SİPARİŞLER</span>
                <span class="float-right"><a class="btn btn-xs btn-warning" href="siparisler.html">Görüntüle</a></span>
              </h6>
              <br>
              <p class="font-size-26"><?php $sorgu = $DB->prepare("SELECT COUNT(*) FROM siparisler");
$sorgu->execute();
$say = $sorgu->fetchColumn();
echo ''.$say.''; ?></p>

<div class="col-xl-3 col-md-6 col-12">
          	<div class="box box-body box-inverse bg-info" style="background-color: #71058c !important;">
              <h6>
                <span class="text-uppercase">DESTEK MERKEZİ</span>
                <span class="float-right"><a class="btn btn-xs btn-warning" href="destekler.html">Görüntüle</a></span>
              </h6>
              <br>
              <p class="font-size-26"><?php $sorgu = $DB->prepare("SELECT COUNT(*) FROM destek");
$sorgu->execute();
$say = $sorgu->fetchColumn();
echo ''.$say.''; ?></p>

<div class="progress progress-xxs mt-0 mb-10">
                <div class="progress-bar bg-warning" role="progressbar" style="width: 55%; height: 4px;" aria-valuenow="35" aria-valuemin="0" aria-valuemax="100"></div>
              </div>
           
            </div>
        </div>	
		
		
		
		
		    <div class="col-xl-3 col-md-6 col-12">
          	<div class="box box-body box-inverse bg-warning">
              <h6>
                <span class="text-uppercase">ÖDEME BİLDİRİMLERİ</span>
                <span class="float-right"><a class="btn btn-xs btn-warning" href="odemeler.html">Görüntüle</a></span>
              </h6>
              <br>
              <p class="font-size-26"><?php $sorgu = $DB->prepare("SELECT COUNT(*) FROM odemeler");
$sorgu->execute();
$say = $sorgu->fetchColumn();
echo ''.$say.''; ?></p>

<div class="progress progress-xxs mt-0 mb-10">
                <div class="progress-bar bg-warning" role="progressbar" style="width: 55%; height: 4px;" aria-valuenow="35" aria-valuemin="0" aria-valuemax="100"></div>
              </div>
           
            </div>
        </div>	
		
		
		
		
		    <div class="col-xl-3 col-md-6 col-12">
          	<div class="box box-body box-inverse bg-info">
              <h6>
                <span class="text-uppercase">GELEN MESAJLAR</span>
                <span class="float-right"><a class="btn btn-xs btn-warning" href="mesajlar.html">Görüntüle</a></span>
              </h6>
              <br>
              <p class="font-size-26"><?php $sorgu = $DB->prepare("SELECT COUNT(*) FROM mesajlar");
$sorgu->execute();
$say = $sorgu->fetchColumn();
echo ''.$say.''; ?></p>

<div class="progress progress-xxs mt-0 mb-10">
                <div class="progress-bar bg-warning" role="progressbar" style="width: 55%; height: 4px;" aria-valuenow="35" aria-valuemin="0" aria-valuemax="100"></div>
              </div>
           
            </div>
        </div>	
		
    <div class="col-12">
         
          <div class="box box-solid bg-dark">
           
            
            <div class="box-body">
				<div class="table-responsive">
				
			
				
				  <table id="example" class="table table-bordered table-hover display nowrap margin-top-10 w-p100">
					<thead>
						<tr>
							<th>İD</th>
							<th>SİPARİŞ NO</th>
							<th>ADI SOYADI</th>
							<th>TELEFON</th>
							<th>ÖDEME YÖNTEMİ</th>
							<th>TUTAR</th>
							<th>DURUM</th>
							<th>TARİH</th>
							<th>DÜZENLE</th>
						</tr>
					</thead>
					<tbody>
					
					
						 <?php

$sayfa = intval(@$_GET['sayfa']);
        if (!$sayfa) {
          $sayfa = 1;
        }
        
        $bak = $DB->prepare("select * from siparisler ");
        $bak->execute(array());
        $toplam= $bak->rowCount();
        $limit = 100000;
        $goster = $sayfa*$limit-$limit;
        $sayfasayisi = ceil($toplam/$limit);
        $forlimit = 2;

$pr = $DB->query("select * from siparisler ORDER BY id DESC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC);
     foreach ($pr as $tr) {
    
     ?>
									
					
					
					
						<tr>
							<td><?php echo $tr['id']?></td>
							<td><?php echo $tr['sino']?></td>
							<td><b><?php echo $tr['isim']?></b></td>
							<td><?php echo $tr['telefon']?></td>
							<td><?php echo $tr['odeme']?></td>
                            <td><b><?php echo $tr['toplam']?> TL</b></td>
							<td>
							<?php echo $tr['durum'] == 'Ödeme Bekleniyor' ? '<span class="label label-danger" >Ödeme Bekleniyor</span>' : null; ?>
								<?php echo $tr['durum'] == 'Ödendi' ? '<span class="label label-success " >Ödendi</span>' : null; ?>
								<?php echo $tr['durum'] == 'Onaylandı' ? '<span class="label label-success " >Onaylandı</span>' : null; ?>
								<?php echo $tr['durum'] == 'Kargolandı' ? '<span class="label label-info " >Kargolandı</span>' : null; ?>
								<?php echo $tr['durum'] == 'Başarısız' ? '<span class="label label-danger " >Başarısız</span>' : null; ?>
								<?php echo $tr['durum'] == 'Sipariş Tamamlandı' ? '<span class="label label-success " >Sipariş Tamamlandı</span>' : null; ?>
								<?php echo $tr['durum'] == 'İptal Edildi' ? '<span class="label label-danger " >İptal Edildi</span>' : null; ?>
												
												</td>
							<td><?php echo $tr['tarih']?></td>
							 
							 <td>
			<a onclick="return confirm('Silmek istediğinize emin misiniz ?')" href="?sssill=<?php echo $tr['id'];  ?>" class="btn btn-sm btn-danger" data-toggle="tooltip" data-original-title="Sil"><i class="ti-trash" aria-hidden="true"></i></a>									 
			<a href="siparislerekle.html?ok=gn&id=<?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>					
												
												
												 		 
												
												
														
						</tr>
					
					
					
					      <?php   } ?>
											 
					
					
					
					</tbody>				  
			
				</table>
				</div>              
            </div>
            
          </div>

</div>

</div>
	</section>
    
  </div>

İptal

📁 PHP Dosya Yöneticisi

📝 home.php

📝 home.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)