Quick actions

cmd+k|ctrl+k

Navigation

Languages

index.php

Snippet info

Language

Php

Visibility

public

Author

sutrisnob33

Created

2025-04-06T01:16:42.838957Z

Updated

2025-04-06T01:18:16.065028Z

<?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/[email protected]/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/[email protected]/dist/js/bootstrap.bundle.min.js"
        integrity="sha384-YvpcrYf0tY3lHB60NNkmXc5s9fDVZLESaAA55NDzOxhy9GkcIdslK1eN7N6jIeHz" crossorigin="anonymous">
    </script>
</body>

</html>
INFO