Untitled

<?php
 // Define relative path from this script to mPDF
 $nama_dokumen='PDF With MPDF'; //Beri nama file PDF hasil.
define('_MPDF_PATH','MPDF57/');
include(_MPDF_PATH . "mpdf.php");
$mpdf=new mPDF('utf-8', 'A4'); // Create new mPDF Document
$mpdf->AddPage('L','','','','',10,10,10,10,18,12);

//Beginning Buffer to save PHP variables and HTML tags
ob_start();
?>

<?php
include ('../config/koneksi.php');
$bulan   = $_GET['bulan'];
$tahun = $_GET['tahun'];
?>
<html>
<head>
<title>Contoh Pengambilan Data Jamak</title>
</head>
<body>

<h2>Daftar Biodata</h2>
<table width="600px" border="1" style="border-collapse:collapse">
<tr style="background:#ccc">
<th>ID</th>
<th>Nama Puskesmas</th>
<th>Alamat</th>
<th>Jenis Puskesmas</th>
<th>Kode Pos</th>
<th>Nama Kontak</th>
<th>Telepon</th>
<th>Email</th>
<th>Bulan</th>
<th>Tahun</th>
<th>Latitude</th>
<th>Longitude</th>
<th>Luas Wilayah</th>
<th>Jumlah Desa</th>
<th>Jumlah Penduduk</th>
<th>Lokasi Strategis</th>
<th>Lokasi Geografis</th>


</tr>
<?php

$sql = "SELECT * FROM identitas_puskesmas ip inner join karakteristik_puskesmas kp on ip.id_puskesmas=kp.id_puskesmas WHERE bulan='$bulan' AND tahun='$tahun'";
$hasil = mysql_query($sql) or exit("Error query: <b>".$sql."</b>.");
while($data = mysql_fetch_assoc($hasil)){ ?>
<tr>
<td align="center"><?php echo $data['id_puskesmas']; ?></td>
<td><?php echo $data['nama_puskesmas']; ?></td>
<td><?php echo $data['alamat']; ?></td>
<td><?php echo $data['jenis_puskesmas']; ?></td>
<td><?php echo $data['kode_pos']; ?></td>
<td><?php echo $data['nama_kontak']; ?></td>
<td><?php echo $data['telepon']; ?></td>
<td><?php echo $data['email']; ?></td>
<td><?php echo $data['bulan']; ?></td>
<td><?php echo $data['tahun']; ?></td>
<td><?php echo $data['lattitude']; ?></td>
<td><?php echo $data['longitude']; ?></td>
<td><?php echo $data['luas_wilayah']; ?></td>
<td><?php echo $data['jml_desa']; ?></td>
<td><?php echo $data['jml_penduduk']; ?></td>
<td><?php echo $data['lokasi_strategis']; ?></td>
<td><?php echo $data['lokasi_geografis']; ?></td>
</tr>
<?php
}
?>
</table>
</body>
</html>

<?php
$html = ob_get_contents(); //Proses untuk mengambil hasil dari OB..
ob_end_clean();
//Here convert the encode for UTF-8, if you prefer the ISO-8859-1 just change for $mpdf->WriteHTML($html);
$mpdf->WriteHTML(utf8_encode($html));
$mpdf->Output($nama_dokumen.".pdf" ,'I');
exit;
?>