APLIKASI PERPUSTAKAAN DENGAN BOOTSTRAP 5, PHP DAN MYSQL

 koneksi.php

<?php 
$db = mysqli_connect("localhost","root","","perpus");

function query($query){
    global $db;
    $result = mysqli_query($db, $query);
    $rows = [];
    while ($row = mysqli_fetch_assoc($result)) {
        $rows[] = $row;
    }
    return $rows;
}

function register($nis,$nama,$password){
    global $db;
    $result = mysqli_query($db, "select nis from user where nis = '$nis'");
    if (mysqli_fetch_assoc($result)) {
        echo "<script>
        alert('NIS sudah terdaftar!')
        </script>";
        return false;
    }
    $sql = mysqli_query($db,"insert into user value('$nis','$nama','$password')");
    return $sql;
}
function login($nis,$password){
    global $db;
    $sql = mysqli_query($db, "select * from user where nis = '$nis'");
    $data_user = $sql->fetch_array();
     if(password_verify($password,$data_user['password'])){
        $_SESSION['nis'] = $nis;
        $_SESSION['nama'] = $data_user['nama'];
        $_SESSION['is_login'] = TRUE;
        return TRUE;
     }
}
function relogin($nis)
{
        global $db;
$query = mysqli_query($db,"select * from user where nis='$nis'");
$data_user = $query->fetch_array();
$_SESSION['nis'] = $nis;
$_SESSION['nama'] = $data_user['nama'];
$_SESSION['is_login'] = TRUE;
}
    function addpengunjung($data){
        global $db;
        $nama = $_POST['nama'];
        $nis = $_POST['nis'];
        $kelas = $_POST['kelas'];
        $jurusan = $_POST['jurusan'];
        $result = mysqli_query($db, "select nis from pengunjung where nis = '$nis'");
    if (mysqli_fetch_assoc($result)) {
        echo "<script>
        alert('NIS sudah terdaftar!')
        </script>";
        return false;
    }

        $sql = mysqli_query($db, "insert into pengunjung values('$nama','$nis','$kelas','$jurusan')");
        return mysqli_affected_rows($db);
    }
    function addpeminjam($data){
        global $db;
        $nama = $_POST['nama'];
        $nis = $_POST['nis'];
        $buku = $_POST['buku'];
        $pinjam = date('d-m-Y');
        $kembali = date('d-m-Y', time()+3600*24*3);

        $result = mysqli_query($db, "select nis from peminjam where nis = '$nis'");
    if (mysqli_fetch_assoc($result)) {
        echo "<script>
        alert('Kamu sedang meminjam buku')
        </script>";
        return false;
    }

        $sql = mysqli_query($db, "insert into peminjam values('$nama','$nis','$buku','$pinjam','$kembali')");
        $sql2 = mysqli_query($db, "insert into riwayat values('$nama','$nis','$buku','$pinjam','$kembali')");
        return mysqli_affected_rows($db);
    }
    function addbuku($data){
        global $db;
        $buku = $_POST['buku'];
        $pengarang = $_POST['pengarang'];
        $penerbit = $_POST['penerbit'];
        $terbitan = $_POST['terbitan'];
        $kode = $_POST['kode'];

        $sql = mysqli_query($db, "insert into tb_buku values('$buku','$pengarang','$penerbit','$terbitan','$kode')");
        return mysqli_affected_rows($db);
    }
    function hapuspengunjung($nis){
        global $db;
        $nis = $_GET['nis'];
        $sql = "delete from pengunjung where nis = '$nis'";
        $query = mysqli_query($db, $sql);
        return mysqli_affected_rows($db);
    }
    function hapuspeminjam($nis){
        global $db;
        $nis = $_GET['nis'];
        $sql = "delete from peminjam where nis = '$nis'";
        $query = mysqli_query($db, $sql);
        return mysqli_affected_rows($db);
    }

    function cari($keyword){
        global $db;
        $query = "SELECT * FROM peminjam WHERE nis LIKE '%".$keyword."%'";
        return query($query);
    }

?>

login.php

<?php 
session_start();
include 'koneksi.php';

if (isset($_SESSION['is_login'])) {
    header('location:home.php');
}
if(isset($_COOKIE['nis'])){
    relogin($_COOKIE['nis']);
    header('location:home.php');
}
if(isset($_POST['login'])){
    $nis = $_POST['nis'];
    $password = $_POST['password'];
    if (login($nis, $password)) {
        header('location:home.php');
    }
    $error = true;
}
?>

