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]; } } }
Penulis: admin
Port Game
GAME PORTS ——————— PUBG Mobile TCP : 7889,10012,17500,18081 UDP : 8011,9030,10010-10650,11000-14000,17000,20000,20001,20002 PUBG PC TCP: 27015-27030,27036-27037 UDP: 4380,27000-27031,27036 FREE FIRE TCP : 7006,14000,20561,39698,39779,39003 UDP : 7008,10000-10009,17000 MOBILE LEGENDS TCP : 5500-5700,8001,30000-30300,9000-9010 30097-30147,30000-30150,9001,30101-30105,5057,5228,5001-5009, 5520-5529,5551,5651,5153 UDP : 5000-5200,5500-5700,8001,30000-30300,9000-9010 5601-5602,5025,5605,5005,5503,5101-5109,5001-5009,30101, 5520-5529,5020-5024,5501-5509,5517 POINT BLANK TCP : 39190-39200,49001-49190 UDP : 40000-40010 AOV TCP : 10001-10094 UDP : 10101-10201,10080-10110,17000-18000 GARENA LEAGUE OF
PhPexcel dari baris mysql
foreach($data as $f ) { //$worksheet->getStyle(‘A’.$row1)->getNumberFormat()->setFormatCode($textFormat); $worksheet->setCellValue(‘A’.$row1, $no.chr(46)); $worksheet->setCellValue(‘B’.$row1,’ ‘.$f[‘nama’]); $spreadsheet->getActiveSheet()->getStyle(‘A’.$row1)->getNumberFormat()->setFormatCode(\PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_TEXT); $row1++; $no++; }
PHPexcel Membuat Bold
// set the font style for the entire workbook $phpExcel->getDefaultStyle()->getFont() ->setName(‘Arial’) ->setSize(14) ->setBold(true); // custom style with different font than the global one $styleArray = array( ‘font’ => array( ‘bold’ => true, ‘color’ => array(‘rgb’ => ‘FF0000’), ‘size’ => 15, ‘name’ => ‘Verdana’ )); // create some cells $phpExcel->getActiveSheet()->getCell(‘A1’)->setValue(‘Hello world’); $phpExcel->getActiveSheet()->getCell(‘A2’)->setValue(‘Hello again’); $phpExcel->getActiveSheet()->getCell(‘A3’)->setValue(‘Goodbye’); // apply
Select Max return coloumn
SELECT * FROM t1 WHERE (id,rev) IN ( SELECT id, MAX(rev) FROM t1 GROUP BY id ) SELECT * FROM Employee where Employee.Salary in (select max(salary) from Employee group by Employe_id) ORDER BY Employee.Salary
Membuat Blink
<style type=”text/css”> <!– /* @group Blink */ .blink { -webkit-animation: blink .75s linear infinite; -moz-animation: blink .75s linear infinite; -ms-animation: blink .75s linear infinite; -o-animation: blink .75s linear infinite; animation: blink .75s linear infinite; } @-webkit-keyframes blink { 0% { opacity: 1; } 50% { opacity: 1; } 50.01% { opacity: 0; } 100% {
Dropdownt dependent selected from jquery
$(‘select[name=”kode2″]’).find(‘option[value=”<?= $model->kode2 ?>”]’).attr(“selected”,true); $(‘select[name=”kode3″]’).find(‘option[value=”<?= $model->kode3 ?>”]’).attr(“selected”,true); $(‘select[name=”kode4″]’).find(‘option[value=”<?= $model->kode4 ?>”]’).attr(“selected”,true); $(‘select[name=”kode5″]’).find(‘option[value=”<?= $model->kode5 ?>”]’).attr(“selected”,true); $(‘select[name=”kode6″]’).find(‘option[value=”<?= $model->kode6 ?>”]’).attr(“selected”,true);