PHP Dosya Yöneticisi

<?php

if (isset($_GET['sill'])) {
	
$id = intval($_GET['sill']);
$verisil = $DB->prepare("delete from destek 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>' ;
}}
   if (isset($_POST['uguncelle'])) {
                              $id   = $_POST['id'];
							  $durum   = $_POST['durum'];
							  $cevap   = $_POST['cevap'];
							  
								
$ekle = $DB->prepare("UPDATE  destek SET durum='$durum' WHERE id=?");
$ekle->execute(array($id));

$not = ' <div class="alert alert-success">
					                    <button class="close" data-dismiss="alert"><i class="pci-cross pci-circle"></i></button>
					                    <strong>Destek Durumu Başarıyla Güncellendi. !</strong>
					                </div>' ;

}

?>
     
  
  <div class="content-wrapper">
    
    <section class="content-header">
      <h1>
        Destek Merkezi
      </h1>
      <ol class="breadcrumb">
        <li class="breadcrumb-item"><a href="index.html"><i class="fa fa-home"></i> Anasayfa</a></li>
      
        <li class="breadcrumb-item active">Gelen Destek Talepleri</li>
      </ol>
	  <?=$not?>
    </section>

<section class="content">
	
      <div class="row">
        <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>DESTEK NO</th>
							<th>SİPARİŞ NO</th>
							<th>ÜYE</th>
							<th>KONU</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 destek ");
        $bak->execute(array());
        $toplam= $bak->rowCount();
        $limit = 100000;
        $goster = $sayfa*$limit-$limit;
        $sayfasayisi = ceil($toplam/$limit);
        $forlimit = 2;

$pr = $DB->query("select * from destek ORDER BY id DESC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC);
     foreach ($pr as $tr) {
    
     ?>
				<?php $uye = $tr['uye'];?>						
					
					
					
						<tr>
							<td>#<?php echo $tr['mid'];?></td>
																		
														 <td><a target="_blank" href="siparislerekle.html?ok=gn&id=<?php echo $tr['sino']?>"/><b><?php echo $tr['sino']?></b></a></td>
														 
	                                          
											  
		    <?php $uyebul = $DB->query("select * from uyeler where durum='1' and uyeId='$uye' order by uyeId asc limit 1")->fetchAll(PDO::FETCH_ASSOC); 
            foreach($uyebul as $uyeb){
			?>		  
											  
											  
													 <td><a target="_blank" href="uyelerekle.html?ok=gn&uyeId=<?php echo $uyeb['uyeId']?>"/><b><?php echo $uyeb['isim']?></b></a></td>
								
<?php } ?>

<td><span class="text-muted"><?php echo $tr['konu']?></span></td>
														
														
														
														
						
														           <td>
														
														<?php echo $tr['durum'] == '0' ? ' <div class="label label-table label-danger">Okunmadı</div>' : null; ?>
														
					                                       <?php echo $tr['durum'] == '1' ? ' <div class="label label-table label-success">Okundu</div>' : null; ?>
														
															  <?php echo $tr['durum'] == '2' ? ' <div class="label label-table label-info">Cevaplandı</div>' : null; ?>
														 <?php echo $tr['durum'] == '3' ? ' <div class="label label-table label-info">Kapatıldı</div>' : null; ?>
														     <form method="POST" action=""> 
															 <select style="width: 88px;
max-height: 40px !important;
margin-top: 10px;" name="durum" onchange="this.form.submit()">
															 <option value="0">Okunmadı</option>
															  <option value="1">Okundu</option>
															   <option value="2">Cevaplandı</option>
															    <option value="3">Kapatıldı</option>
																
														     <select>
															<input type="hidden" name="id" value="<?php echo $tr['id']?>">
																<input type="hidden" name="uguncelle">
															</form>
															
															
															
					                                    </td>
							<td><?php echo $tr['tarih']?></td>
							 
							 <td>
			<a onclick="return confirm('Silmek istediğinize emin misiniz ?')" href="?sill=<?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="desteklerekle.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

📝 destekler.php

📝 destekler.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)