LIHAT BUKU

@?php
include('koneksi.php');
mysql_select_db('DBPerpustakaan');

$query_buku = mysql_query("SELECT * FROM buku01");
$jm_baris = mysql_num_rows($query_buku);

echo "@table>";
echo "@tr>@th>Nomor@/th> @th>Kode Buku@/th> @th>Judul Buku@/th>@/tr>";

for ($i=1; $i@= $jm_baris; $i++)
{
$buku = mysql_fetch_array($query_buku);
echo "@tr>@td>".$i."@/td> @td>".$buku[kode]."@/td> @td>".$buku[judul]."@/td>@/tr>";
}
echo "@/table>";
?>

MENU

@html>
@head>
@title>Menu Utama@/title>
@/head>
@body>
@h1>MENU@/h1>
@br>@a href='form_buku.php' target='isi'>Master Buku@/a>
@br>@a href='lihat_buku.php' target='isi'>Lihat Data@/a>
@br>@a href='cetak_buku.php' target='isi'>Cetak@/a>
@h5>copyright@2010@/h5>
@p>be a creative@/p>
@/body>
@/html>

FORM BUKU

@html>
@head>
@title>Form Entri Buku@/title>
@/head>
@body>
@h4>FORM ENTRI DATA BUKU@/h4>
@form name="fbuku" action="simpan_buku.php" method=POST>

@table>
@tr>
@td>Kode Buku@/td>@td>:@/td>
@td>@input type = text name=textbuku size=7 maxlength=6>@/td>
@/tr>

@tr>
@td>Judul@/td>@td>:@/td>
@td>@input type = text name= judul size=15 maxlength=30>@/td>
@/tr>

@tr>
@td colspan=3>
@input type = submit name=btnsimpan value=simpan>
@/td>
@/tr>
@/table>
@form>
@/body>
@/html>

SIMPAN BUKU

@?php>
include('koneksi.php');
mysql_select_db('DBPerpustakaan');
$kode = $_POST[textbuku];
$judul = $_POST[judul];

$query_buku = mysql_query("SELECT * FROM buku01 WHERE kode='".$kode."'");
$jm_baris = mysql_num_rows($query_buku);

if($jm_baris==1)
{
echo "@h3>Maaf Data Sudah Ada, silakan entri data baru..@/h3>";
echo "@br>@a href = form_buku.php> Kembali Ke Form Buku@/a>";
return;
}
$tambah_buku = mysql_query("INSERT INTO buku01(kode,judul) VALUES ('$kode','$judul')");
echo "@h1>Data berhasil diupdate@h1>";
echo "@br>@a href=form_buku.php>Kembali Ke Form Buku>/a>";
?>

Index(Form)

@html>
@head>@title>STMIK Kharisma Karawang@/title>
@link href="file.css" rel="stylesheet" type="text/css">

@frameset rows="20%,70%,10%" border="">
@frame name="awal" src="judul.php" scrolling="no">

@frameset cols="20%, 65%, 15% border="">
@frame name="navigasi" src="menu.php" scrolling="no">
@frame name="isi" src="profile.php" scrolling="no">
@frame name="pelengkap" src="pelengkap.php" scrollling="no">
@/frameset>

@frame name="bawah" src="bawah.php" scrolling="no">
@/frameset>
@/head>
@body>
@/body>
@/html>