readmessage.asp

来自「集合了学习asp的100个实例」· ASP 代码 · 共 53 行

ASP
53
字号
<%

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 + =
减小字号Ctrl + -
显示快捷键?