search.asp

asp网站 挺不错的 试一下吧 网上购物系统 呵呵呵

<!--#include file="top.asp"-->
<div align="center"><table width=980 border=0 cellpadding=0 cellspacing=0 bgcolor="#FFFFFF">
<tr><td width=181 align="center" valign="top"><!--#include file="log.asp"--><!--#include file="insort.asp"--><script language="javascript" src="inven.asp?ven_id=1"></script></td>
<td width="5"></td>
<td align="center" valign="top"> 
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<%if request("action")="search" then
venshopcom="sdjh@uhtxhvw+%sdjh%,!li#sdjh@%%#wkhq#sdjh@4!li#qrw+lvqxphulf+sdjh,,#wkhq#sdjh@4!li#sdjh?4#wkhq#sdjh@4!sdjh@lqw+sdjh,!kzbqdph@GhoVwu+uhtxhvw+%kzbqdph%,,!sulfh4@GhoVwu+uhtxhvw+%sulfh4%,,!li#sulfh4@%%#ru#qrw+lvqxphulf+sulfh4,,#wkhq#sulfh4@3!sulfh5@GhoVwu+uhtxhvw+%sulfh5%,,!li#sulfh5@%%#ru#qrw+lvqxphulf+sulfh5,,#wkhq#sulfh5@4333333333!li#uhtxhvw+%slqsdl%,?A%3%#wkhq!slqsdl@GhoVwu+uhtxhvw+%slqsdl%,,!hqg#li!txhkxr@GhoVwu+uhtxhvw+%txhkxr%,,!li#uhtxhvw+%rughu%,?A%%#wkhq#!rughu@GhoVwu+uhtxhvw+%rughu%,,!hovh!rughu@%{x%!hqg#li!li#rughu@%wlph%#wkhq!rughu{@%kzblg#ghvf%!hovhli#rughu@%krw%#wkhq!rughu{@%kzbex|v#ghvf/kzblg#ghvf%!hovhli#rughu@%sulfh4%#wkhq!rughu{@%wulp+kzbsulfh5,#dvf%!hovhli#rughu@%sulfh4%#wkhq!rughu{@%wulp+kzbsulfh5,#ghvf%!hovh!rughu{@%kzb{x#ghvf%!hqg#li!li#uhtxhvw+%sdjhf%,@%%#ru#Qrw+lvQxphulf+uhtxhvw+%sdjhf%,,,#wkhq!sdjhf@58!hovh!sdjhf@GhoVwu+uhtxhvw+%sdjhf%,,!hqg#li!li#kzbqdph?A%#%#dqg#kzbqdph?A%%#wkhq!vhw#uv@vhuyhu1fuhdwhremhfw+%dgrge1uhfrugvhw%,!vto@%vhohfw#-#iurp#yhqvkrsbvhdufk#zkhuh#vhdufkbqdph@*%)kzbqdph)%*%!uv1rshq#vto/frqq/4/6!li#uv1hri#wkhq!uv1dggqhz!uv+%vhdufkbqdph%,@kzbqdph!uv+%klwv%,@4!hovh!uv+%klwv%,@uv+%klwv%,.4!hqg#li!uv1xsgdwh!uv1forvh!vhw#uv@qrwklqj!hqg#li!li#vruwblg?A%%#dqg#vruwblg?A3#dqg#lvQxphulf+vruwblg,#wkhq#vhud@%#dqg#vruwblg@%#)#vruwblg#)#%%!li#kzbqdph?A%%#wkhq#vhue@%#dqg#kzbqdph#olnh#*(%#)#kzbqdph#)#%(*%!li#slqsdl?A%%#wkhq#vhuf@%#dqg#slqsdlblg#olnh#*(%#)#slqsdl#)#%(*%!vhug@%#dqg#kzbnxfxqA3%"
execute(vencode(venshopcom))
set rs=server.createobject("adodb.recordset")
sql="select * from venshop_hw where hw_price2>="&price1&" and hw_price2<="&price2&" " &sera&serb&serc&serd&"  order by "&orderx&""
rs.open sql,conn,1,1
if rs.eof then%><tr><td align="center" height="30">你所选的类别没有商品</td></tr><%else
rs.pagesize=pagec
totalrec=rs.recordcount
totalpage=rs.pagecount
if page>totalpage then page=totalpage
rs.absolutepage=page
rs.cachesize=rs.pagesize%>                
<tr><td height="23" class="sort">&nbsp; 共<%=totalrec%>件商品，这是第<%=(page-1)*rs.pagesize+1%>-<%if page+1<=totalpage then%><%=page*rs.pagesize%><%else%><%=totalrec%><%end if%>件</td></tr>
<tr> <td width="100%"> 
	<table width="100%" border="0" cellpadding="0" cellspacing="0"><%if lookt="image" then