<!doctype html>
<html lang="en">
  <head>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">

    <!-- Bootstrap CSS -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous">

    <title>Hello, world!</title>
  </head>
  <body>
    <h1 class="fs-1 p-5">Selamat Datang Kembali</h1>
    <p class="h5 ps-5">Silahkan login terlebih dahulu</p>
    <form class="p-5" method="post" action="">
    <div class="mb-3">
        <label for="nis" class="form-label">Username</label>
        <input type="text" class="form-control" id="nis" aria-describedby="emailHelp" name="nis">
        <div id="emailHelp" class="form-text">Username anda adalah NIS anda.</div>
    </div>
    <div class="mb-3">
        <label for="exampleInputPassword1" class="form-label">Password</label>
        <input type="password" class="form-control" id="exampleInputPassword1" name="password">
        <?php if(isset($error)) :?>
            <p class="mt-3" style="color: red; font-style: italic;">NIS / password anda salah *</p>
        <?php endif; ?>
    </div>
    <button type="submit" class="btn btn-primary" name="login">Login</button>
    <a href="register.php" class="btn btn-outline-primary">Register</a>
    </form>
    <!-- Optional JavaScript; choose one of the two! -->

    <!-- Option 1: Bootstrap Bundle with Popper -->
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.bundle.min.js" integrity="sha384-MrcW6ZMFYlzcLA8Nl+NtUVF0sA7MsXsP1UyJoMp4YLEuNSfAP+JcXn/tWtIaxVXM" crossorigin="anonymous"></script>

    <!-- Option 2: Separate Popper and Bootstrap JS -->
    <!--
    <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.2/dist/umd/popper.min.js" integrity="sha384-IQsoLXl5PILFhosVNubq5LC7Qb9DXgDA9i+tQ8Zj3iwWAwPtgFTxbJ8NT4GN1R8p" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.min.js" integrity="sha384-cVKIPhGWiC2Al4u+LWgxfKTRIcfu0JTxR+EQDz/bgldoEyl4H0zUF0QKbrJ0EcQF" crossorigin="anonymous"></script>
    -->
  </body>
</html>

register.php

<?php 
include 'koneksi.php';
if (isset($_POST['register'])) {
    $nis = $_POST['nis'];
    $password = password_hash($_POST['password'],PASSWORD_DEFAULT);
    $nama = $_POST['nama'];
    if (register($nis, $nama, $password)) {
        header('location:login.php');
    }
}
?>

<!doctype html>
<html lang="en">
  <head>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">

    <!-- Bootstrap CSS -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous">

    <title>Hello, world!</title>
  </head>
  <body>
    <h1 class="fs-1 p-5">Selamat Datang</h1>
    <p class="h5 ps-5">Silahkan isi data anda terlebih dahulu</p>
    <form class="p-5" method="post">
    <div class="mb-3">
        <label for="nis" class="form-label">NIS</label>
        <input type="text" class="form-control" id="nis" aria-describedby="emailHelp" name="nis">
        <div id="emailHelp" class="form-text">Username anda adalah NIS anda.</div>
    </div>
    <div class="mb-3">
        <label for="nama" class="form-label">Nama</label>
        <input type="text" class="form-control" id="nama" name="nama">
    </div>
    <div class="mb-3">
        <label for="exampleInputPassword1" class="form-label">Password</label>
        <input type="password" class="form-control" id="exampleInputPassword1" name="password">
    </div>
    <button type="submit" class="btn btn-primary" name="register">Register</button>
    <a href="login.php" class="btn btn-outline-primary">Login</a>
    </form>
    <!-- Optional JavaScript; choose one of the two! -->

    <!-- Option 1: Bootstrap Bundle with Popper -->
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.bundle.min.js" integrity="sha384-MrcW6ZMFYlzcLA8Nl+NtUVF0sA7MsXsP1UyJoMp4YLEuNSfAP+JcXn/tWtIaxVXM" crossorigin="anonymous"></script>

    <!-- Option 2: Separate Popper and Bootstrap JS -->
    <!--
    <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.2/dist/umd/popper.min.js" integrity="sha384-IQsoLXl5PILFhosVNubq5LC7Qb9DXgDA9i+tQ8Zj3iwWAwPtgFTxbJ8NT4GN1R8p" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.min.js" integrity="sha384-cVKIPhGWiC2Al4u+LWgxfKTRIcfu0JTxR+EQDz/bgldoEyl4H0zUF0QKbrJ0EcQF" crossorigin="anonymous"></script>
    -->
  </body>
