WEB

//UBAH

!DOCTYPE html>
<html>
<head>
	<title>TAMBAH</title>
	<link rel="stylesheet" type="text/css" href="css/bootstrap.css">
	<title></title>
</head>
<body>
	<?php
	include "connect.php";

	$sql=mysqli_query($koneksi," SELECT * FROM siswa WHERE Nis='".$_GET['Nis']."'");
	$data=mysqli_fetch_array($sql);
	?>
		<form method="POST" action="prosesubah.php" enctype="multipart/form-data">
			<h1>FORM UBAH</h1>
		<table cellpadding="8">

	<tr>
			<td>NAMA</td>
			<td><input type="text"class="form-control" name="Nama" value="<?php echo $data['Nama'] ?>"></td>
	</tr>

	<tr>
		<td>JENIS KELAMIN</td>
			<td><input type='radio' name="Jenis_kelamin" value='laki-laki'<?php if($data['Jenis_kelamin']== "laki-laki")echo "checked"?>>laki-laki<input type='radio' name="Jenis_kelamin" value='Perempuan'<?php if($data['Jenis_kelamin']== "Perempuan")echo "checked"?>>Perempuan</td>
	</tr>
		<td>TELEPOHONE</td>
		<td><input type="text"class="form-control" name="Telepon" value="<?php echo $data['Telepon'] ?>"></td>
	</tr>
	<tr>
		<td>ALAMAT</td>
		<td><input type="text"class="form-control" name="Alamat" value="<?php echo $data['Alamat'] ?>"></td>
	</tr>
		<tr>
		<td>FOTO</td>
		<td><input type="checkbox" name="ubahfoto" value="true">ceklist untuk mengganti gambar<input type="file" name="Foto" value="<?= $data['Foto']?>"></td>

	<tr>
			<td><a href="prosesubah.php"><input type="submit" name="update" value="ubah"></a></td>
    </tr>
</table>
</body>
</html>


//PROSES UBAH

<?php
include "connect.php";

$Nis = $_GET['Nis'];
$Nama = $_POST['Nama'];
$Jenis_kelamin = $_POST['Jenis_kelamin'];
$Telepon = $_POST['Telepon'];
$Alamat = $_POST['Alamat'];


if(isset($_POST['ubahfoto'])){
	$Foto=$_FILES['Foto']['name'];
	$tmp=$_FILES['Foto']['tmp_name'];
	$fotobaru=date('dmYHis').$Foto;
	$path="img/".$fotobaru;

	if (move_uploaded_file($tmp,$path)){
		$query="SELECT * FROM siswa WHERE Nis='".$Nis."'";
		$sql= mysqli_query ($koneksi,$query);
		$data=mysqli_fetch_array($sql);

		if(is_file("img/".$data['Foto']))
			unlink("img/".$data['Foto']);
	$query = "UPDATE siswa SET Nama='".$Nama."',Jenis_kelamin='".$Jenis_kelamin."',Telepon='".$Telepon."',Alamat='".$Alamat."',Foto='".$fotobaru."'WHERE Nis='".$Nis."'";
	$sql = mysqli_query ($koneksi,$query);
	if($sql){
	 	 header("location: indexx.php");
	}
	else{
	echo"ERROR";
	}
}
else{
	echo "<b>ERROR UPLOAD FOTO</b>";
}
}
else{
	$query = "UPDATE siswa SET Nama='".$Nama."',Jenis_kelamin='".$Jenis_kelamin."',Telepon='".$Telepon."',Alamat='".$Alamat."',Foto='".$Fotobaru."'WHERE Nis='".$Nis."'";
	$sql= mysqli_query($koneksi,$query);

	if($sql){
	  header("location: indexx.php");
	}
	else{
	echo"maaf,terjadi kesalahan coba ulangi lagi";
	echo"<br><a href='ubah.php'>kembali ke from</a>";
	}
}
?>