Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function printTable() {
- var tableContents = '<table class="table table-bordered table-striped">';
- tableContents += '<thead><tr>';
- tableContents += '<th>No</th>';
- tableContents += '<th>NIK</th>';
- tableContents += '<th>Nama</th>';
- tableContents += '<th>JK</th>';
- tableContents += '<th>Alamat</th>';
- tableContents += '<th>No KK</th>';
- tableContents += '</tr></thead>';
- tableContents += '<tbody>';
- <?php
- $no = 1;
- $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
- tb_pdd p left join tb_anggota a on p.id_pend=a.id_pend
- left join tb_kk k on a.id_kk=k.id_kk where status='Ada'");
- while ($data = $sql->fetch_assoc()) {
- ?>
- tableContents += '<tr>';
- tableContents += '<td><?php echo $no++; ?></td>';
- tableContents += '<td><?php echo $data['nik']; ?></td>';
- tableContents += '<td><?php echo $data['nama']; ?></td>';
- tableContents += '<td><?php echo $data['jekel']; ?></td>';
- tableContents += '<td><?php echo $data['desa']; ?> RT <?php echo $data['rt']; ?>/ RW <?php echo $data['rw']; ?>.</td>';
- tableContents += '<td><?php echo $data['no_kk']; ?>-<?php echo $data['kepala']; ?></td>';
- tableContents += '</tr>';
- <?php
- }
- ?>
- tableContents += '</tbody></table>';
- var printWindow = window.open('', '', 'height=500,width=800');
- printWindow.document.write('<html><head><title>Data Penduduk</title>');
- printWindow.document.write('<style>table{border-collapse: collapse;}th, td{border: 1px solid black;padding: 5px;}</style>');
- printWindow.document.write('</head><body>');
- printWindow.document.write('<h1>Data Penduduk</h1>');
- printWindow.document.write(tableContents);
- printWindow.document.write('</body></html>');
- printWindow.document.close();
- printWindow.print();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement