<?php
if(!defined("Balitbang")) {
die("<h1>Permission Denied</h1>You don't have permission to access the this page.");
}
//------------------ fungsi berhubungan dengan siswa--------------
class ppdbclass {
//************************** data import siswa **********************//
function imppdb() {
echo "<table width=98% ><tr bgcolor=dedede><td><font><b>Membuat Format Data Calon Siswa<b></td></tr>
<tr><td><font><form action='../functions/fungsi_excelnilai.php' method='post' >Pilih Format Data <input type=submit value='Format'> <input type=hidden name=format value='calonsiswa' ></form><br><br>
<font><b>File berupa format Excel dengan nama SHEET harus FormatCalonSiswa</b></font></td></tr>
<tr bgcolor=dedede><td><font><b>Import Data Calon Siswa</td></tr>
<tr><td><br><font><form action='../functions/importcalonsiswa.php' method='post' enctype=\"multipart/form-data\"'>Pilih File Import <input type=file name='excel_file' >&nbsp;<input type=submit value='Import' >
<input type=hidden name=st value='1'><br></form></td><tr></table><br>
<font><b>Keterangan</b><br>
Format Tanggal Lahir : bulan/hari/tahun<br>
Apabila ada kosong diisi dengan tanda ( - )<br>
Dikolom WALI diisi dengan nama orang tua<br>
Format Kelamin berupa L atau P <br>
Nama tidak boleh mengandung tanda petik satu ( ' )<br>
Field NIS harus diisi tidak boleh kosong karena NIS merupakan Primary Key dari Data Siswa<br>";


}

function ppdb() {
include "koneksi.php";
$kelas=$_GET['kelas'];
$hal=$_GET['hal'];

if($program=='') $program='-';

$brs=50;
$byk_result1=mysql_query("select * from t_ppdb where kelas='". mysql_escape_string($kelas)."'");
$byk=mysql_num_rows($byk_result1);
if ($byk<=$brs)
$jml=0;
else
{
$jml=floor($byk / $brs);
$sisa= $byk % $brs;
if ($sisa!=0)
$jml++;
}
if ($hal=="")
$awal=0;
else
$awal=$brs*($hal-1);

$query = "SELECT * from t_ppdb where kelas='". mysql_escape_string($kelas)."' order by nama LIMIT ".$awal.",".$brs."";
$query_result_handle = mysql_query ($query)
or die (mysql_error());
// check that there is news
$num_of_rows = mysql_num_rows ($query_result_handle);
// tambah alan untuk delete multiple

$data .='<select name=kelas onchange="document.location.href=\'admin.php?mode=ppdb&kelas=\'+document.ppdb.kelas.value">';
$data .="<option value='PPDB2013'>PPDB2013</option>
<option value='PPDB2014'>PPDB2014</option>
<option value='PPDB2015'>PPDB2015</option>
<option value='PPDB2016'>PPDB2016</option>";
$data.='</select>&nbsp;&nbsp;';
echo "<form action='admin.php' method='get' name='ppdb' ><table cellspacing='0' cellpadding='5' border='1' bordercolor='#000000' width=100% > <tr><td bgcolor='#999999' ><font><center>--- Daftar Calon Siswa Baru (PPDB) ---</center><br>";
echo " Kelas $data</font>&nbsp;&nbsp;<input type='submit' value=' Pilih ' ><input type=hidden name=mode value=ppdb ></td></tr>";
if ($jml!=0) {
echo "<tr><td ><center><font><a href='admin.php?mode=ppdb&kelas=$kelas&hal=1' title='Hal 1'>awal </a> |";
for($i=1;$i<=$jml;$i++)
{
echo "<a href='admin.php?mode=ppdb&kelas=$kelas&hal=$i' title='Hal $i dari $byk Data'> $i </a> |";
}
echo "<a href='admin.php?mode=ppdb&kelas=$kelas&hal=$jml' title='Hal $jml'> akhir</a> </font></center></td></tr>";
}
echo "</table></form><form action='admin.php' method=\"post\" name='siswa2' >
<table cellspacing='0' cellpadding='5' border='1' bordercolor='#000000' width=100% >";
echo "<tr><td><font><center>No</center></font></td><td><font><center>NIS</center></font></td>
<td><font><center>Nama</center></font></td><td><font><center>Asal Sekolah</center></font></td>
<td><font><center>Edit</center></font></td><td><font><center>Hapus</center></font></td></tr>";
// get news from db
if ($hal==1 || $hal=='')
$j=1;
else
$j=($brs*($hal-1))+1;
echo "<script language='JavaScript'>
function gCheckAll(chk) {
for (var i=0;i < document.forms[1].elements.length;i++) {
var e = document.forms[1].elements[i];
if (e.type == 'checkbox') {
e.checked = chk.checked }
}
}
</script>";
while ($row = mysql_fetch_array($query_result_handle))
{
echo "<tr onMouseOver=\"this.className='highlight'\" onMouseOut=\"this.className='normal'\">
<td width='5%' align='center'><font>$j</font></td>
<td width='10%' ><font>$row[nis]</font></td>
<td width='40%' ><font>$row[nama]</font></td>
<td width='10%' ><font>$row[sekolah]</font></td>";
$j++;
?>
<td width="10%" align="center"><font><a href="admin.php?mode=ppdb_edit&id=<?php echo $row[userid]; ?>"><img src="../images/edit.gif" border="0" ></a></td>
<td width="10%" align="center"><input type='checkbox' name='id[<?php echo $row[userid]; ?>]' value='on'> </td>
</tr>
<?php
}
echo "</table><br><input type=\"hidden\" name=\"mode\" value=\"ppdb_hap\">
<input type='checkbox' name='cekall' value='on' onClick='gCheckAll(cekall);'> Checklist Semua <input type=\"submit\" value=\"Hapus\"></form><br><font >";

}


// Save News
function ppdb_save() {
include "koneksi.php";
$edit=$_POST['edit'];$nama=$_POST['nama'];
$nis=$_POST['nis']; $nisn=$_POST['nisn'];$kelamin=$_POST['kelamin'];
$alamat=$_POST['alamat'];$telp=$_POST['telp'];
$tgllahir=$_POST['tgllahir'];$tmplahir=$_POST['tmplahir'];
$kelas=$_POST['kelas'];$agama=$_POST['agama'];
$ijazah=$_POST['ijazah'];$nilaiijazah=$_POST['nilaiijazah'];
$wali=$_POST['wali'];$ayah=$_POST['ayah'];$ibu=$_POST['ibu'];
$alamatwali=$_POST['alamatwali'];$alamatortu=$_POST['alamatortu'];
$email=$_POST['email'];

$sql = "UPDATE t_ppdb SET nama='". mysql_escape_string($nama)."' WHERE userid = '". mysql_escape_string($edit)."'";
/*
if ($edit=='') {
$total = $nis;
$sql = "INSERT INTO t_siswa (user_id,nama,kelamin,alamat,telp,tgl_lahir,tmp_lahir,kelas,agama,sttb,nem,wali)
VALUES ('". mysql_escape_string($nis)."', '". mysql_escape_string($nama)."', '". mysql_escape_string($kelamin)."','". mysql_escape_string($alamat)."','". mysql_escape_string($telp)."','". mysql_escape_string($tgl_lahir)."','". mysql_escape_string($tmp_lahir)."','". mysql_escape_string($kelas)."','". mysql_escape_string($agama)."','". mysql_escape_string($sttb)."','". mysql_escape_string($nem)."','". mysql_escape_string($wali)."')";
}
else {
$total=$edit;
$sql = "UPDATE t_ppdb SET nama='". mysql_escape_string($nama)."' WHERE userid = '". mysql_escape_string($edit)."'";
}
*/

}

function ppdb_edit() {
$id=$_GET['id'];
$sql="select * from t_ppdb where userid='". mysql_escape_string($id)."'";
if(!$query=mysql_query($sql)) die ("Pengambilan gagal1 profil");
$row=mysql_fetch_array($query);

if($row[kelamin]=='L') $s1="selected";
else $s2="selected";
echo "<script language='javascript' src='../functions/ssCalendar.js'></script>";
echo "<form action='admin.php' method=\"post\" name=\"f1\" enctype=\"multipart/form-data\">
<table border='0' cellpadding='0' cellspacing='6' width='100%'>
<tr><td colspan='2'><font><b>Pengisian Calon Siswa Baru (PPDB)</b><font><br><br></td> </tr>
<tr> <td width='24%'><font>Nama</font></td>
<td width='76%'> <input type='text' name='nama' value='$row[nama]' size='30' maxlength='30' >
</td></tr>
<tr> <td width='24%'><font>NISN</font></td>
<td width='76%'> $row[nisn] <input type=hidden name=nis value='$row[nisn]' >
</td></tr>
<tr> <td width='24%'><font>NIS</font></td>
<td width='76%'> $row[nis] <input type=hidden name=nis value='$row[nis]' >
</td></tr>
<tr> <td width='24%'><font>Kelas</font></td>
<td width='76%'> $row[kelas]
</td></tr>
<tr> <td width='24%'><font>Kelamin</font></td>
<td width='76%'> <select name=kelamin><option value='L' $s1 >Laki-laki</option>
<option value='P'$s2 >Perempuan</option></select>
</td></tr>
<tr> <td width='24%'><font>Tempat Lahir</font></td>
<td width='76%'> <input type='text' name='tmplahir' value='$row[tmplahir]' size='20' maxlength='50' >
</td></tr><tr> <td width='24%'><font>Tgl Lahir</font></td><td>";

echo '<input name="tgl_lahir" type="text" id="tgllahir" value="'.$row[tgllahir].'" readonly />
<a href="#" id="anctgl"><img border=0 style="width:16px;height:16px" src="../images/ssCalendar.jpg" /></a><br><div id="dtDivtgl" border="0" class="calCanvas"></div>';
echo "<font>Format Tanggal : bulan/hari/tahun</td></tr>
<tr> <td width='24%'><font>Alamat</font></td>
<td width='76%'> <input type='text' name='alamat' size='50' value='$row[alamat]' maxlength='60' >
</td></tr>
<tr> <td width='24%'><font>Telp</font></td>
<td width='76%'> <input type='text' name='telp' size='15' value='$row[telp]' maxlength='15' >
</td></tr>
<tr> <td width='24%'><font>Agama</font></td>
<td width='76%'> <input type='text' name='agama' size='20' value='$row[agama]' maxlength='10' >
</td></tr>
<tr> <td width='24%'><font>No. Ijazah</font></td>
<td width='76%'> <input type='text' name='ijazah' size='10' value='$row[ijazah]' maxlength='10' >
</td></tr>
<tr> <td width='24%'><font>Jumlah Nilai Ijazah</font></td>
<td width='76%'> <input type='text' name='nilaiijazah' size='10' value='$row[nilaiijazah]' maxlength='10' >
</td></tr>
<tr> <td width='24%'><font>Ayah</font></td>
<td width='76%'> <input type='text' name='ayah' size='30' value='$row[ayah]' maxlength='50' >
</td></tr>
<tr> <td width='24%'><font>Ibu</font></td>
<td width='76%'> <input type='text' name='ibu' size='30' value='$row[ibu]' maxlength='50' >
</td></tr>
<tr> <td width='24%'><font>Wali</font></td>
<td width='76%'> <input type='text' name='wali' size='30' value='$row[wali]' maxlength='50' >
</td></tr>
<tr> <td width='24%'><font>Alamat Orang Tua</font></td>
<td width='76%'> <input type='text' name='alamatortu' size='30' value='$row[alamatortu]' maxlength='50' >
</td></tr>
<tr> <td width='24%'><font>Alamat Wali</font></td>
<td width='76%'> <input type='text' name='alamatwali' size='30' value='$row[alamatwali]' maxlength='50' >
</td></tr>
<tr> <td width='24%'><font>Email</font></td>
<td width='76%'> <input type='text' name='email' size='30' value='$row[email]' maxlength='50' >
</td></tr>
";

echo"<tr> <td colspan='2'>
<input type=\"hidden\" name=\"mode\" value=\"ppdb_save\"><input type='reset' value='Ulang' > &nbsp;
<input type=\"hidden\" name=\"edit\" value=\"$id\">
<input type=\"submit\" value=\"Simpan\" >
</td></tr></table></form>";
$m=date("m"); $d=date("d"); $y=date("Y");
echo '<script language="javascript"><!--
var currYear = '.$y.';
var currMonth = '.$m.';
var dptgl = new DatePicker();
dptgl.id = "tgl";
dptgl.month = '.$m.';
dptgl.year = '.$y.';
dptgl.canvas = "dtDivtgl";
dptgl.format = "mm/dd/yyyy";
dptgl.anchor = "anctgl";
dptgl.initialize();
</script>';

}

function ppdb_hap() {
$id=$_POST['id'];
if (!empty($id))
{
while (list($key,$value)=each($id))
{
$sql="delete from t_ppdb where userid='". mysql_escape_string($key)."'";
$mysql_result=mysql_query($sql) or die ("Query failed - Mysql");
}
}

}
function carisiswa() {
$hal=$_GET['hal'];
$nama=$_GET['nama'];
if ($nama=='') $nama='0';
$brs=50;
$byk_result1=mysql_query("select * from t_siswa where nama like'%". mysql_escape_string($nama)."%'");
$byk=mysql_num_rows($byk_result1);
if ($byk<=$brs)
$jml=0;
else
{
$jml=floor($byk / $brs);
$sisa= $byk % $brs;
if ($sisa!=0)
$jml++;
}
if ($hal=="")
$awal=0;
else
$awal=$brs*($hal-1);

$query = "SELECT * from t_siswa where nama like'%". mysql_escape_string($nama)."%' order by nama LIMIT ".$awal.",".$brs."";
$query_result_handle = mysql_query ($query)
or die (mysql_error());
// check that there is news
$num_of_rows = mysql_num_rows ($query_result_handle);
// tambah alan untuk delete multiple

echo "<form action='admin.php' method='get' name='siswa' ><table cellspacing='0' cellpadding='5' border='1' bordercolor='#000000' width=100% > <tr><td bgcolor='#999999' ><font><center>--- Daftar Calon Siswa Baru (PPDB)---</center><br>";
echo " Pencarian Nama Siswa : <input type=text name='nama' ></font>&nbsp;&nbsp;<input type='submit' value=' Cari' ><input type=hidden name=mode value=carisiswa ></td></tr>";
if ($jml!=0) {
echo "<tr><td ><center><font><a href='admin.php?mode=carisiswa&nama=$nama&hal=1' title='Hal 1'>awal </a> |";
for($i=1;$i<=$jml;$i++)
{
echo "<a href='admin.php?mode=carisiswa&nama=$nama&hal=$i' title='Hal $i dari $byk Data'> $i </a> |";
}
echo "<a href='admin.php?mode=carisiswa&nama=$nama&hal=$jml' title='Hal $jml'> akhir</a> </font></center></td></tr>";
}
echo "</table></form><form action='admin.php' method=\"post\" name='siswa2' >
<table cellspacing='0' cellpadding='5' border='1' bordercolor='#000000' width=100% >";
echo "<tr><td><font><center>No</center></font></td><td><font><center>NIS</center></font></td>
<td><font><center>Nama</center></font></td><td><font><center>Kelas</center></font></td>
<td><font><center>Member Siswa</center></font></td><td><font><center>Member Ortu</center></font></td>
<td><font><center>Hapus</center></font></td></tr>";
// get news from db
if ($hal==1 || $hal=='')
$j=1;
else
$j=($brs*($hal-1))+1;
echo "<script language='JavaScript'>
function gCheckAll(chk) {
for (var i=0;i < document.forms[1].elements.length;i++) {
var e = document.forms[1].elements[i];
if (e.type == 'checkbox') {
e.checked = chk.checked }
}
}
</script>";
while ($row = mysql_fetch_array($query_result_handle))
{

$wali="<a href='admin.php?mode=sismember_tam&nis=$row[user_id]' title='klik untuk daftar' >Daftar</a>";
$query = "SELECT nama,userid,email,password FROM t_member WHERE nis='$row[user_id]' and kategori='1'";
$result = mysql_query ($query) or die (mysql_error());
if($r = mysql_fetch_array($result)) {
$wali='<a href="admin.php?mode=sismember_edit&id='.$r[userid].'" title="Klik untuk edit member." >'.$r[email].'</a>';
}
$wali2="<a href='admin.php?mode=ortu_tam&nis=$row[user_id]'>Daftar</a>";
$query = "SELECT nama,userid FROM t_member WHERE nis='$row[user_id]' and kategori='2'";
$result = mysql_query ($query) or die (mysql_error());
if($r = mysql_fetch_array($result)) {
$wali2='<a href="admin.php?mode=ortu_edit&id='.$r[userid].'" title="Klik untuk edit member." >'.$r[email].'</a>';
}
echo "<tr onMouseOver=\"this.className='highlight'\" onMouseOut=\"this.className='normal'\">
<td width='5%' align='center'><font>$j</font></td>
<td width='10%' ><font>$row[user_id]</font></td>
<td width='30%' ><font>$row[nama]</font></td>
<td width='10%' align='center'><font>$row[kelas]</font></td>
<td width='10%' align='center'><font>$wali</font></td>
<td width='10%' align='center' ><font>$wali2</font></td>";
$j++;
?>
<td width="10%" align="center"><input type='checkbox' name='id[<?php echo $row[user_id]; ?>]' value='on'> </td>
</tr>
<?php
}
echo "</table><input type=\"hidden\" name=\"mode\" value=\"siswa_hap\">
<input type='checkbox' name='cekall' value='on' onClick='gCheckAll(cekall);'> Checklist Semua <input type=\"submit\" value=\"Hapus\"> </form><br><font >";

}


function naikkelas() {
include "koneksi.php";

$klsasal=$_GET['klsasal'];
$klsakhir=$_GET['klsakhir'];
$program1=$_GET['program1'];
$program2=$_GET['program2'];

if ($klsasal=='') $klsasal='X - 1';
if ($klsakhir=='') $klsakhir='X - 1';
if($program1=='') $program1='-';
if($program2=='') $program2='-';
$query = "SELECT * from t_siswa where kelas='". mysql_escape_string($klsasal)."' order by nama ";
$query_result_handle = mysql_query ($query)
or die (mysql_error());
// check that there is news
// tambah alan untuk delete multiple
echo "<form action='admin.php' method=\"post\" name='naik'>";
if ($cmstingkat=='sma' or $cmstingkat=='smk') {
$data .= 'Jurusan/Prog. Keahlian <select name="program1" onchange="document.location.href=\'admin.php?mode=naikkelas&klsasal=\'+document.naik.klsasal.value+\'&klsakhir=\'+document.naik.klsakhir.value+\'&program1=\'+document.naik.program1.value+\'&program2=\'+document.naik.program2.value">';
$sql2="select * from t_programahli order by idprog";
$my=mysql_query($sql2);
while($al=mysql_fetch_array($my)) {
if ($al[program]==$program1) $data .= "<option value='$al[program]' selected>$al[program]</option>";
else $data .= "<option value='$al[program]' >$al[program]</option>";
}
$data .= "</select> &nbsp;&nbsp;";
}
else echo "<input type=hidden name='program1' value='-'/>";

$data .='<select name=klsasal onchange="document.location.href=\'admin.php?mode=naikkelas&klsasal=\'+document.naik.klsasal.value+\'&klsakhir=\'+document.naik.klsakhir.value+\'&program1=\'+document.naik.program1.value+\'&program2=\'+document.naik.program2.value" >';
$data .="<option value='Alumni'>Alumni</option>";
$sql="select * from t_kelas where program='". mysql_escape_string($program1)."' order by kelas";
if(!$q=mysql_query($sql)) die ("Pengambilan gagal1 kelas ");
while($row=mysql_fetch_array($q)) {
if ($klsasal==$row[kelas]) $data .="<option value='$row[kelas]' selected>$row[kelas]</option>";
else $data .="<option value='$row[kelas]'>$row[kelas]</option>";
}
$data.='</select>';
if ($cmstingkat=='sma' or $cmstingkat=='smk') {
$data2 .= 'Jurusan/Prog. Keahlian <select name="program2" onchange="document.location.href=\'admin.php?mode=naikkelas&klsasal=\'+document.naik.klsasal.value+\'&klsakhir=\'+document.naik.klsakhir.value+\'&program1=\'+document.naik.program1.value+\'&program2=\'+document.naik.program2.value">';
$sql2="select * from t_programahli order by idprog";
$my=mysql_query($sql2);
while($al=mysql_fetch_array($my)) {
if ($al[program]==$program2) $data2 .= "<option value='$al[program]' selected>$al[program]</option>";
else $data2 .= "<option value='$al[program]' >$al[program]</option>";
}
$data2 .= "</select> &nbsp;&nbsp;";
}
else $data2 .= "<input type=hidden name='program2' value='-'/>";

$data2.='<select name=klsakhir onchange="document.location.href=\'admin.php?mode=naikkelas&klsasal=\'+document.naik.klsasal.value+\'&klsakhir=\'+document.naik.klsakhir.value+\'&program1=\'+document.naik.program1.value+\'&program2=\'+document.naik.program2.value" >';
$data2 .="<option value='Alumni'>Alumni</option>";
$sql="select * from t_kelas where program='". mysql_escape_string($program2)."' order by kelas";
if(!$q=mysql_query($sql)) die ("Pengambilan gagal1 kelas ");
while($row=mysql_fetch_array($q)) {
if ($klsakhir==$row[kelas]) $data2 .="<option value='$row[kelas]' selected>$row[kelas]</option>";
else $data2 .="<option value='$row[kelas]'>$row[kelas]</option>";
}
$data2.="</select>";

if ($klsakhir=='Alumni') {
$thn = date("Y");
$data2.=" <select name='tahun' >";
for($k=$thn-2;$k<=$thn+3;$k++) {
if ($thn==$k) $data2 .="<option value='$k' selected >$k</option>";
else $data2 .="<option value='$k' >$k</option>";
}
$data2 .="</select>";
}
echo "<br><table cellspacing='0' cellpadding='5' width=100% border='1' bordercolor='#000000'>
<tr><td bgcolor='#999999' colspan='2' ><font><center>--- Kenaikan Kelas ---</center><br></td></tr>
<tr><td><font>Pilih Data Asal <br>$data <input type=\"submit\" value=\"Pindah\"></td>
<td><font>Pilih Data Tujuan <br>$data2</font></td></tr>";

echo "<tr><td width=50% valign='top'><input type='checkbox' name='cekall' value='on' onClick='gCheckAll(cekall);'>Checklist Semua</font>
<table border=1 cellspacing='0' cellpadding='0' bordercolor='#000000'>
<tr bgcolor=dedede><td><font><center>No</center></font></td><td><font><center>NIS</center></font></td>
<td><font><center>Nama</center></font></td><td><font><center>Pilih</center></font></td></tr>";
$j=1;
echo "<script language='JavaScript'>
function gCheckAll(chk) {
for (var i=0;i < document.naik.elements.length;i++) {
var e = document.naik.elements[i];
if (e.type == 'checkbox') {
e.checked = chk.checked }
}
}
</script>";
while ($row = mysql_fetch_array($query_result_handle))
{
echo "<tr onMouseOver=\"this.className='highlight'\" onMouseOut=\"this.className='normal'\">
<td width='5%' align='center'><font>$j</font></td>
<td width='8%' ><font>$row[user_id]</font></td>
<td width='50%' ><font>$row[nama]</font></td>";
$j++;
?>
<td width="5%" align="center"><input type='checkbox' name='id[<?php echo $row[user_id]; ?>]' value='on'> </td>
</tr>
<?php
}
echo "</table></td><td valign='top'><table border=1 cellspacing='0' cellpadding='3' bordercolor='#000000'>
<tr bgcolor=dedede><td><font><center>No</center></font></td><td><font><center>NIS</center></font></td>
<td><font><center>Nama</center></font></td></tr>";
$query2 = "SELECT * from t_siswa where kelas='". mysql_escape_string($klsakhir)."' order by nama ";
$q= mysql_query ($query2);
$j=1;
while ($r = mysql_fetch_array($q))
{
echo "<tr onMouseOver=\"this.className='highlight'\" onMouseOut=\"this.className='normal'\">
<td width='5%' align='center'><font>$j</font></td>
<td width='8%' ><font>$r[user_id]</font></td>
<td width='50%' ><font>$r[nama]</font></td>";
$j++;
}
echo "</table></td></tr></table>";
echo "<input type=\"hidden\" name=\"mode\" value=\"pindahkelas\">
<input type=\"submit\" value=\"Pindah\"></form><br>";

}

function pindahkelas() {
include "koneksi.php";
$klsasal=$_POST['klsasal'];
$klsakhir=$_POST['klsakhir'];
$id=$_POST['id'];
$tahun = $_POST['tahun'];

if (!empty($id))
{
while (list($key,$value)=each($id))
{
$sql="update t_siswa set kelas='". mysql_escape_string($klsakhir)."' where user_id='". mysql_escape_string($key)."'";
$mysql_result=mysql_query($sql) or die ("Query failed - Mysql");

//$sql="insert into t_niskelas (nis,kelas) values ( '". mysql_escape_string($key)."','". mysql_escape_string($klsasal)."')";
//$mysql_result=mysql_query($sql) or die ("Query failed - Mysql");

if ($klsakhir=='Alumni') {
$sql="update t_member set kelas='".$tahun."',ket='". mysql_escape_string($klsakhir)."' where nis='". mysql_escape_string($key)."'";
$mysql_result=mysql_query($sql) or die ("Query failed - Mysql");
}
else {
$sql="update t_member set kelas='".$klsakhir."' where nis='". mysql_escape_string($key)."'";
$mysql_result=mysql_query($sql) or die ("Query failed - Mysql");
}
}
}
echo "<meta http-equiv=\"refresh\" content=\"1;url=admin.php?mode=naikkelas&klsasal=$klsasal&klsakhir=$klsakhir\">\n";
}

} //akhir
?>