CHALLANGE NILAI

by Andra Qeysa

SCREENSHOT HASIL

PERTAMA BUAT FOLDER BARU KEMUDIAN DILAMA FOLDER BUAT FOLDER ASSET

DILALAM ASSET MASUKKAN BOOTSTRAP FONTAWOSEME DAN BUAT FILE HEADER.PHP DAN FOOTER.PHP

UNTUK KODE HEADER.PHP NYA SEPERTI INI

<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">

    <link rel="stylesheet" href="http://localhost/nilai/aset/bootstrap/css/bootstrap.min.css">
    <link rel="stylesheet" href="http://localhost/nilai/aset/fontawesome/css/all.min.css">

    <title>Form Siswa</title>
</head>
<body>

   <nav class="navbar navbar-expand-lg navbar-info bg-dark">
   <a class="navbar-brand"href="#">Data Bases </a>
   <button class="navbar-toggler"type="button"data-toggle="collapse"data-target="#navbarNavAltMarkup">
   <span class="navbar-toggler-icon"></span>
   </button>
   <div class="collapse navbar-collapse" id="navbarNavAltMarkup">
        <div class="navbar-nav">
        <a class="nav-item nav-link" href="http://nilai/index.php">Form data siswa</a>
        </div>
    </div>
    <form class="form-inline my-2 my-lg-0">
      <input class="form-control mr-sm-2" type="search" placeholder="Search" aria-label="Search">
      <button class="btn btn-outline-success my-2 my-sm-0" type="submit">Search</button>
    </form>

</div>
</nav>
<script src="https://localhost/nilai/aset/jquery.js"></script>
<script src="https://localhost/nilai/aset/bootstrap/js/bootstrap.min.js"></script>
</body>
</html>

SEDANGKAN YANG FOSTER SEPERTI INI

<script src="http://localhost/nilai/aset/jquery.js"></script>
   <script src="http://localhost/nilai/aset/bootstrap/js/bootstrap.min.js"></script>

KEMUDIAN KEMBALI KE FOLDER UTAMA

KEMUDIAN BUAT FILE INDEX DENGAN KODE SEPERTI BERIKUT

<?php

include 'aset/header.php';

?>

<?php
include 'koneksi.php';

$sql = "SELECT * FROM siswa";


$res = mysqli_query($koneksi,$sql);
$anggota = array();

while ($data = mysqli_fetch_assoc($res)){
    $anggota[] = $data;
}
?>

<style>
    body{
        background-color: gray;
    }
    thead{
        background-color: crimson;
        color: white;
    }
    tbody{
        background-color: forestgreen;
        color: white;
    }
</style>
<body>
<div class="container">
    <div class="row mt-4">
        <div class="col-md">
            <div class="card bg-dark">
                <div class="card-header">
                    <h2 class="card-title text-white"><i class="fas fa-edit"></i>Data Siswa</h2>
                </div>
                <div class="card-body">
                    <table class="table table-striped ">
                        <thead>
                            <tr>
                                <th scope="col">#</th>
                                <th scope="col">NISN</th>
                                <th scope="col">Nama</th>
                                <th scope="col">Jurusan</th>
                                <th scope="col">Kelas</th>
                                <th scope="col">Alamat</th>
                                <th scope="col">Aksi</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php
                                $no = 1;
                                foreach ($anggota as $p ) { ?>
                                <tr>
                                    <th scope="row"><?= $no ?></th>
                                    <td><?= $p['NISN'] ?></td>
                                    <td><?= $p['Nama'] ?></td>
                                    <td><?= $p['Jurusan'] ?></td>
                                    <td><?= $p['Kelas'] ?></td>
                                    <td><?= $p['Alamat'] ?></th>
                                    <td>
                                        <a href="detail.php" class="badge badge-primary">DETAIL</a>
                                        <a href="hapus.php" class="badge badge-danger">HAPUS</a>
                                    </td>
                                </tr>
                            <?php
                                $no++;
                                }
                            ?>
                        </tbody>
                    </table>
                    <a href="tambah.php"><button type="submit" class="btn btn-success">Tambah Data Siswa</button></a>
                </div>
            </div>
        </div>
    </div>
</div>
</body>

<?php
include 'aset/footer.php';
?>

JIKA SUDAH BUAT FILE TAMBAH DENGAN CODE BERIKUT

<?php 
    include 'aset/header.php';
?>
<style>
body{
    background-color:gray;
}
</style>

