'; $query="SELECT a.*,(a.insentif+a.kerajinan+a.laind) AS penambahan,(a.pinjaman+a.bpjs+a.potongan+a.laink) AS pengurangan,b.`employees_name`,c.`position_name`,b.employees_code,(a.gpokok+a.kerajinan+a.insentif+a.laind) as dapat,(a.pinjaman+a.bpjs+a.potongan+a.laink) as keluar FROM slipgaji a LEFT JOIN employees b ON a.`nip`=b.`id` LEFT JOIN enae6276_dbabsen.`position` c ON c.`position_id`=b.`position_id` LEFT JOIN building d ON d.`building_id`=b.`building_id` where b.employees_code='$nip' ORDER BY b.`building_id`,a.`nip`,a.`tgl` DESC"; $result = $connection->query($query); if($result->num_rows > 0){ $no=0; while ($row= $result->fetch_assoc()) { $no++; echo' ';}} echo'

No	Tanggal	Gapok	Insentif	Kerajinan	LainLain	Pendapatan	Potongan	BPJS	Pinjaman	LainLain	Pengeluaran	Netto
'.$no.'	'.$row['tgl'].'	'.number_format($row['gpokok']).'	'.number_format($row['insentif']).'	'.number_format($row['kerajinan']).'	'.number_format($row['laind']).'	'.number_format($row['dapat']).'	'.number_format($row['potongan']).'	'.number_format($row['bpjs']).'	'.number_format($row['pinjaman']).'	'.number_format($row['laink']).'	'.number_format($row['keluar']).'	'.number_format($row['netto']).'