Add Product Code on our Project
<title>Add Product</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<body>
<cfif IsDefined(’FORM.submit’)>
<cfquery datasource="webfillers">
INSERT TB_PRODUCTS(DESCRIPTIONS, PRODUCTCATEGID, BRANDNAME, BRANDMODEL, STOCK, UNITCOST, UNITPRICE)
VALUES(’#FORM.descriptions#’, #FORM.productcategID#, ‘#FORM.brandname#’ , ‘#FORM.brandmodel#’ , #FORM.stock# , #FORM.unitcost#, #FORM.unitprice#)
</cfquery>
<cfoutput>#FORM.brandname# Has Been Successfully Added….</cfoutput>
</cfif>
<form name = "addproduct" method="post" action="">
<table width="47%" height="264" border="1">
<tr>
<td>Description</td>
<td><input name="descriptions" type="text"></td>
</tr>
<tr>
<tr>
<td>Product Category ID</td>
<td> <select name = "productcategID">
<cfquery name = "qCateg" datasource="webfillers">
SELECT PRODUCTCATEGID, CATEGORY
From TB_PROD_CATEGORIES
ORDER BY CATEGORY
</cfquery>
<cfoutput query = "qCateg">
<option value = ‘#qCateg.PRODUCTCATEGID#’>#qCateg.CATEGORY#</option>
</cfoutput></select> </td>
</tr>
<tr>
<td>Brand Name</td>
<td><input name="brandname" type="text"></td>
</tr>
<tr>
<td>Brand Model</td>
<td><input name="brandmodel" type="text"></td>
</tr>
<tr>
<td>Stock</td>
<td><input name="stock" type="text"></td>
</tr>
<tr>
<td>Unit Cost</td>
<td><input name="unitcost" type="text"></td>
</tr>
<tr>
<td>Unit Price</td>
<td><input name="unitprice" type="text"></td>
</tr>
<tr>
<td> </td>
<td><input name="submit" type="submit" value="Submit"></td>
</tr>
</table>
</form>
</body>
</html>
</body>
</html>
