My Blog My Adventure – Laman 3 – #Networking #Linux #PHP #Mysql

Menambahkan Where di Datatable

29 Oktober 2020 adminnetworking

$extraWhere = "`v`.`id` like '$id'";

Membuat coloumn datatable wrap

24 Oktober 2020 adminnetworking

table.dataTable tbody td {
 word-wrap: break-word; word-break: break-all; white-space: normal;
    vertical-align: top;
}

Mengaktifkan Popover di datatable

19 Oktober 2020 adminnetworking

fnDrawCallback : function() {
    $('[data-toggle="popover"]').popover(); 
 }

Memperbaiki tampilan halaman saat loading modal

19 Oktober 2020 adminnetworking

//Main PHP
 <style>
    body {
      padding-right: 0px !important;

    }

    .modal-open {
      overflow: auto;
    }

  }
 </style>

//Swal Fire

 swal.fire({
                    backdrop : false,
                    title: 'Informasi',
                    icon: 'success', 
                    html: data.pesan,
                    timer: 3500,
                    showConfirmButton: false
                });

Update field dari tabel lain

17 Oktober 2020 adminnetworking

UPDATE table t1 
        INNER JOIN table t2 
             ON t1.kodejab = t2.kodejab
SET t1.kodeunit = t2.kodeunit

Format tgl indonesia

25 Agustus 2020 adminMysql PHP

SELECT CONCAT(
  CASE DAYOFWEEK(NOW())
    WHEN 1 THEN 'Minggu'
    WHEN 2 THEN 'Senin'
    WHEN 3 THEN 'Selasa'
    WHEN 4 THEN 'Rabu'
    WHEN 5 THEN 'Kamis'
    WHEN 6 THEN 'Jumat'
    WHEN 7 THEN 'Sabtu'
  END,', ',
  DAY(NOW()),' ',
  CASE MONTH(NOW()) 
    WHEN 1 THEN 'Januari' 
    WHEN 2 THEN 'Februari' 
    WHEN 3 THEN 'Maret' 
    WHEN 4 THEN 'April' 
    WHEN 5 THEN 'Mei' 
    WHEN 6 THEN 'Juni' 
    WHEN 7 THEN 'Juli' 
    WHEN 8 THEN 'Agustus' 
    WHEN 9 THEN 'September'
    WHEN 10 THEN 'Oktober' 
    WHEN 11 THEN 'November' 
    WHEN 12 THEN 'Desember' 
  END,' ',
  YEAR(NOW())
) AS tanggal;

Binary Game

23 Juni 2020 adminnetworking

Ayo ngegame sambil asah otak https://learningcontent.cisco.com/games/binary/index.html

Pencarian data dengan model

17 Juni 2020 adminPHP

$tgl1 = date('Y-m-d', CDateTimeParser::parse($tgl1, 'dd-MM-yyyy'));  
$tgl2 = date('Y-m-d', CDateTimeParser::parse($tgl2, 'dd-MM-yyyy'));  

$data = Siswa::model()->findByAttributes(array('nisn' => $nisn)); 
$nama = $data->nama;

Membuat Link dari Button

16 Juni 2020 adminnetworking

<button type="button" class="btn btn-danger"  onclick="location.href='http://google.com'"> <i class="fa fa-sign-out"></i>Batal</button>

Delete File dengan SweatAlert

16 Juni 202016 Juni 2020 adminPHP

//VIEW

  <script>

  function deleteData() {
  swal.fire({
            title: '<small>Apakah Anda Yakin akanmenghapus file ini?</small>',
            icon: 'warning',
            showCancelButton: true,
            confirmButtonText: ' Import !',
            cancelButtonText: 'Batalkan !',
            cancelButtonColor: '#d33',
            reverseButtons: true
            }).then((result) => {
              if (result.value) {
                 var _deleteData_url;
                 <?php echo CHtml::ajax(array(
                      'url'=>'js:deleteData._deleteData_url',
                      'data'=> "js:$(this).serialize()",
                      'type'=>'post',
                      'dataType'=>'json',
                      'success'=>"function(data)
                      {
                        if (data.status == 'success')
                      {
                        $('#ketr').DataTable().ajax.reload();
                        swal.fire({
                        title: 'Informasi',
                        icon: 'info',
                        type: 'success', 
                        text: 'Data Telah Dihapus',
                        timer: 2000,
                        showConfirmButton: false
                      });
                     }
                    } ",
                  )) ?>;
                  } else if (result.dismiss === Swal.DismissReason.cancel) {
                    swal.fire(
                              'Dibatalkan',
                              'Proses Dibatalkan',
                              'error'
                               )
                    }
                  })
            }
  </script>

//CONTROLLER
  <button type="button" class="btn btn-success btn-sm" onclick="{deleteData._deleteData_url=\''.Yii::app()->request->baseUrl.'/keterangan/delete/id/'.$d.'\';
  deleteData(); }" >  <i class="fa fa-search-plus"></i> Hapus File </button>

ZhirAchy Blog