<!--#include file="conn.asp"--><!--#include file="webconfig.asp"--><!--#include file="fuction.asp"--><html><head><title><%=webname%>--高级搜索</title><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><link href="images/css.css" rel="stylesheet" type="text/css"></head><style>td{font-size:9pt;line-height:120%;color:#353535} body{font-size:9pt;line-height:120%}
a:link { color: #000000; text-decoration: none }a:visited { color: #000000; text-decoration: none }a:active { color: #000000; text-decoration: none }a:hover { color: #336699; text-decoration: none; position: relative; right: 0px; top: 1px }</style><body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onMouseOver="window.status='【<%=webname%>】<%=weburl%> 如果您喜欢本站,别忘了把本站介绍给您的好友哦!:)';return true"><!--#include file="webtop.asp"--><table width="760" border="1" cellspacing="0" cellpadding="0" align="center" bordercolor="#EDECEC"> <tr> <td bordercolor="#FFFFFF" bgcolor="#FFFFFF"> <table border="0" align="center" cellpadding="0" cellspacing="0" width="480"> <tr> <td valign="top"> <br> <div align="center"> <p><font color="#FF0000"><b><img src="images/logo/logo_1.gif" width="108" height="99"></b></font></p> <p><font color="#FF0000"><b>商品高级搜索</b></font> </p> <table border="0" cellspacing="0" cellpadding="1" align="center" width="489"> <tr> <td> <table width="60%" border="0" align="center" cellpadding="2" cellspacing="2" bgcolor="#FFFFFF"> <form name="form2" method="post" action="research.asp"> <tr> <td width="36%" style="padding-left:6px"> <div align="center">关 健 字:</div> </td> <td width="64%" style="padding-left:6px"> <input name="searchkey" type="text" id="searchkey"> </td> </tr> <tr> <td style="padding-left:6px" width="36%"> <div align="center">查找方式:</div> </td> <td style="padding-left:6px" width="64%"> <script> var selects111=[];<%dim i set rs=server.createobject("adodb.recordset") rs.open "select * from Pingpai order by pingpaiorder",conn,1,1 '有大类%> selects111['2']=new Array(<% if rs.recordcount>0 then for i=1 to rs.recordcount if i=rs.recordcount then %> new Option('<%=trim(rs("pingpainame"))%>','<%=trim(rs("pingpainame"))%>'));<% else%> new Option('<%=trim(rs("pingpainame"))%>','<%=trim(rs("pingpainame"))%>'),<% end if rs.movenext next else %> new Option('',''));<% end ifrs.closeset rs=nothing
set rs=server.createobject("adodb.recordset") rs.open "select * from shihe order by shiheorder",conn,1,1 '有大类%> selects111['3']=new Array(<% if rs.recordcount>0 then for i=1 to rs.recordcount if i=rs.recordcount then %> new Option('<%=trim(rs("shihename"))%>','<%=trim(rs("shihename"))%>'));<% else%> new Option('<%=trim(rs("shihename"))%>','<%=trim(rs("shihename"))%>'),<% end if rs.movenext next else %> new Option('',''));<% end ifrs.closeset rs=nothing%>
function showselect(){if (document.form2.action.value=="2") { T_select.style.display = ""; //加入内容 with (document.form2){ if(action.value) { selectname.options.length=0; for(var i=0;i<selects111[action.value].length;i++){ selectname.add(selects111[action.value][i]); } } }}else{ T_select.style.display = "none";} }</script> <table border="0" cellspacing="0" cellpadding="0"> <tr> <td> <select name="action" id="action" onChange="showselect();"> <option value="1" selected>商品名称</option> <option value="2">品牌</option> <option value="3">内容简介</option> </select> </td> <td> <table border="0" cellspacing="0" cellpadding="0" id=T_select style="DISPLAY: none"> <tr> <td> <select name="selectname"> </select> </td> </tr> </table> </td> </tr> </table> </td> </tr> <tr> <td style="padding-left:6px" width="36%"> <div align="center">价格范围:</div> </td> <td style="padding-left:6px" width="64%"> <select name="jiage" id="jiage"> <option value="20">20元以下</option> <option value="30">30元以下</option> <option value="50" selected>50元以下</option> <option value="100">100元以下</option> <option value="500">500元以下</option> <option value="1000">1000元以下</option> <option value="10000">10000元以下</option> <option value="100000">100000元以下</option> </select> </td> </tr> <tr> <td height="18" style="padding-left:6px" width="36%"> <div align="center">商品分类:</div> </td> <td style="padding-left:6px" width="64%"> <%set rs=server.CreateObject("adodb.recordset") rs.open "select * from shop_anclass order by anclassidorder",conn,1,1 %> <select name="anclassid"> <option value="0">查讯所有分类</option> <%do while not rs.eof%> <option value="<%=rs("anclassid")%>"><%=trim(rs("anclass"))%></option> <%rs.movenext loop rs.close set rs=nothing%> </select> </td> </tr> <tr> <td height="18" colspan="2" style="padding-left:6px"> <div align="center"> <input type="image" border="0" name="submit" src="images/kscx.gif" width="54" height="18" onClick="return checkk();"> </div> </td> </tr> </form> </table> </td> </tr> </table> <br> </div> </td> </tr> </table> <br> </td> </tr></table><!--#include file="service1.asp"--><!--#include file="copyright.asp"--></body></html><SCRIPT LANGUAGE="JavaScript"><!--function checkspace(checkstr) { var str = ''; for(i = 0; i < checkstr.length; i++) { str = str + ' '; } return (str == checkstr);}function checkk(){ if(checkspace(document.form2.searchkey.value)&&((document.form2.action.value=="3")||(document.form2.action.value=="1"))) { document.form2.searchkey.focus(); alert("请输入查讯关键字!"); return false; } document.form2.submit();}
//--></script>
转载于:https://www.cnblogs.com/hotsoho.net/archive/2004/10/19/54374.html
相关资源:conn连接方法大全