?? adminflash.asp
字號:
<!-- #include file="conn.asp" --><!-- #include file="se.asp" -->
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="7thcss.css" rel=stylesheet>
</head>
<body background=images/zhbg.gif>
<table border="1" width="80%" cellpadding="1" cellspacing="0" bordercolordark="#FFFFFF" bordercolorlight="#00215a" align="center">
<tr>
<td width="45%" height="25" background="images/iebg.gif"><b> <font color="#FFFFFF">
網站名稱 </font></b></td>
<td width="11%" height="25" align="center" background="images/iebg.gif"><b><font color="#FFFFFF">設為推薦</font></b></td>
<td width="10%" height="25" align="center" background="images/iebg.gif"><b><font color="#FFFFFF">修改</font></b></td>
<td width="9%" height="25" align="center" background="images/iebg.gif"><b><font color="#FFFFFF">人氣</font></b>
</td>
<td width="16%" height="25" align="center" background="images/iebg.gif"><b><font color="#FFFFFF">添加時間</font></b></td>
<td width="9%" height="25" align="center" background="images/iebg.gif">刪除</td>
</tr>
<%
Set rs=Server.CreateObject("ADODB.RecordSet")
'判斷classid開始
classid=request("classid")
If classid <> "" then
classid = cint(classid)
if err.number <> 0 then
err.clear
classid = 1
end if
if classid < 1 then
classid = 1
end if
else
classid = 1
End if
'判斷classid結束
if Request("classid")<>"" then
sql="Select * from music where class=" & classid & "and isview=1 order by id Desc"
else
sql="Select * from music where isview=1 order by id Desc"
end if
rs.open sql,conn,1,1
rs.pagesize=20 '每頁顯示數目
num=rs.recordcount
pagenum=rs.pagecount
page=request("page")
if rs.eof and rs.bof then
response.Write("此分類沒有網站")
else
'判斷頁碼開始
If page <> "" then
page = cint(page)
if err.number <> 0 then
err.clear
page = 1
end if
if page < 1 then
page = 1
end if
else
page = 1
End if
if page*rs.pagesize > num and not((page-1)*rs.pagesize < num)then
page=1
end if
'判斷頁碼結束
rs.absolutepage = page 'absolutepage：設置指針指向某頁開頭
if page<>pagenum then
for i=1 to rs.pagesize
%>
<tr>
<td bordercolorlight="#00215a" align=left width="45%"><img src=images/046.gif>
<a href="<%=rs("address")%>" target="_blank"><b><%=rs("name")%></b></a>
<%if rs("isgood")=true then%>
<font color="#FF0000">薦
<%end if%>
</font></td>
<td bordercolorlight="#00215a" align=center width="11%"><a href="add2.asp?num=<%=rs("num")%>">推薦</a></td>
<td align="center" width="10%"><a href="edit.asp?id=<%=rs("id")%>">修改</a></td>
<td bordercolorlight="#00215a" align=center width="9%"><b><%=rs("d")%></b>
</td>
<td bordercolorlight="#00215a" align=center width="16%">[<%=rs("time")%>]</td>
<td bordercolorlight="#00215a" align=center width="9%"><a href="dell.asp?num=<%=rs("num")%>">刪除</a></td>
</tr><%
rs.movenext
next
else
for i=1 to num-(page-1)*rs.pagesize
%>
<tr>
<td bordercolorlight="#00215a" align=left width="45%"><img src=images/046.gif>
<a href="<%=rs("address")%>" target="_blank" ><b><%=rs("name")%></b></a>
<%if rs("isgood")=true then%>
<font color="#FF0000">薦
<%end if%>
</font></td>
<td bordercolorlight="#00215a" align=center width="11%"><a href="add2.asp?num=<%=rs("num")%>">推薦</a></td>
<td align="center" width="10%"><a href="edit.asp?id=<%=rs("id")%>">修改</a></td>
<td bordercolorlight="#00215a" align=center width="9%"><b><%=rs("d")%></b>
</td>
<td bordercolorlight="#00215a" align=center width="16%">[<%=rs("time")%>]</td>
<td bordercolorlight="#00215a" align=center width="9%"><a href="dell.asp?num=<%=rs("num")%>">刪除</a></td>
</tr>
<%
rs.movenext
next
end if
end if
rs.close
Set rs=nothing
%>
<tr>
<td colspan=6 align=middle bordercolorlight="#00215a"> 共有 <%=num%> 個網站
| <a href=adminflash.asp?page=1&classid=<%=request("classid")%>>首頁</a> |
<%if page>1 then%>
<a href=adminflash.asp?page=<%=page-1%>&classid=<%=request("classid")%>>
<%end if%>
上一頁</a> |
<%if page<pagenum then%>
<a href=adminflash.asp?page=<%=page+1%>&classid=<%=request("classid")%>>
<%end if%>
下一頁</a> | <a href=adminflash.asp?page=<%if pagenum=0 then%>1<%else%><%=pagenum%><%end if%>&classid=<%=request("classid")%>>尾頁</a>
</td>
</tr>
</table>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -