<div class="row">
    <div class="box col-md-12">
    <div class="box-inner">
    <div class="box-header well" data-original-title="">
        <h2><i class="glyphicon glyphicon-user"></i> Data Tenaga Kerja</h2>


    </div>
    <div class="box-content">


<form action="<?$_SERVER['PHP_SELF']?>" method="POST" name="pencarian" id="pencarian">
    <strong>Pencarian  :</strong>
    <input  type="text" name="search" id="search" size="20" placeholder="Masukkan nama "> <input class="btn btn-success btn-sm" type="submit" name="submit" id="submit" Value="Cari"><br><br>

</form>
<?php
$Open = mysql_connect("localhost","root","6LLEvhpPRnL96pzC");
    if (!$Open){
    die ("Koneksi ke Engine MySQL Gagal !<br>");
        }
$Koneksi = mysql_select_db("tk");
    if (!$Koneksi){
    die ("Koneksi ke Database Gagal !");
    }


session_start();// Memulai Session
// Menyimpan Session
$user_check=$_SESSION['user_sesi'];
// Ambil nama karyawan berdasarkan username karyawan dengan mysql_fetch_assoc
$ses_sql=mysql_query("select k_desa, nama, desa_kel from tb_user where username='$user_check'");




$row = mysql_fetch_assoc($ses_sql);
$login_session =$row['nama'];
$desa =$row['k_desa'];
$desakel =$row['desa_kel'];







//menampilkan data
if ((isset($_POST['submit'])) AND ($_POST['search'] <> "")) {
  $search = $_POST['search'];
  $sql = mysql_query("SELECT * FROM tb_tenaga, tb_pekerjaan, t_pendidikan where tb_tenaga.k_kerja=tb_pekerjaan.id_kerja and tb_tenaga.id_pend=t_pendidikan.id_pend  and nama LIKE '%$search%' and desa_kel='$desakel'") or die(mysql_error());
    //menampilkan jumlah hasil pencarian
  $jumlah = mysql_num_rows($sql);

  if ($jumlah > 0) {
    echo '<p>Ada '.$jumlah.' data yang sesuai.</p>';
    $nomer=0;
    while (    $hasil = mysql_fetch_assoc ($sql)) {
        $nomer++;
        $id_mahasiswa = stripslashes ($hasil['no_ktp']);
        $nama = stripslashes ($hasil['nama']);
        $t4_lahir = stripslashes ($hasil['t4_lahir']);

        $tgl_lahir = stripslashes ($hasil['tgl_lahir']);
        $pend = stripslashes ($hasil['n_tpend']);
        $kerja = stripslashes ($hasil['n_kerja']);

        }
?>
 <table class="table table-striped table-bordered bootstrap-datatable datatable responsive">

    <tr bgcolor="#FFA800">
        <td >No</td>
        <td >NIM</td>
        <td >Nama</td>
              <td >Tempat Lahir</td>
         <td >Tanggal Lahir</td>
         <td >Umur</td>
         <td >Pendidikan</td>
         <td >Pekerjaan</td>

        <td >aksi</td>

    </tr>

    <tr align="center">
        <td><?=$nomer?><div align="center"></div></td>
        <td><?=$id_mahasiswa?><div align="center"></div></td>
        <td><?=$nama?><div align="center"></div></td>
 <td><?=$t4_lahir?><div align="center"></div></td>


<td>
<?php
$birthday =$tgl_lahir;

    // Convert Ke Date Time
    $biday = new DateTime($birthday);
    $today = new DateTime();

    $diff = $today->diff($biday);

    // Display
    echo date('d M Y', strtotime($birthday)) .'<br />';
 ?>
</td>

<td>
<?php
$birthday = $tgl_lahir;

    // Convert Ke Date Time
    $biday = new DateTime($birthday);
    $today = new DateTime();

    $diff = $today->diff($biday);

    // Display echo $diff->m." Bulan".'</br>'; echo $diff->d." Hari";

    echo $diff->y.'</br>';

 ?>

</td>

<td><?=$pend?><div align="center"></div></td>
<td><?=$kerja?><div align="center"></div></td>


      <td class="right">

            <a class="btn btn-info btn-sm" href="?a=tenaga&aksi=ubah&id=<?php echo $data['id'];?>">
                <i class="glyphicon glyphicon-edit icon-white"></i>

            </a>

        </td>
           </tr>
</table>
<?
    }
    else {
   // menampilkan pesan zero data
        echo 'Maaf, hasil pencarian tidak ditemukan.';
    }
}
//Tutup koneksi engine MySQL
    mysql_close($Open);
?>

</div>
</div>
</div>
</div>

<a href="cetak.php" class="btn btn-danger btn-sm "><i class="glyphicon glyphicon-download-alt"></i>  Ekspor Data Ke Excell</a>