<?php
    require_once 'db/koneksi.php';

//Fungsi Hapus
if(isset($_GET['del'])){
    $nis = $_GET['del'];
    $hapus = mysql_query("DELETE FROM tbl_siswa WHERE nis = '$nis'");
    if($hapus){
        echo "<b>Berhasil Menghapus data.</b>";
    }else{
        echo "Gagal menghapus.".mysql_error();
    }
}


?>
                        <div class="panel panel-default">
                        <div class="panel-heading">
                            Tabel Siswa
                        </div>
                        <div class="panel-body">
                            <form method="post">
                                <input type="text" name="search" placeholder="Cari data..."> <input type="submit" value="CARI">
                            </form>
                            <div class="table-responsive">
                                <table class="table table-striped table-bordered table-hover" id="dataTables-example">
                                    <thead>
                                        <tr>
                                <th>NIS</th>
                                <th>NAMA SISWA</th>
                                <th>Jenis Kelamin</th>
                                <th>Agama</th>
                                <th>Asal Kota</th>
                                <th>Aksi</th>
                                        </tr>
                                    </thead>
                                    <tbody>
<?php
//Fungsi cari
$query = "SELECT * FROM tbl_siswa ORDER BY nis";

if(isset($_POST['search'])){
    $cari = $_POST['search'];
    $query = "SELECT * FROM tbl_siswa WHERE nis LIKE '%$cari%' OR nama LIKE '%$cari%'";
    $cekd = mysql_num_rows(mysql_query($query));

    if($cekd < 1){ ?>
        <tr>
            <td colspan="7" align="center style="padding:10px;"> Data Tidak Ditemukan</td>
        </tr>
    <?php }
        $mysql = mysql_query($query) or die(mysql_error());
        while ($cek = mysql_fetch_assoc($mysql)) {
            $nis = $cek['nis'];
            $nama = $cek['nama'];
            $jenkel = $cek['jenkel'];
            $agama = $cek['agama'];
            $idkota = $cek['idkota'];

            $querykota = mysql_query("SELECT kota FROM tbl_kota WHERE id = '$idkota'");
            $cekkota = mysql_fetch_assoc($querykota);
            $namakota = $cekkota['kota'];
        ?>
                              <tr class="odd gradeA">
                                <td><?php echo $nis; ?></td>
                                <td><?php echo $nama; ?></td>
                                <td><?php echo $jenkel; ?></td>
                                <td><?php echo $agama; ?></td>
                                <td><?php echo $namakota; ?></td>
                                <td><a href="blog.php?conten=menampilkan_data&del=<?php echo $nis; ?>">Delete</a> | </td>
                              </tr>
<?php
}
?>
                                    </tbody>
                                </table>
                            </div>

                        </div>
                    </div>
<?php
}

  //$query = mysql_query("SELECT * FROM tbl_siswa ORDER BY nis");