📄 readmessage.asp
字号:
<%
response.buffer=true
response.clear
response.expires=0
%>
<html>
<head>
</head>
<body bgcolor=#c1f7d8>
<p align=center><font size=5>查看留言</font></p>
<%
if not request.querystring("id")="" then
strdsn="dsn=bbs;uid=feng;pwd=feng"
strdeletesql="delete from message where id=" &request.querystring("id")
set rsdelete=server.createoject("adodb.recordset")
rsdelete.open strdeletesql,strdsn,1,3
set rsdelete=nothing
response.redirect "readmessage.asp"
end if
%>
<%
dim strsql,strdsn
strsql="select * from message where messagetoname='" & session("name") & "'"
strdsn="dsn=bbs;uid=feng;pwd=feng"
set rs=server.createobject("adodb.recordset")
rs.open strsql,strdsn,1,3
response.write "<center> 你共有" & rs.recordcount & "条留言"
%>
<%
dim i
response.write "<table border=1 width=100%/><tr>"
for i=1 to rs.recordcount
response.write "<td width=27%/>" & rs("messagedate") & " " & rs("messagetime") & "</td>"
response.write "<td width=18%/>" & rs("messagename") & "</td>"
response.write "<td width=20%/>" & rs("messageemail") & "</td>"
response.write "<td width=20%/>" & rs("messagehomepage") & "</td>"
response.write "<td width=15%/><a href=return.asp?toname=" & rs("messagename")
response.write ">回复</a>"
response.write "<a href=readmessage.asp?id=" & rs("id") & ">删除</a></td></tr>"
response.write "<tr><td colspan=5>" & rs("messagecontent") & "</td></tr>"
rs.movenext
next
response.write "</table>"
rs.close
set rs=nothing
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -