📄 search.asp
字号:
<%PageName="search"%>
<%on error resume next%>
<!--#include file="conn.asp"-->
<!--#include file="functionuser.asp"-->
<!--#include file="star.INC"-->
<!--#include file="md5.asp"-->
<!--#include file="bzmtvconst.asp"-->
<meta name="keywords" content="音乐,音乐网,音乐网站,音乐下载,在线音乐,免费音乐">
<meta name="description" content="音乐,音乐网,音乐网站,音乐下载,在线音乐,免费音乐">
<title><%=webname%>-搜索引挚-音乐,音乐网,音乐网站,音乐下载,在线音乐,免费音乐</title>
<LINK href="../images/index.css" rel=stylesheet type=text/css>
<script src=../js/header.js></script>
<script src=../js/js.js></script>
<script language="javascript" src="../js/altjs.JS"></script>
<body topmargin="0" leftmargin="0" bgcolor="#FFFFFF">
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="770" height="1">
<tr>
<td width="133" height="1" bgcolor="#F9F9F9" valign="top">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="200">
<tr>
<td width="100%"> </td>
</tr>
</table>
</td>
<td width="637" height="1" valign="top">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td width="100%" bgcolor="#FFFFFF">
<%
keyword=trim(request("keyword"))
keyword=replace(keyword,"'","''")
stype=request("stype")
if keyword="" then
errmsg=errmsg+"查找字符不能为空，请重输入查找的信息<a href=""javascript:history.go(-1)"">返回重查</a>"
call error()
Response.End
end if
%>
<%
Set rs= Server.CreateObject("ADODB.Recordset")
if stype="Singer" then
sql="select * from Nclass"
elseif stype="Special" then
sql="select * from Special"
else
end if
rs.open sql,conn,1,1
if stype="Singer" then
rs.filter = "Nclass Like '%"& keyword &"%'"
end if
if stype="Special" then
rs.filter = "Name Like '%"& keyword &"%'"
end if
if not isempty(request.QueryString("page")) then
currentPage=cint(request.QueryString("page"))
else
currentPage=1
end if
if rs.eof and rs.bof then
if stype="Singer" then
response.write "<p align='center'><br><br>Sorry, 未 找 到 你 想 要 的 歌 手<br><br><a href=""javascript:history.go(-1)"">点 此 返 回</a><br><br></p>"
elseif stype="Special" then
response.write "<p align='center'><br><br>Sorry, 未 找 到 你 想 要 的 MTV<br><br><a href=""javascript:history.go(-1)"">点 此 返 回</a><br><br></p>"
end if
else
totalPut=rs.recordcount
MaxPerPage=30
PageUrl="Search.asp"
if currentpage<1 then currentpage=1
if (currentpage-1)*MaxPerPage>totalput then
if (totalPut mod MaxPerPage)=0 then
currentpage= totalPut \ MaxPerPage
else
currentpage= totalPut \ MaxPerPage + 1
end if
end if
if currentPage=1 then
showpage totalput,MaxPerPage,PageUrl
showContent
showpage totalput,MaxPerPage,PageUrl
search
else
if (currentPage-1)*MaxPerPage<totalPut then
rs.move (currentPage-1)*MaxPerPage
dim bookmark
bookmark=rs.bookmark
showpage totalput,MaxPerPage,PageUrl
showContent
showpage totalput,MaxPerPage,PageUrl
search
else
currentPage=1
showpage totalput,MaxPerPage,PageUrl
showContent
showpage totalput,MaxPerPage,PageUrl
search
end if
end if
rs.close
end if
sub showContent
i=0
%>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td>
<div align="center">
<!-----------------------搜索歌手----------------------------->
<%if stype="Singer" then%>
<table border="1" width="547" cellspacing="0" cellpadding="3" class="TableLine" bordercolor="#CCCCCC" style="border-collapse: collapse">
<tr>
<td width="369" height="22" align="center" background="bzmtv/bgleft.gif" bgcolor="#F9F9F9">
歌手</td>
<td width="76" height="22" align="center" background="bzmtv/bgleft.gif" bgcolor="#F9F9F9">
MTV数量</td>
</tr>
<%
Set Trs= Server.CreateObject("ADODB.Recordset")
do while not rs.eof
i=i+1
Tsql="SELECT * FROM Special where Nclassid="+cstr(rs("Nclassid"))
Trs.open Tsql,conn,1,1
TotalSNum=Trs.recordcount
Trs.close
Tsql="SELECT * FROM Nclass where Nclassid="+cstr(rs("Nclassid"))
Trs.open Tsql,conn,1,1
Trs.close
%>
<form method="POST" action="bzmtv-35.asp?act=rename&NClassid=<%=rs("NClassid")%>" id="Nform<%=k%>" name="Nform<%=k%>">
<tr>
<td width="369"><%=i%>.
<a href="../Html/Mtv_<%=rs("NClassid")%>.htm"><%=rs("Nclass")%></a></td>
<td align="center" width="76"><%=TotalSNum%></td>
</tr>
</form>
<%
if i>=MaxPerPage then exit do
rs.movenext
loop
set Trs=nothing
%>
</table>
<!-----------------------搜索专辑----------------------------->
<%elseif stype="Special" then%>
<table border="1" width="96%" cellspacing="0" cellpadding="3" class="TableLine" bordercolor="#CCCCCC" style="border-collapse: collapse">
<tr>
<td width="38%" height="22" align="center" background="bzmtv/bgleft.gif" bgcolor="#F9F9F9">
专辑名称</td>
<td width="7%" height="22" align="center" background="bzmtv/bgleft.gif" bgcolor="#F9F9F9">
所属歌手</td>
<td width="4%" height="22" align="center" background="bzmtv/bgleft.gif" bgcolor="#F9F9F9">
收藏</td>
</tr>
<%
Set Trs= Server.CreateObject("ADODB.Recordset")
do while not rs.eof
i=i+1
Tsql="SELECT * FROM Special where Specialid="+cstr(rs("Specialid"))
Trs.open Tsql,conn,1,1
Trs.close
%>
<tr>
<td width="38%"><%=i%>.<a href="../Html/MtvPlay_<%=rs("Specialid")%>.htm"><%=rs("Name")%></a></td>
<td width="7%" align="center">
<a href="../Html/Mtv_<%=rs("NClassid")%>.htm"><%=rs("Nclass")%></a> </td>
<td width="4%" align="center">
<a href="#" onClick="window.open('albumsc1.asp?action=add&id=<%=rs("specialid")%>','bzmtv','scrollbars=no,resizable=no,width=316,height=450,menubar=no,top=168,left=168')">
<img border="0" src="../images/shoucang.gif"></a></td>
</tr>
<%
if i>=MaxPerPage then exit do
rs.movenext
loop
Set Trs=nothing
%>
</table>
<%
else
end if
%> <%
end sub
function showpage(totalnumber,maxperpage,filename)
dim n
if totalnumber mod maxperpage=0 then
n= totalnumber \ maxperpage
else
n= totalnumber \ maxperpage+1
end if
%>
<div align="center">
<center>
<table border="0" width="100%" cellpadding="6" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" height="1">
<tr>
<form method="Post" action="<%=filename%>?classid=<%=classid%>&Nclassid=<%=Nclassid%>">
<td bgcolor="#ffffff" align="center" height="1">
<%=Nclass%><span style="font-size: 10.8pt"><font color="#FF9933"><b>
共找到<%=totalnumber%>个结果 分<%=n%>页显示 当前第<%=CurrentPage%>页
<a href="<%=filename%>?page=1&keyword=<%=keyword%>&stype=<%=stype%>">
首页</a> <%if CurrentPage<2 then%>上一页 <%else%>
</b></font><b>
<a href="<%=filename%>?page=<%=CurrentPage-1%>&keyword=<%=keyword%>&stype=<%=stype%>">
<font color="#FF9933">上一页</font></a><font color="#FF9933">
<%
end if
if n-currentpage<1 then
%> 下一页 末页 <%else%> </font><a href="<%=filename%>?page=<%=CurrentPage+1%>&keyword=<%=keyword%>&stype=<%=stype%>">
<font color="#FF9933">下一页</font></a></b><font color="#FF9933"><b>
<a href="<%=filename%>?page=<%=n%>&keyword=<%=keyword%>&stype=<%=stype%>">
末页</a> <%end if%> </b></font></span></td>
</form>
</tr>
</table>
</center>
</div>
<%
end function
function Search
%></td>
</tr>
</table>
</td>
</tr>
</table>
</center>
</div>
<%end function%><%
set rs=nothing
conn.close
set conn=nothing
%> </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</center>
</div>
</div>
</td>
</tr>
</table>
</td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<script src=../js/copy.js></script>
</center>
</div>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -