mlist.asp
上传用户:qyswxdl
上传日期:2013-06-01
资源大小:1373k
文件大小:20k
源码类别:

家庭/个人应用

开发平台:

ASP/ASPX

  1. <!--#include file=articleconn.asp-->
  2. <%
  3.    MaxPerPage=6
  4.    dim totalPut   
  5.    dim CurrentPage
  6.    dim TotalPages
  7.    dim i
  8.    dim ty
  9.    typeid=Replace(request("typeid"), "'", "''")
  10.     if not isempty(request("page")) then
  11.       currentPage=cint(request("page"))
  12.    else
  13.       currentPage=1
  14.    end if
  15.       dim rstype
  16.    dim typesql
  17.    dim types
  18.    if not isEmpty(Replace(request("typeid"), "'", "''")) then
  19. typeid=Replace(request("typeid"), "'", "''")
  20.    else
  21. typeid="所有影片"
  22.    end if
  23. %>
  24. <HTML><HEAD>
  25. <meta http-equiv="Content-Language" content="en-gb">
  26. <%set rs=conn.execute("select * from [home]")%>
  27. <TITLE>万众电影</TITLE>
  28. <META http-equiv=Content-Type content="text/html; charset=gb2312">
  29. <LINK href="img/style.css" type=text/css rel=stylesheet>
  30. <META content="MSHTML 6.00.2800.1505" name=GENERATOR>
  31. <script language="JavaScript">
  32. <!--
  33. function checkinput()
  34. {
  35. if (document.search.keyword.value=="")
  36.  {
  37. alert("请输入想查询的内容!");
  38. document.search.keyword.focus();
  39. return false;
  40.  }
  41.  return true;
  42. }
  43. -->
  44. </script>
  45. <script language="javascript">kstatus();function kstatus(){self.status="<%=rs("Description")%>";setTimeout("kstatus()",0);}</script></HEAD>
  46. <BODY >
  47. <!--#include file=top.asp-->
  48. <TABLE cellSpacing=0 cellPadding=0 width=993 border=0>
  49. <TBODY>
  50. <TR>
  51. <TD bgColor=#7d7d7d height=1></TD></TR></TBODY></TABLE>
  52. <TABLE cellSpacing=0 cellPadding=0 width=993 border=0>
  53. <TBODY>
  54. <TR>
  55. <TD bgColor=#ffffff height=2></TD></TR></TBODY></TABLE>
  56. <TABLE cellSpacing=0 cellPadding=0 width=993 bgColor=#ffffff border=0>
  57. <TBODY>
  58. <TR>
  59. <TD vAlign=top align=middle>
  60. <TABLE cellSpacing=0 cellPadding=0 width=977 border=0>
  61. <TBODY>
  62. <TR>
  63. <TD background=img/2.gif height=8></TD></TR></TBODY></TABLE>
  64. <TABLE cellSpacing=1 cellPadding=0 width=977 bgColor=#b7b7b7 border=0>
  65. <TBODY>
  66. <TR>
  67. <TD bgColor=#ffffff>
  68. <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
  69. <TBODY>
  70. <TR>
  71. <TD>
  72. <TABLE height=94 cellSpacing=0 cellPadding=1 width="100%" border=0>
  73. <TBODY>
  74. <TR>
  75. <TD align=right width=189><IMG height=90 src="img/channel_title_movie.gif" width=188></TD>
  76. <TD>
  77. <OBJECT codeBase=http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0 height=90 width=780 classid=clsid:D27CDB6E-AE6D-11cf-96B8-444553540000>
  78. <PARAM NAME="movie" VALUE="img/banner_780x90.swf">
  79. <PARAM NAME="quality" VALUE="High">
  80.  
  81. <embed src="img/banner_780x90.swf" quality="High" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="780" height="90"></embed></OBJECT></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
  82. <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
  83. <TBODY>
  84. <TR>
  85. <TD background=img/1.jpg height=12></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
  86. <TABLE cellSpacing=0 cellPadding=0 width=977 border=0>
  87. <TBODY>
  88. <TR>
  89. <TD height=2></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
  90. <TABLE cellSpacing=0 cellPadding=0 width=993 bgColor=#ffffff border=0>
  91. <TBODY>
  92. <TR>
  93. <TD vAlign=top align=middle height=173>
  94. <TABLE height=36 cellSpacing=0 cellPadding=0 width=977 border=0>
  95. <TBODY>
  96. <TR>
  97. <TD vAlign=top width=191 height=25>
  98. <!--#include file=left.asp--></TD>
  99. <TD width=2></TD>
  100. <TD width=1 bgColor=#c6c6c6></TD>
  101. <TD vAlign=top width=783>
  102. <TABLE cellSpacing=0 cellPadding=0 width=783 border=0>
  103. <TBODY>
  104. <TR>
  105. <TD><A href="#"><IMG height=60 src="img/dl_01.jpg" width=179 border=0></A></TD>
  106. <TD><A href="#"><IMG height=60 src="img/dl_02.jpg" width=171 border=0></A></TD>
  107. <TD><A href="#"><IMG height=60 src="img/dl_03.jpg" width=168 border=0></A></TD>
  108. <TD><A href="#"><IMG height=60 src="img/dl_04.jpg" width=160 border=0></A></TD>
  109. <TD><A href="#"><IMG height=60 src="img/dl_05.jpg" width=105 border=0></A></TD></TR></TBODY></TABLE>
  110. <TABLE height=40 cellSpacing=0 cellPadding=0 width="100%" background=img/5.gif border=0>
  111. <TBODY>
  112. <TR vAlign=top>
  113. <TD width=116><img border="0" src="img/18.gif" width="116" height="32"></TD>
  114. <TD align=right><IMG height=31 src="img/7.gif" width=83></TD></TR></TBODY></TABLE>
  115. <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0><TBODY><TR align=right>
  116. <TD>
  117. <TABLE height=240 cellSpacing=0 cellPadding=0 width="100%" border=0 id="table1"><TBODY>
  118. <TR align=right>
  119. <TD>
  120. <table width="126" border="0" cellpadding="0" cellspacing="0">
  121. <tr><%
  122. sql="select articleid,domurl,title,hits,content from learning where firstbest=1 order by articleid desc"
  123. set rs=server.createobject("adodb.recordset")
  124. rs.open sql,conn,1,1
  125. b=0
  126. row_count=1
  127.                     %> <%
  128.           do while not rs.eof
  129.           b=b+1%>
  130. <td><div align="center">
  131. <table width="126" border="0" cellspacing="0" cellpadding="0">
  132. <tr height="119" align="center">
  133. <td width="3"><!--Blank--></td>
  134. <td width="123" background="images/commend_pic.gif"><table border="1" width="100%" cellpadding="0" style="border-collapse: collapse" bordercolor="#939393" id="table5">
  135. <tr>
  136. <td><table border="0" cellspacing="4" width="100%" cellpadding="0" id="table5">
  137. <tr>
  138. <td><a href="movie.asp?id=<%=rs("articleid")%>" target="_blank">
  139. <img border="0" src="<%if rs("domurl")="" then%>img/w.gif<%else%><%=rs("domurl")%><%end if%>" width="137" height="191"></a></td>
  140. </tr>
  141. </table></td>
  142. </tr>
  143. </table></td>
  144. </tr>
  145. <tr height="21" align="middle">
  146. <td width="5"><img src height=1 width=9></td>
  147. <td background="img/8.gif"><table border="0" cellspacing="0" width="90%" cellpadding="0">
  148. <tr>
  149. <td height="22" width=109 align="center">
  150. <% if row_count mod 1 =0 then%>
  151.                               <%content=rs("title")
  152.                             if len(content)>11 then content=left(content,11)&"?-"
  153.                           response.write content
  154.                             %> 
  155. </td>
  156. <td>
  157. <p align="center"><a href="movie.asp?id=<%=rs("articleid")%>" target="_blank">
  158. <img src="img/sort_play1.gif" width="18" height="18" border="0" alt="播放"></a></td>
  159. </tr>
  160. </table></td>
  161. </tr>
  162. </table>
  163. </div></td>
  164.   <%end if%>
  165.                   <%row_count=row_count+1
  166.       if b>=5 then exit do
  167.       rs.movenext
  168.       loop
  169.       rs.close
  170.           set rs=nothing
  171.               %>
  172. </tr>
  173. </table>
  174. </TD>
  175. </TR></TBODY></TABLE>
  176. </TD>
  177. </TR></TBODY></TABLE>
  178. <TABLE height=40 cellSpacing=0 cellPadding=0 width="100%" background=img/5.gif border=0>
  179. <TBODY>
  180. <TR vAlign=top>
  181. <TD width=146><img border="0" src="img/11.gif" width="116" height="32"></TD>
  182. <TD align=right>
  183. <table border="0" cellspacing="0" width="100%" cellpadding="0" id="table6">
  184. <tr>
  185. <td height="9"><img src height=9 width=1></td>
  186. </tr>
  187. <tr>
  188. <td><!--webbot
  189. bot="HTMLMarkup" startspan --><font color="#000000"><b><span class="样式3" lang="zh-cn">本站共收录有电影:</span>
  190.                         <%        
  191. function gettipnum1()
  192. dim tmprs1
  193. tmprs1=conn.execute("Select Count(articleid) from learning")
  194. gettipnum1=tmprs1(0)
  195. set tmprs1=nothing
  196. if isnull(gettipnum1) then gettipnum1=0
  197. end function
  198.                                 %><font color="#FF0000"><%=gettipnum1()%></font><span class="样式3">部</span>&nbsp; <span class="样式3">今天更新:</span><span lang="zh-cn">
  199.                               <%
  200.                              function todays()
  201. dim tmprs
  202. tmprs=conn.execute("Select count(articleid) from learning Where year(dateandtime)=year(date()) and month(dateandtime)=month(date()) and day(dateandtime)=day(date())")
  203. todays=tmprs(0)
  204. set tmprs=nothing
  205. if isnull(todays) then todays=0
  206. end function%><font color="#FF0000"><%=todays()%></font></b><span class="样式3">部</span></span>
  207.                                   <!--webbot bot="HTMLMarkup" endspan i-checksum="62826" -->
  208. </td>
  209. </tr>
  210. </table>
  211. </TD>
  212. <TD align=right width="158"><IMG height=31 src="img/7.gif" width=83></TD></TR></TBODY></TABLE>
  213. <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0><TBODY>
  214. <TR>
  215.     <TD vAlign=top align=middle width=8>
  216.       <table width="591" border="0" align="center" cellpadding="0" cellspacing="0">
  217.         <tr>
  218.           <td colspan="2"><%
  219. dim sql
  220. dim rs
  221. if typeid="所有影片" then
  222.     sql="select * from learning order by articleid desc"
  223. else
  224.    sql="select * from learning where typeid='"&typeid&"' order by articleid desc"
  225. end if   
  226. set rs=server.createobject("adodb.recordset")
  227. rs.open sql,conn,1,1
  228.  if rs.eof and rs.bof then
  229.        response.write "<script>alert('该类还没有任何影片,要想看的话请联系管理员!')</Script><script Language=Javascript>location.href = '';</script>"
  230.        response.end
  231.    else
  232.   totalPut=rs.recordcount
  233.       totalPut=rs.recordcount
  234.       if currentpage<1 then
  235.           currentpage=1
  236.       end if
  237.       if (currentpage-1)*MaxPerPage>totalput then
  238.    if (totalPut mod MaxPerPage)=0 then
  239.      currentpage= totalPut  MaxPerPage
  240.    else
  241.       currentpage= totalPut  MaxPerPage + 1
  242.    end if
  243.       end if
  244.        if currentPage=1 then
  245.            showpage totalput,MaxPerPage,"mlist.asp"
  246.             showContent
  247.             showpage totalput,MaxPerPage,"mlist.asp"
  248.        else
  249.           if (currentPage-1)*MaxPerPage<totalPut then
  250.             rs.move  (currentPage-1)*MaxPerPage
  251.             dim bookmark
  252.             bookmark=rs.bookmark
  253.            showpage totalput,MaxPerPage,"mlist.asp"
  254.             showContent
  255.             showpage totalput,MaxPerPage,"mlist.asp"
  256.         else
  257.         currentPage=1
  258.           showpage totalput,MaxPerPage,"mlist.asp"
  259.            showContent
  260.            showpage1 totalput,MaxPerPage,"mlist.asp"
  261.       end if
  262.    end if
  263.    end if
  264.    sub showContent
  265. 'Split("Sun,Mon,Tue,Wed,Thu,Fri,Sat",",")
  266. BgImg1 = "06,04,08,09"
  267. BgImg2 = "12,11,14,15"
  268.        dim i
  269.    i=0
  270.                     %>
  271.             <%i=0
  272.           do while not rs.eof
  273. If i mod 4 = 0 Then MyBgImg = BgImg1 Else MyBgImg = BgImg2
  274. MyBgImg = Split(MyBgImg,",")
  275. %></td>
  276.         </tr>
  277.         <tr>
  278.           <td valign="top">
  279.             
  280.             <table border="0" cellspacing="3" width="100%" cellpadding="0" id="table8">
  281. <tr>
  282. <td>
  283. <table width="385" height="100%" border="0" cellspacing="1" cellpadding="5" bgcolor="#DBDBDB">
  284.               <tr>
  285.                 <td bgcolor="#ffffff" width="110"><a target="_blank" title="影片名称:<%=rs("title")%>
  286. 主演:<%content=rs("name")
  287.                           if len(content)>20 then content=left(content,20)&"…"
  288.                           response.write content
  289.                             %>
  290. 上传时间:<%=rs("dateandtime")%>
  291. 观看次数:<%=rs("hits")%>次
  292. " href="movie.asp?id=<%=rs("articleid")%>"><img border="0" height="152" src="<%if rs("domurl")="" then%>img/w.gif<%else%><%=rs("domurl")%><%end if%>" width="110"></a></td>
  293.                 <td bgcolor="#ffffff" valign="top">
  294.                   <table width="100%" height="100%" border="0" cellspacing="0" cellpadding="2">
  295.                     <tr>
  296.                       <td align="center" bgcolor="#E9E9E9"><span class="style2"></span></td>
  297.                       <td align="center" bgcolor="#E9E9E9"><div align="left"><span class="style2"> <strong>
  298.                         <span class="3dfont2"><a target="_blank" title="影片名称:<%=rs("title")%>
  299. 主演:<%content=rs("name")
  300.                           if len(content)>8 then content=left(content,8)&"?-"
  301.                           response.write content
  302.                             %>
  303. 上传时间:<%=rs("dateandtime")%>
  304. 观看次数:<%=rs("hits")%>次
  305. " href="movie.asp?id=<%=rs("articleid")%>">
  306.                         <%content=rs("title")
  307.                           if len(content)>13 then content=left(content,13)&""
  308.                           response.write content
  309.                             %>
  310.                         </a></span>                      </strong></a></span></div></td>
  311.                     </tr>
  312.                     <tr>
  313.                       <td colspan="2">类别: <%=rs("typeid")%></td>
  314.                     </tr>
  315.                     <tr>
  316.                       <td colspan="2">主演: 
  317.                         <%content=rs("name")
  318.                           if len(content)>20 then content=left(content,10)&"…"
  319.                           response.write content
  320.                             %></td>
  321.                     </tr>
  322.                     <tr>
  323.                       <td colspan="2">级别:
  324.                         <% if rs("canlook")=1 then%>  
  325.  普通电影  
  326.                     <%elseif rs("canlook")=3 then%>
  327.                     黄金电影   
  328.                     <%elseif rs("canlook")=0 then%>
  329.                     免费电影  
  330.                     <%end if%></td>
  331.                     </tr>
  332.                     <tr>
  333.                       <td colspan="2">观看:<%=rs("hits")%>次</td>
  334.                     </tr>
  335.                     <tr>
  336.                       <td width="10%" align="center"> </td>
  337.                       <td width="90%" align="center"><div align="left">
  338. <table border="0" cellspacing="5" cellpadding="0" id="table9">
  339. <tr>
  340. <td><a href="movie.asp?id=<%=rs("articleid")%>" target="_blank"><img src="img/sort_play.gif" border="0"></a></td>
  341. <td><a href="movie.asp?id=<%=rs("articleid")%>" target="_blank"><img src="img/sort_down.gif" width="60" height="18" border="0"></a></td>
  342. <td><img src="img/sort_sou.gif" border="0"></td>
  343. </tr>
  344. </table>
  345. </div></td>
  346.                     </tr>
  347.                 </table></td>
  348.             </table></td>
  349. </tr>
  350. </table>
  351.             
  352.             <%rs.movenext%></td>
  353.           <td><% If not rs.eof Then %>
  354.               <table border="0" width="100%">
  355. <tr>
  356. <td>
  357. <table width="385" height="100%" border="0" cellspacing="1" cellpadding="5" bgcolor="#DBDBDB">
  358.                 <tr>
  359.                   <td bgcolor="#ffffff" width="110"><a target="_blank" title="影片名称:<%=rs("title")%>
  360. 主演:<%content=rs("name")
  361.                           if len(content)>20 then content=left(content,20)&"…"
  362.                           response.write content
  363.                             %>
  364. 上传时间:<%=rs("dateandtime")%>
  365. 观看次数:<%=rs("hits")%>次
  366. " href="movie.asp?id=<%=rs("articleid")%>"><img border="0" height="152" src="<%if rs("domurl")="" then%>img/w.gif<%else%><%=rs("domurl")%><%end if%>" width="110"></a></td>
  367.                   <td bgcolor="#ffffff" valign="top">
  368.                     <table width="100%" height="100%" border="0" cellspacing="0" cellpadding="2">
  369.                       <tr>
  370.                         <td align="center" bgcolor="#E9E9E9"><span class="style2"></span></td>
  371.                         <td align="center" bgcolor="#E9E9E9"><div align="left"><span class="style2"> <strong> <span class="3dfont2"></span></strong></a><strong><span class="3dfont2"><a target="_blank" title="影片名称:<%=rs("title")%>
  372. 主演:<%content=rs("name")
  373.                           if len(content)>8 then content=left(content,8)&"?-"
  374.                           response.write content
  375.                             %>
  376. 上传时间:<%=rs("dateandtime")%>
  377. 观看次数:<%=rs("hits")%>次
  378. " href="movie.asp?id=<%=rs("articleid")%>">
  379.                             <%content=rs("title")
  380.                           if len(content)>13 then content=left(content,13)&""
  381.                           response.write content
  382.                             %>
  383.                         </a></span> </strong></span></div></td>
  384.                       </tr>
  385.                       <tr>
  386.                         <td colspan="2">类别: <%=rs("typeid")%></td>
  387.                       </tr>
  388.                       <tr>
  389.                         <td colspan="2">主演:
  390.                             <%content=rs("name")
  391.                           if len(content)>20 then content=left(content,10)&"…"
  392.                           response.write content
  393.                             %></td>
  394.                       </tr>
  395.                       <tr>
  396.                         <td colspan="2">级别:
  397.                             <% if rs("canlook")=1 then%>
  398.             普通电影
  399.             <%elseif rs("canlook")=3 then%>
  400.             黄金电影
  401.             <%elseif rs("canlook")=0 then%>
  402.             免费电影
  403.             <%end if%></td>
  404.                       </tr>
  405.                       <tr>
  406.                         <td colspan="2">观看:<%=rs("hits")%>次</td>
  407.                       </tr>
  408.                       <tr>
  409.                         <td width="10%" align="center"> </td>
  410.                         <td width="90%" align="center"><div align="left"><div align="left">
  411. <table border="0" cellspacing="5" cellpadding="0" id="table10">
  412. <tr>
  413. <td><a href="movie.asp?id=<%=rs("articleid")%>" target="_blank"><img src="img/sort_play.gif" border="0"></a></td>
  414. <td><a href="movie.asp?id=<%=rs("articleid")%>" target="_blank"><img src="img/sort_down.gif" width="60" height="18" border="0"></a></td>
  415. <td><img src="img/sort_sou.gif" border="0"></td>
  416. </tr>
  417. </table>
  418. </div></div></td>
  419.                       </tr>
  420.                   </table></td>
  421.               </table></td>
  422. </tr>
  423. </table>
  424.               <%rs.movenext%>
  425.           </td>
  426.         </tr>
  427.         <tr>
  428.           <% End If %>
  429.         </tr>
  430.         <tr>
  431.           <td colspan="2">
  432.             <% i=i+2
  433.       if i>=MaxPerPage then exit do
  434.    loop
  435.               %>
  436.           </td>
  437.         </tr>
  438.       </table>
  439.       <%
  440. end sub 
  441. function showpage(totalnumber,maxperpage,filename)
  442. dim n
  443. if totalnumber mod maxperpage=0 then
  444. n= totalnumber  maxperpage
  445. else
  446. n= totalnumber  maxperpage+1
  447. end if
  448. %>
  449.       <table border="0" cellspacing="0" height="25" width="659" background="images/top-bg3.gif">
  450.         <form method=Post action="<%=filename%>?typeid=<%=typeid%>">
  451.           <tr>
  452.             <td height="25"> &nbsp;&nbsp;
  453.             <font color="000000" class="fontshadow">〓 <%=typeid%> 〓 &nbsp;&nbsp;共有<font color="ff0000"><b><%=totalnumber%></b></font>部&nbsp;&nbsp;&nbsp;当前:第<font color="ff0000"><strong><%=CurrentPage%></strong></font>页/共<font color="ff0000"><strong><%=n%></strong></font>页
  454.             <td><div align="right">
  455.                 <%if CurrentPage<2 then%>
  456.                 <font color="888888">首页&nbsp;上一页&nbsp;&nbsp;&nbsp;
  457.                 <%else%>
  458.                 <a class=left href="<%=filename%>?typeid=<%=typeid%>&page=1&"><font color="000000">首页</font></a><font color="000000">&nbsp; <a class=left href="<%=filename%>?typeid=<%=typeid%>&page=<%=CurrentPage-1%>"><font color="000000">上一页</font></a><font color="000000">&nbsp;&nbsp;&nbsp;
  459.                 <%
  460. end if
  461. if n-currentpage<1 then
  462. %>
  463.                 <font color="888888">下一页&nbsp;尾页&nbsp;&nbsp;&nbsp;
  464.                 <%else%>
  465.                 <a class=left href="<%=filename%>?typeid=<%=typeid%>&page=<%=(CurrentPage+1)%>"><font color="000000">下一页</font></a><font color="000000">&nbsp; <a class=left href="<%=filename%>?typeid=<%=typeid%>&page=<%=n%>"><font color="000000">尾页</font></a><font color="000000">&nbsp;
  466.                 <%end if%>
  467.               </font></font></font></font></font></font></div>
  468.             <font color="888888"><font color="000000"><font color="000000"><font color="888888"><font color="000000"><font color="000000">
  469.             <td align="center"><select name="page" style="color:#000000;font-size: 9pt" onchange="javascript:submit()">
  470.                 <%for i = 1 to n%>
  471.                 <option value="<%=i%>" <%if cint(CurrentPage)=cint(i) then%> selected <%end if%>>第<%=i%>页</option>
  472.                 <%next%>
  473.             </select></td>
  474.           </font></font></font></font></font></font></font></tr>
  475.         </form>
  476.       </table>
  477.       <% 
  478. end function
  479. %>
  480.       <%
  481. sub gotopage
  482. end sub
  483. %>
  484. </TABLE>
  485. </td>
  486. </tr>
  487. </table>
  488. </td>
  489. </TR></TBODY></TABLE>
  490. </TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
  491. <!--#include file=bottom.asp-->
  492. </BODY></HTML>