UTS PWeb - e Rapor Prestasi Siswa

Nama : Muh. Shafwatallah Wahid
NRP : 05111740007002
Kelas : PWeb C



1). config.php
<?php

$server = "localhost";
$user = "root";
$password = "";
$nama_database = "prestasi_siswa";

$db = mysqli_connect($server, $user, $password, $nama_database);

if( !$db ){
    die("Gagal terhubung dengan database: " . mysqli_connect_error());
}

?>

2). index.php
<!DOCTYPE html>
<html>
<head>
    <title>Prestasi Siswa</title>
</head>

<body>
    <header>
        <h3>Prestasi Siswa</h3>
        <h1>Kelas PWeb C</h1>
    </header>

    <h4>Menu</h4>
    <nav>
        <ul>
            <li><a href="form-daftar.php">Daftar Baru</a></li>
            <li><a href="list-siswa.php">Pendaftar</a></li>
        </ul>
    </nav>

    </body>
</html>

3). list-siswa.php
<?php include("config.php"); ?>

<!DOCTYPE html>
<html>
<head>
    <title>Prestasi Siswa</title>
</head>

<body>
    <header>
        <h3>Siswa yang Berprestasi</h3>
    </header>

    <nav>
        <a href="form-daftar.php">[+] Tambah Baru</a>
    </nav>

    <br>

    <table border="1">
    <thead>
        <tr>
            <th>Id</th>
            <th>Nama</th>
            <th>Kelas</th>
            <th>Semester</th>
            <th>Prestasi</th>
            <th>Ket_Prestasi</th>
        </tr>
    </thead>
    <tbody>

        <?php
        $sql = "SELECT * FROM prestasi";
        $query = mysqli_query($db, $sql);

        while($siswa = mysqli_fetch_array($query)){
            echo "<tr>";

            echo "<td>".$siswa['id']."</td>";
            echo "<td>".$siswa['Nama']."</td>";
            echo "<td>".$siswa['Kelas']."</td>";
            echo "<td>".$siswa['Semester']."</td>";
            echo "<td>".$siswa['Prestasi']."</td>";
            echo "<td>".$siswa['Ket_Prestasi']."</td>";
            echo "<td>";
            echo "<a href='form-edit.php?id=".$siswa['id']."'>Edit</a> | ";
            echo "<a href='hapus.php?id=".$siswa['id']."'>Hapus</a>";
            echo "</td>";

            echo "</tr>";
        }
        ?>

    </tbody>
    </table>

    <p>Total: <?php echo mysqli_num_rows($query) ?></p>

    </body>
</html>

4). form-daftar
<!DOCTYPE html>
<html>
<head>
    <title>Prestasi Siswa</title>
</head>

<body>
    <header>
        <h3>Prestasi Siswa</h3>
    </header>

    <form action="proses-pendaftaran.php" method="POST">

        <fieldset>

        <p>
            <label for="Nama">Nama: </label>
            <input type="text" name="nama" placeholder="Nama lengkap" />
        </p>
        <p>
            <label for="Semester">Semester: </label>
            <label><input type="radio" name="Semester" value="Semeter"> 1</label>
            <label><input type="radio" name="Semester" value="Semester">2</label>
        </p>
        <p>
            <label for="Kelas">Kelas: </label>
            <select name="Kelas">
                <option>X</option>
                <option>XI</option>
                <option>XII</option>
            </select>
        </p>
        <p>
            <label for="Prestasi">Prestasi: </label>
            <input type="text" name="Prestasi" placeholder="" />
        </p>
         <p>
            <label for="Ket_Prestasi">Ket Prestasi: </label>
            <textarea name="Ket Prestasi"></textarea>
        </p>
        <p>
            <input type="submit" value="Daftar" name="daftar" />
        </p>

        </fieldset>

    </form>

    </body>
</html>

5). proses-pendaftaran
<?php

include("config.php");

// cek apakah tombol daftar sudah diklik atau blum?
if(isset($_POST['daftar'])){

    // ambil data dari formulir
    $Nama = $_POST['Nama'];
    $Semester = $_POST['Semester'];
    $Kelas = $_POST['Kelas'];
    $Prestasi = $_POST['Prestasi'];
    $Ket_Prestasi = $_POST['Ket_Prestasi'];
    // buat query
    $sql = "INSERT INTO prestasi_siswa (Nama, Kelas, Semester, Prestasi, Ket_Prestasi) VALUE ('$Nama', '$Kelas', '$Semester', 'Prestasi', 'Ket_Prestasi')";
    $query = mysqli_query($db, $sql);

    // apakah query simpan berhasil?
    if( $query ) {
        // kalau berhasil alihkan ke halaman index.php dengan status=sukses
        header('Location: index.php?status=sukses');
    } else {
        // kalau gagal alihkan ke halaman indek.php dengan status=gagal
        header('Location: index.php?status=gagal');
    }


} else {
    die("Akses dilarang...");
}

?>

output







Komentar

Posting Komentar

Postingan Populer