</html>

home.php

<?php 
include 'koneksi.php';
$no = 1;
session_start();
if (!isset($_SESSION['is_login'])) {
    header('location:login.php');
}
?>

<!doctype html>
<html lang="en">
  <head>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link rel="stylesheet" href="https://fonts.googleapis.com/css2?family=Material+Symbols+Outlined:opsz,wght,FILL,GRAD@20..48,100..700,0..1,-50..200" />

    <!-- Bootstrap CSS -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous">

    <title>Hello, world!</title>
    <style>
        .material-symbols-outlined {
        font-variation-settings:
        'FILL' 0,
        'wght' 700,
        'GRAD' 200,
        'opsz' 48
        }
    </style>
  </head>
  <body>
    <!-- navbar -->
    <nav class="navbar navbar-dark bg-primary">
    <div class="container-fluid d-flex justify-content-between">
        <a class="navbar-brand fs-1" href="#">
        <span class="material-symbols-outlined">local_library</span>
        Perpustakaan
        </a>
        <a href="logout.php" class="btn btn-outline-light">Log Out</a>
    </div>
    </nav>
    <!-- akhir navbar -->
    <!-- tampilan utama -->
    <center>
        <h1 class="fs-3 m-5">Selamat Datang, <?php echo $_SESSION['nama'];?></h1>
        
        <a class="btn btn-primary m-5" href="pinjambuku.php" role="button">Pinjam Buku Sekarang!</a>
        <br>
        <hr>
    
        <h1 class="fs-3 m-5">Riwayat Peminjaman</h1>
        <br>
    
        <table class="table table-striped m-5" style="width: fit-content;">
    <thead>
        <tr>
            <th class="col">No</th>
            <th class="col">Judul Buku</th>
            <th class="col">Tanggal Pinjam</th>
            <th class="col">Tanggal Pengembalian</th>
        </tr>
    </thead>
    <tbody>
        <?php 
        $nis = $_SESSION['nis'];
        $sql = mysqli_query($db, "select buku, pinjam, kembali from riwayat where nis='$nis'");
        foreach ($sql as $row) {
        ?>
        <tr>
            <th scope="row"><?php echo $no++;?></th>
            <td><?php echo $row['buku'];?></td>
            <td><?php echo $row['pinjam'];?></td>
            <td><?php echo $row['kembali'];?></td>
        </tr>
        <?php }?>
    </tbody>
    </table>
    <br>

    </center>
    <footer class="col-12 bg-primary p-5 position-absolute bottom-0">
            <p class="text-light float-sm-start">Created by Kelompok6</p>
    </footer>

    <!-- Optional JavaScript; choose one of the two! -->

    <!-- Option 1: Bootstrap Bundle with Popper -->
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.bundle.min.js" integrity="sha384-MrcW6ZMFYlzcLA8Nl+NtUVF0sA7MsXsP1UyJoMp4YLEuNSfAP+JcXn/tWtIaxVXM" crossorigin="anonymous"></script>

    <!-- Option 2: Separate Popper and Bootstrap JS -->
    <!--
    <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.2/dist/umd/popper.min.js" integrity="sha384-IQsoLXl5PILFhosVNubq5LC7Qb9DXgDA9i+tQ8Zj3iwWAwPtgFTxbJ8NT4GN1R8p" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.min.js" integrity="sha384-cVKIPhGWiC2Al4u+LWgxfKTRIcfu0JTxR+EQDz/bgldoEyl4H0zUF0QKbrJ0EcQF" crossorigin="anonymous"></script>
    -->
  </body>
</html>

pinjambuku.php

<?php 
include 'koneksi.php';

session_start();
if (!isset($_SESSION['is_login'])) {
    header('location:login.php');
}
if (isset($_POST['submit'])) {
    if (addpeminjam($_POST)>0) {
        echo "<script>alert('Peminjaman buku berhasil');
        document.location.href = 'home.php';
        </script>";
    }
}
?>
<!doctype html>
<html lang="en">
  <head>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link rel="stylesheet" href="https://fonts.googleapis.com/css2?family=Material+Symbols+Outlined:opsz,wght,FILL,GRAD@20..48,100..700,0..1,-50..200" />
    <!-- Bootstrap CSS -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous">

    <title>Hello, world!</title>
  </head>
  <body>
    <nav class="navbar navbar-dark bg-primary">
    <div class="container-fluid d-flex justify-content-between">
        <a class="navbar-brand fs-1" href="#">
        <span class="material-symbols-outlined">local_library</span>
        Perpustakaan
        </a>
    </div>
    </nav>
    <form action="" method="post" class="row g-3 m-5">
        <div class="col-md-6">
            <label for="inputNama" class="form-label">Nama Peminjam</label>
            <input class="form-control" type="text" name="nama" id="inputNama" value="<?php echo $_SESSION['nama']; ?>">
        </div>
        <div class="col-md-6">
            <label for="inputNis" class="form-label">NIS</label>
            <input class="form-control" type="text" name="nis" id="inputNis" value="<?php echo $_SESSION['nis'] ?>">
        </div>
        <div class="col-md-12">
            <label for="inputBuku" class="form-label">Judul Buku</label>
            <select class="form-select" id="inputBuku" name="buku">
                <option selected>Choose...</option>
                <?php 
                    $databuku = mysqli_query($db, "select * from tb_buku");
                    foreach($databuku as $rows){
                ?>
                <option value="<?php echo $rows['buku']; ?>"><?php echo $rows['buku']; ?></option>
                <?php }?>
            </select>
        </div>
        <div class="col-12">
            <button type="submit" name="submit" class="btn btn-primary">Pinjam</button>
            <a class="btn btn-primary" href="home.php" role="button">Kembali</a>
        </div>
    </form>
    <footer class="col-12 bg-primary p-5 position-absolute bottom-0">
            <p class="text-light float-sm-start">Created by Kelompok6</p>
    </footer>

    <!-- Optional JavaScript; choose one of the two! -->

    <!-- Option 1: Bootstrap Bundle with Popper -->
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.bundle.min.js" integrity="sha384-MrcW6ZMFYlzcLA8Nl+NtUVF0sA7MsXsP1UyJoMp4YLEuNSfAP+JcXn/tWtIaxVXM" crossorigin="anonymous"></script>

    <!-- Option 2: Separate Popper and Bootstrap JS -->
    <!--
    <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.2/dist/umd/popper.min.js" integrity="sha384-IQsoLXl5PILFhosVNubq5LC7Qb9DXgDA9i+tQ8Zj3iwWAwPtgFTxbJ8NT4GN1R8p" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.min.js" integrity="sha384-cVKIPhGWiC2Al4u+LWgxfKTRIcfu0JTxR+EQDz/bgldoEyl4H0zUF0QKbrJ0EcQF" crossorigin="anonymous"></script>
    -->
  </body>
</html>



BAGIAN ADMIN

admin.php

<?php 
include 'koneksi.php';

$no = 1;
$sql = query('select * from pengunjung');

if(isset($_POST['cari'])){
    $sql = cari($_POST['keyword']);
}

?>

<!doctype html>
<html lang="en">
  <head>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link rel="stylesheet" href="https://fonts.googleapis.com/css2?family=Material+Symbols+Outlined:opsz,wght,FILL,GRAD@20..48,100..700,0..1,-50..200" />

    <!-- Bootstrap CSS -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous">
    <link rel="stylesheet" href="style.css">
    <title>Hello, world!</title>
  </head>
  <body>
    <!-- navbar -->
    <nav class="navbar navbar-expand-lg navbar-dark bg-primary py-4">
    <!-- Navbar content -->
        <div class="container-fluid">
        <a class="navbar-brand fs-1" href="#">Perpustakaan</a>
        
        <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarTogglerDemo02" aria-controls="navbarTogglerDemo02" aria-expanded="false" aria-label="Toggle navigation">
        <span class="navbar-toggler-icon"></span>
        </button>
        <div class="collapse navbar-collapse" id="navbarTogglerDemo02">
        <ul class="navbar-nav me-auto mb-2 mb-lg-0">
            <li class="nav-item">
            <a class="nav-link active fs-5" aria-current="page" href="#home">Home</a>
            </li>
            <li class="nav-item">
            <a class="nav-link fs-5" href="#datakunjung">Data Pengunjung</a>
            </li>
            <li class="nav-item">
            <a class="nav-link fs-5" href="#datapinjam">Data Peminjaman</a>
            </li>
            <li class="nav-item">
            <a class="nav-link fs-5" href="#databuku">Data Buku</a>
            </li>
            <li class="nav-item">
            <a class="nav-link fs-5" href="riwayat.php">Riwayat</a>
            </li>
        </ul>
        <form class="d-flex" method="post" action="">
            <input class="form-control me-2" type="search" placeholder="Search" aria-label="Search" name="keyword">
            <button class="btn btn-outline-light" type="submit" name="cari">Search</button>
        </form>
        </div>
        </div>
    </nav>
    <!-- akhir navbar -->
    <center>
    <h1 class="mt-5" id="home">Selamat Datang, Admin</h1>
    <hr>
    <p class="h3 my-5" id="datakunjung">Data Pengunjung</p>
    <!-- table pengunjung -->
    <table class="table table-striped mx-auto" style="width: fit-content;">
        <thead>
            <tr>
                <th class="col">No</th>
                <th class="col">Nama Siswa</th>
                <th class="col">NIS</th>
                <th class="col">Kelas</th>
                <th class="col">Jurusan</th>
                <th class="col">Option</th>
            </tr>
        </thead>
        <tbody>
            <?php 
            
            foreach ($sql as $data) {
            ?>
            <tr>
                <th scope="row"><?php echo $no++;?></th>
                <td><?php echo $data['nama'];?></td>
                <td><?php echo $data['nis'];?></td>
                <td><?php echo $data['kelas'];?></td>
                <td><?php echo $data['jurusan'];?></td>
                <td>
                    <a href="hapuspengunjung.php?nis=<?=$data['nis']?>"><span class="material-symbols-outlined">person_remove</span></a>
                </td>
            </tr>
            <?php }?>
        </tbody>
    </table>
    <a class="btn btn-primary m-5" href="addpengunjung.php" role="button">Tambah Pengunjung</a>
    <br>
    <!-- table data peminjam -->
    <p class="h3 my-5" id="datapinjam">Data Peminjaman</p>
    <table class="table table-striped mx-auto" style="width: fit-content;">
    <thead>
        <tr>
            <th class="col">No</th>
            <th class="col">Nama Siswa</th>
            <th class="col">NIS</th>
            <th class="col">Judul Buku</th>
            <th class="col">Tanggal Pinjam</th>
            <th class="col">Tanggal Pengembalian</th>
            <th class="col">Option</th>
        </tr>
    </thead>
    <tbody>
        <?php 
        $sql = query("select * from peminjam");
        foreach ($sql as $row) {
        ?>
        <tr>
            <th scope="row"><?php echo $no++;?></th>
            <td><?php echo $row['nama'];?></td>
            <td><?php echo $row['nis'];?></td>
            <td><?php echo $row['buku'];?></td>
            <td><?php echo $row['pinjam'];?></td>
            <td><?php echo $row['kembali'];?></td>
            <td>
                <a href="editpeminjam.php?nis=<?=$row['nis']?>"><span class="material-symbols-outlined text-warning">edit</span></a>
                <a href="hapuspeminjam.php?nis=<?=$row['nis']?>"><span class="material-symbols-outlined text-primary">delete</span></a>
            </td>
        </tr>
        <?php }?>
    </tbody>
    </table>
    
    <!-- table data buku -->
    <p class="h3 my-5" id="databuku">Data Buku</p>
    <table class="table table-striped mx-auto" style="width: fit-content;">
    <thead>
        <tr>
            <th class="col">No</th>
            <th class="col">Judul Buku</th>
            <th class="col">Nama Pengarang</th>
            <th class="col">Penerbit</th>
            <th class="col">Tahun Terbit</th>
            <th class="col">Kode Buku</th>
            <th class="col">Option</th>
        </tr>
    </thead>
    <tbody>
        <?php 
        $sql = query("select * from tb_buku");
        foreach ($sql as $key) {
        ?>
        <tr>
            <th scope="row"><?php echo $no++;?></th>
            <td><?php echo $key['buku'];?></td>
            <td><?php echo $key['pengarang'];?></td>
            <td><?php echo $key['penerbit'];?></td>
            <td><?php echo $key['terbitan'];?></td>
            <td><?php echo $key['kode'];?></td>
            <td>
                <a href=""><span class="material-symbols-outlined text-warning">edit</span></a>
                <a href=""><span class="material-symbols-outlined text-primary">delete</span></a>
            </td>
        </tr>
        <?php }?>
    </tbody>

    </table>
    <a class="btn btn-primary m-5" href="databuku.php" role="button">Tambah Data Buku</a>
    </center>
    <footer class="col-12 bg-primary p-5 position-relative bottom-0">
            <p class="text-light float-sm-start">Created by Kelompok6</p>
    </footer>
    <!-- Optional JavaScript; choose one of the two! -->

    <!-- Option 1: Bootstrap Bundle with Popper -->
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.bundle.min.js" integrity="sha384-MrcW6ZMFYlzcLA8Nl+NtUVF0sA7MsXsP1UyJoMp4YLEuNSfAP+JcXn/tWtIaxVXM" crossorigin="anonymous"></script>

    <!-- Option 2: Separate Popper and Bootstrap JS -->
    <!--
    <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.2/dist/umd/popper.min.js" integrity="sha384-IQsoLXl5PILFhosVNubq5LC7Qb9DXgDA9i+tQ8Zj3iwWAwPtgFTxbJ8NT4GN1R8p" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.min.js" integrity="sha384-cVKIPhGWiC2Al4u+LWgxfKTRIcfu0JTxR+EQDz/bgldoEyl4H0zUF0QKbrJ0EcQF" crossorigin="anonymous"></script>
    -->
  </body>
</html>

addpengunjung.php

<?php 
include 'koneksi.php';

if (isset($_POST['submit'])) {
    if (addpengunjung($_POST)>0) {
        echo "<script>alert('Data berhasil ditambah');
        document.location.href = 'admin.php';
        </script>";
    }
}
?>

<!doctype html>
<html lang="en">
  <head>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link rel="stylesheet" href="https://fonts.googleapis.com/css2?family=Material+Symbols+Outlined:opsz,wght,FILL,GRAD@20..48,100..700,0..1,-50..200" />
    <!-- Bootstrap CSS -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous">

    <title>Hello, world!</title>
  </head>
  <body>
    <nav class="navbar navbar-dark bg-primary">
    <div class="container-fluid d-flex justify-content-between">
        <a class="navbar-brand fs-1" href="#">
        <span class="material-symbols-outlined">local_library</span>
        Perpustakaan
        </a>
    </div>
    </nav>
    <form action="" method="post" class="row g-3 m-5">
        <div class="col-md-6">
            <label for="inputNama" class="form-label">Nama Pengunjung</label>
            <input class="form-control" type="text" name="nama" id="inputNama">
        </div>
        <div class="col-md-6">
            <label for="inputNis" class="form-label">NIS</label>
            <input class="form-control" type="text" name="nis" id="inputNis">
        </div>
        <div class="col-md-6">
            <label for="inputkelas" class="form-label">Kelas</label>
            <select class="form-select" id="inputkelas" name="kelas">
                <option selected>Pilih...</option>
                <option value="X">X</option>
                <option value="XI">XI</option>
                <option value="XII">XII</option>
            </select>
        </div>
        <div class="col-md-6">
            <label for="inputjurusan" class="form-label">Jurusan</label>
            <select class="form-select" id="inputGroupSelect01" name="jurusan">
                <option selected>Pilih...</option>
                <?php 
                    $jurusan = mysqli_query($db, "select * from jurusan");
                    foreach($jurusan as $pilih){
                ?>
                <option value="<?php echo $pilih['jurusan']; ?>"><?php echo $pilih['jurusan']; ?></option>
                <?php }?>
            </select>
        </div>
        <div class="col-12">
            <button type="submit" name="submit" class="btn btn-primary">Tambah</button>
            <a class="btn btn-primary" href="admin.php" role="button">Kembali</a>
        </div>
    </form>
    <footer class="col-12 bg-primary p-5 position-absolute bottom-0">
            <p class="text-light float-sm-start">Created by Kelompok6</p>
    </footer>

    <!-- Optional JavaScript; choose one of the two! -->

    <!-- Option 1: Bootstrap Bundle with Popper -->
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.bundle.min.js" integrity="sha384-MrcW6ZMFYlzcLA8Nl+NtUVF0sA7MsXsP1UyJoMp4YLEuNSfAP+JcXn/tWtIaxVXM" crossorigin="anonymous"></script>

    <!-- Option 2: Separate Popper and Bootstrap JS -->
    <!--
    <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.2/dist/umd/popper.min.js" integrity="sha384-IQsoLXl5PILFhosVNubq5LC7Qb9DXgDA9i+tQ8Zj3iwWAwPtgFTxbJ8NT4GN1R8p" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.min.js" integrity="sha384-cVKIPhGWiC2Al4u+LWgxfKTRIcfu0JTxR+EQDz/bgldoEyl4H0zUF0QKbrJ0EcQF" crossorigin="anonymous"></script>
    -->
  </body>
</html>

databuku.php

<?php 
include 'koneksi.php';

session_start();
if (!isset($_SESSION['is_login'])) {
    header('location:login.php');
}
if (isset($_POST['submit'])) {
    if (addbuku($_POST)>0) {
        echo "<script>alert('Data berhasil ditambah');
        document.location.href = 'admin.php';
        </script>";
    }
}
?>

<!doctype html>
<html lang="en">
  <head>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link rel="stylesheet" href="https://fonts.googleapis.com/css2?family=Material+Symbols+Outlined:opsz,wght,FILL,GRAD@20..48,100..700,0..1,-50..200" />
    <!-- Bootstrap CSS -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous">

    <title>Hello, world!</title>
  </head>
  <body>
    <nav class="navbar navbar-dark bg-primary">
    <div class="container-fluid d-flex justify-content-between">
        <a class="navbar-brand fs-1" href="#">
        <span class="material-symbols-outlined">local_library</span>
        Perpustakaan
        </a>
    </div>
    </nav>
    <form action="" method="post" class="row g-3 m-5">
        <div class="col-md-12">
            <label for="inputbuku" class="form-label">Judul Buku</label>
            <input class="form-control" type="text" name="buku" id="inputbuku">
        </div>
        <div class="col-md-6">
            <label for="inputpengarang" class="form-label">Nama Pengarang</label>
            <input class="form-control" type="text" name="pengarang" id="inputpengarang">
        </div>
        <div class="col-md-6">
            <label for="inputpenerbit" class="form-label">Penerbit</label>
            <input type="text" class="form-control" name="penerbit" id="inputpenerbit">
        </div>
        <div class="col-md-6">
            <label for="inputterbitan" class="form-label">Tahun Terbit</label>
            <input type="text" class="form-control" name="terbitan" id="inputterbitan">
        </div>
        <div class="col-md-6">
            <label for="inputkode" class="form-label">Kode Buku</label>
            <input type="text" class="form-control" name="kode" id="inputkode">
        </div>
        <div class="col-12">
            <button type="submit" name="submit" class="btn btn-primary">Tambah</button>
            <a class="btn btn-primary" href="admin.php" role="button">Kembali</a>
        </div>
    </form>
    <footer class="col-12 bg-primary p-5 position-absolute bottom-0">
            <p class="text-light float-sm-start">Created by Kelompok6</p>
    </footer>

    <!-- Optional JavaScript; choose one of the two! -->

    <!-- Option 1: Bootstrap Bundle with Popper -->
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.bundle.min.js" integrity="sha384-MrcW6ZMFYlzcLA8Nl+NtUVF0sA7MsXsP1UyJoMp4YLEuNSfAP+JcXn/tWtIaxVXM" crossorigin="anonymous"></script>

    <!-- Option 2: Separate Popper and Bootstrap JS -->
    <!--
    <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.2/dist/umd/popper.min.js" integrity="sha384-IQsoLXl5PILFhosVNubq5LC7Qb9DXgDA9i+tQ8Zj3iwWAwPtgFTxbJ8NT4GN1R8p" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.min.js" integrity="sha384-cVKIPhGWiC2Al4u+LWgxfKTRIcfu0JTxR+EQDz/bgldoEyl4H0zUF0QKbrJ0EcQF" crossorigin="anonymous"></script>
    -->
  </body>
</html>

hapuspengunjung.php

<?php
    include 'koneksi.php';

    $nis = $_GET['nis'];

    if (hapuspengunjung($nis)>0) {
        echo "
        <script>alert('data berhasil dihapus');
        document.location.href = 'admin.php';
        </script>";
    }else{
        echo "
        <script>alert('data gagal dihapus');
        </script>";
    }
?>

hapuspeminjam.php

<?php
    include 'koneksi.php';

    $nis = $_GET['nis'];

    if (hapuspeminjam($nis)>0) {
        echo "
        <script>alert('data berhasil dihapus');
        document.location.href = 'admin.php';
        </script>";
    }else{
        echo "
        <script>alert('data gagal dihapus');
        </script>";
    }
?>

riwayat.php

<?php
include 'koneksi.php'; 
$no = 1;
?>
<!doctype html>
<html lang="en">
  <head>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link rel="stylesheet" href="https://fonts.googleapis.com/css2?family=Material+Symbols+Outlined:opsz,wght,FILL,GRAD@20..48,100..700,0..1,-50..200" />
    <!-- Bootstrap CSS -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous">

    <title>Riwayat Perpustakaan</title>
  </head>
  <body>
    <nav class="navbar navbar-dark bg-primary">
    <div class="container-fluid d-flex justify-content-between">
        <a class="navbar-brand fs-1" href="#">
        <span class="material-symbols-outlined">local_library</span>
        Perpustakaan
        </a>
    </div>
    </nav>
    <center>
    <div class="container  p-5">
      <legend class="m-5">Riwayat Pengunjung</legend>
    <table class="table table-light table-striped mx-3">
      <tr>
        <th>No</th>
        <th>Nama</th>
        <th>NIS</th>
        <th>Kelas</th>
        <th>Jurusan</th>
        <th>Tanggal Kunjungan</th>
      </tr>
      
        <?php 
          $data = mysqli_query($db, "select * from rekap");
          foreach ($data as $key) {
        ?>
        <tr>
          <td><?= $no++; ?></td>
          <td><?= $key['nama']; ?></td>
          <td><?= $key['nis']; ?></td>
          <td><?= $key['kelas']; ?></td>
          <td><?= $key['jurusan']; ?></td>
          <td><?= $key['tanggal']; ?></td>
        </tr>
        <?php }?>
      
    </table>
    <legend class="m-5">Riwayat Peminjaman</legend>
    <table class="table table-light table-striped mx-3">
      <tr>
        <th>No</th>
        <th>Nama</th>
        <th>NIS</th>
        <th>Judul Buku</th>
        <th>Tanggal pinjam</th>
        <th>Tanggal Pengembalian</th>
      </tr>
      
        <?php 
          $data = mysqli_query($db, "select * from riwayat");
          foreach ($data as $key) {
        ?>
        <tr>
          <td><?= $no++; ?></td>
          <td><?= $key['nama']; ?></td>
          <td><?= $key['nis']; ?></td>
          <td><?= $key['buku']; ?></td>
          <td><?= $key['pinjam']; ?></td>
          <td><?= $key['kembali']; ?></td>
        </tr>
        <?php }?>
      

    </table>
    </div>
    </center>
    <footer class="col-12 bg-primary p-5 position-absolute bottom-0">
            <p class="text-light float-sm-start">Created by Kelompok6</p>
    </footer>

    <!-- Optional JavaScript; choose one of the two! -->

    <!-- Option 1: Bootstrap Bundle with Popper -->
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.bundle.min.js" integrity="sha384-MrcW6ZMFYlzcLA8Nl+NtUVF0sA7MsXsP1UyJoMp4YLEuNSfAP+JcXn/tWtIaxVXM" crossorigin="anonymous"></script>

    <!-- Option 2: Separate Popper and Bootstrap JS -->
    <!--
    <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.2/dist/umd/popper.min.js" integrity="sha384-IQsoLXl5PILFhosVNubq5LC7Qb9DXgDA9i+tQ8Zj3iwWAwPtgFTxbJ8NT4GN1R8p" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.min.js" integrity="sha384-cVKIPhGWiC2Al4u+LWgxfKTRIcfu0JTxR+EQDz/bgldoEyl4H0zUF0QKbrJ0EcQF" crossorigin="anonymous"></script>
    -->
  </body>
</html>

logout.php

<?php 
session_start();
session_unset();
session_destroy();
setcookie('username', '', 0, '/');
setcookie('nama', '', 0, '/');
header('location:login.php');
?>

Comments

Post a Comment

Popular posts from this blog

Aplikasi PKL dengan PHP

PHP koneksi.php <?php       $host = "localhost"; $username = "root"; $password = ""; $database = "pkl"; $koneksi = mysqli_connect($host,$username,$password,$database);       function register($username,$password,$nama) {         global $koneksi; $insert = mysqli_query($koneksi,"insert into user values ('$username','$password','$nama')"); return $insert; }   function login($username,$password,$remember) {         global $koneksi; $query = mysqli_query($koneksi,"select * from user where username='$username'"); $data_user = $query->fetch_array(); if(password_verify($password,$data_user['password'])) { if($remember) { setcookie('username', $username, time() + (60 * 60 * 24 * 5), '/'); setcookie('nama', $data_user['nama'], time() + (60 * 60 * 24 * 5), '/'); } $_SESSION['user...
Read more