<%seo_title="商品搜索:"&request("hw_name")&"-"&sitename%>
<% if request("action")="search" then showp="search.asp?action=search" order=request("order") page=request("page") orderx=getorder(order) page=getpage(page) hw_name=request("hw_name") if hw_name<>"" then hwn=split(hw_name," ") sera=sera&" and ( (1=1 " for i=0 to ubound(hwn) hwna=trim(hwn(i)) if hwna<>" " and hwna<>"" then sera=sera&" and hw_name like '%"&hwna&"%'" end if next sera=sera&" )" if searchsn=1 then sera=sera&" or (1=1" for i=0 to ubound(hwn) hwna=trim(hwn(i)) if hwna<>" " and hwna<>"" then sera=sera&" and hw_sn like '%"&hwna&"%'" end if next sera=sera&" )" end if if searchc1=1 then sera=sera&" or (1=1" for i=0 to ubound(hwn) hwna=trim(hwn(i)) if hwna<>" " and hwna<>"" then sera=sera&" and hw_content like '%"&hwna&"%'" end if next sera=sera&" )" end if if searchc2=1 then sera=sera&" or (1=1" for i=0 to ubound(hwn) hwna=trim(hwn(i)) if hwna<>" " and hwna<>"" then sera=sera&" and hw_content2 like '%"&hwna&"%'" end if next sera=sera&" )" end if if searchk=1 then sera=sera&" or (1=1" for i=0 to ubound(hwn) hwna=trim(hwn(i)) if hwna<>" " and hwna<>"" then sera=sera&" and hw_keyword like '%"&hwna&"%'" end if next sera=sera&" )" end if sera=sera&" or (1=2) )" showp=showp&"&hw_name="&hw_name end if price1=DelStr(request("price1")) if price1="" or not(isnumeric(price1)) then price1=0 price2=DelStr(request("price2")) if price2="" or not(isnumeric(price2)) then price2=1000000000 showp=showp&"&price1="&price1 showp=showp&"&price2="&price2 if request("pagec")="" or Not(isNumeric(request("pagec"))) then pagec=25 else pagec=DelStr(request("pagec")) end if showp=showp&"&pagec="&pagec sort_id=Request("sort_id") if sort_id="" then sort_id=0 if not(isnumeric(sort_id)) then sort_id=0 if sort_id<1 then sort_id=0 sort_id=int(sort_id) if sort_id<>0 then chkid(sort_id) sera=sera&" and sort_id=" & sort_id & "" showp=showp&"&sort_id="&sort_id end if nsort_id=Request("nsort_id") if nsort_id="" then nsort_id=0 if not(isnumeric(nsort_id)) then nsort_id=0 if nsort_id<1 then nsort_id=0 nsort_id=int(nsort_id) if nsort_id<>0 then chkid(nsort_id) sera=sera&" and nsort_id=" & nsort_id & "" end if pinpai=request("pinpai") if pinpai<>"" and pinpai<>0 then chkid(pinpai) sera=sera&" and pinpai_id=" & pinpai & "" showp=showp&"&pinpai="&pinpai end if set rs=server.createobject("adodb.recordset") sql="select hw_id,hw_name,hw_price1,hw_price2,hw_pic,hw_content from Baiyou_hw where hw_price2>="&price1&" and hw_price2<="&price2&" " &sera&" order by "&orderx&"" rs.open sql,conn,1,1 if rs.eof then%>
你所选的类别没有商品
<%else rs.pagesize=pagec totalrec=rs.recordcount totalpage=rs.pagecount if page>totalpage then page=totalpage rs.absolutepage=page rs.cachesize=rs.pagesize if request.form("hw_name")<>"" then set rss=server.createobject("adodb.recordset") sql="select * from Baiyou_search where search_name='"&hw_name&"'" rss.open sql,conn,1,3 if rss.eof then rss.addnew rss("search_name")=hw_name rss("hits")=1 else rss("hits")=rss("hits")+1 end if rss.update rss.close set rss=nothing end if %>
  您的位置: 首页 >> 商品查询 (共<%=totalrec%>件商品, 这是第<%=(page-1)*rs.pagesize+1%>-<%if page+1<=totalpage then%><%=page*rs.pagesize%><%else%><%=totalrec%><%end if%>件)
<% if sort_id=0 then response.write "继续筛选:" set rss=conn.execute("select sort_id from Baiyou_hw where hw_price2>="&price1&" and hw_price2<="&price2&" " &sera&" group by sort_id order by count(sort_id) desc") do while not rss.eof response.write "" response.write conn.execute("select sort_name from Baiyou_sort where sort_id="&rss("sort_id")&"")(0)&"("&conn.execute("select count(*) from Baiyou_hw where hw_price2>="&price1&" and hw_price2<="&price2&" " &sera&"")(0)&"件)  " rss.movenext loop rss.close set rss=nothing else response.write "继续筛选:" set rss=conn.execute("select nsort_id from Baiyou_hw where hw_price2>="&price1&" and hw_price2<="&price2&" " &sera&" group by nsort_id order by count(nsort_id) desc") do while not rss.eof response.write "" response.write conn.execute("select nsort_name from Baiyou_nsort where nsort_id="&rss("nsort_id")&"")(0)&"("&conn.execute("select count(*) from Baiyou_hw where hw_price2>="&price1&" and hw_price2<="&price2&" " &sera&"")(0)&"件)  " rss.movenext loop rss.close set rss=nothing end if %>
method=post>
<% if page<=pagecc then spage=1 else spage=page-pagecc end if if page>=totalpage-pagecc then lpage=totalpage else lpage=page+pagecc end if %> 第<%=page%>页/共<%=totalpage%>页   页面跳转:
<%if page-1>0 then%><%else%><%end if%> <%for i=spage to lpage if i=page then%><%=i%> <%else%><%=i%><%end if next%> <%if page+1<=totalpage then%> <%else%><%end if%>
<%end if%><% rs.close set rs=nothing end if%>
关键字:
">
选择分类:
<%set rs=server.createobject("adodb.recordset") rs.open "select sort_id,sort_name from Baiyou_sort order by sort_id DESC",conn,1,1%>
选择品牌:
价格范围:
"> - ">
热门搜索:
<%getsearch 10,10,null%>
每页数量: