📄 right.asp
字号:
<!--#include file="conn.asp"-->
<%
key=trim(request("key"))
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<META name="Keywords" content="mp3,asf,wav,ram">
<META name="Description" content="mp3,asf,wav,mid,网上媒体播放">
<link href="../images/font.css" rel="stylesheet" type="text/css">
<title>音乐吧</title>
<NOSCRIPT><IFRAME SRC="*.html"></IFRAME></NOSCRIPT>
<style type="text/css">
<!--
a { font-family: "宋体"; font-size: 9pt; font-style: normal; line-height: 13pt; font-weight: normal; font-variant: normal; text-transform: none; color: <%=fontcolor%>; text-decoration: none}
a:hover { font-family: "宋体"; font-size: 9pt; font-style: normal; line-height: 13pt; font-weight: normal; font-variant: normal; text-transform: none; color: <%=fontcolor%>; text-decoration: underline}
td { font-family: "宋体"; font-size: 9pt; font-style: normal; line-height: 13pt; font-weight: normal; font-variant: normal; text-transform: none; color: <%=fontcolor%>}
br { font-family: "宋体"; font-size: 9pt; font-style: normal; line-height: 13pt; font-weight: normal; font-variant: normal; text-transform: none; color: <%=fontcolor%>}
.bk { font-size: 9pt; border: 5px<%=xcolor%> solid}
body { font-family: "宋体"; font-size: 9pt; font-style: normal; line-height: 13pt; font-weight: normal; font-variant: normal; text-transform: none}
.an { font-family: "宋体"; font-size: 9pt; background-color: <%=bgcolor%>; border: 1px <%=xcolor%> solid; color: <%=fontcolor%>}
.xzy { border: <%=xcolor%> solid; border-width: 0px 1px 1px}
.zx { border: <%=xcolor%> solid; border-width: 0px 0px 1px 1px}
.sxz { border: <%=xcolor%> solid; border-width: 1px 0px 1px 1px}
.s { border: <%=xcolor%>; border-style: solid; border-top-width: 1px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px}
.y { border: <%=xcolor%>; border-style: solid; border-top-width: 0px; border-right-width: 1px; border-bottom-width: 0px; border-left-width: 0px}
.font { font-family: "Arial Black"; font-size: 14pt; color: <%=fontcolor%>}
.x { border: <%=xcolor%>; border-style: solid; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 1px; border-left-width: 0px}
.z { border: <%=xcolor%>; border-style: solid; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 1px}
.sx { border: <%=xcolor%>; border-style: solid; border-top-width: 1px; border-right-width: 0px; border-bottom-width: 1px; border-left-width: 0px}
.bk1 {
BORDER-BOTTOM: #86540c 1px dashed; BORDER-LEFT: #86540c 1px dashed; BORDER-RIGHT: #86540c 1px dashed; BORDER-TOP: #86540c 1px dashed
-->
</style>
</head>
<body text="#471b0a" vlink="#86540c" link="#86540c" bgcolor="#67331f" background="../img/dnacebg2.jpg" topmargin="0">
<div align="center">
<center>
<table width="614" height="313" border="0" cellpadding="0" cellspacing="10" bgcolor="#E4C59A">
<tbody>
<tr>
<td valign="top" width="634" background="../img/dnacebg.jpg" height="313">
<div align="center">
<table cellspacing="0" cellpadding="0" width="600" border="0" height="178" bgcolor="#E4C59A">
<tbody>
<tr>
<td width="600" height="99">
<p align="center">
<img border="0" src="../img/bgtop.jpg" width="580" height="100"></p>
</td>
</tr>
<center></center>
<center>
<tr>
<td width="600" height="37">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="12%" align="center"><a href="../index.asp"><img border="0" src="../img/index.gif" align="absmiddle" width="50" height="20"></a></td>
<td width="12%" align="center"><a href="../diary/index.asp"><img border="0" src="../img/rj.gif" align="absmiddle" width="50" height="20"></a></td>
<td width="12%" align="center"><a href="../pic/index.asp"><img border="0" src="../img/xc.gif" align="absmiddle" width="50" height="20"></a></td>
<td width="12%" align="center"><a href="index.asp"><img border="0" src="../img/y.gif" align="absmiddle" width="50" height="20"></a></td>
<td width="13%" align="center"><a href="../new/index.asp"><img src="../img/wen.jpg" width="50" height="20" border="0" align="absmiddle"></a></td>
<td width="13%" align="center"><a href="../down/index.asp"><img src="../img/xia.jpg" width="50" height="20" border="0" align="absmiddle"></a></td>
<td width="13%" align="center"><a href="../guestbook/index.asp"><img border="0" src="../img/gb.gif" align="absmiddle" width="50" height="20"></a></td>
<td width="13%" align="center"><a href="../link/index.asp"><img border="0" src="../img/link.gif" align="absmiddle" width="50" height="20"></a></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="600" height="21">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="409" valign="top">
<% set rs=server.createobject("adodb.recordset")
if key="" then
sql="select * from music where id ORDER BY id desc"
elseif key="count" then
sql="select * from music where id ORDER BY count desc"
else
sql="select * from music where name like '%"&key&"%' or show like '%"&key&"%' or url like '%"&key&"%' or geshi like '%"&key&"%' order by id desc"
end if
rs.open sql,conn,1,1
if rs.eof and rs.bof then
on error resume next
end if
if not isempty(request("page")) then
pagecount=cint(request("page"))
else
pagecount=1
end if
rs.pagesize=20 //控制显示多少行
if pagecount>rs.pagecount or pagecount<=0 then
pagecount=1
end if
rs.AbsolutePage=pagecount %>
</td>
</tr>
<tr>
<td width="100%">
<div align="center">
<center>
<table border="0" width="580" cellspacing="0" cellpadding="0" style="border: 1 solid #67331F">
<tr>
<td width="426" valign="top">
<% set rs=server.createobject("adodb.recordset")
if key="" then
sql="select * from music where id ORDER BY id desc"
elseif key="count" then
sql="select * from music where id ORDER BY count desc"
else
sql="select * from music where name like '%"&key&"%' or show like '%"&key&"%' or url like '%"&key&"%' or geshi like '%"&key&"%' order by id desc"
end if
rs.open sql,conn,1,1
if rs.eof and rs.bof then
on error resume next
end if
if not isempty(request("page")) then
pagecount=cint(request("page"))
else
pagecount=1
end if
rs.pagesize=10 //控制显示多少行
if pagecount>rs.pagecount or pagecount<=0 then
pagecount=1
end if
rs.AbsolutePage=pagecount %>
<table border="0" cellpadding="0" cellspacing="0" width="580" >
<tr>
<td width="566" height="6" colspan="2" valign="bottom" bgcolor="#cea772">
<%
if pagecount=1 then
response.write "首页 上页 "
else
if key="" then
response.write "<a href=right.asp?page=1>首页</a> "
response.write "<a href=right.asp?page="+cstr(pagecount-1)+">上页</a> "
else response.write "<a href=right.asp?page=1&key="+key+">首页</a> "
response.write "<a href=right.asp?page="+cstr(pagecount-1)+"&key="+key+">上页</a> "
end if
end if
if rs.PageCount-pagecount<1 then
response.write "下页 尾页"
else
if key="" then
response.write "<a href=right.asp?page="+cstr(pagecount+1)+">下页</a> "
response.write "<a href=right.asp?page="+cstr(rs.PageCount)+">尾页</a>"
else
response.write "<a href=right.asp?page="+cstr(pagecount+1)+"&key="+key+">下页</a> "
response.write "<a href=right.asp?page="+cstr(rs.PageCount)+"&key="+key+">尾页</a>"
end if
end if
response.write "共:"&pagecount&"/"&rs.pagecount&"页</font>"
%>
</td></form>
</tr>
<tr >
<td width= 396 align="center">
<a href=right.asp?key=count title="列出排行榜">排行榜</a>
<a href=right.asp?key=视频 title="列出所有视频">视频</a>
<a href=right.asp?key=音频 title="列出所有音频">音频</a>
</td>
</tr>
<% do while not rs.eof
i=i+1%>
<tr>
<td width=396 height="18" align="left"><a href=index1.asp?id=<%=rs("id")%> target=play title=<%=rs("show")%>,<%=rs("geshi")%>,<%=rs("count")%>><%=rs("name")%></a></td>
<td width=168 height="18" align=right valign="bottom">
<a href=index1.asp?id=<%=rs("id")%> target=play title=<%=rs("geshi")%>><%=rs("geshi")%></a>
</td>
</tr>
<%
rs.movenext
if i>=rs.PageSize then exit do
loop
%>
</table>
</td>
</tr>
<tr>
<td width="466" align="center" bgcolor="#E4C59A">
<form method=Post name=form1 action='right.asp'>
<input type="text" name="Key">
<input type=submit name=xc value="搜索">
</form></td>
</tr>
<tr>
<td width="100%" align="center">
</td>
</tr>
</table>
</div>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="600" height="21">
<table border="0" width="100%" cellspacing="0" cellpadding="0" height="40">
<tr>
<td width="100%" align="center" height="18"> </td>
</tr>
<tr>
<td width="100%" align="center" height="1"></td>
</tr>
<tr>
<td width="100%" align="center" height="46"></td>
</tr>
</table>
</td>
</tr>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>
<%
rs.close
set rs=nothing
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -