Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!-- pages/bibliografi.php -->
- <div class="container-fluid">
- <!-- Page Heading -->
- <div class="d-sm-flex align-items-center justify-content-between mb-4">
- <h1 class="h3 mb-0 text-gray-800">Bibliografi Buku</h1>
- </div>
- <?php tampilPesan(); ?>
- <!-- Content Row -->
- <div class="row">
- <div class="col-xl-3 col-md-6 mb-4">
- <div class="card shadow mb-4">
- <!-- Card Header - Dropdown -->
- <div class="card-header py-3 d-flex flex-row align-items-center justify-content-between">
- <h6 class="m-0 font-weight-bold text-primary">Entry Data Bibliografi</h6>
- </div>
- <?php // mengambil baris data untuk diedit, jika terdeteksi parameter URL id
- $data = false;
- if (isset($_GET["id"])) {
- $id = $_GET["id"];
- $stmt = $conn->prepare("SELECT * FROM buku
- WHERE Kode_Buku = ?");
- $stmt->execute([$id]);
- $data = $stmt->fetch(PDO::FETCH_OBJ);
- }
- ?>
- <!-- Card Body -->
- <div class="card-body">
- <!-- PERHATIKAN bagian atribut pada form, harus ada enctype... tsb untuk bisa upload file -->
- <form action="proses/biblio-proses.php" method="post" enctype="multipart/form-data">
- <div class="form-group">
- <label>Judul Buku</label>
- <input type="text" name="judul_buku" class="form-control"
- value="<?= ($data) ? $data->Bk_Judul_Buku : ''; ?>">
- </div>
- <div class="form-group">
- <label>Penulis</label>
- <input type="text" name="penulis" class="form-control"
- value="<?= ($data) ? $data->Bk_Penulis : ''; ?>">
- </div>
- <div class="form-group">
- <label>Peberbit</label>
- <input type="text" name="penerbit" class="form-control"
- value="<?= ($data) ? $data->Bk_Penerbit : ''; ?>">
- </div>
- <div class="form-group">
- <label>Tahun Terbit</label>
- <input type="text" name="th_terbit" class="form-control"
- value="<?= ($data) ? $data->Bk_Th_Terbit : ''; ?>">
- </div>
- <div class="form-group">
- <label>Kategori</label>
- <select name="kode_kategori" class="form-control" id="select_kategori">
- <?php
- $sql = "SELECT * FROM kategori_buku
- ORDER BY Nama_Kategori ASC";
- $stmt = $conn->query($sql);
- while ($row = $stmt->fetch(PDO::FETCH_OBJ)):
- ?>
- <option value="<?= $row->Kode_Kategori; ?>"
- <?= ($data && ($data->Bk_Kode_Kategori == $row->Kode_Kategori)) ?
- "selected" : ''; ?>>
- <?= $row->Nama_Kategori; ?></option>
- <?php endwhile; ?>
- </select>
- </div>
- <div class="form-group">
- <label>Cover (jika ada)</label>
- <input type="file" name="file_cover" class="form-control">
- </div>
- <input type="hidden" name="kode_buku"
- value="<?= ($data) ? $data->Kode_Buku : 0; ?>">
- <input type="hidden" name="cover_existing"
- value="<?= ($data) ? $data->Bk_Foto : ''; ?>">
- <input type="submit" class="btn btn-success" value="Simpan">
- </form>
- </div>
- </div>
- </div>
- </div> <!-- end row untuk form -->
- <div class="row"> <!-- start row untuk tabel -->
- <div class="col-xl-12 col-md-12 mb-12">
- <table class="table table-striped" id="tabel_biblio">
- <thead>
- <tr>
- <th>Kode</th>
- <th>Judul Buku</th>
- <th>Tahun Terbit</th>
- <th>Kategori</th>
- <th>Aksi</th>
- </tr>
- </thead>
- <tbody>
- <?php
- $sql = "SELECT * FROM buku
- LEFT JOIN kategori_buku
- ON Kode_Kategori = Bk_Kode_Kategori
- ORDER BY Kode_Buku DESC";
- $stmt = $conn->query($sql);
- while ($row = $stmt->fetch(PDO::FETCH_OBJ)):
- ?>
- <tr>
- <td><?= $row->Kode_Buku; ?></td>
- <td><?= $row->Bk_Judul_Buku; ?>
- <?php if ($row->Bk_Foto != "") { ?>
- <br>
- <img src="img/coverbuku/<?= $row->Bk_Foto ?>" width="80">
- <?php } ?>
- </td>
- <td><?= $row->Bk_Th_Terbit; ?></td>
- <td><?= $row->Nama_Kategori; ?></td>
- <td>
- <a href="?p=bibliografi&id=<?= $row->Kode_Buku; ?>" class="btn btn-sm btn-warning">Edit</a>
- <a href="proses/biblio-proses.php?id=<?= $row->Kode_Buku; ?>"
- class="btn btn-sm btn-danger"
- onclick="return confirm('Apakah Anda yakin untuk menghapus ?')">Hapus</a>
- </td>
- </tr>
- <?php endwhile; ?>
- </tbody>
- </table>
- </div>
- </div> <!-- end row untuk tabel -->
- <!-- /.container-fluid -->
- </div>
- <script>
- $(document).ready(function() {
- $('#select_kategori').select2();
- $('#tabel_biblio').DataTable({
- "language": {
- "url": "http://localhost/pwd2019/perpustakaan/vendor/datatables/Indonesian.json"
- }
- });
- });
- </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement