TAMPILBUU.PHP
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Tugas Pemrograman Web Dasar</title>
</head>
<body>
<table width="750" border="1">
<tr bgcolor="#33CCCC">
<td colspan="8"><b><p align="center">DAFTAR BUKU</p></b></td>
</tr>
<tr bgcolor="#33FFFF">
<td align="center" width="100"><b>Kode Buku</b></td>
<td align="center" width="500"><b>Judul Buku</b></td>
<td align="center" width="150"><b>Kode Pengarang</b></td>
<td align="center" width="150"><b>Kode Penerbit</b></td>
<td align="center" width="200"><b>ISBN Buku</b></td>
<td align="center" width="150"><b>Tahun Terbit</b></td>
<td align="center" colspan="2" width="100"><b>Tombol</b></td>
</tr>
<?php
$koneksi=mysql_connect("localhost", "root", "")
or die ("Gagal konek server".mysql_error());
mysql_select_db("bukudb",$koneksi)
or die ("Database gagal dibuka".mysql_error());
$sql = "SELECT * FROM buku ";
$qry = mysql_query($sql, $koneksi)
or die ("Query Gagal ".mysql_error());
while($data=mysql_fetch_array($qry)){
?>
<tr>
<td><?php echo $data['kode_buku']; ?></td>
<td><?php echo $data['judul_buku']; ?></td>
<td><?php echo $data['kode_pengarang']; ?></td>
<td><?php echo $data['kode_penerbit']; ?></td>
<td><?php echo $data['isbn_buku']; ?></td>
<td><?php echo $data['tahun_terbit']; ?></td>
<td align="center"><a href="hapusbuku.php?ID=<?php echo $data['kode_buku']; ?>">Hapus</a></td>
<td align="center"><a href="tampilubahbuku.php?ID=<?php echo $data['kode_buku']; ?>">Ubah</a></td>
</tr>
<?php } ?>
</table>
</body>
</html>
0 komentar:
Posting Komentar