<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>:Pengembalian</title>
</head>
<body>
<center>
<h2>Data Pengembalian</h2>
<table border="1" width="100%" style="border-collapse:collapse">
<tr>
<td>No</td>
<td>Nama Anggota</td>
<td>Kode Buku</td>
<td>Tgl Pinjam</td>
<td>Tgl Kembali</td>
<td>Telat</td>
<td>Keterangan Buku</td>
<td>Denda Telat</td>
<td>Denda Buku</td>
<td>Total Denda</td>
</tr>
<?php
require_once "../koneksi.php";
$no = 1;
$query = $conn->query("SELECT * FROM pinjam_kembali INNER JOIN anggota on(pinjam_kembali.id_anggota=anggota.id_anggota) WHERE status_buku = \'Kembali\'");
while($res = $query->fetch_assoc()):
?>
<tr>
<td><?php echo $no++ ?></td>
<td><?php echo $res[\'nama\'] ?></td>
<td><?php echo $res[\'kode_buku\'] ?></td>
<td><?php echo $res[\'tgl_pinjam\'] ?></td>
<td><?php echo $res[\'tgl_kembali\'] ?></td>
<td><?php echo $res[\'telat\'] ?></td>
<td><?php echo $res[\'keterangan_buku\'] ?></td>
<td><?php echo $res[\'denda_telat\'] ?></td>
<td><?php echo $res[\'denda_buku\'] ?></td>
<td><?php echo $res[\'total_denda\'] ?></td>
</tr>
<?php endwhile;?>
</table>
<a href="../">Menu Utama</a>
</center>
</body>
</html>