📄 admin_msna.asp

📁 漂亮的欧美旅游模板
💻 ASP
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="chk.asp"-->
<!--#include file="db_conn.asp"-->
<!--#include file="../my_libs/my_request.asp"-->
<!--#include file="../my_libs/my_lib.asp"-->
<!--#include file="../my_libs/pages.asp"-->
<html>

<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>新建网页 1</title>
<link rel="stylesheet" type="text/css" href="style_admin.css" />
</head>

<body>

<br>
<b>站内短消息查看<font face="宋体" color="#FF6600">↓</font></b>
<br>
<table border="1" width="100%" id="table1">
	<tr>
		<td width="3%" class="top_td">ID</td>
		<td width="37%" class="top_td" align="center">姓名</td>
		<td width="20%" class="top_td" align="center">时间</td>
		<td width="17%" class="top_td" align="center">主题</td>
		<td width="11%" class="top_td" align="center">是否已经看过</td>
		<td width="9%" class="top_td" align="center">删除</td>
	</tr>
				<%
	dim sql,rs,arrlist(4),i,ii
	sql="select id,zm_uzname,zm_title,zm_msntime,zm_isnew from ssort_msn order by zm_msntime desc"
	set rs=server.CreateObject("adodb.recordset")
	rs.open sql,conn,1,1
	if (rs.eof and rs.bof) then
	response.write "<tr>"
    response.write "<td class=12px width=760 colspan=7><font color=#FF0000>暂时还没有任何数据</font></td>"
    response.write "</tr>"
    else
    rs.PageSize =20 '每页记录条数
			iCount=rs.RecordCount '记录总数
			iPageSize=rs.PageSize
    		maxpage=rs.PageCount 
    		page=request("page")
    
    if Not IsNumeric(page) or page="" then
        page=1
    else
        page=cint(page)
    end if
    
    if page<1 then
        page=1
    elseif  page>maxpage then
        page=maxpage
    end if
    
    rs.AbsolutePage=Page

	if page=maxpage then
		x=iCount-(maxpage-1)*iPageSize
	else
		x=iPageSize
	end if

end if
						  ii=1
						  while not rs.eof and ii<=rs.pagesize
for i=0 to 4
arrlist(i)=rs(i)
next

%>
	<tr>
		<td width="3%" align="center"><%=(page-1)*19+ii%></td>
		<td width="37%" align="center"><%=arrlist(1)%></td>
		<td width="20%" align="center"><%=arrlist(3)%></td>
		<td width="17%" align="center"><a href=listmsn.asp?id=<%=arrlist(0)%>><%=arrlist(2)%></a></td>
		<td width="11%" align="center"><%
		if arrlist(4)=0 then
		response.write "新"
		else
		response.write "旧"
		end if%></td>
		<td width="9%" align="center"><a href="delmsn.asp?id=<%=arrlist(0)%>">删除</a></td>
	</tr>
<%
rs.movenext
ii=ii+1
wend
call PageControl(iCount,maxpage,page,"border=0 width=100% align=center class=left_td ","<p align=right>")
rs.close
set rs=nothing
%>
</table>
</body>

</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -