Membuat Halaman Edit Paket Kursus
Selanjutnya, kita akan membuat halaman untuk mengedit Paket Kursus.
Pertama buatlah New File diproject kita dengan nama “edit_paket.php”.
Kemudian Copy Source code nya dibawah postingan ini, dan save. Jika berhasil maka akan muncul halaman edit paket kursus. Selanjutnya coba akses menu paket kursus dan pada kolom aksi di data tabel, klik tombol edit. cobalah lakukan pengeditan data.
Source code :
<?php
session_start();
if (!isset($_SESSION[“login”])){
header(“Location: login.php”);
exit;
}
require ‘function.php’;
// ambil data dari url
// query data pelajar berdasarkan id
$id = $_GET[“id”];
$tabel_paket = query(“SELECT * FROM tb_paket_kursus WHERE id = $id”)[0];
// cek apakah tombol edit sudah ditekan apa belum
if (isset($_POST[“edit_paket”])) {
// cek apakah data berhasil diedit atau tidak
if (edit_paket($_POST) > 0){
echo “<script>
alert(‘Data berhasil diedit’);
document.location.href=’paket_kursus.php’;
</script>
“;
} else {
echo “<script>
alert(‘Data gagal diedit’);
document.location.href=’paket_kursus.php’;
</script>
“;
}
}
?>
<!DOCTYPE html>
<html>
<head>
<!–Import Google Icon Font–>
<link href=”https://fonts.googleapis.com/icon?family=Material+Icons” rel=”stylesheet”>
<!–Import materialize.css–>
<link type=”text/css” rel=”stylesheet” href=”css/materialize.min.css” media=”screen,projection”/>
<link type=”text/css” rel=”stylesheet” href=”fonts/fontawesome-all.css”>
<link rel=”stylesheet” href=”css/style.css”>
<title>Rumah Coding</title>
<!–Let browser know website is optimized for mobile–>
<meta name=”viewport” content=”width=device-width, initial-scale=1.0″/>
</head>
<body id=”home” class=”scrollspy”>
<!– navbar –>
<div class=”navbar-fixed”>
<nav class=”teal darken-3″>
<div class=”container”>
<div class=”nav-wrapper”>
<a href=”#home!” class=”brand-logo”>Rumah Coding</a>
<a href=”#” data-target=”mobile-nav” class=”sidenav-trigger”><i class=”material-icons”>menu</i></a>
<ul class=”right hide-on-med-and-down”>
<li><a href=”index.php”>Home</a></li>
<li><a href=”data_pelajar.php”>Data Pelajar</a></li>
<li><a href=””>Jadwal Belajar</a></li>
<li><a href=”paket_kursus.php”>Paket Kursus</a></li>
<li><a href=”logout.php” class=”tooltipped” data-position=”bottom” data-tooltip =”Logout”><i class=”material-icons”>account_circle</i></a></li>
</ul>
</div>
</div>
</nav>
</div>
<!– sidenav –>
<ul class=”sidenav teal darken” id=”mobile-nav”>
<li><a href=”index.php”>Home</a></li>
<li><a href=”data_pelajar.php”>Data Pelajar</a></li>
<li><a href=””>Jadwal Belajar</a></li>
<li><a href=”paket_kursus.php”>Paket Kursus</a></li>
<li><a href=”logout.php” class=”tooltipped” data-position=”bottom” data-tooltip =”Logout”><i class=”material-icons”>account_circle</i></a></li>
</ul>
<!– edit data pelajar –>
<section>
<div class=”container”>
<h5 class=”center-align”>Edit Data Paket</h5>
<div class=”row center-align”>
<form class=”col s8 offset-s2″ action=”” method=”post”>
<input type=”hidden” name=”id” value=”<?php echo $tabel_paket[“id”]; ?>”>
<div class=”row”>
<div class=”input-field col s12″>
<select id=”nama_paket” name=”nama_paket”>
<option value=”” disabled selected>Pilih Nama Paket</option>
<option value=”Ekonomi”<?php if($tabel_paket[“nama_paket”] == “Ekonomi”){echo”selected=\”selected\””; } ?>>Ekonomi</option>
<option value=”Bisnis”<?php if($tabel_paket[“nama_paket”] == “Bisnis”){echo”selected=\”selected\””; } ?>>Bisnis</option>
<option value=”Private”<?php if($tabel_paket[“nama_paket”] == “Private”){echo”selected=\”selected\””; } ?>>Private</option>
</select>
</div>
</div>
<div class=”row”>
<div class=”input-field col s12″>
<select id=”services” name=”services”>
<option value=”” disabled selected>Pilih Sevices</option>
<option value=”Materi + Manual + Book”<?php if($tabel_paket[“services”] == “Materi + Manual + Book”){echo”selected=\”selected\””; } ?>>Materi + Manual Book</option>
<option value=”Materi + Manual Book + Video”<?php if($tabel_paket[“services”] == “Materi + Manual Book + Video”){echo”selected=\”selected\””; } ?>>Materi + Manual Book + Video Tutorial</option>
<option value=”Materi + Manual Book + Video + Hosting & Domain”<?php if($tabel_paket[“services”] == “Materi + Manual Book + Video + Hosting & Domain”){echo”selected=\”selected\””; } ?>>Materi + Manual Book + Video Tutorial + Hosting & Domain</option>
</select>
</div>
</div>
<div class=”row”>
<div class=”input-field col s12″>
<select id=”pertemuan” name=”pertemuan”>
<option value=”” disabled selected>Pilih Jumlah Pertemuan</option>
<option value=”4 x Pertemuan”<?php if($tabel_paket[“pertemuan”] == “4 x Pertemuan”){echo”selected=\”selected\””; } ?>>4 x Pertemuan</option>
<option value=”8 x Pertemuan”<?php if($tabel_paket[“pertemuan”] == “8 x Pertemuan”){echo”selected=\”selected\””; } ?>>8 x Pertemuan</option>
<option value=”12 x Pertemuan”<?php if($tabel_paket[“pertemuan”] == “12 x Pertemuan”){echo”selected=\”selected\””; } ?>>12 x Pertemuan</option>
</select>
</div>
</div>
<div class=”row”>
<div class=”input-field col s12″>
<select id=”harga_paket” name=”harga_paket”>
<option value=”” disabled selected>Pilih Harga Paket</option>
<option value=”Rp. 500.000,-“<?php if($tabel_paket[“harga_paket”] == “Rp. 500.000,-“){echo”selected=\”selected\””; } ?>>Rp. 500.000,-</option>
<option value=”Rp. 1.000.000,-“<?php if($tabel_paket[“harga_paket”] == “Rp. 1.000.000,-“){echo”selected=\”selected\””; } ?>>Rp. 1.000.000,-</option>
<option value=”Rp. 2.000.000,-“<?php if($tabel_paket[“harga_paket”] == “Rp. 2.000.000,-“){echo”selected=\”selected\””; } ?>>Rp. 2.000.000,-</option>
</select>
</div>
</div>
<div class=”row”>
<div class=”input-field col s12″>
<select id=”tutor” name=”tutor”>
<option value=”” disabled selected>Pilih Tutor</option>
<option value=”Suseno Rudiansyah”<?php if($tabel_paket[“tutor”] == “Suseno Rudiansyah”){echo”selected=\”selected\””; } ?>>Suseno Rudiansyah</option>
<option value=”Yusuf Bachtiar”<?php if($tabel_paket[“tutor”] == “Yusuf Bachtiar”){echo”selected=\”selected\””; } ?>>Yusuf Bachtiar</option>
<option value=”Indra Bayu”<?php if($tabel_paket[“tutor”] == “Indra Bayu”){echo”selected=\”selected\””; } ?>>Indra Bayu</option>
</select>
</div>
</div>
<button type=”submit” name=”edit_paket” class=”btn”>Edit Data</button>
</form>
</div>
</div>
</section>
<!– footer –>
<footer class=”teal darken-3 white-text center”>
<p>Maya Haryani (201543501606) || Copyright 2018</p>
</footer>
<script type=”text/javascript”>
</script>
<!–JavaScript at end of body for optimized loading–>
<script type=”text/javascript” src=”js/materialize.min.js”></script>
<script type=”text/javascript” src=”js/script.js”></script>
</body>
</html>