PHP Dosya Yöneticisi

<?php

require 'header.php';
yetkikontrol(e);
if (isset($_POST['mailsilme'])) {
  $sonuc=$crud->silme("mailler","mail_id",$_POST['mail_id']);
 
  if ($sonuc['sonuc']) {
    le(s,$_POST['mail_baslik']." başlıklı mail kaydını sildi.");
     header("location:mailler?durum=ok");
    exit;
  } else {
    header("location:mailler?durum=no");
    exit;
  }
} 
?>

<div class="container-fluid">

<h1 class="h3 mb-2 text-gray-800">Mailler</h1>
  <p class="mb-4">Buradan Daha Önce Göndermiş Olduğunuz Mailleri Görebilirsiniz...</p>

<div class="card card-primary br-1 shadow mb-4">
    <div class="card-header py-3">
      <h6 class="m-0 font-weight-bold text-primary">Mailler</h6>
    </div>
    <div class="card-body" style="width: 100%">
      <button type="button"class="btn btn-sm btn-info icon-split mobilgoster">
        <span class="icon text-white-65">
          <i class="fas fa-edit"></i>
        </span>
        <span class="text">Seçenekler</span>
      </button>
      
      
      <span class="dropdown no-arrow">
       <button data-toggle="dropdown" aria-expanded="false" type="button" id="aktarmagizleme" style="margin-left: 4px;" class="btn btn-sm btn-primary icon-split dropdown-toggle mb-2">
        <span class="icon text-white-65">
          <i class="fas fa-file-export"></i>
        </span>
        <span class="text">Dışa Aktar</span>
      </button> 
      <div class="dropdown-menu" aria-labelledby="aktarmagizleme">
        <a class="dropdown-item" href="#"> <button type="button" onclick="fnAction('copy');" title="asdsad" attr="Tabloyu Kopyala" class="btn btn-sm icon-split btn-dark">
          <span class="icon text-white-65"><i class="fas fa-copy"></i></span>
          <span class="text">Kopyala</span>
        </button></a>
        <a class="dropdown-item" title="">  <button type="button" onclick="fnAction('excel');" attr="Excel Formatında Dışa Aktar" class="btn btn-sm icon-split btn-success">
          <span class="icon text-white-65"><i class="fas fa-file-excel"></i></span>
          <span class="text">Excel</span>
        </button></a>
        <a class="dropdown-item" href="#"><button type="button" onclick="fnAction('pdf');" attr="PDF Formatında Dışa Aktar" class="btn btn-sm icon-split btn-danger"><span class="icon text-white-65"><i class="fas fa-file-pdf"></i></span>
          <span class="text">PDF</span>
        </button></a>
        <a class="dropdown-item" href="#"><button type="button" onclick="fnAction('csv');" attr="CSV Formatında Dışa Aktar" class="btn btn-sm icon-split btn-primary">
          <span class="icon text-white-65"><i class="fas fa-file-csv"></i></span>
          <span class="text">CSV</span>
        </button></a>
      </div>
    </span>

<div class="table-responsive">
      <table class="table table-bordered" id="mailtablosu" width="100%" cellspacing="0">
        <thead>
          <tr> 
            <th>No</th>
            <th>Mail Başlık</th>
            <th>Gönderen İsmi</th>
            <th>Gönderilen Mail</th>
            <th>Gönderilme Tarihi</th>
            <th>Mail Türü</th>
            <th>İşlemler</th>
          </tr>
        </thead>
        
        <tbody>
         <?php 
         $say=0;
         $mailsor=$db->prepare("SELECT * FROM mailler ORDER BY mail_id DESC");
         $mailsor->execute();
         while ($mailcek=$mailsor->fetch(PDO::FETCH_ASSOC)) {$say++?>
           <tr>
            <td><?php echo $say; ?></td>
            <td><?php echo $mailcek['mail_baslik']; ?></td>
            <td><?php echo $mailcek['gonderen_isim']; ?></td>
            <td><?php echo $mailcek['gonderilen_mail']; ?></td>
            <td><?php echo $mailcek['gonderilme_tarihi']; ?></td>
            <td><?php echo $mailcek['mail_tur']; ?></td>
            <td>

</div>
          </td>   
        </tr>
      <?php } ?>
    </tbody>
    <tfoot>
      <tr> 
        <th>No</th>
        <th>Mail Başlık</th>
        <th>Gönderen İsmi</th>
        <th>Gönderilen Mail</th>
        <th>Gönderilme Tarihi</th>
        <th>Mail Türü</th>
        <th>İşlemler</th>
      </tr>
    </tfoot>
    
  </table>
</div>
</div>
</div>

</div>

<?php include'footer.php' ?>

column
          .search( val ? '^'+val+'$' : '', true, false )
          .draw();
        });

column.data().unique().sort().each( function ( d, j ) {
          var val = $('<div/>').html(d).text();
          
          if (val.length>29) {
            filtremetin =  val.substr(0,30)+"...";
          } else {
            filtremetin=val;
          }
          select.append( '<option value="' + val + '">' + filtremetin + '</option>' )
        });

});
    },
    "ordering": true,  //Tabloda sıralama özelliği gözüksün mü? true veya false
    "searching": true,  //Tabloda arama yapma alanı gözüksün mü? true veya false
    "lengthChange": true, //Tabloda öğre gösterilme gözüksün mü? true veya false
    "info": true,
    colReorder: true,
    stateSave:  true,
    responsive: {
      details: true
    },

stateSaveParams: function (settings, data) {
      data.search.search = "";
      console.log(data);
      delete data.search;
      delete data.columns;
      delete data.order;
      console.log(data);
    },
    dom: "<'row mobilgizleexport gizlemeyiac'<'col-md-6'l><'col-md-6'f><'col-md-4 d-none d-print-block'B>>rtip",
    buttons: [
    {
      extend: 'copyHtml5', 
      className: 'kopyalama-buton'
    },
    {
      extend: 'excelHtml5', 
      className: 'excel-buton'
    },
    {
     extend: 'pdfHtml5',
     className: 'pdf-buton'
   },
   {
    extend: 'csvHtml5',
    className: 'csv-buton'
  }
  ]
});
  //Sonradan yapılan butona tıklandığında asıl dışa aktarma butonunun çalışması
  function fnAction(action) {
    switch (action) {
      case "excel":
      $('.excel-buton').trigger('click');
      break;
      case "pdf":
      $('.pdf-buton').trigger('click');
      break;
      case "copy":
      $('.kopyalama-buton').trigger('click');
      break;
      case "csv":
      $('.csv-buton').trigger('click');
      break;
    }
  }

</script>

İptal

📁 PHP Dosya Yöneticisi

📝 mailler.php

📝 mailler.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)