satsu

tblmonitoring

Aug 2nd, 2015
275
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.83 KB | None | 0 0
  1. <?php
  2. include_once "ceksesi.php";
  3. $nama=$_SESSION['namauser'];
  4. $level=$_SESSION['leveluser'];
  5. $norw=$_SESSION['rw'];
  6. $nort=$_SESSION['rt'];
  7. echo "Anda Login Sebagai : $level";
  8. ?>
  9. <p><a href="fmonitoring.php">Back</a></p>
  10.  
  11.  
  12. <table width="100%" border="1" align="center" bordercolor="#0000FF">
  13.   <tr>
  14.     <th width="39" bgcolor="#CCCCCC" scope="col">No</th>
  15.     <th width="124" bgcolor="#CCCCCC" scope="col">No KK</th>
  16.     <th width="265" bgcolor="#CCCCCC" scope="col">NIK</th>
  17.     <th width="265" bgcolor="#CCCCCC" scope="col">Nama</th>
  18.     <th width="265" bgcolor="#CCCCCC" scope="col">Kelamin</th>
  19.     <th width="265" bgcolor="#CCCCCC" scope="col">Alamat</th>
  20.     <th width="265" bgcolor="#CCCCCC" scope="col">RT</th>
  21.     <th width="124" bgcolor="#CCCCCC" scope="col">RW</th>
  22.     <th width="265" bgcolor="#CCCCCC" scope="col">Kelurahan</th>
  23.     <th width="265" bgcolor="#CCCCCC" scope="col">Pekerjaan</th>
  24.     <th width="200" bgcolor="#CCCCCC" scope="col">Tempat Lahir</th>
  25.     <th width="200" bgcolor="#CCCCCC" scope="col">Tanggal Lahir</th>
  26.     <th width="124" bgcolor="#CCCCCC" scope="col">Agama</th>
  27.     <th width="265" bgcolor="#CCCCCC" scope="col">Warga Negara</th>
  28.     <th width="265" bgcolor="#CCCCCC" scope="col">Pendidikan Terakhir</th>
  29.     <th width="265" bgcolor="#CCCCCC" scope="col">Status Penduduk</th>
  30.     <th width="265" bgcolor="#CCCCCC" scope="col">Status Tinggal</th>
  31.     <th width="265" bgcolor="#CCCCCC" scope="col">Status Kawin</th>
  32.   </tr>
  33.  
  34.   <?php
  35. include "conn.php";
  36. $rrw=$_REQUEST['t1'];
  37. $no=0;
  38. if ($level=="RW")  
  39. {
  40. $query = mysql_query("select * from penduduk where rw='$norw' and rt='$rrw' order by nokk asc");
  41. }
  42. else
  43. if ($level=="RT")  
  44. {
  45. $query = mysql_query("select * from penduduk where rw='$norw'and rt='$rrw' order by nokk asc");
  46. }
  47. else
  48. if ($level=="Super Admin")  
  49. {
  50. $query = mysql_query("select * from penduduk where rw='$rrw' order by nokk asc");
  51. }
  52.  
  53. while($ada = mysql_fetch_array($query)){
  54. $no ++;
  55. ?>
  56.   <tr>
  57.     <td><?php echo "$no" ?></td>
  58.     <td><?php echo "$ada[nokk]" ?></td>
  59.     <td><?php echo "$ada[nik]" ?></td>
  60.     <td><?php echo "$ada[nama]" ?></td>
  61.     <td><?php echo "$ada[jk]" ?></td>
  62.     <td><?php echo "$ada[alamat]" ?></td>
  63.     <td><?php echo "$ada[rt]" ?></td>
  64.     <td><?php echo "$ada[rw]" ?></td>
  65.     <td><?php echo "$ada[kelurahan]" ?></td>
  66.     <td><?php echo "$ada[pekerjaan]" ?></td>
  67.      <td><?php echo "$ada[tempatlahir]" ?></td>
  68.     <td><?php echo date('d-m-Y', strtotime($ada["tanggallahir"])); ?></td>
  69.     <td><?php echo "$ada[agama]" ?></td>
  70.     <td><?php echo "$ada[warganegara]" ?></td>
  71.     <td><?php echo "$ada[pddterakhir]" ?></td>
  72.     <td><?php echo "$ada[stpenduduk]" ?></td>
  73.     <td><?php echo "$ada[sttinggal]" ?></td>
  74.     <td><?php echo "$ada[stkawin]" ?></td>
  75.   </tr>
  76.   <?php } ?>
  77. </table>
  78.  
  79. <p><a href="indexlaporanpenduduk.php" target="_blank">Cetak Laporan</a></p>
Advertisement
Add Comment
Please, Sign In to add comment