I need a script (to create a function) that automatically gives all information about product when we write the name of the product.I was in the process build a system inventory. So, what i want is:when i sales product.I just write the product’s name,and what i want is:when i write the product’s name,it will automatically gives all information about the product such as price.Im working with php and mySQL.So, may be someone can help me???May be we can use php or javacript.Ive used javascript doing a calculation-(sales price).Ive to pages of codes that related to each other-which are stock and sales.Please help me dude!!!!!
Here is the codes of sales:
[code=php]
<? $jualan=$_POST[‘jualan’];
?>
<html>
<head>
<title>Terminal Computer Services :: JUALAN</title>
<meta http-equiv=”Content-Type” content=”text/html; charset=iso-8859-1″>
</head>
<script type=”text/javascript”>
function CalcPercnt(f) {
var val=f.peratuskeuntungan.options[f.peratuskeuntungan.selectedIndex].text
if (val == “”)return false
var daTotal=(f.hargaseunit.value * (val / 100 + 1)).toFixed(2)
f.hargajualan.value = daTotal
f.profit.value=(daTotal-f.hargaseunit.value).toFixed(2)
}
</script>
<style type=”text/css”>
.ro{
background-color: royalblue;
color: white;
border: 2px solid skyblue;
}
</style>
<body>
<a href=”paparjualan.php”><strong><font face=”Verdana, Arial, Helvetica, sans-serif”><font color =”black”></font></font>
<h1><p align=”center”>JUALAN</h1></strong></a></p>
<form action=”insertjualan.php” name=”Imp” method=”post”>
<table width=”40%” height=”292″ border=”0″ align=”center” bgcolor=”#000000″>
<tr>
<td width=”41%”><font color=”#FFFFFF”><h3>Nama Produk:</h3></font></td>
<td width=”29%”> <input name=”namaproduk” type=”text” size=”25″></td>
</tr>
<tr>
<td width=”29%”><font color=”#FFFFFF”><h3>Harga Seunit:</h3><td width=”71%”><input name=”hargaseunit” type=”text” size=”25″></td>
</tr>
<tr>
<td width=”29%”><font color=”#FFFFFF”><h3>Peratus Keuntungan:</h3></td><td><select name=”peratuskeuntungan” id=”peratus”>
<option>5</option>
<option>10</option>
<option>15</option>
<option>20</option>
<option>25</option>
<option>30</option>
</select></td>
</tr>
<tr>
<td width=”41%”><font color=”#FFFFFF”><h3>Harga Jualan:</h3><td width=”30%”><input name=”hargajualan” type=”text” readonly class=”ro” size=”25″></td>
</tr>
<td width=”41%”><font color=”#FFFFFF”><h3>Profit:</h3><td width=”30%”><input name=”profit” type=”text” readonly class=”ro” size=”25″></td>
</tr>
<tr><td height=”45″> </td>
<td><input onClick=”CalcPercnt(this.form)” type=”button” value=”Calculate”>
<input type=”reset” value=”Clear”></td>
</tr>
<tr><td width=”29%”><font color=”#FFFFFF”>
<h3>Bil Jualan:</h3></font></td>
<td width=”71%”><input name=”biljualan” type=”text” size=”25″></td>
</tr>
<tr><td height=”45″> </td>
<td><input type=”submit” name=”Submit” value=”Submit”>
<input type=”reset” name=”Submit2″ value=”Reset”></td>
</tr>
</form></table>
<a href=”produk.php”><strong><font face=”Verdana, Arial, Helvetica, sans-serif”><font color =”black”></font></font>
<h2><p align=”center”>PRODUK</h2></strong></a></p>
</td>
</tr>
</table>
</body>
</html>