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