sebagian table di html2pdf ga muncul

assalamualaikum, permisi agan2 mau bertanya kenapa ya ane mau memunculkan $hasil tidak mucnul tp ketika $hasil tersebut dihapus maka tablenya muncul.. terimaksih.. mohon bantuannya..

 <link rel="stylesheet" type="text/css" href="style.css">
<?php
	extract($_POST);
	ob_start();
	mysql_connect("localhost","root","");
	mysql_select_db("skp");
	require ("html2pdf/html2pdf.class.php");
	$now = date('d-m-Y');
	$filename="account.pdf";
	$content = ob_get_clean();
	$atasan = $_GET['atasan'];
	$penilai = $_GET['penilai'];
	$dinilai = $_GET['dinilai'];
	$tahun = $_GET['tahun'];
	$sql="SELECT * FROM user WHERE nip =".$atasan;
	$sqlsa="SELECT * FROM user WHERE nip = ".$penilai;
	$sqldu="SELECT * FROM user WHERE nip = ".$dinilai;
	$rata = mysql_query("select round(sum(nilai)/count(tahun),2) AS rata_rata from penilaian where tahun = '".$tahun."' AND dinilai='".$dinilai."'");
	$nilai="SELECT * FROM perilaku WHERE dinilai = '".$_GET['dinilai']."' AND tahun = '".$_GET['tahun']."'";
	$content = "<br><br><br><br><br><br><table align=center border=0 style='padding-bottom: 5px; font-size: 18pt;'>
				<tr><td align=center><img src=images/garuda.jpg height=120 width=120></td></tr>
				<tr><th align=center>PENILAIAN PRESTASI KERJA<br>PEGAWAI NEGERI SIPIL</th></tr>
				</table>
				<table border=0 style='padding-bottom: 5px; font-size: 12pt;'>
				<tr><td width=350>BADAN KEPEGAWAIAN DAERAH</td><td width=350 align=right>JANGKA WAKTU PENILAIAN<br>1 Januari s/d Desember $tahun</td></tr>
				</table>
				<table align=center border=1 style='padding-bottom: 5px; font-size: 14pt;'>";
		$hasil1=mysql_query($sqldu);
		while($row=mysql_fetch_assoc($hasil1)){
				$content.="<tr><td rowspan=6 style='height: 60mm;'>1.</td><td colspan=5 style='width=600;'>YANG DINILAI</td></tr>
				<tr><td >a. NAMA</td><td colspan=4>$row[nama]</td></tr>
				<tr><td >b. NIP</td><td colspan=4>$row[nip]</td></tr>
				<tr><td >c. Pangkat, golongan ruang</td><td colspan=4>$row[pangkat_gol]</td></tr>
				<tr><td >d. Jabatan/Pekerjaan</td><td colspan=4>$row[jabatan]</td></tr>
				<tr><td >Unit Organisasi</td><td colspan=4>$row[unit_kerja]</td></tr>";
				}
		$hasil2=mysql_query($sqlsa);
		while($row=mysql_fetch_assoc($hasil2)){
				$content.="<tr><td rowspan=6 style='height: 60mm;'>2.</td><td colspan=5>PEJABAT PENILAI</td></tr>
				<tr><td colspan=1>a. NAMA</td><td colspan=4>$row[nama]</td></tr>
				<tr><td colspan=1>b. NIP</td><td colspan=4>$row[nip]</td></tr>
				<tr><td colspan=1>c. Pangkat, golongan ruang</td><td colspan=4>$row[pangkat_gol]</td></tr>
				<tr><td colspan=1>d. Jabatan/Pekerjaan</td><td colspan=4>$row[jabatan]</td></tr>
				<tr><td colspan=1>e. Unit Organisasi</td><td colspan=4>$row[unit_kerja]</td></tr>";
				}
		$hasil3=mysql_query($sql);
		while($row=mysql_fetch_assoc($hasil3)){
				$content.="<tr><td rowspan=6 style='height: 60mm;'>3.</td><td colspan=5>ATASAN PEJABAT PENILAI</td></tr>
				<tr><td colspan=1>a. NAMA</td><td colspan=4>$row[nama]</td></tr>
				<tr><td colspan=1>b. NIP</td><td colspan=4>$row[nip]</td></tr>
				<tr><td colspan=1>c. Pangkat, golongan ruang</td><td colspan=4>$row[pangkat_gol]</td></tr>
				<tr><td colspan=1>d. Jabatan/Pekerjaan</td><td colspan=4>$row[jabatan]</td></tr>
				<tr><td colspan=1>e. Unit Organisasi</td><td colspan=4>$row[unit_kerja]</td></tr>
				";
				}
	$row2 = mysql_fetch_array($rata);{
	$content.="	<tr><td rowspan=11 style='height: 60mm;'>4.</td><td colspan=4>UNSUR YANG DINILAI</td><td>Jumlah</td></tr>
				<tr><td colspan=4>a. Sasaran Kerja Pegawai (SKP) $row2[rata_rata] x 60%</td><td>".$row2['rata_rata']*0.6."</td></tr>";
				}
	$hasil=mysql_query($nilai);
		while($row1=mysql_fetch_assoc($hasil)){
				$content.="<tr><td align=top rowspan=9>b. Perilaku <br>  Kerja</td>
				<td>1. Orientasi Pelayanan</td><td>$row1[orietasi_pel]</td><td>baik</td><td rowspan=8></td></tr>
				<tr><td>2. Integritas</td><td>$row1[integritas]</td><td></td></tr>
				<tr><td>3. Komitmen</td><td>$row1[komitmen]</td><td></td></tr>
				<tr><td>4. Disiplin</td><td>$row1[disiplin]</td><td></td></tr>
				<tr><td>5. Kerjasama</td><td>$row1[kerjasam]</td><td></td></tr>
				<tr><td>6. Kepemimpinan</td><td>$row1[kepemimpinan]</td><td></td></tr>
				<tr><td>Jumlah</td><td>$row1[jumlah]</td><td></td></tr>
				<tr><td>Nilai Rata-rata</td><td>$row1[rata_rata]</td><td></td></tr>
				<tr><td colspan=3>Nilai Perilaku Kerja</td><td></td></tr>
				<tr><td colspan=5>Nilai Prestasi Kerja</td><td></td></tr>
				<tr></tr>";
				}
	$content.="</table>";

	ob_end_clean();
	// conversion HTML => PDF
	try
	{
		$html2pdf = new HTML2PDF('P', 'Legal','fr', false, 'ISO-8859-15',array(10, 10, 10, 10));
		$html2pdf->setDefaultFont('Times');
		$html2pdf->writeHTML($content, isset($_GET['vuehtml']));
		$html2pdf->Output($filename);
	}
	catch(HTML2PDF_exception $e) { echo $e; }
?>

avatar ghifargoodunk
@ghifargoodunk

81 Kontribusi 3 Poin

Diperbarui 6 tahun yang lalu

Belum ada Jawaban. Jadi yang pertama Jawaban

Login untuk ikut Jawaban