📄 music.asp
字号:
<!--#include file="conn.asp"-->
<%
Dim action
action=trim(request.QueryString("action"))
If action="all" Then
stats="全部歌曲列表"
Else
stats="所有推荐歌曲"
End If
%>
<!--#include file="home.asp"-->
<head>
<style>body,td{font-size:12px}</style></head>
<table width="779" height="570" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td width="1" height="570" background="images/sunny01.gif"><img src="images/b.gif" width="1" height="1"></td>
<td width="186" valign="top"><table width="100%" height="25" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="25" valign="top"><img src="images/amusic_0a11.gif" width="188" height="25"></td>
</tr>
</table>
<!--#include file="inc/login.inc" -->
<table width="100%" height="25" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="32"><img src="images/amusic_0a13.gif" width="188" height="25"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="images/0394_top0.gif" width="188" height="29"></td>
</tr>
</table>
<!--#include file="inc/links.inc" -->
<table width="100%" height="23" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="23"><img src="images/0394_top1.gif" width="188" height="29"></td>
</tr>
</table>
<table width="98%" border="0" align="center" cellpadding="2" cellspacing="0">
<!--#include file="inc/list_music_hot.inc"-->
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="images/0394_top2.gif" width="188" height="29"></td>
</tr>
</table>
<table width="98%" border="0" align="center" cellpadding="2" cellspacing="0">
<!--#include file="inc/list_special_hot.inc"-->
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="images/0394_top3.gif" width="188" height="29"></td>
</tr>
</table>
<table width="95%" border="0" align="center" cellpadding="2" cellspacing="0">
<tr>
<td height="45"> <div align="center"><img src="images/WMP9series_Free.gif" width="120" height="32"></div></td>
</tr>
</table>
<table width="95%" border="0" align="center" cellpadding="2" cellspacing="0">
<tr>
<td height="45"> <div align="center"><img src="images/real.gif" width="121" height="34"></div></td>
</tr>
</table></td>
<td width="1" background="images/sunny01.gif"><img src="images/b.gif" width="1" height="1"></td>
<td width="590" valign="top"><table width="589" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="314" height="18"> <div align="center">
<!--#include file="inc/top_count.inc" -->
</div></td>
<td width="24"><img src="images/fink.gif" width="25" height="23"></td>
<td width="251">
<!-- 导航歌曲搜索 开始 -->
<table width="250" border="0" cellspacing="0" cellpadding="4" align="center" height="17">
<form action="search.asp" method="get">
<tr align="center">
<td width="71" height="2"> <input name="key_keyword" class=input onFocus="this.value=''" value="关键字" size="10" maxlength="30" ></td>
<td width="79"> <select size="1" name="key_type" class=input >
<option selected value="music">歌曲名称</option>
<option value="singer">歌手名称</option>
<option value="special">专辑名称</option>
</select></td>
<td width="42"> <input type="submit" value="搜索" class=input name="submit"></td>
<td width="42"> <input type="reset" value="清除" class=input name="submit2"></td>
</tr>
</form>
</table>
<!-- 导航歌曲搜索 结束 -->
</td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td height="29" background="images/0394_list1.gif" bgcolor="#FFFFFF"><table width="100%" height="29" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="3%"> </td>
<td width="97%" valign="bottom"><%=stats%></td>
</tr>
</table></td>
</tr>
<tr>
<td height="55" bgcolor="#FFFFFF"> <table width="579" height="132" border="0" align="right" cellpadding="0" cellspacing="0">
<tr>
<td width="1" bgcolor="#CCCCCC"><img src="images/b.gif" width="1" height="1"></td>
<td width="550" valign="top"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#FFFFFF"> <table width="98%" height="22" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="left"><a href="index.asp"><%=HOST_NAME%></a> - <%=stats%></div></td>
</tr>
</table></td>
</tr>
</table>
<TABLE width=575 height=2 border=0 align="center" cellPadding=0 cellSpacing=0 background="images/txwm_line_1.gif">
<TBODY>
<TR>
<TD height=1><img src="images/b.gif" width="1" height="1"></TD>
</TR>
</TBODY>
</TABLE>
<table width="98%" height="30" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center">
<%
Dim pagesize,curpage,Music_rs
pagesize=28 '设置每页显示 3的倍数
If Request.QueryString("page")="" or not IsNumeric(Request.QueryString("page")) Then
curpage = 1
Else
curpage = cint(Request.QueryString("page"))
End If
If action="all" Then
sql = "select ID,MusicName,Singer,hits,NClassID from [MusicList] ORDER BY ID desc"
Else
sql = "select ID,MusicName,Singer,hits,NClassID from [MusicList] where IsGood=true ORDER BY ID desc"
End If
Set Music_rs = Server.CreateObject("ADODB.Recordset")
Music_rs.open sql, conn, 1, 1
If Music_rs.eof Then
Response.Write("还没有推荐歌曲呢!~ 谢谢你的支持!~")
End If
Music_rs.pagesize = pagesize
Music_rs.absolutepage = curpage
If curpage = 1 Then
Response.Write ("首页 上一页")
Else%>
<a href='?page=1&action=<%=action%>'>首页</a> <a href='?page=<%=cint(curpage-1)%>&action=<%=action%>'>上一页</a>
<%
End If
If curpage = Music_rs.pagecount Then
Response.Write (" 下一页 尾页")
Else%>
<a href='?page=<%=cint(curpage+1)%>&action=<%=action%>'>下一页</a> <a href='?page=<%=cint(Music_rs.pagecount)%>&action=<%=action%>'>尾页</a>
<%End If%>
页次：<STRONG><%=curpage%>/<%=Music_rs.pagecount%></STRONG>页
共<b><%=Music_rs.recordcount%></b>首推荐歌曲 每页<B><%=pagesize%></B>首
</td>
</tr>
</table>
<TABLE cellSpacing=0 cellPadding=0 width=100 border=0>
<TBODY>
<TR>
<TD height=8><IMG height=8 src="img/dot.gif" width=18></TD>
</TR>
</TBODY>
</TABLE>
<table width="575" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="37" height="24"> <div align="center"><strong><font color="#FF6600">选择</font></strong></div></td>
<td width="253" height="24"> <div align="center"><strong><font color="#FF6600">歌
曲</font></strong></div></td>
<td width="107"><div align="center"><strong><font color="#FF6600">歌
手</font></strong></div></td>
<td width="37" height="24"> <div align="center"><strong><font color="#FF6600">试听</font></strong></div></td>
<td width="38" height="24"> <div align="center"><strong><font color="#FF6600">歌词</font></strong></div></td>
<td width="44" height="24"> <div align="center"><strong><font color="#FF6600">音乐盒</font></strong></div></td>
<td width="53" height="24"> <div align="center"><strong><font color="#FF6600">人气</font></strong></div></td>
</tr>
<tr>
<td colspan="7"><TABLE width=575 height=2 border=0 align="center" cellPadding=0 cellSpacing=0 background="images/txwm_line_1.gif">
<TBODY>
<TR>
<TD height=1><img src="images/b.gif" width="1" height="1"></TD>
</TR>
</TBODY>
</TABLE>
</td>
</tr>
<form name="form" onsubmit="javascript:return lbsong();" target="lbsong" action="Yxplaylist.asp">
<%
For i=1 To pagesize
If i mod 2<>0 Then
bgcolor="f7f7f7"
Else
bgcolor="ffffff"
End If
%>
<tr bgcolor="<%=bgcolor%>">
<td height="18" align="center">
<input type="checkbox" name="checked" value="<%Response.Write (Music_rs(0))%>"></td>
<td height="18" > <img src="images/d.gif" alt="" width="12" height="12">
<%Response.Write (Music_rs(1))%></td>
<td height="18" align="center"><a href="special.asp?id=<%Response.Write (Music_rs(4))%>">
<%Response.Write (Music_rs(2))%></a></td>
<td height="18" align="center"><a href="#" onclick="window.open('yxplay.asp?id=<%Response.Write(Music_rs(0))%>','','scrollbars=no,resizable=no,width=400,height=190,menubar=no,top=98,left=198')"><img src="images/0394_test.gif" alt="试 听" width="26" height="11" border=0></a></td>
<td height="18" align="center">
<%
Dim Open_MusicWord_rs
Set Open_MusicWord_rs=conn.execute("select ID from [MusicWord] where IsShow=true and MusicID="&Music_rs(0))
If Open_MusicWord_rs.eof Then
Response.Write ("<a href='#' onclick=""showword('musicword.asp?action=add&id="&Music_rs(0)&"&musicname="&Replace(Music_rs(1),"'","’")&"&singer="&Music_rs(2)&"')""><img src='images/035no.gif' alt='添加歌词' width='16' height='13' border=0></a>")
Else
Response.Write ("<a href='#' onclick=""showword('musicword.asp?action=show&id="&Music_rs(0)&"&musicname="&Replace(Music_rs(1),"'","’")&"&singer="&Music_rs(2)&"')""><img src='images/035.gif' alt='浏览歌词' width='16' height='13' border=0></a>")
End If
Open_MusicWord_rs.close
Set Open_MusicWord_rs=NOTHING%>
</td>
<td height="18" align="center"><a href="#" onclick="javascript:window.open('musicbox.asp?action=add&id=<%Response.Write(Music_rs(0))%>','blank')"><img src="images/center_img22.gif" alt="放入音乐盒" width="17" height="12" border=0></a></td>
<td height="18" align="center"><font color="#FF0000">
<%Response.Write (Music_rs(3))%></font></td>
</tr>
<tr>
<td colspan="7"> <TABLE width=100% height=2 border=0 align="center" cellPadding=0 cellSpacing=0 background="images/txwm_line_1.gif">
<TBODY><TR><TD height=2><IMG height=2 src="img/dot.gif" width=10></TD></TR></TBODY></TABLE>
</td>
</tr>
<%
Music_rs.movenext
If Music_rs.eof Then Exit For
Next
%>
</table>
<div align="center">
<div align="center"><br>
<input type="button" name="chkall" value="" onclick="CheckAll(this.form)" title="选择显示的所有歌曲" style="width: 62px; height: 23px; background-image: url('images/ly1.gif'); border-style: none; border-width: medium">
<input type="button" name="chkOthers" value="" onclick="CheckOthers(this.form)" title="反向选择歌曲" style="width: 62px; height: 23px; background-image: url('images/ly2.gif'); border-style: none; border-width: medium">
<input type="submit" name="player" value=" " title="请先选择你想听的歌曲后再点击播放" style="width: 62px; height: 23px; background-image: url('images/ly3.gif'); border-style: none; border-width: medium">
</div>
<table width="98%" height="30" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center">
<% If curpage = 1 Then
Response.Write ("首页 上一页")
Else%>
<a href='?page=1&action=<%=action%>'>首页</a> <a href='?page=<%=cint(curpage-1)%>&action=<%=action%>'>上一页</a>
<%
End If
If curpage = Music_rs.pagecount Then
Response.Write (" 下一页 尾页")
Else%>
<a href='?page=<%=cint(curpage+1)%>&action=<%=action%>'>下一页</a> <a href='?page=<%=cint(Music_rs.pagecount)%>&action=<%=action%>'>尾页</a>
<%End If%>
页次：<STRONG><%=curpage%>/<%=Music_rs.pagecount%></STRONG>页
共<b><%=Music_rs.recordcount%></b>首推荐歌曲 每页<B><%=pagesize%></B>首</td>
<%
Music_rs.close
Set Music_rs=NOTHING
%>
</tr>
</table> </td>
<td width="1" bgcolor="#CCCCCC"><img src="images/b.gif" width="1" height="1"></td>
</tr>
</table></tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="images/0394log.gif" width="589" height="30"></td>
</tr>
</table>
</td>
<td width="1" background="images/sunny01.gif"><img src="images/b.gif" width="1" height="1"></td>
</tr>
</table>
<!--#include file="box.asp"--><%CloseDatabase%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -