<br />
<br />
<?php
include 'koneksi.php';



if($_GET) {
if(isset($_POST['btnSave']))
{
# Validasi form, jika kosong sampaikan pesan error
$pesanError = array();
if (trim($_POST['txtnama'])=="") {
$pesanError[] = "Data <b>Nama</b> tidak boleh kosong !";
}

$xidkelas =$_POST['xidkelas'];

# JIKA ADA PESAN ERROR DARI VALIDASI
if (count($pesanError)>=1 )
{
echo "<div class='mssgBox'>";
echo "<img src='images/attention.png'> <br><hr>";
$noPesan=0;
foreach ($pesanError as $indeks=>$pesan_tampil)
{
$noPesan++;
echo "   $noPesan. $pesan_tampil<br>";
}
echo "</div> <br>";
}
else
{

# SIMPAN DATA KE DATABASE.
// Jika tidak menemukan error, simpan data ke database
$mySql = "UPDATE siswa SET id_kelas='$xidkelas'

WHERE id_siswa='".$_POST['txtkode']."'";
$myQry = mysql_query($mySql) or die ("Gagal query".mysql_error());
if($myQry)
{
echo "<meta http-equiv='refresh' content='0; url=?menu=siswa'>";
}
exit;
}
} // Penutup POST

# TAMPILKAN DATA
$kode = isset($_GET['kode']) ? $_GET['kode'] : $_POST['txtidguru'];
$sqlShow= "SELECT * FROM siswa WHERE id_siswa='$kode'";
$qryShow= mysql_query($sqlShow) or die ("Query salah : ".mysql_error());
$dataShow = mysql_fetch_array($qryShow);

# MASUKKAN DATA KE VARIABEL
$datakode = $dataShow['id_siswa'];

} // Penutup GET

?>
<form action="?menu=siswa_edit" method="post">
<table width="459" border="0" class="table-list">
<tr>
<th colspan="3"><div align="center"><strong>Update Siswa</strong></div></th>
<input name="txtkode" type="hidden" value="<?php echo $datakode; ?>" />
</tr>
<tr><td valign="top">Kelas</td>
<td>:</td>
<td><select name="xidkelas" class="styledselect_form_1">
<?php
$pswt=mysql_query("SELECT * FROM kelas ORDER BY id_kelas ASC");
while($row=mysql_fetch_array($pswt))
{
?>
<option name="xidkelas" value="<?php echo $row['id_kelas'];?>"><?php echo $row['nama_kelas'];?></option>
<?php
}
?>
</select>
</td>

</table>

</form>