<html>
<head>
<title>SISTEM INFORMASI BUKU</title>
</head>
<body> <center>
<body background="2.jpg">
<table border="3" widht="150%"><tr text-align="center">
<tr>
<td>
<center>
<table border="3">
<tr>
<td>
<h1>SISTEM INFORMASI BUKU</h1>
</td>
</tr>
</table>
<a href="tambahbuku.php">TAMBAH BUKU</a>|<a href="caribuku.php">CARI BUKU</a>
</center>
<table border="3" widht="150%">
<tr>
<td>NO</td>
<td>KODE</td>
<td>NAMA</td>
<td>JENIS</td>
<td>MERK</td>
<td>JUMLAH</td>
<td>HARGA</td>
<td>TINDAKAN</td>
</tr>
<?php
//koneksi ke database
$dblink = mysql_connect('localhost','root','');
if(!is_resource($dblink))
{
die("Koneksi gagal: ".mysql_error());
}
//mengaktifkan database;
if (!mysql_select_db('gudang',$dblink))
{
die("Gagal mengaktifkan database");
}
//menampilkan buku dari data base
$q = mysql_query("SELECT * FROM buku");
if(mysql_num_rows($q)>0) {
//taruh data pada tabel
while ($r = mysql_fetch_assoc($q))
{
echo <<<DATA
<tr>
<td>$r[id]</td>
<td>$r[kode]</td>
<td>$r[nama]</td>
<td>$r[jenis]</td>
<td>$r[merk]</td>
<td>$r[jumlah]</td>
<td>$r[harga]</td>
<td>
<a href="editbuku.php?id=$r[id]">Edit</a> |
<a href="hapusbuku.php?id=$r[id]">Hapus</a>
</td>
<tr>
DATA;
}
}
else
{
echo <<<DATA
<tr>
<td colspan="5">Belum ada data</td>
</tr>
DATA;
}
?>
</table>
<center>
<div class="footer">
Copyright © andan
</div>
</center>
</tr>
</table>
</form>
</body>
</body>
</html>
1/30/2012 08:47:00 PM |
Category:
belajar web
|
0
komentar
Comments (0)