📄 so.asp
字号:
<!--#include file="conn.asp"-->
<%
keyword=request("keyword")
if keyword<>"" then
sql="select * from data where name like '%"&keyword&"%'"
else
sql="select * from data order by id desc"
end if
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,1
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>后台管理</title>
<style type="text/css">BODY {
SCROLLBAR-FACE-COLOR: #009ace; FONT-SIZE: 12px; SCROLLBAR-HIGHLIGHT-COLOR: #b8e9fa; SCROLLBAR-SHADOW-COLOR: #009aaa; COLOR: #a9c8e4; SCROLLBAR-ARROW-COLOR: #ffffff; SCROLLBAR-TRACK-COLOR: #cccccc; FONT-FAMILY: 宋体,Arial,Verdana ; BACKGROUND-COLOR: #1a2942
}
TD {
FONT-SIZE: 12px; COLOR: #a9c8e4; LINE-HEIGHT: 140%
}
A:link {
COLOR: #a9c8e4; TEXT-DECORATION: none
}
A:visited {
COLOR: #a9c8e4; TEXT-DECORATION: none
}
A:active {
COLOR: #a9c8e4; TEXT-DECORATION: none
}
A:hover {
COLOR: #00FF00; TEXT-DECORATION: underline
}
</style>
</head>
<body>
<div align="center">
<form action=? method=get>
频道搜索：
<input type="text" name="keyword" size="15">
<input type="submit" value="搜索" name="B1">
</form>
<table width="142" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><%
if rs.eof then
response.write "<p align=center><font color=#FF0000>暂时没有任何频道！</font></p>"
else
const maxperpage=10000
dim currentpage
rs.pagesize=maxperpage
currentpage=request.querystring("pageid")
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
if not isnumeric(currentpage) then
currentpage=1
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
%>
<li><a href="Play.Asp?Id=<%=rs("id")%>" target="play"><%=rs("name")%></a>
<% if session("admin")<>"" then %>
<a href=admin.asp?admin=edit&id=<%=rs("id")%> target="play"><font color="#008000">修改</font></a> <a onClick="return confirm('确认要删除吗？');" href="?admin=del&id=<%=rs("id")%>&tv=<%=rs("name")%>"><font color="#FF0000">删除</font></a>
<% if rs("yesno")="0" then %>
<br>
<font color="#bb0000">隐藏频道(ID:<%=rs("id")%>)</font>
<%end if%>
<%end if%>
<%
i=i+1
rs.movenext
loop
end if
set rs=nothing
k=currentpage
if k<>1 then
else
end if
%>
</td>
</tr>
</table>
</div>
</body>
</html>
<%
Set rs = Nothing
conn.close
set conn=Nothing
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -