home.php

<h1 class="mt-4">Dashboard</h1>
<ol class="breadcrumb mb-4">
    <li class="breadcrumb-item active">Dashboard</li>
</ol>
<div class="row">
    <div class="col-xl-3 col-md-6">
        <div class="card bg-primary text-white mb-4">
            <?php
                $total_user = mysqli_num_rows(mysqli_query($connection, "SELECT * FROM user"));
            ?>
            <div class="card-body">Total User = <?php echo $total_user?></div>
            <div class="card-footer d-flex align-items-center justify-content-between">
                <a class="small text-white stretched-link" href="#">View Details</a>
                <div class="small text-white"><i class="fas fa-angle-right"></i></div>
            </div>
        </div>
    </div>
    <div class="col-xl-3 col-md-6">
        <div class="card bg-warning text-white mb-4">
            <?php
                $total_book = mysqli_num_rows(mysqli_query($connection, "SELECT * FROM book"));
            ?>
            <div class="card-body">Total Buku = <?php echo $total_book?></div>
            <div class="card-footer d-flex align-items-center justify-content-between">
                <a class="small text-white stretched-link" href="#">View Details</a>
                <div class="small text-white"><i class="fas fa-angle-right"></i></div>
            </div>
        </div>
    </div>
    <div class="col-xl-3 col-md-6">
        <div class="card bg-success text-white mb-4">
            <?php
                $total_category = mysqli_num_rows(mysqli_query($connection, "SELECT * FROM category"));
            ?>
            <div class="card-body">Total Category = <?php echo $total_category?></div>
            <div class="card-footer d-flex align-items-center justify-content-between">
                <a class="small text-white stretched-link" href="#">View Details</a>
                <div class="small text-white"><i class="fas fa-angle-right"></i></div>
            </div>
        </div>
    </div>
    <div class="col-xl-3 col-md-6">
        <div class="card bg-danger text-white mb-4">
            <?php
                $total_review = mysqli_num_rows(mysqli_query($connection, "SELECT * FROM review"));
            ?>
            <div class="card-body">Total  = <?php echo $total_review?></div>
            <div class="card-footer d-flex align-items-center justify-content-between">
                <a class="small text-white stretched-link" href="#">View Details</a>
                <div class="small text-white"><i class="fas fa-angle-right"></i></div>
            </div>
        </div>
    </div>
</div>