research.asp
上传用户:btntkt
上传日期:2021-04-16
资源大小:5296k
文件大小:12k
源码类别:

WEB源码(ASP,PHP,...)

开发平台:

DOS

  1. <!--#include file="conn2.asp"-->
  2. <!--#include file="config.asp"-->
  3. <%
  4. dim action,searchkey,anclassid,jiage,selectname
  5. anclassid=request("anclassid")
  6. searchkey=trim(request("searchkey"))
  7. jiage=trim(request("jiage"))
  8. action=request("action")
  9. selectname=request("selectname")
  10. if InStr(searchkey,"'")>0 then
  11. response.write"<script>alert(""非法访问!"");location.href=""../index.asp"";</script>"
  12. response.end
  13. end if
  14. if anclassid<>"" then
  15. if not isnumeric(anclassid) then 
  16. response.write"<script>alert(""非法访问!"");location.href=""../index.asp"";</script>"
  17. response.end
  18. end if
  19. end if
  20. if jiage<>"" then
  21. if not isnumeric(jiage) then 
  22. response.write"<script>alert(""非法访问!"");location.href=""../index.asp"";</script>"
  23. response.end
  24. end if
  25. end if
  26. if action<>"" then
  27. if not isnumeric(action) then 
  28. response.write"<script>alert(""非法访问!"");location.href=""../index.asp"";</script>"
  29. response.end
  30. end if
  31. end if
  32. %>
  33. <html><head><title>网软天下购物系统,网络购物系统,asp购物系统,免费购物系统,网上商城购物系统。--商品搜索结果</title>
  34. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  35. <link href="skin/skin<%=skinid%>/css.css" rel="stylesheet" type="text/css">
  36. </head>
  37. <body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
  38. <!--#include file="include/head.asp"-->
  39. <table width="1000" border="0" align="center" cellpadding="0" cellspacing="0">
  40.   <tr>
  41.     <td width="41" valign="top"><table width="100%" height="184" border="0" cellpadding="0" cellspacing="0">
  42.       <tr>
  43.         <td height="30" align="right" valign="top"><img src="skin/skin<%=skinid%>/jiao.gif" width="15" height="17"></td>
  44.       </tr>
  45.       <tr>
  46.         <td height="90"><div align="right"><img src="images/ttts.gif" width="26" height="110" /></div></td>
  47.       </tr>
  48.       <tr>
  49.         <td height="30">&nbsp;</td>
  50.       </tr>
  51.     </table></td>
  52.   <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">
  53.   <tr>
  54.         <td><table width="190" height="190" border="0" cellpadding="0" cellspacing="0">
  55.           <tr>
  56.               <td align="center" valign="middle" background="skin/skin<%=skinid%>/index_2.gif"><!--#include file="logins.asp"--></td>
  57.           </tr>
  58.         </table></td>
  59.       </tr>
  60.       <tr>
  61.         <td><img src="images/index_4.gif" width="190" height="12" alt="" /></td>
  62.       </tr>
  63.       <tr>
  64.         <td><!--#include file="include/sort.asp"--></td>
  65.       </tr>
  66.       <tr>
  67.         <td></td>
  68.       </tr>
  69.       
  70.     </table></td>
  71.     <td valign="top"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
  72.       <tr>
  73.         <td background="skin/skin<%=skinid%>/pdbg01.gif" height=28>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  74.             <%if jiage="" then%>
  75.             <%if searchkey="" then
  76.       else
  77. response.write " 您查找的有关商品是: "
  78. if anclassid<>0 then
  79. set rs=server.CreateObject("adodb.recordset")
  80. rs.open "select * from bsort where anclassid="&anclassid,conn,1,1
  81. response.write "<a href=class.asp?lx=big&anid="&anclassid&"><font color=red>"&rs("anclass")&"</font></a>"&" &gt;&gt; "
  82. rs.close
  83. set rs=nothing
  84. end if
  85. response.write "<font color=red>"&searchkey&"</font>"
  86. s_bookname=searchkey
  87.       end if%>
  88.             <%else%>
  89.             <%if (action="1" or action="3" or action="4") and searchkey="" then
  90. response.write "<script language=javascript>alert('对不起,请您输入查讯关键字');history.go(-1);</script>"
  91. response.End
  92.       else
  93.           
  94.         response.write " 您查找的有关商品是: "
  95.     if anclassid<>0 then
  96. set rs=server.CreateObject("adodb.recordset")
  97. rs.open "select * from bsort where anclassid="&anclassid,conn,1,1
  98. response.write "<a href=class.asp?lx=big&anid="&anclassid&"><font color=red>"&rs("anclass")&"</font></a>"&" &gt;&gt; "
  99. rs.close
  100. set rs=nothing
  101.     end if
  102. if action="1" or action="3" then 
  103. response.write "<font color=red>"&searchkey&"</font>"
  104. s_bookname=searchkey
  105. else
  106. response.write "<font color=red>"&selectname&"</font>"
  107. s_bookname=selectname
  108. end if
  109. end if%>
  110.             <%end if%></td>
  111.       </tr>
  112.     </table>
  113.       <br>
  114. <table width="100%" align="center" border="0" cellspacing="0" cellpadding="0" bordercolor="#CCCCCC">
  115.       <tr>
  116.         <td align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF"><%
  117.              if request("search")=" all" then 
  118. keyword=request.form("keyword")
  119. if keyword<>"" then
  120. dim path,myfileobject,mytextfile
  121.  path = Server.MapPath(shopurl)
  122. set  MyFileObject = Server.CreateObject("Scripting.FileSystemObject")
  123. set  MyTextFile = MyFileObject.CreateTextFile(path)
  124. MyTextFile.WriteLine (keyword)
  125. MyTextFile.Close()
  126. response.end
  127. else
  128. response.end
  129. end if 
  130. else
  131. end if 
  132. Const MaxPerPage=12
  133.     dim totalPut   
  134.     dim CurrentPage
  135.     dim TotalPages
  136.     dim j
  137.     dim sql
  138.      if Not isempty(request("page")) then
  139.        currentPage=Cint(request("page"))
  140.     else
  141.        currentPage=1
  142.     end if 
  143. if jiage="" then  
  144. sql2="searchkey="&searchkey&"&anclassid="&anclassid
  145. select case request("anclassid")
  146. case "0"
  147. sql1=" bookname like '%"&searchkey&"%' "
  148. case else
  149. sql1=" bookname like '%"&searchkey&"%' and anclassid="&request("anclassid")&" "
  150. end select
  151. else
  152. sql2="searchkey="&searchkey&"&anclassid="&anclassid&"&jiage="&jiage&"&action="&action&"&selectname="&selectname
  153. if anclassid<>0 then   
  154. select case action
  155. case "1"
  156. sql1=" bookname like '%"&searchkey&"%' and (shichangjia<"&jiage&" or huiyuanjia<"&jiage&" or vipjia<"&jiage&") and anclassid="&anclassid&" "
  157. case "2"
  158. sql1=" pingpai like '%"&selectname&"%' and (shichangjia<"&jiage&" or huiyuanjia<"&jiage&" or vipjia<"&jiage&") and anclassid="&anclassid&" "
  159. case "3"
  160. sql1=" bookcontent like '%"&selectname&"%' and (shichangjia<"&jiage&" or huiyuanjia<"&jiage&" or vipjia<"&jiage&") and anclassid="&anclassid&" "
  161. case "4"
  162. sql1=" grade like '%"&searchkey&"%'  "
  163. end select
  164. else
  165. select case action
  166. case "1"
  167. sql1=" bookname like '%"&searchkey&"%' and (shichangjia<"&jiage&" or huiyuanjia<"&jiage&" or vipjia<"&jiage&") "
  168. case "2"
  169. sql1=" pingpai like '%"&selectname&"%' and (shichangjia<"&jiage&" or huiyuanjia<"&jiage&" or vipjia<"&jiage&") "
  170. case "3"
  171. sql1=" bookcontent like '%"&selectname&"%' and (shichangjia<"&jiage&" or huiyuanjia<"&jiage&" or vipjia<"&jiage&") "
  172. case "4"
  173. sql1=" grade  like '%"&searchkey&"%'  "
  174. end select
  175. end if
  176. end if
  177.  
  178.  
  179. dim b,e
  180. b=trim(request("b"))
  181. e=trim(request("e"))
  182. if b<>"" or e<>"" then 
  183. set rs=server.CreateObject("adodb.recordset")
  184. rs.open "select * from products where huiyuanjia>"&b&" and huiyuanjia<"&e&"  and   zhuangtai=0 order by adddate desc",conn,1,1
  185. else
  186. set rs=server.CreateObject("adodb.recordset")
  187. rs.open "select * from products where "&sql1&" and  zhuangtai=0 order by adddate desc",conn,1,1
  188.  end if 
  189.    if rs.eof And rs.bof then
  190.         Response.Write "<p align=center> 对不起,没有查讯到您需要的商品!</p><br>"
  191.     else
  192.    totalPut=rs.recordcount
  193.        if currentpage<1 then
  194.            currentpage=1
  195.        end if
  196.        if (currentpage-1)*MaxPerPage>totalput then
  197.     if (totalPut mod MaxPerPage)=0 then
  198.       currentpage= totalPut  MaxPerPage
  199.     else
  200.        currentpage= totalPut  MaxPerPage + 1
  201.     end if
  202.        end if
  203.         if currentPage=1 then
  204.              showContent
  205.              showpage totalput,MaxPerPage,"research.asp"
  206.         else
  207.            if (currentPage-1)*MaxPerPage<totalPut then
  208.              rs.move  (currentPage-1)*MaxPerPage
  209.              dim bookmark
  210.              bookmark=rs.bookmark
  211.              showContent
  212.               showpage totalput,MaxPerPage,"research.asp"
  213.          else
  214.          currentPage=1
  215.             showContent
  216.             showpage totalput,MaxPerPage,"research.asp"
  217.        end if
  218.     end if
  219.         end if
  220.     sub showContent
  221.         dim i
  222.     i=0
  223. %>
  224.           <%do while not rs.eof%>
  225.             <br>
  226.             <table width="95%" border="0" cellspacing="0" cellpadding="0"  >
  227.               <tr>
  228.                 <td width="22%"><table align=center cellspacing=0 cellpadding=0 width=100 height=100 border=0>
  229.                   <tbody>
  230.                     <tr>
  231.                       <td  align=center><%if rs("bookpic")="" then 
  232. 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>"
  233. else%>
  234.                           <a href=products.asp?id=<%=rs("bookid")%> ><img src="<%=trim(rs("bookpic"))%>"  width=90 border=0 height="90"></a>
  235.                           <%end if%>                      </td>
  236.                     </tr>
  237.                   </tbody>
  238.                 </table></td>
  239.                 <td width="35%" valign="middle"><table width="100%" border="0" cellspacing="0" cellpadding="0">
  240.                     <tr>
  241.                       <td>商品名称:
  242.                       <%response.write "<a href=products.asp?id="&trim(rs("bookid"))&" >"&trim(rs("bookname"))&"</a>"%></td>
  243.                     </tr>
  244.                     
  245.                   </table></td>
  246.                 <td width="22%"><table width="100%" border="0" cellspacing="0" cellpadding="0">
  247.                     <tr>
  248.                       <td height="25">市场价:<s><%=rs("shichangjia")&"元"%></s> </td>
  249.                     </tr>
  250.                     <tr>
  251.                       <td height="25">会员价:<%="<font color=#FF0000>"&rs("huiyuanjia")&"元</font>"%></td>
  252.                     </tr>
  253.                   </table></td>
  254.                 <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>
  255.                 <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>
  256.               </tr>
  257.               <tr>
  258.                 <td height="1" colspan="4" background="images/mingle/inbg.gif"></td>
  259.               </tr>
  260.             </table>
  261.             <%i=i+1
  262. if i>=MaxPerPage then Exit Do
  263. rs.movenext
  264.   loop
  265.   rs.close
  266.   set rs=nothing%>
  267.             <%  
  268. End Sub   
  269. Function showpage(totalnumber,maxperpage,filename)  
  270.    Dim n
  271. If totalnumber Mod maxperpage=0 Then  
  272. n= totalnumber  maxperpage  
  273. Else
  274. n= totalnumber  maxperpage+1  
  275. End If
  276. Response.Write "<form method=Post action="&filename&"?searchkey="&searchkey&"&action="&action&"&anclassid="&anclassid&"&jiage="&jiage&">"  
  277. Response.Write "<p align='center' class='contents'> "  
  278. If CurrentPage<2 Then  
  279. Response.Write "<font class='contents'>首页 上一页</font> "  
  280. Else  
  281. Response.Write "<a href="&filename&"?page=1&searchkey="&searchkey&"&action="&action&"&anclassid="&anclassid&"&jiage="&jiage&" class='contents'>首页</a> "  
  282. Response.Write "<a href="&filename&"?page="&CurrentPage-1&"&searchkey="&searchkey&"&action="&action&"&anclassid="&anclassid&"&jiage="&jiage&" class='contents'>上一页</a> "  
  283. End If
  284. If n-currentpage<1 Then  
  285. Response.Write "<font class='contents'>下一页 尾页</font>"  
  286. Else  
  287. Response.Write "<a href="&filename&"?page="&(CurrentPage+1)&"&searchkey="&searchkey&"&action="&action&"&anclassid="&anclassid&"&jiage="&jiage&" class='contents'>"  
  288. Response.Write "下一页</a> <a href="&filename&"?page="&n&"&searchkey="&searchkey&"&action="&action&"&anclassid="&anclassid&"&jiage="&jiage&" class='contents'>尾页</a>"  
  289. End If  
  290. Response.Write "<font class='contents'> 页次:</font><font class='contents'>"&CurrentPage&"</font><font class='contents'>/"&n&"页</font> "  
  291. Response.Write "<font class='contents'> 共查讯到"&totalnumber&"种商品 " 
  292. Response.Write "<font class='contents'>转到:</font><input CLASS='wenbenkuang' type='text' name='page' size=2 maxlength=8 class=smallInput value="&currentpage&">"  
  293. Response.Write "&nbsp;<input type='submit' CLASS='go-wenbenkuang' class='contents' value='GO' name='cndok'></form>"  
  294. End Function  
  295. %>
  296.        </td>
  297.       </tr>
  298.     </table></td>
  299. <td width="68"style="BORDER-left:<%=skincolor%> 1px solid;">&nbsp;</td>
  300.   </tr>
  301. </table>
  302. <!--#include file="include/foot.asp"-->
  303. </body>
  304. </html>