buat arman
add.html
<html>
<head>
<title>Insert Data Inventory Lhokseumawe Office</title>
</head>
<center><h3>Imput Data Inventory</h3>
<hr>
<form method="POST" action=add-test.php>
<table border=0>
<tr><td><b>KODE BARANG<td><br>:</b><input type="text" size="20" name="kdbarang" ><br><br>
<tr><td><b>KATAGORI BARANG<td><br>:</b>
<select name="katagori">
<option>-|PILIH|-</option>
<option value='Desktop'>Desktop</option><!--valuenya harus di isi -->
<option value='Notebook'>Notebook</option>
<option value='FD'>Flash DISK</option>
<option value='Meja'>Meja</option>
</select><br /> <br>
<tr><td><b>JENIS BARANG<td><br>:</b><input type="text" size="50" name="jbarang"><br><br>
<tr><td><b>KONDISI BARANG<td>:</b>
<select name="kondisi"><!--ini namenya jangan sama dengan select atas-->
<br><br>
<option>-|PILIH|-</option>
<option value='BAGUS'>BAGUS</option>
<option value=>RUSAK</option>
<option value=>REPAIRED</option>
<option value=>STANBY</option>
</select><br />
</table><br><br>
<input type="submit" value="Submit">
<input type="reset" value="Reset"></p>
<br>
</form>
</body>
</html>
add-test.php
<html>
<H1>Insert Result</H1>
<br><br>
<table border=1>
<?
if(($kdbarang != '') || ($katagori != '') || ($jbarang != '') || ($kondisi != ''))
{
$conn=mysql_connect("localhost","inventaris","******");
if($conn)
{
mysql_select_db("inventaris");
echo "<tr><td>KODE BARANG <td>: $kdbarang";
echo "<tr><td>KATARGORI <td>: $katagori";
echo "<tr><td>JENIS BARANG <td>: $jbarang";
echo "<tr><td>KONDISI<td>: $kondisi";
echo "</table>";
$SQL = "INSERT INTO tblbrg(kdbarang,katagori,jbarang,kondisi)
VALUES('$kdbarang','$katagori','$jbarang','$kondisi')";
$hasil= mysql_query($SQL,$conn);
echo "Simpan Data Success ...!<br>\n";
mysql_close($conn);
}
else
{
echo "Simpan Data Eroorr>\n";
}
}
else
{
echo "Masukkan data secara lengkap ! <br>\n";
}
?>
tablenya
DROP TABLE IF EXISTS `inventaris`;
CREATE TABLE `inventaris` (
`id` int(11) NOT NULL auto_increment,
`kdbarang` varchar(11) default '0',
`katagori` varchar(100) default '0',
`jbarang` varchar(50) default '0',
`kondisi` varchar(50) default NULL,
PRIMARY KEY (`id`)
);
