<h2>Edit Biodata Siswa</h2>
<?php
$ambil=$koneksi->query("SELECT * FROM siswa WHERE id_siswa='$_GET[id]'");
$pecah=$ambil->fetch_assoc();
echo "<pre>";
	print_r($pecah);
echo"</pre>";
 ?>
 <form method="post" enctype="multipart/form-data">
 	<div class="form-group">
 		<label>NISN</label>
 		<input type="text" name="nisn" class="form-control" value="<?php echo $pecah['nisn']; ?>">
 	</div>
<div class="form-group">
	<label>Nama Siswa</label>
	<input type="text" name="nama_siswa" class="form-control" value="<?php echo $pecah['nama_siswa']; ?>">
</div>
<div class="form-group">
	<label>Ganti Jenis Kelamin</label>
			<select name="jenis_kelamin" class="form-control">
				<option value="" selected>Pilih Jenis Kelamin</option>
				<option value="Laki - Laki">Laki - laki</option>
				<option value="Perempuan">Perempuan</option>
			</select>
</div>
<div class="form-group">
	<label>Ganti Tanggal Lahir</label>
<select name="tanggal" id="">
	<option value="">Pilih Tanggal</option>
<?php for ($d=1; $d<=31 ; $d++) {?>
<option value="<?php echo $d ?>"><?php echo $d ?></option>
<?php } ?>
</select>
<select name="bulan" id="">
	<option value="">Pilih Bulan</option>
<?php for ($m=1; $m<=12 ; $m++) {?>
<option value="<?php echo $m ?>"><?php echo $m ?></option>
<?php } ?>
</select>
<select name="tahun" id="">
	<option value="">Pilih Tahun</option>
	<?php for ($y=date('Y'); $y>=1945 ; $y--) {?>
<option value="<?php echo $y ?>"><?php echo $y ?></option>
<?php } ?>
</select>
</div>
	<div class="form-group">
		<label>Alamat</label>
		<textarea name="alamat" class="form-control" rows="10"><?php echo $pecah['alamat'];?></textarea>
	</div>
	<div class="form-group">
		<label>Agama</label>
		<input type="text" class="form-control" name="agama" value="<?php echo $pecah['agama']; ?>">
	</div>
<div class="form-group">
	<img src="../foto_siswa/<?php echo $pecah['foto'] ?>" width="100">
</div>
<div class="form-group">
	<label>Ganti Foto</label>
<input type="file" class="form-control" name="foto">
</div>
<div class="form-group">
	<label>username</label>
	<input type="text" class="form-control" name="username" value="<?php echo $pecah['username']; ?>">
</div>
<div class="form-group">
	<label>password</label>
	<input type="password" class="form-control" name="password" value="<?php echo $pecah['password']; ?>">
</div>
<?php
	$ambil = $koneksi->query("select * from kelas order by nama_kelas asc");
	echo "<label>Kelas</label>";
echo "<select name='id_kelas' class='form-control'>";
echo "<option value='0'>Pilih Kelas</option>";
while($pecah =$ambil->fetch_assoc()){
	echo "<option value='$pecah[id_kelas]'>$pecah[nama_kelas]</option>";
}
echo "</select>";
?>
<br>

<button class="btn btn-primary" name="edit">Edit</button>
 </form>
<?php
if (isset($_POST['edit'])) {
	$namafoto=$_FILES['foto']['name'];
	$lokasifoto=$_FILES['foto']['tmp_name'];
	if (!empty($lokasifoto)) {
		move_uploaded_file($lokasifoto, "../foto_siswa/$namafoto");
$koneksi->query("update siswa set nisn='$_POST[nisn]',nama_siswa='$_POST[nama_siswa]',jenis_kelamin='$_POST[jenis_kelamin]',
tgl_lahir='$_POST[tahun]-$_POST[bulan]-$_POST[tanggal]',alamat='$_POST[alamat]',agama='$_POST[agama]',foto='$namafoto',
username='$_POST[username]',password='$_POST[password]',id_kelas='$_POST[id_kelas]' where id_siswa='$_GET[id]'");

	}
	else{
$koneksi->query("update siswa set nisn='$_POST[nisn]',nama_siswa='$_POST[nama_siswa]',jenis_kelamin='$_POST[jenis_kelamin]',tgl_lahir='$_POST[tahun]-$_POST[bulan]-$_POST[tanggal]',
alamat='$_POST[alamat]',agama='$_POST[agama]',username='$_POST[username]',password='$_POST[password]',id_kelas='$_POST[id_kelas]' where id_siswa='$_GET[id]'");
	}

	echo "<script>alert('Data Siswa Telah diubah');</script>";
	echo "<script>location='index.php?halaman=siswa';</script>";
}
 ?>