📄 productsearch.asp
字号:
<%@ LANGUAGE="VBSCRIPT" %>
<!--#include file="conn.asp" -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<STYLE>BODY {
FONT-SIZE: 9pt
}
TD {
FONT-SIZE: 9pt;
line-height: 150%;
}
</STYLE>
<SCRIPT language=JavaScript>
<!--
function openbag(url,name){
window.open(url,name,"height=200,width=600,left=190,top=0,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no")}
-->
</SCRIPT>
<title>商品搜索</title>
</head>
<body leftmargin="0" topmargin="0">
<!--#include file="top.asp" -->
<div align="center">
<table border="0" cellpadding="0" cellspacing="0" width="778" height="300" background="IMAGES/bg3.gif">
<tr>
<td width="172" valign="top">
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="17" valign="bottom" bgcolor="#FFE28C"> <p align="center"><b>商 品 搜 索</b>
</td>
</tr>
<tr>
<td height="1"></td>
</tr>
<tr>
<td background="PIC/bg-line2.gif" height="1"></td>
</tr>
<tr>
<td> <div align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="4">
<form name="Search_form" action="ProductSearch.asp" method="post">
<tr>
<td> <div align="center">类型:
<select name="up" id="select">
<option value="商品名称" selected>商品名称</option>
<option value="网店名称">网店名称</option>
<option value="商品所在地">商品所在地</option>
<option value="商品简介">商品简介</option>
</select>
<br>
</div></td>
</tr>
<tr>
<td> <div align="center">关键字:
<input type='text' name='Search' size='10' class='a'>
<br>
</div></td>
</tr>
<tr>
<td> <div align="center">价格:
<select name="jiage" id="jiage">
<option value="20">20元以下</option>
<option value="30">30元以下</option>
<option value="50">50元以下</option>
<option value="100" selected>100元以下</option>
<option value="300">300元以下</option>
<option value="500">500元以下</option>
<option value="1000">1000千以下</option>
<option value="10000">1万以下</option>
<option value="100000">10万元以下</option>
</select>
<br>
</div></td>
</tr>
<tr>
<td><div align="center">商品类别:
<select name="Product_Class" size="1" tabindex="0" class="a" font-size: 9pt>
<option value="所有类别" selected>所有类别</option>
<%
set rs_lx=server.CreateObject("adodb.recordset")
sql="select * from Class_1"
rs_lx.open sql,conn,1
if not rs_lx.eof and not rs_lx.bof then
for i=1 to rs_lx.recordcount
%>
<option value=<%=rs_lx("Class_1_Name")%>><%=rs_lx("Class_1_Name")%></option>
<%
rs_lx.movenext
next
rs_lx.close
end if
%>
</select>
</div></td>
</tr>
<tr>
<td><div align="center">
<input name="imageField2" type="image" src="IMAGES/Search.gif" width="90" height="19" border="0">
</div></td>
</tr>
</form>
</table>
</div></td>
</tr>
</table>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" width="145" height="3">
<tr>
<td height="3"> </td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table width="170" height="147" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td background="PIC/bg-line2.gif" height="1"></td>
</tr>
<tr>
<td height="1"></td>
</tr>
<tr>
<td bgcolor="#FFE9A6" height="17" valign="bottom">
<p align="center"><b>商 品 分 类</b>
</td>
</tr>
<tr>
<td height="1"></td>
</tr>
<tr>
<td background="PIC/bg-line2.gif" height="1"></td>
</tr>
<tr>
<td height="3"> </td>
</tr>
<tr>
<td height="250" valign="top" >
<%
set rs_class_1=server.createobject("adodb.recordset")
sqltext2="select * from Class_1 "
rs_class_1.open sqltext2,conn,1,1
While Not rs_class_1.EOF
%>
<table width="100%" border="0" cellspacing="3" cellpadding="0">
<tr>
<td>
<%
set rs_p2=server.createobject("adodb.recordset")
sqltext3="select * from Class_2 where Class_1_Name='" & rs_class_1("Class_1_Name") & "'"
rs_p2.open sqltext3,conn,1,1
%>
<%=rs_class_1("Class_1_Name")%><br>
<%While Not rs_p2.EOF%>
<a href="ProductClass.asp?ProductClass_1=<%=rs_class_1("Class_1_Name")%>&ProductClass_2=<%=rs_p2("Class_2_Name")%>"><%=rs_p2("Class_2_Name")%></a>
<%
rs_p2.MoveNext
j=j+1
Wend
rs_p2.close
%>
<table width="153" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="3"></td>
</tr>
<tr>
<td height="1" bgcolor="#EAAF00"></td>
</tr>
<tr>
<td height="3"></td>
</tr>
</table></td>
</tr>
</table>
<%
rs_class_1.MoveNext
Wend
rs_class_1.close
%>
</td>
</tr>
</table>
</center>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -