Merubah Format Inteeger ke String di datatable
customizeData: function(data) { for(var i = 0; i < data.body.length; i++) { for(var j = 0; j < data.body[i].length; j++) { data.body[i][j] = ‘\u200C’ + data.body[i][j]; } } }
Kategori: PHP
Query Row
$data = Yii::app()->dc->createCommand(” SELECT * from table “)->queryrow(); foreach($data as $row ) { echo $row[“data”] ; }
Format tgl indonesia
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
Pencarian data dengan model
$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;
Delete File dengan SweatAlert
//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’,
Yii Dropdown Dependent Controller
public function actionFilterjurusan() { $data=Jurusan::model()->findAll(‘id_tingkatan=:id_tingkatan’,array(‘:id_tingkatan’=>$_POST[‘id_tingkatan’])); $data=CHtml::listData($data,’id_jurusan’,’jurusan’); echo ‘<option value=””>Pilih Jurusan</option>’; foreach($data as $value=>$name) { echo CHtml::tag(‘option’,array(‘value’=>$value),CHtml::encode($name),true); } } public function actionFilterkelas() { $data=Kelas::model()->findAll(‘id_jurusan=:id_jurusan’,array(‘:id_jurusan’=>$_POST[‘id_jurusan’])); $data=CHtml::listData($data,’kelas’,’kelas’); echo ‘<option value=””>Pilih Kelas</option>’; foreach($data as $value=>$name) { echo CHtml::tag(‘option’,array(‘value’=>$value),CHtml::encode($name),true); } } public function actionFiltersiswa() { $data=Siswa::model()->findAll(‘kelas=:kelas’,array(‘:kelas’=>$_POST[‘kelas’])); $data=CHtml::listData($data,’nisn’,’nama’); foreach($data as $value=>$name) { echo CHtml::tag(‘option’,array(‘value’=>$value),CHtml::encode($name),true); } } public function actionAutocomplete() { //$id
Yii Dropdown Dependent
<?php $form=$this->beginWidget(‘CActiveForm’, array( ‘id’=>’keterangan-form’, ‘enableAjaxValidation’=>false, )); ?> <br><div class=”col-lg-12″> <div class=”card”> <div class=”card-close”> <div class=”dropdown”> <button type=”button” id=”closeCard2″ data-toggle=”dropdown” aria-haspopup=”true” aria-expanded=”false” class=”dropdown-toggle”><i class=”fa fa-ellipsis-v”></i></button> <div aria-labelledby=”closeCard2″ class=”dropdown-menu dropdown-menu-right has-shadow”><a href=”#” class=”dropdown-item remove”> <i class=”fa fa-times”></i>Close</a><a href=”#” class=”dropdown-item edit”> <i class=”fa fa-gear”></i>Edit</a></div> </div> </div> <div class=”card-header d-flex align-items-center”> <h3 class=”h4″>Input Presensi ( Izin/Sakit )</h3> </div> <div
Import Excel ke PHP
public function actionCreate() { $database = ‘karyawan’; //nama database $user = ‘user’; //nama user db $pass = ‘passwordnya’; //pass db $host = ‘localhost’; $conn = mysqli_connect($host,$user,$pass,$database); if (!$conn) { die(“Connection failed: ” . mysqli_connect_error()); exit(); } include”PHPExcel.php”; $random = “file_upload_”.date(‘Y-m-d-H-i-s’).rand(11111,99999); $target_file = Yii::app()->basePath.’/../upload/’.$random.basename($_FILES[“file_excel”][“name”]); $uploadOk = 1; if (move_uploaded_file($_FILES[“file_excel”][“tmp_name”], $target_file)) { ini_set(‘memory_limit’, ‘-1’); $objReader = PHPExcel_IOFactory::createReader(‘Excel2007’);
Menghitung Jumlah Baris di PHP
$sum = 0; while($row=mysql_fetch_array($result)){ $id = $row[‘id’]; $score = $row[‘score’]; $sum += (int)$score; } echo $sum;