<?php
include("config.php");
// kalau tidak ada id di query string
if( !isset($_GET['id']) ){
header('Location: list-siswa.php');
}
//ambil id dari query string
$id = $_GET['id'];
// buat query untuk ambil data dari database
$sql = "SELECT * FROM calon_mahasiswa WHERE id=$id";
$query = mysqli_query($db, $sql);
$siswa = mysqli_fetch_assoc($query);
// jika data yang di-edit tidak ditemukan
if( mysqli_num_rows($query) < 1 ){
die("data tidak ditemukan...");
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Formulir Edit Siswa | SMK Coding</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
<link href='https://fonts.googleapis.com/css?family=Poppins' rel='stylesheet'>
<style type="text/css">
html,
body {
height: 100%;
background-color: green;
font-family: Poppins;
justify-content: center;
}
</style>
</head>
<body>
<nav class="navbar navbar-expand-md navbar-light bg-light mb-4">
<div class="container-fluid">
<ul class="navbar-nav me-auto mb-2 mb-md-0">
<li class="nav-item">
<a class="nav-link active" aria-current="page" href="index.php">Home</a>
</li>
<li class="nav-item">
<a class="nav-link" href="form-daftar.php">Form Pendaftaran</a>
</li>
<li class="nav-item">
<a class="nav-link" href="list-siswa.php">List Pendaftar</a>
</li>
</ul>
</div>
</nav>
<div class="container">
<header>
<h3 class="text-center mt-5">Formulir Edit Siswa</h3>
</header>
<form action="proses-edit.php" method="POST">
<input type="hidden" name="id" value="<?php echo $siswa['id'] ?>" />
<div class="form-group">
<label for="nama">Nama: </label>
<input type="text" class="form-control" name="nama" placeholder="nama lengkap" value="<?php echo $siswa['nama'] ?>" />
</div>
<div class="form-group">
<label for="foto" class="form-label">Foto: </label>
<input type="file" name="foto" class="form-control" required />
</div>
<div class="form-group">
<label for="alamat">Alamat: </label>
<textarea class="form-control" name="alamat"><?php echo $siswa['alamat'] ?></textarea>
</div>
<fieldset class="form-group">
<legend class="col-form-label">Jenis Kelamin</legend>
<?php $jk = $siswa['jenis_kelamin']; ?>
<div class="form-check">
<input class="form-check-input" type="radio" id="laki" name="jenis_kelamin" value="laki-laki" <?php echo ($jk == 'laki-laki') ? "checked": "" ?>>
<label class="form-check-label" for="laki">
Laki laki
</label>
</div>
<div class="form-check">
<input class="form-check-input" type="radio" id="perempuan" name="jenis_kelamin" value="perempuan" <?php echo ($jk == 'perempuan') ? "checked": "" ?>>
<label class="form-check-label" for="perempuan">
Perempuan
</label>
</div>
</fieldset>
<div class="form-group">
<label for="agama">Agama: </label>
<?php $agama = $siswa['agama']; ?>
<select class="form-control" name="agama">
<option <?php echo ($agama == 'Islam') ? "selected": "" ?>>Islam</option>
<option <?php echo ($agama == 'Kristen') ? "selected": "" ?>>Kristen</option>
<option <?php echo ($agama == 'Hindu') ? "selected": "" ?>>Hindu</option>
<option <?php echo ($agama == 'Budha') ? "selected": "" ?>>Budha</option>
<option <?php echo ($agama == 'Katolik') ? "selected": "" ?>>Katolik</option>
<option <?php echo ($agama == 'Konghucu') ? "selected": "" ?>>Konghucu</option>
</select>
</div>
<div class="form-group">
<label for="sekolah_asal">Sekolah Asal: </label>
<input type="text" class="form-control" name="sekolah_asal" placeholder="nama sekolah" value="<?php echo $siswa['sekolah_asal'] ?>" />
</div>
<div class="form-group">
<input class="btn btn-primary btn-lg btn-block" type="submit" value="Simpan" name="simpan" />
</div>
</form>
</div>
</body>
</html>