tam

<!-- form advanced search -->
<form name="form1" method="get" action="">
<table>
<tr>
<td>Nama Siswa <input type="text" name="nama" id="nama"/></td>
<td>Kelas <input type="text" name="nama_kelas" id="nama_kelas"/></td>
<td>TA <input type="text" name="thn_ajaran" id="thn_ajaran"/></td>
<td>NIPN <input type="text" name="nip" id="nip"/> </td>
<td><input type="submit" value="Search" name="search"/></td>
</tr>
</table>
</form>
<!-- menampilkan hasil pencarian -->
<?php
if(isset($_GET['search'])){
	$conn = mysql_connect("localhost", "root", "");
	mysql_select_db("sibepe");
	$nama = $_GET['nama'];
	$kelas = $_GET['nama_kelas'];
	$thn = $_GET['thn_ajaran'];
	$nip= $_GET['nip'];
	$sql="select a.id_absen,a.count(a.ket='sakit') as Sakit,a.count(a.ket='izin') as Izin,a.count(a.ket='alpha') as Alpha,b.nip,b.nama_guru,c.nis,c.nama,d.kd_kelas,d.nama_kelas from absensi a,tb_guru b, tb_siswa c, tb_kelas d where a.nip=b.nip and a.nis=c.nis and a.kd_kelas=d.kd_kelas and c.nama like '%$nama%' and d.nama like '%$kelas%' and a.thn_ajaran like '%$kelas%' and b.nip like '%$nip%' group by a.thn_ajaran desc,c.nama asc, d.nama_kelas asc";


	$result = mysql_query($sql);
	if(mysql_num_rows($result) > 0){

		?>
		<table width="799">
    <tr>
      <td colspan="8"><div align="center">DAFTAR ABSENSI</div></td>
      </tr>
    <tr>
			  <td rowspan="2"><div align="center">NISN</div></td>
			  <td rowspan="2"><div align="center">Nama Siswa</div></td>
			  <td rowspan="2"><div align="center">Kelas</div></td>
			  <td rowspan="2"><div align="center">Tahun Ajaran</div></td>
			  <td colspan="3"><div align="center">Keterangan</div></td>
			  <td><div align="center"></div></td>
		  </tr>
			<tr>
				<td><div align="center">Sakit</div></td>
                <td><div align="center">Izin</div></td>
                <td><div align="center">Alpah</div></td>
                <td><div align="center">Pengajar</div></td>
			</tr>
			<?php
			while($row = mysql_fetch_array($result)){?>
			<tr>
				<td><div align="center"><?php echo $row['nis'];?></div></td>
				<td><div align="center"><?php echo $row['nama'];?></div></td>
				<td><div align="center"><?php echo $row['nama_kelas'];?></div></td>
				<td><div align="center"><?php echo $row['thn_ajaran'];?></div></td>
                <td><div align="center"><?php echo $row['sakit'];?></div></td>
                <td><div align="center"><?php echo $row['izin'];?></div></td>
                <td><div align="center"><?php echo $row['alpha'];?></div></td>
                <td><div align="center"><?php echo $row['nama_guru'];?></div></td>
			</tr>
			<?php }?>
		</table>
		<?php
	}else{
		echo 'Data not found!';
	}
}
?>