lo

<!-- form advanced search -->
<form name="form1" method="get" action="">
NISN : <input type="text" name="nis" id="nis"/>
<!--NAMA SISWA : <input type="text" name="nama" id="nama"/>-->
KELAS <input type="text" name="nama_kelas" id="nama_kelas"/>
SEMESTER : <input type="text" name="semester" id="semester"/>
TAHUN AJARAN : <input type="text" name="thn_ajaran" id="thn_ajaran"/>
<input type="submit" value="Search" name="search"/>
</form>
<!-- menampilkan hasil pencarian -->
<?php
if(isset($_GET['search'])){
	$conn = mysql_connect("localhost", "root", "");
	mysql_select_db("sibepe");
	$nis = $_GET['nis'];
	$nama = $_GET['nama'];
	$kls = $_GET['nama_kelas'];
	$sm = $_GET['semester'];
	$ta = $_GET['thn_ajaran'];
	$sql = "select a.id,a.thn_ajaran,a.semester,count(a.ket='sakit') as Sakit,count(a.ket='izin') as Izin,count(a.ket='alpha') as Alpha,count(a.ket='terlambat') as Terlambat,b.nis,b.nama,c.kd_kelas,c.nama_kelas from absensi a, tb_siswa b,tb_kelas c where a.nis=b.nis and a.kd_kelas=c.kd_kelas and b.nis like '%$nis%' and
	c.nama_kelas like '%$kls%' and a.semester like '%$sm%' and a.thn_ajaran like '%$ta%'";
	$result = mysql_query($sql);
	if(mysql_num_rows($result) > 0){
		?>
		<table>
  <tr>
    <td colspan="9"><div align="center">ABSENSI SISWA</div></td>
  </tr>
  <tr>
    <td width="95" rowspan="2"><div align="center">NISN</div></td>
    <td width="109" rowspan="2"><div align="center">NAMA SISWA</div></td>
    <td width="81" rowspan="2"><div align="center">KELAS</div></td>
    <td width="95" rowspan="2"><div align="center">SEMESTER</div></td>
    <td width="95" rowspan="2"><div align="center">TA</div></td>
    <td colspan="4"><div align="center">KETERANGAN</div></td>
  </tr>
  <tr>
    <td width="95"><div align="center">SAKIT</div></td>
    <td width="95"><div align="center">IZIN</div></td>
    <td width="96"><div align="center">ALPHA</div></td>
    <td width="96"><div align="center">TERLAMBAT</div></td>
  </tr>
			<?php
			while($siswa = mysql_fetch_array($result)){?>
  <tr>
    <td><div align="center"><?php echo $siswa['nis'];?></div></td>
    <td><div align="center"><?php echo $siswa['nama'];?></div></td>
    <td><div align="center"><?php echo $siswa['nama_kelas'];?></div></td>
    <td><div align="center"><?php echo $siswa['semester'];?></div></td>
    <td><div align="center"><?php echo $siswa['thn_ajaran'];?></div></td>
    <td><div align="center"><?php echo $siswa['sakit'];?></div></td>
    <td><div align="center"><?php echo $siswa['izin'];?></div></td>
    <td><div align="center"><?php echo $siswa['alpha'];?></div></td>
    <td><div align="center"><?php echo $siswa['terlambat'];?></div></td>
  </tr>
			<?php }?>
		</table>
		<?php
	}else{
		echo 'Data not found!';
	}
}
?>