Menampilan Data (Edit,Hapus, Search)

<script type="text/javascript" src="js/jquery.min.js"></script>
    <script type="text/javascript">
        $("document").ready(function(){
            alert ("Halaman ini membutuhkan koneksi internet untuk menampilkan CSS nya, Terima Kasih.");
        });
    </script>

<?php
//Copyright by Dganisha
    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();
    }
}

//Fungsi Edit
if(isset($_GET['edit'])){
    $nis = $_GET['edit'];
                //Fungsi Simpan Data
                if(isset($_POST['simpan'])){
                    //$nis_user = $_POST['nisnya'];
                    $ganti_nama = $_POST['namasiswa'];
                    $ganti_jenkel = $_POST['jenkelsis'];

                    $save = mysql_query("UPDATE tbl_siswa SET nama = '$ganti_nama' WHERE nis = '$nis'");
                    $save = mysql_query("UPDATE tbl_siswa SET jenkel = '$ganti_jenkel' WHERE nis = '$nis'");
                        if($save){
                            echo "<b>Berhasil merubah data.</b><br>";
                        }else{
                            echo "Gagal merubah data. ".mysql_error();
                        }
                }
    $querycek = mysql_query("SELECT nis,nama,jenkel FROM tbl_siswa WHERE nis = '$nis'");
    $data = mysql_fetch_assoc($querycek);
        $c_nama = $data['nama'];
        $c_nis = $data['nis'];
        $c_jenkel = $data['jenkel']; ?>
        <form method="post">
            NIS Siswa : <input type="text" name="nisnya" value="<?php echo $c_nis; ?>" disabled><br><br>
            Nama Siswa : <input type="text" name="namasiswa" value="<?php echo $c_nama; ?>"><br><br>
            Jenis Kelamin : <input type="text" name="jenkelsis" value="<?php echo $c_jenkel; ?>" ><br>
            <input type="submit" name="simpan" value="SIMPAN">
        </form>
<?php
} ?>
    <a href="blog.php?conten=tesdb">Tambah Data</a>

                        <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%'";

}
$dhiemas = mysql_num_rows(mysql_query($query));
    if($dhiemas < 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> |  <a href="blog.php?conten=menampilkan_data&edit=<?php echo $nis; ?>">Edit</a></td>
                              </tr>
<?php
}
?>
                                    </tbody>
                                </table>
                            </div>

                        </div>
                    </div>