<?php
include_once("koneksi.php");
$books = [];
$queryBook = mysqli_query($conn, "SELECT * FROM books");
while($book = mysqli_fetch_assoc($queryBook)){
$books[] = $book;
}
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Library</title>
<!-- link css boostrap -->
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css" rel="stylesheet"
integrity="sha384-QWTKZyjpPEjISv5WaRU9OFeRpok6YctnYmDr5pNlyT2bRjXh0JMhjY6hW+ALEwIH" crossorigin="anonymous">
</head>
<body>
<!-- navbar start -->
<nav class="navbar navbar-expand-lg navbar-dark bg-dark">
<div class="container">
<a class="navbar-brand" href="#">My Blog</a>
<button class="navbar-toggler" type="button" data-bs-toggle="collapse"
data-bs-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false"
aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarSupportedContent">
<ul class="navbar-nav me-auto mb-2 mb-lg-0">
<li class="nav-item">
<a class="nav-link active" aria-current="page" href="">Home</a>
</li>
<li class="nav-item">
<a class="nav-link" href="#">Link</a>
</li>
</ul>
<form class="d-flex">
<input class="form-control me-2" type="search" placeholder="Search" aria-label="Search">
<button class="btn btn-success" type="submit">Search</button>
</form>
</div>
</div>
</nav>
<!-- navbar end -->
<!-- isi table buku start -->
<div class="container mt-5">
<h1>Daftar Postingan</h1>
<a href="tambah.php" class="btn btn-outline-success btn-lg mt-5">Tambah postingan</a>
<table class="table mt-5">
<thead>
<tr>
<th>Judul</th>
<th>Gambar</th>
<th>Kategori</th>
<th>Aksi</th>
</tr>
</thead>
<tbody>
<?php foreach ($books as $buku) : ?>
<tr>
<td><?= $buku["judul"] ?></td>
<td><?= $buku["gambar"] ?></td>
<td><?= $buku["kategori"] ?></td>
<td>
<a href="delete.php?id=<?= $row['id'] ?>"
onclick="return confirm('Apakah Anda yakin ingin menghapus postingan ini?')"
class="btn btn-danger delete-btn">Delete</a>
</td>
</tr>
<?php endforeach; ?>
</tbody>
</table>
</div>
<!-- isi table buku end -->
<!-- link javascript boostrap -->
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/js/bootstrap.bundle.min.js"
integrity="sha384-YvpcrYf0tY3lHB60NNkmXc5s9fDVZLESaAA55NDzOxhy9GkcIdslK1eN7N6jIeHz" crossorigin="anonymous">
</script>
</body>
</html>
