Tugas 8 Pemrograman Web C: Latihan MySQL
config.php:
1: <?php
2: $server = "sql305.byethost24.com";
3: $user = "b24_32977667";
4: $password = "000webhostampas";
5: $nama_database = "b24_32977667_pendaftaran_siswa";
6: $db = mysqli_connect($server, $user, $password, $nama_database);
7: if( !$db ){
8: die("Gagal terhubung dengan database: " . mysqli_connect_error());
9: }
10: ?>
database.sql:
1: CREATE DATABASE `pendaftaran_siswa`;
2: CREATE TABLE `pendaftaran_siswa`.`calon_siswa` (
3: `id` INT NOT NULL AUTO_INCREMENT ,
4: `nama` VARCHAR(64) NOT NULL ,
5: `alamat` VARCHAR(255) NOT NULL ,
6: `jenis_kelamin` VARCHAR(16) NOT NULL ,
7: `agama` VARCHAR(16) NOT NULL ,
8: `sekolah_asal` VARCHAR(64) NOT NULL ,
9: PRIMARY KEY (`id`)
10: ) ENGINE = InnoDB;
11: INSERT INTO `calon_siswa` (`id`, `nama`, `alamat`, `jenis_kelamin`, `agama`, `sekolah_asal`) VALUES (NULL, 'Lia', 'Jl. Mangga No. 3, Mataram', 'perempuan', 'islam', 'SMPN 32 Ampenan');
form-daftar.php:
1: <!DOCTYPE html>
2: <html>
3: <head>
4: <title>Formulir Pendaftaran Siswa Baru | SMK Coding</title>
5: </head>
6: <body>
7: <header>
8: <h3>Formulir Pendaftaran Siswa Baru</h3>
9: </header>
10: <form action="proses-pendaftaran.php" method="POST">
11: <fieldset>
12: <p>
13: <label for="nama">Nama: </label>
14: <input type="text" name="nama" placeholder="nama lengkap" />
15: </p>
16: <p>
17: <label for="alamat">Alamat: </label>
18: <textarea name="alamat"></textarea>
19: </p>
20: <p>
21: <label for="jenis_kelamin">Jenis Kelamin: </label>
22: <label><input type="radio" name="jenis_kelamin" value="laki-laki"> Laki-laki</label>
23: <label><input type="radio" name="jenis_kelamin" value="perempuan"> Perempuan</label>
24: </p>
25: <p>
26: <label for="agama">Agama: </label>
27: <select name="agama">
28: <option>Islam</option>
29: <option>Kristen</option>
30: <option>Hindu</option>
31: <option>Budha</option>
32: <option>Atheis</option>
33: </select>
34: </p>
35: <p>
36: <label for="sekolah_asal">Sekolah Asal: </label>
37: <input type="text" name="sekolah_asal" placeholder="nama sekolah" />
38: </p>
39: <p>
40: <input type="submit" value="Daftar" name="daftar" />
41: </p>
42: </fieldset>
43: </form>
44: </body>
45: </html>
form-edit.php:
1: <?php
2: include("config.php");
3: // kalau tidak ada id di query string
4: if( !isset($_GET['id']) ){
5: header('Location: list-siswa.php');
6: }
7: //ambil id dari query string
8: $id = $_GET['id'];
9: // buat query untuk ambil data dari database
10: $sql = "SELECT * FROM calon_siswa WHERE id=$id";
11: $query = mysqli_query($db, $sql);
12: $siswa = mysqli_fetch_assoc($query);
13: // jika data yang di-edit tidak ditemukan
14: if( mysqli_num_rows($query) < 1 ){
15: die("data tidak ditemukan...");
16: }
17: ?>
18: <!DOCTYPE html>
19: <html>
20: <head>
21: <title>Formulir Edit Siswa | SMK Coding</title>
22: </head>
23: <body>
24: <header>
25: <h3>Formulir Edit Siswa</h3>
26: </header>
27: <form action="proses-edit.php" method="POST">
28: <fieldset>
29: <input type="hidden" name="id" value="<?php echo $siswa['id'] ?>" />
30: <p>
31: <label for="nama">Nama: </label>
32: <input type="text" name="nama" placeholder="nama lengkap" value="<?php echo $siswa['nama'] ?>" />
33: </p>
34: <p>
35: <label for="alamat">Alamat: </label>
36: <textarea name="alamat"><?php echo $siswa['alamat'] ?></textarea>
37: </p>
38: <p>
39: <label for="jenis_kelamin">Jenis Kelamin: </label>
40: <?php $jk = $siswa['jenis_kelamin']; ?>
41: <label><input type="radio" name="jenis_kelamin" value="laki-laki" <?php echo ($jk == 'laki-laki') ? "checked": "" ?>> Laki-laki</label>
42: <label><input type="radio" name="jenis_kelamin" value="perempuan" <?php echo ($jk == 'perempuan') ? "checked": "" ?>> Perempuan</label>
43: </p>
44: <p>
45: <label for="agama">Agama: </label>
46: <?php $agama = $siswa['agama']; ?>
47: <select name="agama">
48: <option <?php echo ($agama == 'Islam') ? "selected": "" ?>>Islam</option>
49: <option <?php echo ($agama == 'Kristen') ? "selected": "" ?>>Kristen</option>
50: <option <?php echo ($agama == 'Hindu') ? "selected": "" ?>>Hindu</option>
51: <option <?php echo ($agama == 'Budha') ? "selected": "" ?>>Budha</option>
52: <option <?php echo ($agama == 'Atheis') ? "selected": "" ?>>Atheis</option>
53: </select>
54: </p>
55: <p>
56: <label for="sekolah_asal">Sekolah Asal: </label>
57: <input type="text" name="sekolah_asal" placeholder="nama sekolah" value="<?php echo $siswa['sekolah_asal'] ?>" />
58: </p>
59: <p>
60: <input type="submit" value="Simpan" name="simpan" />
61: </p>
62: </fieldset>
63: </form>
64: </body>
65: </html>
hapus.php:
1: <?php
2: include("config.php");
3: if( isset($_GET['id']) ){
4: // ambil id dari query string
5: $id = $_GET['id'];
6: // buat query hapus
7: $sql = "DELETE FROM calon_siswa WHERE id=$id";
8: $query = mysqli_query($db, $sql);
9: // apakah query hapus berhasil?
10: if( $query ){
11: header('Location: list-siswa.php');
12: } else {
13: die("gagal menghapus...");
14: }
15: } else {
16: die("akses dilarang...");
17: }
18: ?>
index.php:
1: <!DOCTYPE html>
2: <html>
3: <head>
4: <title>Pendaftaran Siswa Baru | SMK Coding</title>
5: </head>
6: <body>
7: <header>
8: <h3>Pendaftaran Siswa Baru</h3>
9: <h1>SMK Coding</h1>
10: </header>
11: <h4>Menu</h4>
12: <nav>
13: <ul>
14: <li><a href="form-daftar.php">Daftar Baru</a></li>
15: <li><a href="list-siswa.php">Pendaftar</a></li>
16: </ul>
17: </nav>
18: <?php if(isset($_GET['status'])): ?>
19: <p>
20: <?php
21: if($_GET['status'] == 'sukses'){
22: echo "Pendaftaran siswa baru berhasil!";
23: } else {
24: echo "Pendaftaran gagal!";
25: }
26: ?>
27: </p>
28: <?php endif; ?>
29: </body>
30: </html>
list-siswa.php:
1: <?php include("config.php"); ?>
2: <!DOCTYPE html>
3: <html>
4: <head>
5: <title>Pendaftaran Siswa Baru | SMK Coding</title>
6: </head>
7: <body>
8: <header>
9: <h3>Siswa yang sudah mendaftar</h3>
10: </header>
11: <nav>
12: <a href="form-daftar.php">[+] Tambah Baru</a>
13: </nav>
14: <br>
15: <table border="1">
16: <thead>
17: <tr>
18: <th>No</th>
19: <th>Nama</th>
20: <th>Alamat</th>
21: <th>Jenis Kelamin</th>
22: <th>Agama</th>
23: <th>Sekolah Asal</th>
24: <th>Tindakan</th>
25: </tr>
26: </thead>
27: <tbody>
28: <?php
29: $sql = "SELECT * FROM calon_siswa";
30: $query = mysqli_query($db, $sql);
31: while($siswa = mysqli_fetch_array($query)){
32: echo "<tr>";
33: echo "<td>".$siswa['id']."</td>";
34: echo "<td>".$siswa['nama']."</td>";
35: echo "<td>".$siswa['alamat']."</td>";
36: echo "<td>".$siswa['jenis_kelamin']."</td>";
37: echo "<td>".$siswa['agama']."</td>";
38: echo "<td>".$siswa['sekolah_asal']."</td>";
39: echo "<td>";
40: echo "<a href='form-edit.php?id=".$siswa['id']."'>Edit</a> | ";
41: echo "<a href='hapus.php?id=".$siswa['id']."'>Hapus</a>";
42: echo "</td>";
43: echo "</tr>";
44: }
45: ?>
46: </tbody>
47: </table>
48: <p>Total: <?php echo mysqli_num_rows($query) ?></p>
49: </body>
50: </html>
proses-edit.php:
1: <?php
2: include("config.php");
3: // cek apakah tombol simpan sudah diklik atau blum?
4: if(isset($_POST['simpan'])){
5: // ambil data dari formulir
6: $id = $_POST['id'];
7: $nama = $_POST['nama'];
8: $alamat = $_POST['alamat'];
9: $jk = $_POST['jenis_kelamin'];
10: $agama = $_POST['agama'];
11: $sekolah = $_POST['sekolah_asal'];
12: // buat query update
13: $sql = "UPDATE calon_siswa SET nama='$nama', alamat='$alamat', jenis_kelamin='$jk', agama='$agama', sekolah_asal='$sekolah' WHERE id=$id";
14: $query = mysqli_query($db, $sql);
15: // apakah query update berhasil?
16: if( $query ) {
17: // kalau berhasil alihkan ke halaman list-siswa.php
18: header('Location: list-siswa.php');
19: } else {
20: // kalau gagal tampilkan pesan
21: die("Gagal menyimpan perubahan...");
22: }
23: } else {
24: die("Akses dilarang...");
25: }
26: ?>
proses-pendaftaran.php:
1: <?php
2: include("config.php");
3: // cek apakah tombol daftar sudah diklik atau blum?
4: if(isset($_POST['daftar'])){
5: // ambil data dari formulir
6: $nama = $_POST['nama'];
7: $alamat = $_POST['alamat'];
8: $jk = $_POST['jenis_kelamin'];
9: $agama = $_POST['agama'];
10: $sekolah = $_POST['sekolah_asal'];
11: // buat query
12: $sql = "INSERT INTO calon_siswa (nama, alamat, jenis_kelamin, agama, sekolah_asal) VALUE ('$nama', '$alamat', '$jk', '$agama', '$sekolah')";
13: $query = mysqli_query($db, $sql);
14: // apakah query simpan berhasil?
15: if( $query ) {
16: // kalau berhasil alihkan ke halaman index.php dengan status=sukses
17: header('Location: index.php?status=sukses');
18: } else {
19: // kalau gagal alihkan ke halaman indek.php dengan status=gagal
20: header('Location: index.php?status=gagal');
21: }
22: } else {
23: die("Akses dilarang...");
24: }
25: ?>
Link Repository: https://github.com/brianakbar/Tugas8_PWebC_LatihanMySQL
Link Website: http://pendaftaransiswa.byethost24.com/
Screenshot:
Comments
Post a Comment