<!DOCTYPE html>
<html>
<head>
<style>
ul {
list-style-type: none;
margin: 0;
padding: 0;
overflow: hidden;
background-color: #333;
}
li {
float: left;
}
li a, .dropbtn {
display: inline-block;
color: white;
text-align: center;
padding: 14px 16px;
text-decoration: none;
}
li a:hover, .dropdown:hover .dropbtn {
background-color: crimson;
}
li.dropdown {
display: inline-block;
}
.dropdown-content {
display: none;
position: absolute;
background-color: white;
min-width: 160px;
box-shadow: 0px 8px 16px 0px rgba(0,0,0,0.2);
z-index: 1;
}
.dropdown-content a {
color: black;
padding: 12px 16px;
text-decoration: none;
display: block;
text-align: left;
}
.dropdown-content a:hover {background-color: mediumspringgreen}
.dropdown:hover .dropdown-content {
display: block;
}
</style>
</head>
<body>
<body background = "/Project/resize-img.jpg">
<center><h2><font color="white">Selamat Datang ! Admin </h2></center>
<ul>
<li><a href="Homepage.php">Menu</a></li>
<li><a href="#news">News</a></li>
<div class="dropdown">
<li class="dropdown">
<a href="javascript:void(0)" class="dropbtn">Standar Kompetensi</a>
<div class="dropdown-content">
<a href="#">Data Standar Kompetensi</a>
<a href="#">Input Standar Kompetensi</a>
</li>
</div>
<div class="dropdown">
<li class="dropdown">
<a href="javascript:void(0)" class="dropbtn">Siswa</a>
<div class="dropdown-content">
<a href="#">Data Siswa</a>
<a href="#">Input Siswa</a>
</li>
</div>
<div class="dropdown">
<li class="dropdown">
<a href="javascript:void(0)" class="dropbtn">Nilai</a>
<div class="dropdown-content">
<a href="#">Data Nilai</a>
<a href="#">Input Nilai</a>
</li>
</div>
<div class="dropdown">
<li class="dropdown">
<a href="javascript:void(0)" class="dropbtn">Guru</a>
<div class="dropdown-content">
<a href="#">Data Guru</a>
<a href="#">Input Guru</a>
</li>
</div>
<li style="float:right"><a class="active" href="logout.php">Log out </font></a></li>
</ul>
<center>
<br><br><h1><font color="silver">Data Siswa<br></h1>
<table border="2">
<form method="post" name="form1" action="cari_siswa.php">
<script>
function showDiv(xxx) {
if(xxx.value == 1){
document.getElementById('NISN').style.display = "block";
document.getElementById('nama').style.display = "none";
}
else if(xxx.value == 2) {
document.getElementById('NISN').style.display = "none";
document.getElementById('nama').style.display = "block";
}
}
</script>
Cari : <select name="select" onchange="showDiv(this)">
<option value="" disabled selected>Select your option..</option>
<option value="1">NISN</option>
<option value="2">Nama</option>
</select>
<div id="NISN" style="display: none">
NISN :<input type="text" name="NISN"><br>
<input type="submit" id="" name="submit_NISN">
</div>
<div id="nama" style="display: none">
Nama Siswa : <input type="text" name="nama"><br>
<input type="submit" name="submit_siswa">
</div>
</form>
<tr>
<td><center><font color=cyan >No</font></td>
<td><center><font color=cyan >NISN</font></td>
<td><center><font color=cyan >Nama</font></td>
<td><center><font color=cyan >Alamat</font></td>
<td><center><font color=cyan >Tanggal Lahir</font></td>
<td><center><font color=cyan >Foto</font></td>
<td><center><font color=cyan >Pilihan</font></td>
</tr>
<?php
include"koneksi.php";
if (isset ($_POST['submit_NIP'])){
$nip=$_POST['NIP'];
$query=mysql_query("SELECT * FROM siswa where NISN LIKE ('%$_POST[NISN]%')");
while($r = mysql_fetch_array($query));{
echo"<tr>
<td>$r[NISN]</td>
<td>$r[nama]</td>
<td>$r[alamat]</td>
<td>$r[tgl_lahir]</td>
</tr>
";
}
}
if (isset ($_POST['submit_NIP'])){
$nip=$_POST['NIP'];
$query=mysql_query("SELECT * FROM siswa where nama LIKE ('%$_POST[nama]%')");
while($r = mysql_fetch_array($query)){
echo"<tr>
<td>$r[NISN]</td>
<td>$r[nama]</td>
<td>$r[alamat]</td>
<td>$r[tgl_lahir]</td>
</tr>
";
}
}
if (isset ($_POST['submit_NIP'])){
$nip=$_POST['NIP'];
$query=mysql_query("SELECT * FROM siswa where alamat LIKE ('%$_POST[alamat]%')");
while($r = mysql_fetch_array($query)){
echo"<tr>
<td>$r[NISN]</td>
<td>$r[nama]</td>
<td>$r[alamat]</td>
<td>$r[tgl_lahir]</td>
</tr>
";
}
}
if (isset ($_POST['submit_NIP'])){
$nip=$_POST['NIP'];
$query=mysql_query("SELECT * FROM siswa where NISN LIKE ('%$_POST[NISN]%')");
while($r = mysql_fetch_array($query)){
echo"<tr>
<td>$r[NISN]</td>
<td>$r[nama]</td>
<td>$r[alamat]</td>
<td>$r[tgl_lahir]</td>
</tr>
";
}
}
?>
<?php
include "koneksi.php";
$query="SELECT * FROM siswa";
$tampil=mysql_query($query);
$no=1;
while($row=mysql_fetch_array($tampil)){
?>
<tr>
<td><font color="cyan" =5><?php echo $no;?></td>
<td class="center"><center><font color=white><?php echo $row["NISN"];?></td>
<td class="center"><center><font color=white><?php echo $row["nama"];?></td>
<td class="center"><center><font color=white><?php echo $row["alamat"];?></td>
<td class="center"><center><font color=whites><?php echo $row["tgl_lahir"];?></td>
<td><?php
echo "
<img src=image/$row[foto] whidt=50 height=50 align center>" ?></td>
<td align="center">
<a href="edit_siswa.php?id=<?php echo $row['NISN'] ?>"><font color=cyan face=tahoma =5>Edit</a>
<a href="hapus_siswa.php?id=<?php echo $row['NISN'] ?>" onclick="return confirm('Anda yakin akan menghapus data?')"><font color=cyan face=tahoma =5>Hapus</a>
</td>
</tr>
<?php $no++; }?>
</tr>
</table>
<td><a href="input_siswa.php"><font color=white>Tambah Data</a></td></tr>
</form>
<nav aria-label="Page navigation">
<ul class="pagination">
<?php if($curpage != $startpage){ ?>
<li class="page-item">
<a class="page-link" href="?page=<?php echo $startpage ?>" tabindex="-1" aria-label="Previous">
<span aria-hidden="true">«</span>
<span class="sr-only">First</span>
</a>
</li>
<?php } ?>
<?php if($curpage >= 2){ ?>
<li class="page-item"><a class="page-link" href="?page=<?php echo $previouspage ?>"><?php echo $previouspage ?></a></li>
<?php } ?>
<li class="page-item active"><a class="page-link" href="?page=<?php echo $curpage ?>"><?php echo $curpage ?></a></li>
<?php if($curpage != $endpage){ ?>
<li class="page-item"><a class="page-link" href="?page=<?php echo $nextpage ?>"><?php echo $nextpage ?></a></li>
<li class="page-item">
<a class="page-link" href="?page=<?php echo $endpage ?>" aria-label="Next">
<span aria-hidden="true">»</span>
<span class="sr-only">Last</span>
</a>
</li>
<?php } ?>
</ul>
</nav>
</body>
</html>