<body>
<div class="container">
    <div class="row mt-4">
        <div class="col-md-9">
            <div class="card">
                <div class="card-header bg-info text-white">
                    <h2>Tambah Data Siswa</h2>
                </div>
                <div class="card-body bg">
                    <form method="post" action="proses-tambah.php">
                        <div class="form-group">
                            <label for="NISN">NISN</label>
                            <input type="text" class="form-control" name="NISN" id="NISN" placeholder="Input NISN siswa">
                        </div>
                        <div class="form-group">
                            <label for="Nama">Nama Lengkap</label>
                            <input type="text" class="form-control" name="Nama" id="Nama" placeholder="Input nama lengkap">
                        </div>
                        <div class="form-group">
                            <label for="Jurusan">Jurusan</label>
                            <select name="Jurusan" class="form-control">
                                <option value="RPL">RPL</option>
                                <option value="TKJ">TKJ</option>
                                <option value="MM">MM</option>
                            </select>
                        </div>
                        <div class="form-group">
                            <label for="Kelas">Kelas</label>
                            <select name="Kelas" class="form-control">
                                <option value="X">X</option>
                                <option value="XI">XI</option>
                                <option value="XII">XII</option>
                            </select>
                        </div>
                        <div class="form-group">
                            <label for="Alamat">Alamat</label>
                            <input type="text" class="form-control" name="Alamat" id="Alamat" placeholder="Masukkan alamat">
                        </div>
                        <div class="form-group">
                            <label for="nilai_mw">Nilai Matpel Web</label>
                            <input type="number" class="form-control" name="nilai_mw" id="nilai_mw" placeholder="Masukkan nilai">
                        </div>
                        <div class="form-group">
                            <label for="nilai_mpbo">Nilai Matpel PBO</label>
                            <input type="number" class="form-control" name="nilai_mpbo" id="nilai_mpbo" placeholder="Masukkan nilai">
                        </div>
                        <div class="form-group">
                            <label for="nilai_mb">Nilai Matpel Basdat</label>
                            <input type="number" class="form-control" name="nilai_mb" id="nilai_mb" placeholder="Masukkan nilai">
                        </div>
                        <div class="form-group">
                            <label for="nilai_md">Nilai Matpel Desain</label>
                            <input type="number" class="form-control" name="nilai_md" id="nilai_md" placeholder="Masukkan nilai">
                        </div>
                        <div class="form-group">
                            <label for="nilai_mp">Nilai Matpel Progdas</label>
                            <input type="nilai_mp" class="form-control" name="nilai_mp" id="nilai_mp" placeholder="Masukkan nilai">
                        </div>
                        <button type="submit" class="btn btn-primary" name="simpan">Simpan</button>
                    </form>
                </div>
            </div>
        </div>
    </div>
</div>
</body>

<?php 
    include 'aset/footer.php';
?>

KEMUDIAN BUAT FILE PROSES TAMBAH DENGAN KODE BERIKUT

<?php

    include 'koneksi.php';

    if(isset($_POST['simpan']))
    {
        $nisn = $_POST['NISN'];
        $nama = $_POST['Nama'];
        $jurusan = $_POST['Jurusan'];
        $kelas = $_POST['Kelas'];
        $alamat = $_POST['Alamat'];
        $nilai_mw = $_POST['nilai_mw'];
        $nilai_mpbo = $_POST['nilai_mpbo'];
        $nilai_mb = $_POST['nilai_mb'];
        $nilai_md = $_POST['nilai_md'];
        $nilai_mp = $_POST['nilai_mp'];

        $jumlah = $nilai_mw + $nilai_mpbo + $nilai_mb + $nilai_md + $nilai_mp;
        $rata = $jumlah / 5;

    if($rata >= 90)
    {
        $predikat ='A';
        $keterangan ='Excellent';
    }
    else if($rata >= 80)
    {
        $predikat ='B';
        $keterangan ='Baik';
    }
    else if($rata >= 70)
    {
        $predikat ='C';
        $keterangan ='Cukup';
    }
    else if($rata >= 60)
    {
        $predikat ='D';
        $keterangan ='Kurang';
    }
    else if($rata<= 50)
    {
        $predikat='E';
        $keterangan='Rendah';
    }
    $sql = "INSERT INTO siswa (NISN, Nama, Jurusan, Kelas, Alamat, nilai_mw, nilai_mpbo, nilai_mb, nilai_md, nilai_mp, rata, predikat, keterangan)
            VALUES ('$nisn', '$nama', '$jurusan', '$kelas', '$alamat', '$nilai_mw', '$nilai_mpbo', '$nilai_mb', '$nilai_md', '$nilai_mp', '$rata', '$predikat', '$keterangan')";

    $res = mysqli_query($koneksi, $sql);

    $count = mysqli_affected_rows($koneksi);

    if($count == 1)
    {
    header("Location: index.php");
    }
    else
    {
    header("Location: tambah.php");
    }
}
else
{
    header("Location: tambah.php");
}

?>

YANG TERAKHIR BUAT FILE HAPUS DENGAN KODE BERIKUT

<?php 

    include 'koneksi.php';

    $nisn = $_GET['NISN'];
    

    header("Location: index.php");
?>

JANGAN LUPA UNTUK MEMBUAT FILE KONEKSI

<?php
$koneksi = mysqli_connect("localhost","root","","db_nilai");
 ?>

Leave a comment