<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title></title>
<?php
$koneksi=mysql_connect("localhost", "root", "")
or die ("Gagal Konek Server !!!!".mysql_error());
mysql_select_db("bukudb",$koneksi)
or die ("Gagal Buka Database !!!!".mysql_error());
$sql = "SELECT * FROM penerbit ";
$qry = mysql_query($sql, $koneksi)
or die ("Gagal Tampilkan Data !!!!".mysql_error());
$data = mysql_fetch_array($qry);
$kode_penerbit = $data['kode_penerbit'];
$nama_penerbit = $data['nama_penerbit'];
$alamat_penerbit = $data['alamat_penerbit'];
?>
</head>
<body>
<form action="simpanbuku.php" method="post" name="formbuku" target="_self">
<table width="350" border="1">
<tr bgcolor="#66ffff">
<td colspan="2">
<b><p align="center">Masukan Data Buku</p></b>
</td>
</tr>
<tr>
<td width="200">Kode Buku</td>
<td width="250"> : <input name="txtkodebuku" type="text" size="10" maxlenght="10"></td>
</tr>
<tr>
<td>Judul Buku</td>
<td> : <input name="txtjudulbuku" type="text" size="30" maxlength="30">
</td>
</tr>
<tr>
<td>Kode Pengarang</td>
<td> :
<select name="cmbpengarang">
<option value="notpenerbit" selected>[ Pengarang Buku ]</option>
<?php
$sql = "SELECT * FROM pengarang ORDER BY kode_pengarang";
$qry = mysql_query($sql, $koneksi) or die ("Gagal query");
while ($data =mysql_fetch_array($qry))
{
echo "<option value='$data[kode_pengarang]' $cek>$data[kode_pengarang]</option>";
}
?>
</select>
</td>
</tr>
<tr>
<td>Kode Penerbit</td>
<td> :
<select name="cmbpenerbit">
<option value="notpenerbit" selected>[ Penerbit Buku ]</option>
<?php
$sql = "SELECT * FROM penerbit ORDER BY kode_penerbit";
$qry = mysql_query($sql, $koneksi) or die ("Gagal query");
while ($data =mysql_fetch_array($qry)) {
echo "<option value='$data[kode_penerbit]' $cek>$data[kode_penerbit]</option>";
}
?>
</select>
</td>
</tr>
<tr>
<td>ISBN Buku</td>
<td> : <input name="txtisbnbuku" type="text" size="30" maxlength="30"></td>
</tr>
<tr>
<td>Tahun Terbit</td>
<td> : <input name="txttahunterbit" type="text" size="30" maxlength="30"></td>
</tr>
<tr>
<td></td>
<td>
<input type="submit" name="submit" value="Simpan">
</td>
</tr>
</table>
</form>
</body>
</html>
0 komentar:
Posting Komentar