Contekan datatables export


CSS


<link rel="stylesheet" href="https://cdn.datatables.net/1.11.4/css/jquery.dataTables.min.css">
<link rel="stylesheet" href="https://cdn.datatables.net/buttons/2.2.2/css/buttons.dataTables.min.css">

Javascript


<script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.3/js/select2.min.js"></script>
<script src="https://cdn.datatables.net/1.11.3/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.0.1/js/dataTables.buttons.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
<script src="https://cdn.datatables.net/buttons/2.0.1/js/buttons.html5.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.0.1/js/buttons.print.min.js"></script>




<script>
$(document).ready(function() {
  $('.exporting-table').DataTable( {
      "ordering": false,
      "paging": false,
      "searching": false,
      dom: 'Bfrtip',
      buttons: [
        'copy', 'csv', 'excel', 'pdf', 'print'
      ]
    } );
});
</script>



Html

<table class="exporting-table"></table>

Komentar

Posting Komentar

Postingan populer dari blog ini

Contekan reset password mysql di ubuntu

Script Ubuntu : sudo systemctl stop mysql sudo systemctl set-environment MYSQLD_OPTS="--skip-networking --skip-grant-tables" sudo systemctl start mysql sudo mysql -u root Script MYSQL : mysql> flush privileges; mysql> use mysql; mysql> ALTER USER  'root'@'localhost' IDENTIFIED BY 'password_baru'; mysql> flush privileges; mysql> quit; Script Ubuntu lagi : sudo systemctl unset-environment MYSQLD_OPTS
Baca selengkapnya

Contekan datatable untuk mengatasi pagination reset ketika reload

 Berikut Script untuk handle pagination yang reset ke halaman satu ketika melakukan reload halaman. Untuk penggunaan asset lengkap nya bisa dilihat disini . < script > $ ( document ). ready ( function () { $ ( '.exporting-table' ). DataTable ( { stateSave: true , // tambahkan script ini "ordering" : false , "paging" : false , "searching" : false , dom: 'Bfrtip' , buttons: [ 'copy' , 'csv' , 'excel' , 'pdf' , 'print' ] } ); }); </ script >
Baca selengkapnya