Coldfusion (CFM) - Searching A Product on our Project
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Advanced Search</title>
</head>
<body>
<h2>Advanced Search Form</h2>
<form method="post">
Enter keyword : <input type="text" name="keyword" /> <br />
Search in : <input type="radio" name="name" value="BRANDNAME" checked="checked" /> Brandname
<input type="radio" name="name" value="BRANDMODEL" /> Brandmodel <br />
Category <select name = "productcategID">
<cfquery name = "qCateg" datasource="webfillers">
EXEC sp_show_category
</cfquery>
<option value="">Any Category</option>
<cfoutput query = "qCateg">
<option value = ‘#qCateg.CATEGORY#’>#qCateg.CATEGORY#</option>
</cfoutput></select>
<br /><br />
<input type="submit" value="Search" name="Search" />
</form>
<cfif IsDefined(’FORM.Search’)>
<cfquery name = "qProd" datasource="webfillers">
EXEC sp_get_product @name = ‘#FORM.name#’, @keyword = ‘#FORM.keyword#’,
@productcategID = ‘#FORM.productcategID#’
</cfquery>
<table>
<tr>
<td width="18" bgcolor="#0066FF"> </td>
<td width="138" bgcolor="#0066FF"><div align="center"><strong>PRODUCTID</strong></div></td>
<td width="204" bgcolor="#0066FF"><div align="center"><strong>DESCRIPTIONS</strong></div></td>
<td width="279" bgcolor="#0066FF"><div align="center"><strong>CATEGORY</strong></div></td>
<td width="96" bgcolor="#0066FF"><div align="center"><strong>BRANDNAME</strong></div></td>
<td width="129" bgcolor="#0066FF"><div align="center"><strong>BRANDMODEL</strong></div></td>
<td width="129" bgcolor="#0066FF"><div align="center"><strong>STOCK</strong></div></td>
<td width="129" bgcolor="#0066FF"><div align="center"><strong>UNITCOST</strong></div></td>
<td width="129" bgcolor="#0066FF"><div align="center"><strong>UNITPRICE</strong></div></td>
<td width="129" bgcolor="#0066FF"><div align="center"><strong>ACTION</strong></div></td>
</tr>
<cfset i = 1>
<cfloop query="qProd">
<cfoutput>
<tr>
<td>#i#</td>
<td><div align="center">#qProd.PRODUCTID#</div></td>
<td>#qProd.DESCRIPTIONS#</td>
<td>#qProd.CATEGORYNAME#</td>
<td>#qProd.BRANDNAME#</td>
<td>#qProd.BRANDMODEL#</td>
<td>#qProd.STOCK#</td>
<td>#qProd.UNITCOST#</td>
<td>#qProd.UNITPRICE#</td>
<td><a href="updateproduct.cfm?productID=#qProd.PRODUCTID#&categoryname=#qProd.CATEGORYNAME#">Update</a>
<a href="deleteproduct.cfm?productID=#qProd.PRODUCTID#">Delete</a></td>
</tr>
</cfoutput>
<cfset i = i + 1>
</cfloop>
</table>
</cfif>
</body>
</html>
