📄 search_ad.asp
字号:
<!--#include file="conn.asp"-->
<%
if session("ad_admin")="" then
response.redirect "ad_login.asp"
end if
dim sql,rs
Set rs = Server.CreateObject("ADODB.Recordset")
name=HtmlEncode(trim(request("keyword")))
if name="" then
response.write "<SCRIPT language=JavaScript>alert('请您输入搜索关键字！');"
response.write "this.location.href='javascript:history.back()';</SCRIPT>"
response.end
else
sql="select * from data where (title Like '%"& name &"%' or text Like '%"& name &"%' or type Like '%"& name &"%') and stop >= date() order by top desc,money desc,time desc"
rs.open sql,conn,1,1
end if
if rs.eof then
response.write "<SCRIPT language=JavaScript>alert('对不起，没有找到符合条件的广告！');"
response.write "this.location.href='javascript:history.back()';</SCRIPT>"
rs.close
set rs=nothing
response.end
else
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>过期失效广告 - 查询结果</title>
<style type="text/css">
<!--
td { font-size: 12px; line-height: 17px }
body { font-size: 12px; line-height: 17px }
p { margin-top: 1px; margin-bottom: 1px }
a:link { text-decoration: none; color: black }
a:visited { text-decoration: none; color: black }
a:active { text-decoration: none }
a:hover { text-decoration: underline; color: red }
-->
</style>
</head>
<body background="images/background.gif">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td height="30">
<p align="center"><font style="font-size:14px"><a href="add.asp">发布新广告</a> <a href="list.asp">全部广告</a> <a href="guding.asp">固顶广告</a> <a href="shixiao.asp">过期广告</a> <a href="pass.asp">修改管理密码</a> <a href="quit.asp"><font color="#FF0000">退出管理</font></a></font></p>
</td>
</tr>
<tr>
<td width="100%">
<div align="center">
<center>
<table border="1" width="700" bordercolorlight="#000000" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="0" bgcolor="#F3F3F3">
<tr><td height="25" colspan="8" bgcolor="#C0C0C0">
<p align="center"><b>现 有 广 告 查 询 结 果</b></td></tr>
<tr>
<td width="46" bgcolor="#E8E8E8">
<p align="center">编号</p>
</td>
<td width="158" bgcolor="#E8E8E8"> 广告标题</td>
<td width="83" bgcolor="#E8E8E8" align="center">广告类别</td>
<td width="83" bgcolor="#E8E8E8">
<p align="center">发布日期</td>
<td width="83" bgcolor="#E8E8E8">
<p align="center">升效日期</td>
<td width="83" bgcolor="#E8E8E8">
<p align="center">截止日期</td>
<td width="83" bgcolor="#E8E8E8">
<p align="center">发布状态</td>
<td width="65" bgcolor="#E8E8E8">
<p align="center">管理操作</p>
</td>
</tr>
<%
const maxperpage=100
dim currentpage
rs.pagesize=maxperpage
currentpage=request.querystring("pageid")
if isnumeric(currentpage)=false then
response.write "<script>alert('参数错误，关闭窗口！');window.close();</script>"
response.end
end if
if currentpage="" then
currentpage=1
elseif currentpage<1 then
currentpage=1
else
currentpage=clng(currentpage)
if currentpage > rs.pagecount then
currentpage=rs.pagecount
end if
end if
dim totalput,n
totalput=rs.recordcount
if totalput mod maxperpage=0 then
n=totalput\maxperpage
else
n=totalput\maxperpage+1
end if
if n=0 then
n=1
end if
rs.move(currentpage-1)*maxperpage
i=0
do while i< maxperpage and not rs.eof
%>
<tr>
<td width="46">
<p align="center"><%=i+currentpage*maxperpage-maxperpage+1%></td>
<td width="158"> <%=rs("title")%></td>
<td width="83" align="center"><%=rs("type")%></td>
<td width="83">
<p align="center"><%=rs("date")%></td>
<td width="83">
<p align="center"><%=rs("time")%></td>
<td width="83">
<p align="center"><%=rs("stop")%></td>
<td width="83"><p align="center"><% If rs("mark")="yes" Then %><font color="#008000">已经发布</font><% Else %><font color="#FF0000">尚未发布</font><% End If %></td>
<td width="65">
<p align="center"><a href="edit.asp?id=<%=rs("adid")%>"><font color="green">编辑</font></a> <a href="del.asp?id=<%=rs("adid")%>" onClick="return confirm('确定要删除吗？\n\n该操作不可恢复！')"><font color="red">删除</font></a></p>
</td>
</tr>
<%
i=i+1
rs.movenext
loop
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -