Advertisement
Guest User

Untitled

a guest
Mar 28th, 2017
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.70 KB | None | 0 0
  1. <?php
  2. // Define relative path from this script to mPDF
  3. $nama_dokumen='PDF With MPDF';
  4. define('_MPDF_PATH','MPDF60/');
  5. include(_MPDF_PATH . "mpdf.php");
  6. $mpdf=new mPDF('utf-8', 'A4');
  7.  
  8. //Beginning Buffer to save PHP variables and HTML tags
  9. ob_start();
  10. ?>
  11. <!--sekarang Tinggal Codeing seperti biasanya. HTML, CSS, PHP tidak masalah.-->
  12. <!--CONTOH Code START-->
  13. <?php
  14. $dsn = "mysql:dbname=db_kircon;host=localhost";
  15. $user = "root";
  16. $pass = "";
  17.  
  18. try {
  19. $dbh = new PDO($dsn, $user, $pass);
  20. $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  21. } catch (PDOException $e) {
  22. echo "Koneksi ke database gagal: ".$e->getMessage();
  23. }
  24.  
  25. ?>
  26. <table border=1>
  27. <tr>
  28. <td>Kode KTP</td>
  29. <td>Tanggal</td>
  30. <td>Nama</td>
  31. <td>Jenis Permohonan</td>
  32. <td>Kelurahan</td>
  33. <td>Alamat</td>
  34. <td>RT</td>
  35. <td>RW</td>
  36. </tr>
  37. <?php
  38. $sql = "SELECT * FROM tbl_rktp";
  39. foreach ($dbh->query($sql) as $data) :
  40. ?>
  41. <tr>
  42. <td><?php echo $no++; ?></td>
  43. <td><?php echo $data['kode'] ?></td>
  44. <td><?php echo $data['tanggal'] ?></td>
  45. <td><?php echo $data['nama'] ?></td>
  46. <td><?php echo $data['kelurahan'] ?></td>
  47. <td><?php echo $data['permohonan'] ?></td>
  48. <td><?php echo $data['alamat'] ?></td>
  49. <td><?php echo $data['rt'] ?></td>
  50. <td><?php echo $data['rw'] ?></td>
  51. <td align="center">
  52. ?>
  53. </table>
  54. <!--CONTOH Code END-->
  55.  
  56. <?php
  57. $html = ob_get_contents(); //Proses untuk mengambil hasil dari OB..
  58. ob_end_clean();
  59. //Here convert the encode for UTF-8, if you prefer the ISO-8859-1 just change for $mpdf->WriteHTML($html);
  60. $mpdf->WriteHTML(utf8_encode($html));
  61. $mpdf->Output($nama_dokumen.".pdf" ,'I');
  62. exit;
  63. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement