Form Pencarian
<style type="text/css">
tr:hover{
background:blue;
color:white;
}
</style>
<h1> Data SMK </h1>
<form method="get" action="#">
<table class="table" align="right">
<tr>
<td data-label="NIS" align="right">
<input type="hidden" name="page" value="data_siswa">
<input type="text" name="kata_kunci">
<input type="submit" name="cari">
</td>
</tr>
</table>
</form>
<table class=table>
<tr>
<th>NIS</th><th>Nama Siswa</th><th>Jenis Kelamin</th>
<th>Tempat Lahir</th><th>Tanggal Lahir</th><th>Nama Ibu Kandung</th>
<th>Aksi</th>
</tr>
<?php
include"conn/config.php";
if(!isset($_GET['kata_kunci']))
{$perintah="select * from tb_siswa";}
else
{
$kata_kunci=$_GET['kata_kunci'];
$perintah="select * from tb_siswa WHERE
nis='$kata_kunci' OR
nama='$kata_kunci' OR
tempat_lahir='$kata_kunci' OR
jenis_kelamin='$kata_kunci' OR
tanggal_lahir='$kata_kunci' OR
nama_ibukandung='$kata_kunci'";}
$query=mysqli_query($koneksi,$perintah);
while($data=mysqli_fetch_row($query))
{
echo"
<tr>
<td>$data[0]</td> <td>$data[1]</td> <td>$data[2]</td>
<td>$data[3]</td> <td>$data[4]</td> <td>$data[5]</td>
<td>
<a href=form_ubahsiswa.php?nis=$data[0]>
<button class='btn btn-edit'>Ubah</button></a> ";
?>
<a href=hapus_siswa.php?nis=<?=$data[0];?>
onclick="return confirm('Yakin ingin menghapus data ini?')">
<button class="btn btn-delete">Hapus</button>
</a>
<?php echo"
</td>
</tr>
";
}
?>
Komentar
Posting Komentar