research.asp
资源名称:shop2.rar [点击查看]
上传用户:btntkt
上传日期:2021-04-16
资源大小:5296k
文件大小:12k
源码类别:
WEB源码(ASP,PHP,...)
开发平台:
DOS
- <!--#include file="conn2.asp"-->
- <!--#include file="config.asp"-->
- <%
- dim action,searchkey,anclassid,jiage,selectname
- anclassid=request("anclassid")
- searchkey=trim(request("searchkey"))
- jiage=trim(request("jiage"))
- action=request("action")
- selectname=request("selectname")
- if InStr(searchkey,"'")>0 then
- response.write"<script>alert(""非法访问!"");location.href=""../index.asp"";</script>"
- response.end
- end if
- if anclassid<>"" then
- if not isnumeric(anclassid) then
- response.write"<script>alert(""非法访问!"");location.href=""../index.asp"";</script>"
- response.end
- end if
- end if
- if jiage<>"" then
- if not isnumeric(jiage) then
- response.write"<script>alert(""非法访问!"");location.href=""../index.asp"";</script>"
- response.end
- end if
- end if
- if action<>"" then
- if not isnumeric(action) then
- response.write"<script>alert(""非法访问!"");location.href=""../index.asp"";</script>"
- response.end
- end if
- end if
- %>
- <html><head><title>网软天下购物系统,网络购物系统,asp购物系统,免费购物系统,网上商城购物系统。--商品搜索结果</title>
- <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
- <link href="skin/skin<%=skinid%>/css.css" rel="stylesheet" type="text/css">
- </head>
- <body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
- <!--#include file="include/head.asp"-->
- <table width="1000" border="0" align="center" cellpadding="0" cellspacing="0">
- <tr>
- <td width="41" valign="top"><table width="100%" height="184" border="0" cellpadding="0" cellspacing="0">
- <tr>
- <td height="30" align="right" valign="top"><img src="skin/skin<%=skinid%>/jiao.gif" width="15" height="17"></td>
- </tr>
- <tr>
- <td height="90"><div align="right"><img src="images/ttts.gif" width="26" height="110" /></div></td>
- </tr>
- <tr>
- <td height="30"> </td>
- </tr>
- </table></td>
- <td width="190" valign="top"style="BORDER-bottom:<%=skincolor%> 1px solid;BORDER-left:<%=skincolor%> 1px solid; BORDER-right:<%=skincolor%> 1px solid;"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr>
- <td><table width="190" height="190" border="0" cellpadding="0" cellspacing="0">
- <tr>
- <td align="center" valign="middle" background="skin/skin<%=skinid%>/index_2.gif"><!--#include file="logins.asp"--></td>
- </tr>
- </table></td>
- </tr>
- <tr>
- <td><img src="images/index_4.gif" width="190" height="12" alt="" /></td>
- </tr>
- <tr>
- <td><!--#include file="include/sort.asp"--></td>
- </tr>
- <tr>
- <td></td>
- </tr>
- </table></td>
- <td valign="top"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
- <tr>
- <td background="skin/skin<%=skinid%>/pdbg01.gif" height=28>
- <%if jiage="" then%>
- <%if searchkey="" then
- else
- response.write " 您查找的有关商品是: "
- if anclassid<>0 then
- set rs=server.CreateObject("adodb.recordset")
- rs.open "select * from bsort where anclassid="&anclassid,conn,1,1
- response.write "<a href=class.asp?lx=big&anid="&anclassid&"><font color=red>"&rs("anclass")&"</font></a>"&" >> "
- rs.close
- set rs=nothing
- end if
- response.write "<font color=red>"&searchkey&"</font>"
- s_bookname=searchkey
- end if%>
- <%else%>
- <%if (action="1" or action="3" or action="4") and searchkey="" then
- response.write "<script language=javascript>alert('对不起,请您输入查讯关键字');history.go(-1);</script>"
- response.End
- else
- response.write " 您查找的有关商品是: "
- if anclassid<>0 then
- set rs=server.CreateObject("adodb.recordset")
- rs.open "select * from bsort where anclassid="&anclassid,conn,1,1
- response.write "<a href=class.asp?lx=big&anid="&anclassid&"><font color=red>"&rs("anclass")&"</font></a>"&" >> "
- rs.close
- set rs=nothing
- end if
- if action="1" or action="3" then
- response.write "<font color=red>"&searchkey&"</font>"
- s_bookname=searchkey
- else
- response.write "<font color=red>"&selectname&"</font>"
- s_bookname=selectname
- end if
- end if%>
- <%end if%></td>
- </tr>
- </table>
- <br>
- <table width="100%" align="center" border="0" cellspacing="0" cellpadding="0" bordercolor="#CCCCCC">
- <tr>
- <td align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF"><%
- if request("search")=" all" then
- keyword=request.form("keyword")
- if keyword<>"" then
- dim path,myfileobject,mytextfile
- path = Server.MapPath(shopurl)
- set MyFileObject = Server.CreateObject("Scripting.FileSystemObject")
- set MyTextFile = MyFileObject.CreateTextFile(path)
- MyTextFile.WriteLine (keyword)
- MyTextFile.Close()
- response.end
- else
- response.end
- end if
- else
- end if
- Const MaxPerPage=12
- dim totalPut
- dim CurrentPage
- dim TotalPages
- dim j
- dim sql
- if Not isempty(request("page")) then
- currentPage=Cint(request("page"))
- else
- currentPage=1
- end if
- if jiage="" then
- sql2="searchkey="&searchkey&"&anclassid="&anclassid
- select case request("anclassid")
- case "0"
- sql1=" bookname like '%"&searchkey&"%' "
- case else
- sql1=" bookname like '%"&searchkey&"%' and anclassid="&request("anclassid")&" "
- end select
- else
- sql2="searchkey="&searchkey&"&anclassid="&anclassid&"&jiage="&jiage&"&action="&action&"&selectname="&selectname
- if anclassid<>0 then
- select case action
- case "1"
- sql1=" bookname like '%"&searchkey&"%' and (shichangjia<"&jiage&" or huiyuanjia<"&jiage&" or vipjia<"&jiage&") and anclassid="&anclassid&" "
- case "2"
- sql1=" pingpai like '%"&selectname&"%' and (shichangjia<"&jiage&" or huiyuanjia<"&jiage&" or vipjia<"&jiage&") and anclassid="&anclassid&" "
- case "3"
- sql1=" bookcontent like '%"&selectname&"%' and (shichangjia<"&jiage&" or huiyuanjia<"&jiage&" or vipjia<"&jiage&") and anclassid="&anclassid&" "
- case "4"
- sql1=" grade like '%"&searchkey&"%' "
- end select
- else
- select case action
- case "1"
- sql1=" bookname like '%"&searchkey&"%' and (shichangjia<"&jiage&" or huiyuanjia<"&jiage&" or vipjia<"&jiage&") "
- case "2"
- sql1=" pingpai like '%"&selectname&"%' and (shichangjia<"&jiage&" or huiyuanjia<"&jiage&" or vipjia<"&jiage&") "
- case "3"
- sql1=" bookcontent like '%"&selectname&"%' and (shichangjia<"&jiage&" or huiyuanjia<"&jiage&" or vipjia<"&jiage&") "
- case "4"
- sql1=" grade like '%"&searchkey&"%' "
- end select
- end if
- end if
- dim b,e
- b=trim(request("b"))
- e=trim(request("e"))
- if b<>"" or e<>"" then
- set rs=server.CreateObject("adodb.recordset")
- rs.open "select * from products where huiyuanjia>"&b&" and huiyuanjia<"&e&" and zhuangtai=0 order by adddate desc",conn,1,1
- else
- set rs=server.CreateObject("adodb.recordset")
- rs.open "select * from products where "&sql1&" and zhuangtai=0 order by adddate desc",conn,1,1
- end if
- if rs.eof And rs.bof then
- Response.Write "<p align=center> 对不起,没有查讯到您需要的商品!</p><br>"
- else
- totalPut=rs.recordcount
- if currentpage<1 then
- currentpage=1
- end if
- if (currentpage-1)*MaxPerPage>totalput then
- if (totalPut mod MaxPerPage)=0 then
- currentpage= totalPut MaxPerPage
- else
- currentpage= totalPut MaxPerPage + 1
- end if
- end if
- if currentPage=1 then
- showContent
- showpage totalput,MaxPerPage,"research.asp"
- else
- if (currentPage-1)*MaxPerPage<totalPut then
- rs.move (currentPage-1)*MaxPerPage
- dim bookmark
- bookmark=rs.bookmark
- showContent
- showpage totalput,MaxPerPage,"research.asp"
- else
- currentPage=1
- showContent
- showpage totalput,MaxPerPage,"research.asp"
- end if
- end if
- end if
- sub showContent
- dim i
- i=0
- %>
- <%do while not rs.eof%>
- <br>
- <table width="95%" border="0" cellspacing="0" cellpadding="0" >
- <tr>
- <td width="22%"><table align=center cellspacing=0 cellpadding=0 width=100 height=100 border=0>
- <tbody>
- <tr>
- <td align=center><%if rs("bookpic")="" then
- response.write "<div align=center><a href=products.asp?id="&rs("bookid")&" ><img src=images/emptybook.gif width=90 height=90 border=0></a></div>"
- else%>
- <a href=products.asp?id=<%=rs("bookid")%> ><img src="<%=trim(rs("bookpic"))%>" width=90 border=0 height="90"></a>
- <%end if%> </td>
- </tr>
- </tbody>
- </table></td>
- <td width="35%" valign="middle"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr>
- <td>商品名称:
- <%response.write "<a href=products.asp?id="&trim(rs("bookid"))&" >"&trim(rs("bookname"))&"</a>"%></td>
- </tr>
- </table></td>
- <td width="22%"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr>
- <td height="25">市场价:<s><%=rs("shichangjia")&"元"%></s> </td>
- </tr>
- <tr>
- <td height="25">会员价:<%="<font color=#FF0000>"&rs("huiyuanjia")&"元</font>"%></td>
- </tr>
- </table></td>
- <td width="21%" align="center"><a href="buy.asp?id=<%=rs("bookid")%>&action=add" target="_blank" ><img src=images/buy.gif width=91 height=30 border=0></a><br>
- <a href=# onClick="window.open('stow.asp?id=<%=rs("bookid")%>&action=add ', 'basket','menubar=no,toolbar=no,location=no,directories=no,status=no,scrollbars=0,resizable=0,width=520,top=10,left=0,height=260')"><img src='images/house.gif' width=91 height=30 border=0></a></td>
- </tr>
- <tr>
- <td height="1" colspan="4" background="images/mingle/inbg.gif"></td>
- </tr>
- </table>
- <%i=i+1
- if i>=MaxPerPage then Exit Do
- rs.movenext
- loop
- rs.close
- set rs=nothing%>
- <%
- End Sub
- Function showpage(totalnumber,maxperpage,filename)
- Dim n
- If totalnumber Mod maxperpage=0 Then
- n= totalnumber maxperpage
- Else
- n= totalnumber maxperpage+1
- End If
- Response.Write "<form method=Post action="&filename&"?searchkey="&searchkey&"&action="&action&"&anclassid="&anclassid&"&jiage="&jiage&">"
- Response.Write "<p align='center' class='contents'> "
- If CurrentPage<2 Then
- Response.Write "<font class='contents'>首页 上一页</font> "
- Else
- Response.Write "<a href="&filename&"?page=1&searchkey="&searchkey&"&action="&action&"&anclassid="&anclassid&"&jiage="&jiage&" class='contents'>首页</a> "
- Response.Write "<a href="&filename&"?page="&CurrentPage-1&"&searchkey="&searchkey&"&action="&action&"&anclassid="&anclassid&"&jiage="&jiage&" class='contents'>上一页</a> "
- End If
- If n-currentpage<1 Then
- Response.Write "<font class='contents'>下一页 尾页</font>"
- Else
- Response.Write "<a href="&filename&"?page="&(CurrentPage+1)&"&searchkey="&searchkey&"&action="&action&"&anclassid="&anclassid&"&jiage="&jiage&" class='contents'>"
- Response.Write "下一页</a> <a href="&filename&"?page="&n&"&searchkey="&searchkey&"&action="&action&"&anclassid="&anclassid&"&jiage="&jiage&" class='contents'>尾页</a>"
- End If
- Response.Write "<font class='contents'> 页次:</font><font class='contents'>"&CurrentPage&"</font><font class='contents'>/"&n&"页</font> "
- Response.Write "<font class='contents'> 共查讯到"&totalnumber&"种商品 "
- Response.Write "<font class='contents'>转到:</font><input CLASS='wenbenkuang' type='text' name='page' size=2 maxlength=8 class=smallInput value="¤tpage&">"
- Response.Write " <input type='submit' CLASS='go-wenbenkuang' class='contents' value='GO' name='cndok'></form>"
- End Function
- %>
- </td>
- </tr>
- </table></td>
- <td width="68"style="BORDER-left:<%=skincolor%> 1px solid;"> </td>
- </tr>
- </table>
- <!--#include file="include/foot.asp"-->
- </body>
- </html>
English
