      <?php
$input_cari=$_POST['input_cari'];
$p= mysql_query("SELECT * FROM data_warga WHERE status_admin='adminirmus' and nama_warga like  '%$input_cari%' or nik like '%$input_cari%'");   
$dt=mysql_fetch_array($p);
$kw=$dt['id_penghuni'];
$has=mysql_num_rows($p);
                    if($has==0){
                        echo "<script>alert('$input_cari Tidak Terdata Dalam Data Warga Rt04 Rw05 Silahkan Periksa Kembali ');location.href='?page=home'</script>";
                    }
          

$pe=mysql_query("select *from penghuni where id_penghuni='$kw'");
$dtp=mysql_fetch_array($pe);


include "pages/kategori.php";


  
    ?>

<div class="col-md-12 " style="padding:0px; text-align:center;"> 
        
  

<?php echo $ic;?>  
    </div>
<div class="col-md-12">
          <div class="col-md-12 " id="bgjdl">
                  <div class="col-md-2">
                
<a href="?page=input_warga" class="btn btn-default" id="tp"><i class="fa fa-users"></i> Tambah Penduduk</a>
                      </div>
                    <div class="col-md-7">
    <div id="fontjdl">
    <?php echo $t;?> DATA WARGA PENDUDUK <?PHP echo $dtp ['nm_penghuni'];?>
        </div>
    </div>
</div>     
</div>
<div class="col-md-12">

   <?php
                      
                      
                      
            if ($_POST['input_cari'])
            {
                echo "<a href='?page=kategori_warga2&dp=$kw' class='btn btn-warning' id='tp'>LIHAT SEMUA</a>";
            }
            ?>
					 
</div>



            
<div class="col-md-12" >

            <table  class="table table-striped table-hover order-table " >
            <thead >
                <th id="th" class="INFO">NO</th>
                <th id="th" class="INFO">NIK</th>
                <th id="th" class="INFO">NO.KK</th>
                <th id="th" class="INFO">NAMA</th>
                <th id="th" class="INFO">JENIS KELAMIN</th>
                <th id="th" class="INFO">TTL</th>
                <th id="th" class="INFO">NO. RUMAH</th>
                <th id="th" class="INFO">ALAMAT</th>
                <th id="th" class="INFO">FOTO</th>
                <th id="th" class="INFO">OPSI</th>
            </thead>
            <tbody>
                
            <?php
                
                $input_cari = @$_POST['input_cari'];
                $no=1;

             
                $q = mysql_query("SELECT * FROM data_warga WHERE status_admin='adminirmus' and nama_warga LIKE '%$input_cari%' or nik LIKE '%$input_cari%'");   
         
                while ($data=mysql_fetch_array($q)){
                
                    $peng=$data['id_penghuni'];
                $jk=$data['id_jenis_k'];
                $sd=$data['id_status_d'];

                $p=mysql_query("select*from penghuni where id_penghuni='$peng'");
                $dtp=mysql_fetch_array($p);
                $j=mysql_query("select*from jenis_k where id_jenis_k='$jk'");
                $dtk=mysql_fetch_array($j);
        
                
                  
                
                
                    
            ?>
                
            <tbody>
               <tr style="text-align:center;" id="tr">
                  
                    <td data-content="No" id="td"><?php echo ++$no_urut;?></td>    
                    <td data-content="NIK" id="td"><?php echo $data['nik'];?></td>    
                    <td data-content="NO.KK" id="td"><?php echo $data ['nokk'];?></td>    
                    <td data-content="NAMA" id="td"><?php echo $data ['nama_warga'];?></td>    
                    <td data-content="JENIS KELAMIN" id="td"><?php echo $dtk ['nm_kelamin'];?></td>    
                    <td data-content="Ttl" id="td"><?php echo $data ['tempat_lahir'];?> <?php echo $data ['tanggal_lahir'];?></td>              
                    <td data-content="No.RUMAH" id="td"><?php echo $data ['no_rumah'];?></td>           
                    <td data-content="ALAMAT" id="td"><?php echo $data ['alamat'];?></td>
                   <td data-content="Foto" id="td"> <img src="fotowarga/<?php echo $data ['foto_warga'];?>" width="40px" height="50px"></td>
                    <td data-content="LIHAT" id="td"><a class="btn btn-default" HREF="?page=detail_warga&dw=<?php echo $data ['nik'];?>" id="op"><i class="fa fa-eye"> Detail</i></A>  <a class="btn btn-default" href="?page=edit_warga&dw=<?php echo $data ['id_warga'];?>" id="op" ><i class="fa fa-edit"> Edit</i></a></td>
                 
                </tr>
            </tbody>
            <?php
    
      

                
    }
    ?>
    </table>
            
</div>

</body>
</html>