Membuat Halaman List

Hanya HTML

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

    <div class="card border-radius p-4">
        <!-- baris judul halaman dan tombol tambah -->
        <div class="row align-items-center">
            <div class="col">
                <h1>List Data Pengguna</h1>
            </div>
            <div class="col text-end">
                <a href="" class="btn btn-outline-primary"> 
                    Tambah Data Pengguna
                </a>
            </div>
        </div>
        <!-- baris untuk tabel -->
        <div class="row mt-4">
            <div class="col">
                <table class="table table-border table-striped">
                    <thead>
                        <tr>
                            <th>No.</th>
                            <th>Nama</th>
                            <th>Email</th>
                            <th class="text-center">Aksi</th>
                        </tr>
                    </thead>
                    <tbody>
                        <tr>
                            <td>1</td>
                            <td>Agus Sukamto</td>
                            <td>[email protected]</td>
                            <td class="text-center">
                                <a href="" class="btn btn-sm btn-outline-info">Detail</a>
                                <a href="" class="btn btn-sm btn-outline-warning">Ubah</a>
                                <a href="" class="btn btn-sm btn-outline-danger">Hapus</a>
                            </td>
                        </tr>
                    </tbody>
                </table>
            </div>
        </div>
    </div>

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

HTML + PHP + List Database

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

    <?php

        $query = "SELECT * FROM users";
        $stmt = $pdo->query($query);
        $datas = $stmt->fetchAll(PDO::FETCH_ASSOC);

    ?>

    <div class="card border-radius p-4">
        <!-- baris judul halaman dan tombol tambah -->
        <div class="row align-items-center">
            <div class="col">
                <h1>List Data Pengguna</h1>
            </div>
            <div class="col text-end">
                <a href="/views/data-pengguna/create.php" class="btn btn-outline-primary"> 
                    Tambah Data Pengguna
                </a>
            </div>
        </div>
        <!-- baris untuk tabel -->
        <div class="row mt-4">
            <div class="col">
                <table class="table table-border table-striped">
                    <thead>
                        <tr>
                            <th>No.</th>
                            <th>Nama</th>
                            <th>Email</th>
                            <th class="text-center">Aksi</th>
                        </tr>
                    </thead>
                    <tbody>
                        <!-- Start Looping Foreach -->
                        <?php foreach ($datas as $key => $data) : ?>
                        <tr>
                            <td>
                                <?= $key + 1 ?>
                            </td>
                            <td>
                                <?= $data['name'] ?>
                            </td>
                            <td>
                                <?= $data['email'] ?>
                            </td>
                            <td class="text-center">
                                <a href="/views/data-pengguna/detail.php?user_id=<?= $data['user_id'] ?>" class="btn btn-sm btn-outline-info">Detail</a>
                                <a href="/views/data-pengguna/edit.php?user_id=<?= $data['user_id'] ?>" class="btn btn-sm btn-outline-warning">Ubah</a>
                                <a href="/views/data-pengguna/delete.php?user_id=<?= $data['user_id'] ?>" class="btn btn-sm btn-outline-danger">Hapus</a>
                            </td>
                        </tr>
                        <?php endforeach; ?>
                        <!-- End Looping Foreach -->
                    </tbody>
                </table>
            </div>
        </div>
    </div>

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

Data Barang

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

<?php 

    $query = "SELECT * FROM tbl_barang";
    $stmt = $pdo->query($query);
    $datas = $stmt->fetchAll(PDO::FETCH_ASSOC);

?>

<div class="card p-3">
    <div class="row">
        <div class="col-md-6">
            <h3>List Data Barang</h3>
        </div>
        <div class="col-md-6 text-end">
            <a href="/views/data-barang/create.php" class="btn btn-primary">
                <i class="fa fa-plus"></i> Tambah Barang
            </a>
        </div>
    </div>
    <div class="row mt-4">
        <div class="col-md-12">
            <table class="table table-hover table-striped table-bordered">
                <thead>
                    <tr>
                        <th>Nama</th>
                        <th class="text-center">Kuantitas</th>
                        <th class="text-end">Harga Modal</th>
                        <th class="text-end">Harga Jual</th>
                        <th class="text-center">Tanggal</th>
                        <th></th>
                    </tr>
                </thead>
                <tbody>
                    <? foreach ($datas as $data) :?>
                    <tr>
                        <td><?= $data['nama_barang'] ?></td>
                        <td class="text-center"><?= $data['kuantitas'] ?></td>
                        <td class="text-end">Rp. <?= number_format($data['harga_modal'], 2) ?></td>
                        <td class="text-end">Rp. <?= number_format($data['harga_jual']) ?></td>
                        <td class="text-center"><?= date('d-m-Y', strtotime($data['tanggal'])) ?></td>
                        <td class="text-center">
                            <a href="" class="btn btn-sm btn-outline-info">
                                <i class="fa fa-eye"></i>
                            </a>
                            <a href="" class="btn btn-sm btn-outline-warning">
                                <i class="fa fa-pencil-alt"></i>
                            </a>
                            <a href="" class="btn btn-sm btn-outline-danger">
                                <i class="fa fa-trash"></i>
                            </a>
                        </td class="text-center">
                    </tr>
                    <? endforeach; ?>
                </tbody>
            </table>
        </div>
    </div>
</div>

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

Last updated