ad_search.asp

凡人网络购物系统 v8.0 中文版

<!--#include file="conn.asp"-->
<!--#include file="ad_chk.asp"-->
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href=inc/css.css rel=STYLESHEET type=text/css>

<%if request("action")="del" then
id=request("id")
set rs=server.createobject("adodb.recordset")
sql="select * from venshop_search where id="&id&""
rs.open sql,conn,1,3
if rs.eof then
response.redirect "ad_search.asp"
response.end
else
rs.delete
rs.update
response.write "删除完毕"
response.write "<Br>"
response.write "<a href=# onClick=history.go(-1)><font color=#ff0000>返回</font></a>"
response.end
end if
rs.close
set rs=nothing
else%>
<table border="0" width="600" cellspacing="1" style="border-collapse: collapse" cellpadding="5" bgcolor="#C8C8C8">
<tr bgcolor="#6894d8"> 
<td bgcolor="#F0F0F0" align="center">关键字</td>
<td bgcolor="#F0F0F0" align="center"> 搜索量</td>
<td bgcolor="#F0F0F0" align="center">操作</td></tr>
<%page=request("page")
if page="" then page=1
if not(isnumeric(page)) then page=1
if page<1 then page=1
page=int(page)
set rs=server.createobject("adodb.recordset")
sql="select * from venshop_search order by hits DESC"
rs.open sql,conn,1,1
if rs.eof then%>
<tr><td colspan="3" bgcolor="#FFFFFF" align="center">没有内容</td></tr>
<%else
rs.pagesize=20
totalrec=rs.recordcount
totalpage=rs.pagecount
if page>totalpage then page=totalpage
rs.absolutepage=page
rs.cachesize=rs.pagesize
i=0
do while not rs.eof and (i<rs.pagesize)
i=i+1%>
<tr bgcolor="#FFFFFF"> 
  <td align="center"><a target="_blank" href="search.asp?action=search&hw_name=<%=rs("search_name")%>"><%=rs("search_name")%></a></td>
  <td align="center"><%=rs("hits")%></td>
  <td align="center"><a href="ad_search.asp?id=<%=rs("id")%>&action=del"  onClick="return confirm('您确定进行删除操作吗？')">删除</a></td></tr>
<%rs.movenext
loop
end if
rs.close
set rs=nothing
conn.close
set conn=nothing%>
<tr><td colspan="3" bgcolor="#FFFFFF" align="center">
共<font color=red><%=totalpage%></font>页 第<%=page%>页&nbsp;&nbsp;
<%if page-1>0 then%><a href="<%=filename%>?page=<%=page-1%>">上一页</a><%else%>上一页<%end if%>&nbsp;&nbsp;
<%if page+1<=totalpage then%><a href="<%=filename%>?page=<%=page+1%>">下一页</a> <%else%>下一页<%end if%>
</td></tr></table>
<%end if%>
<br>
<div class="help">
备注：<br>这里统计的数据为前台客户搜索的关键字。</div><table cellSpacing="0" cellPadding="3" border="0" width="500"><tr><td height="20"></td></tr>
<tr><td bgcolor="#F2F2F2"><p style="LINE-HEIGHT: 150%"><font color="#FF0000">凡人网络购物系统V8.0 版权所有:</font><a target="_blank" href="http://www.venshop.com"><font color="#FF0000">凡人网络VenShop.Com</font></a><font color="#FF0000"><br>客服电话:[phone]&nbsp; QQ:57152557/5404818 Email/Msn:</font><a href="mailto:[e-mail]"><font color="#FF0000">[e-mail]</font></a></td>
</tr></table>