Codenya : laporan.php <form action='cetak_laporan.php' method='GET'> <div class='form-group'> <div class='col-sm-4'> <select name='KRETERIA' class='form-control' required> <option value='' selected>-Pilih Kreteria PMKS-</option>"; $tampil=mysqli_query($koneksi,"SELECT * FROM mkreteria ORDER BY KDKRETERIA"); while($p=mysqli_fetch_array($tampil)){ if ($r['KDKRETERIA']==$p['KDKRETERIA']){ echo "<option value='$p[KDKRETERIA]'selected>$p[KRETERIA]</option>"; }else{ echo "<option value='$p[KDKRETERIA]'>$p[KRETERIA]</option>"; } } echo "</select> </div> </div> <button type='submit' name='submit' class='btn btn-success btn-xl'><i class='fa fa-print'></i> Cetak</button> </form> cetak_laporan.php <?php// Include file class.ezpdf dalam folder fungsiPDF include "../../../config/koneksi.php"; include "../../../config/fungsi_seo.php"; include "../../../config/library.php"; include "../../../pdf/fpdf.php"; if ($_POST[KDKRETERIA]=='Pilih KRETERIA'){ echo "Pilih dulu Kretereia.. "; } else { $pdf = new Cezpdf(); // Set margin dan font $pdf->ezSetCmMargins(3, 3, 3, 3); $pdf->selectFont('fungsiPDF/fonts/Courier.afm'); $all = $pdf->openObject(); // Tampilkan logo $pdf->setStrokeColor(0, 0, 0, 1); $pdf->addJpegFromFile('logo.jpg',20,800,69); // Teks di tengah atas untuk judul header $pdf->addText(200, 820, 16,'<b>Laporan Data Dosen</b>'); $pdf->addText(90, 800, 14,'<b>ALamat</b>'); // Garis atas untuk header $pdf->line(10, 795, 578, 795); $pdf->addText(50, 780, 8,'<b>KRETERIA :</b> '. $_POST[KRETERIA]); // Garis bawah untuk footer $pdf->line(10, 50, 578, 50); // Teks kiri bawah $pdf->addText(30,34,8,'Dicetak tgl:' . date( 'd-m-Y, H:i:s')); $pdf->closeObject(); // Tampilkan object di semua halaman $pdf->addObject($all, 'all'); // Query untuk merelasikan kedua tabel $sql = mysql_query("SELECT * FROM mkreteria WHERE KRETERIA = '$_POST[KRETERIA]'"); $i = 1; $data[$i]=array('<b>No</b>'=>$i, '<b>NIK</b>'=>$r[NIK], '<b>Nama</b>'=>$r[KRETERIA], '<b>Alamat</b>'=>$r[alamat], '<b>jk</b>'=>$r[jk], '<b>handphone</b>'=>$r[handPhone]); $i++; } $pdf->ezTable($data, '', '', ''); // Penomoran halaman $pdf->ezStartPageNumbers(320, 15, 8); $pdf->ezStream(); } ?>
|