Advertisement
rasyid03

printtable

Jun 13th, 2023
43
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.91 KB | None | 0 0
  1. function printTable() {
  2. var tableContents = '<table class="table table-bordered table-striped">';
  3. tableContents += '<thead><tr>';
  4. tableContents += '<th>No</th>';
  5. tableContents += '<th>NIK</th>';
  6. tableContents += '<th>Nama</th>';
  7. tableContents += '<th>JK</th>';
  8. tableContents += '<th>Alamat</th>';
  9. tableContents += '<th>No KK</th>';
  10. tableContents += '</tr></thead>';
  11. tableContents += '<tbody>';
  12.  
  13. <?php
  14. $no = 1;
  15. $sql = $koneksi->query("SELECT p.id_pend, p.nik, p.nama, p.jekel, p.desa, p.rt, p.rw, a.id_kk, k.no_kk, k.kepala from
  16. tb_pdd p left join tb_anggota a on p.id_pend=a.id_pend
  17. left join tb_kk k on a.id_kk=k.id_kk where status='Ada'");
  18. while ($data = $sql->fetch_assoc()) {
  19. ?>
  20. tableContents += '<tr>';
  21. tableContents += '<td><?php echo $no++; ?></td>';
  22. tableContents += '<td><?php echo $data['nik']; ?></td>';
  23. tableContents += '<td><?php echo $data['nama']; ?></td>';
  24. tableContents += '<td><?php echo $data['jekel']; ?></td>';
  25. tableContents += '<td><?php echo $data['desa']; ?> RT <?php echo $data['rt']; ?>/ RW <?php echo $data['rw']; ?>.</td>';
  26. tableContents += '<td><?php echo $data['no_kk']; ?>-<?php echo $data['kepala']; ?></td>';
  27. tableContents += '</tr>';
  28. <?php
  29. }
  30. ?>
  31.  
  32. tableContents += '</tbody></table>';
  33.  
  34. var printWindow = window.open('', '', 'height=500,width=800');
  35. printWindow.document.write('<html><head><title>Data Penduduk</title>');
  36. printWindow.document.write('<style>table{border-collapse: collapse;}th, td{border: 1px solid black;padding: 5px;}</style>');
  37. printWindow.document.write('</head><body>');
  38. printWindow.document.write('<h1>Data Penduduk</h1>');
  39. printWindow.document.write(tableContents);
  40. printWindow.document.write('</body></html>');
  41. printWindow.document.close();
  42. printWindow.print();
  43. }
  44.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement