search

Data Peminjam

hashtag
Tambah Data Peminjam

<?php include __DIR__. './../../includes/config.php'; ?>
<?php include __DIR__. './../../includes/header.php'; ?>

    <?php
        $query = "SELECT * FROM buku";
        $stmt = $pdo->query($query);
        $buku = $stmt->fetchAll(PDO::FETCH_ASSOC);
    ?>

    <div class="card border-radius p-4">
        <!-- baris judul dan kembali -->
        <div class="row align-item-center">
            <div class="col">
                <h2>Tambah Data Peminjam</h2>
            </div>
            <div class="col text-end">
                <a href="/views/data-kategori-buku" class="btn btn-outline-secondary"><i class="fa-solid fa-arrow-right-to-bracket"></i></a>
            </div> 
        </div>

        <!-- form -->
         <div class="row mt-4">
            <div class="col">
                <form action="" method="post">
                    <div class="mb-3">
                        <label for="inputNamaBuku" class="form-label">Buku</label>
                        <select name="bukuID" id="" class="form-control">
                            <option disabled selected>-- Pilih Data Buku --</option>
                            <?php foreach ($buku as $bk) : ?>
                                <option value="<?= $bk['buku_id'] ?>"><?= $bk['name'] ?></option>
                            <? endforeach; ?>
                        </select>
                    </div>
                    <div class="row mb-3">
                        <div class="col-md-6">
                            <label for="inputTglPeminjaman" class="form-label">Tgl Peminjaman</label>
                            <input type="date" name="tglPeminjaman" class="form-control" id="inputTglPeminjaman">
                        </div>
                        <div class="col-md-6">
                            <label for="inputTglPengembalian" class="form-label">Tgl Pengembalian</label>
                            <input type="date" name="tglPengembalian" class="form-control" id="inputTglPengembalian">
                        </div>
                    </div>
                    <div>
                        <button type="submit" class="btn btn-primary btn-sm"><i class="fa-solid fa-floppy-disk"></i></button>
                        <button type="reset" class="btn btn-secondary btn-sm"><i class="fa-solid fa-eraser"></i></button>
                    </div>
                </form>
            </div>
         </div>
    </div>

    <?php

        if ($_SERVER["REQUEST_METHOD"] == "POST") {

            $pdo->beginTransaction();

            date_default_timezone_set('Asia/Jakarta');

            $bukuID = $_POST['bukuID'];
            $tglPeminjaman = $_POST['tglPeminjaman'];
            $tglPengembalian = $_POST['tglPengembalian'];
            $status = 'dipinjam';

            $sql = "
                INSERT INTO peminjam 
                (UserID, BukuID, TanggalPeminjaman, TanggalPengembalian, StatusPeminjaman) 
                VALUES (:userID,  :bukuID, :tanggalPeminjaman, :tanggalPengembalian, :statusPeminjaman)
            ";
            $stmt = $pdo->prepare($sql);
            
            $stmt->bindParam(':userID', $_SESSION['UserID']);
            $stmt->bindParam(':bukuID', $bukuID);
            $stmt->bindParam(':tanggalPeminjaman', $tglPeminjaman);
            $stmt->bindParam(':tanggalPengembalian', $tglPengembalian);
            $stmt->bindParam(':statusPeminjaman', $status);
            $stmt->execute();
            
            if ($pdo->commit()) {
                echo "<script>alert('Data berhasil ditambah!'); window.location.replace('/views/data-peminjam/index.php');</script>";
            } else {
                echo "Failed to create user.";
            }
        }
    ?>

<?php include __DIR__. './../../includes/footer.php'; ?>

hashtag
List Data Peminjam

PreviousMembuat Pengecekan Terhadap RoleNextUpload Photo

Last updated