i=0
do while not rs.eof and (i<rs.pagesize)
i=i+1%><tr><td width="25%" height="30" align="center"><!--#include file="insimage.asp"--></td></tr><%rs.movenext
loop
else%><tr><%i=0
do while not rs.eof and (i<rs.pagesize)
i=i+1%><td width="25%" height="30" align="center"><!--#include file="ins.asp"--></td>
<%if (i mod lookhang=0) and i>=lookhang then%></tr><tr><%end if
rs.movenext
loop%></tr><%end if%></table></td></tr>
<form action="<%=filename%>?action=search&sort_id=<%=sort_id%>&hw_name=<%=hw_name%>&pinpai=<%=pinpai%>&price1=<%=request("price1")%>&price2=<%=request("price2")%>&quehuo=<%=quehuo%>&order=<%=order%>&pagec=<%=pagec%>" method=post>
<tr><td height="2"></td></tr>
<tr><td height="23" class="sortb"> 
<p style="line-height: 150%; margin: 5px">第<%=page%>页/共<%=totalpage%>页&nbsp;&nbsp;
<%if page-1>0 then%><a href="search.asp?action=search&page=<%=page-1%>&sort_id=<%=sort_id%>&hw_name=<%=hw_name%>&pinpai=<%=pinpai%>&price1=<%=request("price1")%>&price2=<%=request("price2")%>&quehuo=<%=quehuo%>&order=<%=order%>&pagec=<%=pagec%>">上一页</a><%else%>上一页<%end if%>&nbsp;&nbsp;
<%if page+1<=totalpage then%> <a href="search.asp?action=search&page=<%=page+1%>&sort_id=<%=sort_id%>&hw_name=<%=hw_name%>&pinpai=<%=pinpai%>&price1=<%=request("price1")%>&price2=<%=request("price2")%>&quehuo=<%=quehuo%>&order=<%=order%>&pagec=<%=pagec%>">下一页</a><%else%>下一页<%end if%>&nbsp;&nbsp;
页面跳转：<input type="text" name="page" value="<%=page+1%>" size="1" style="text-align: center" class=input><input type="submit" value="GO" class=input><br>
选择页数：<%for i=1 to totalpage
if i=page then%>
<font color="#FF0000"><b><%=i%></b></font>
<%else%>
<a href="search.asp?action=search&page=<%=i%>&sort_id=<%=sort_id%>&hw_name=<%=hw_name%>&pinpai=<%=pinpai%>&price1=<%=request("price1")%>&price2=<%=request("price2")%>&quehuo=<%=quehuo%>&order=<%=order%>&pagec=<%=pagec%>"><%=i%></a>
<%end if
next%></td></tr></form><%end if%><%end if
rs.close
set rs=nothing%></table>
<table width="581" border="0" cellpadding="0" cellspacing="0"><form method="POST" action="search.asp?action=search">
<tr><td height="41"><img border="0" src="img/s-0.gif" width="581" height="41"></td></tr>
<tr><td background="img/s-1.gif" align="center">
<table border="0" cellpadding="5" cellspacing="0" width="90%">
<tr><td align="right" width="100">关键字：</td>
<td width="200"><input type="text" name="hw_name" size="20" class=input value="<%=request("hw_name")%>"></td>
</tr>
<tr><td align="right" width="100">　</td><td width="423"><a href="ven.asp">
	<font color="#FF0000">免费版不支持多关键字搜索，购买正式版可支持任意多关键字搜索！</font></a></td></tr>
<tr><td align="right" width="100">选择分类：</td><td width="423"><%set rs=server.createobject("adodb.recordset")
rs.open "select * from venshop_sort order by sort_id DESC",conn,1,1%><select name="sort_id"><option value="0">查询所有分类</option>
<%do while not rs.eof%><option value="<%=rs("sort_id")%>"<%if request("sort_id")<>"0" and int(request("sort_id"))=rs("sort_id") then%> selected<%end if%>><%=rs("sort_name")%></option>
<%rs.movenext
loop
rs.close
set rs=nothing%></select></td></tr>
<tr><td align="right" width="100">选择品牌：</td>
<td width="423"><%set rs=server.createobject("adodb.recordset")
rs.open "select * from venshop_pinpai order by pinpai_id DESC",conn,1,1%><select name="pinpai">
<option value="0">查询所有品牌</option><%do while not rs.eof%>
<option value="<%=rs("pinpai_id")%>"<%if request("pinpai")<>"0" and int(request("pinpai"))=rs("pinpai_id") then%> selected<%end if%>><%=rs("pinpai_name")%></option>
<%rs.movenext
loop
rs.close
set rs=nothing%></select></td></tr>
<tr><td align="right" width="100">价格范围：</td><td width="423">
<input type="text" name="price1" size="3" class=input value="<%=request("price1")%>"> -
<input type="text" name="price2" size="3" class=input value="<%=request("price2")%>"></td></tr>
<tr><td colspan="2" width="100%">热门搜索：<%set rs=server.createobject("adodb.recordset")
sql="select top 10 * from venshop_search order by hits desc"
rs.open sql,conn,1,1
if rs.eof then
response.write "没有数据"
else
do while not rs.eof%><a href="search.asp?action=search&hw_name=<%=rs("search_name")%>"><%=rs("search_name")%></a>,
<%rs.movenext
loop
end if
rs.close
set rs=nothing
%></td></tr></table></td></tr>
<tr><td height="86"><img border="0" src="img/s-2.gif" width="581" height="86"></td></tr>
<tr><td align="center" background="img/s-1.gif"><table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr><td height="30" width="100" align="right">排列方式：</td><td height="30" width="423"><select size="1" name="order">
<option selected value="">默认</option>
<option value="price1">价格由低到高</option>
<option value="price2">价格由高到低</option>
<option value="time">添加时间</option></select></td></tr>
<tr><td height="30" width="100" align="right">每页数量：</td><td height="30" width="423"><select size="1" name="pagec">
<option>10</option>
<option selected>25</option>
<option>50</option>
<option>100</option></select></td></tr>
<tr><td width="100" height="30"></td><td height="30" width="423"><input type="submit" name="imageField" value="提交查询" style="height:23;width:107"></td></tr>
</table></td></tr>
<tr><td height="17"><img border="0" src="img/s-3.gif" width="581" height="17"></td></tr></form>
</table></td></tr></table></div><!--#include file="copy.asp"-->