rendered paste body<html><head><title>Data Siswa</title><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><script><!--// Secript scrolling Title Barvar repeat=1 // 1 untuk mengulang terus-menerus, 0 untuk satu kalivar title=document.titlevar leng=title.lengthvar start=1function titlemove() { titl=title.substring(start, leng) + title.substring(0, start) document.title=titl start++ if (start==leng+1) { start=0 if (repeat==0) return } setTimeout("titlemove()",140)}if (document.title)titlemove()function MM_jumpMenu(targ,selObj,restore){ //v3.0 eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'"); if (restore) selObj.selectedIndex=0;}//--></script><SCRIPT language=JavaScript>function reload(form){var val=form.cat.options[form.cat.options.selectedIndex].value; self.location='nisn.php?cat=' + val ;}function reload3(form){var val=form.cat.options[form.cat.options.selectedIndex].value; var val2=form.subcat.options[form.subcat.options.selectedIndex].value; self.location='nisn.php?cat=' + val + '&cat3=' + val2 ;}function reload4(form){var val=form.cat.options[form.cat.options.selectedIndex].value; var val2=form.subcat.options[form.subcat.options.selectedIndex].value; var val3=form.subcategory.options[form.subcategory.options.selectedIndex].value; self.location='nisn.php?cat=' + val + '&cat3=' + val2 + '&cat4=' + val3;}</script></head><body bgcolor="#2A1A63" leftmargin="0" topmargin="0" rightmargin="0" bottommargin="0" marginwidth="0" marginheight="0"><table width="760" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF"> <!--DWLayoutTable--> <tr> <td width="760" height="200" valign="top"> <?php include "header.html"; ?> </td> </tr> <tr> <td height="149" valign="top"><table width="96%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td> <?require("konfigurasi.php");if ($SortOrder == ""){ $strSort = "nomor";}elseif ($SortOrder == "nomor"){ $strSort = "nomor";}elseif ($SortOrder == "nisn"){ $strSort = "nisn";}elseif ($SortOrder == "nama"){ $strSort = "nama";}elseif ($SortOrder == "sekolah"){ $strSort = "sekolah";}else{ $strSort = "nomor";}$strSQL = "SELECT * FROM $TNisn ORDER BY $strSort";?> <br> <form method=post name=f1 action=''> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td><table width="100%" border="0"> <tr> <td width="234">Pilih Kecamatan : <?$quer2=mysql_query("SELECT DISTINCT kecamatan FROM $TNisn ORDER BY kecamatan ASC"); ?><?echo "<select name='cat' onchange=\"reload(this.form)\"><option value=''>Select one</option>";while($noticia2 = mysql_fetch_array($quer2)) { $selected = ($_GET['cat']==$noticia2['kecamatan'])?$selected = "selected":$selected = "";echo "<option $selected value='$noticia2[kecamatan]'>{$noticia2['kecamatan']}</option>"."<BR>";}echo "</select>";?></td> <td width="254">Pilih Jenjang / Tingkatan: <?$cat=$_GET['cat']; // This line is added to take care if your global variable is off$cat3=$_GET['cat3'];if(isset($cat) and strlen($cat) > 0){$quer=mysql_query("SELECT * FROM $TNisn WHERE kecamatan = '$cat' ORDER BY jenjang ASC"); }else{$quer=mysql_query("SELECT DISTINCT jenjang FROM $TNisn"); } ?><?echo " <select name=\"subcat\" onchange=\"reload3(this.form)\" ><option value=''>Select one</option>";while($noticia = mysql_fetch_array($quer)) { $selected = ($cat3==$noticia['nisn'])?$selected = "selected":$selected = "";echo "<option $selected value='$noticia[nisn]'>$noticia[jenjang]</option>";}echo "</select>";?></td> <td width="254">Pilih Penghasilan: <?$cat=$_GET['cat']; // This line is added to take care if your global variable is off$cat3=$_GET['cat3'];$cat4=$_GET['cat4'];if(isset($cat) and strlen($cat) > 0){$quer=mysql_query("SELECT * FROM $TNisn WHERE jenjang = '$cat3' ORDER BY penghasilan ASC"); }else{$quer=mysql_query("SELECT DISTINCT penghasilan FROM $TNisn"); } ?><?echo " <select name=\"subcategory\" onchange=\"reload4(this.form)\" ><option value=''>Select one</option>";while($noticia = mysql_fetch_array($quer)) { $selected = ($cat4==$notice['nisn'])?$selected = "selected":$selected = "";echo "<option $selected value='$notice[nisn]'>$notice[penghasilan]</option>";}echo "</select>";?></td> <td width="116" valign="middle"><input name="tampil" type="submit" id="tampil" value="Tampil" /></td> <td width="108"> </td> </tr> </table></td> </tr> </table></form><table width="100%" border="0" cellpadding="0" cellspacing="0" bordercolor="#FF0000"> <tr bgcolor="#5E43BC"> <td width="9%"><strong><font color="#FFFFFF">No.</font></strong></td> <td width="13%"><strong><font color="#FFFFFF">NISN</font></strong></td> <td width="28%" height="30" bgcolor="#5E43BC"><strong><font color="#FFFFFF">Nama</font></strong></td> <td width="31%"><strong><font color="#FFFFFF">Sekolah</font></strong></td> <td width="19%"><div align="center"><strong><font color="#FFFFFF">Detail</font></strong></div></td> </tr><?if(isset($cat) && isset($cat3) && isset($cat4)) $strSQL = "SELECT * FROM $TNisn WHERE kecamatan = '$cat' AND nisn = '$cat3' AND penghasilan = '$cat4' ORDER BY $strSort";$MyQuery = @mysql_query($strSQL, $conn) or die ("Pesan Error");while ($row = mysql_fetch_array($MyQuery)){ if($no%2==0) $warna="#FFFFFF"; else $warna="#F3F3F3"; echo "<tr bgcolor='$warna'>\n"; echo "<td width=\"5%\">" . $row["nomor"] . "</td>\n"; echo "<td width=\"26%\">" . $row["nisn"] . "</td>\n"; echo "<td width=\"34%\" height=\"30\">" . $row["nama"] . "</td>\n"; echo "<td width=\"20%\">" .$row["sekolah"] . "</td>\n"; echo "<td width=\"15%\"><input type=\"button\" value=\"Detail\" onClick=\"window.location.href='detail-siswa.php?ViewID=" . $row["id"] . "&Signature=" .md5($row["id"]) . "';\"></td>\n"; echo "</tr>\n";$no=$no+1; }?><br> </table></td> </tr> </table></td> </tr> <tr> <td height="50" valign="top"> <div align="center"> <?php include "footer.html"; ?> </div></td> </tr></table></body></html>