report.php

<?php
	include('koneksi.php');
?>
<!DOCTYPE html>
<html>
<head>
	<title>HALAMAN REPORT</title>
</head>
<body>
	<h1 style="text-align:center;"> HALAMAN REPORT </h1>
	<table border="1">
		<tr style="text-align: center;">
			<td>Nomor</td>
			<td>Nama Kategori</td>
			<td>Tanggal</td>
			<td>Judul</td>
			<td>Berkas</td>
			<td>Deskripsi</td>
			<td>Keterangan</td>
		</tr>
		<?php
			include("koneksi.php");
			$no = 0;

			$kibo = mysql_query("SELECT arsip.id_arsip, kategori.nama_kategori, arsip.tanggal, arsip.berkas, arsip.judul, arsip.deskripsi, arsip.keterangan FROM arsip LEFT JOIN kategori ON arsip.id_kategori = kategori.id_kategori ORDER BY id_arsip DESC");

			if (false === $kibo) {
            	echo mysql_error();
        	}else{
			while ($miyya = mysql_fetch_array($kibo)) {
				$no++;

		?>
		<tr>
			<td><?php echo $no; ?></td>
			<td><?php echo $miyya['nama_kategori']; ?></td>
			<td><?php echo $miyya['tanggal']; ?></td>
			<td><?php echo $miyya['judul']; ?></td>
			<td><?php echo $miyya['berkas']; ?></td>
			<td><?php echo $miyya['deskripsi']; ?></td>
			<td><?php echo $miyya['keterangan']; ?></td>
		</tr>
		<?php
			} }
		?>
	</table>
</body>
</html>