📄 showtopic.asp
字号:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href=images/font.css rel=stylesheet type=text/css>
<title>轻舞飞扬--BBS</title>
<style type="text/css">
<!--
.style4 {font-family: Georgia, "Times New Roman", Times, serif}
.style9 {color: #0000FF; font-size: 18px; }
body {
background-image: url(images/background.gif);
}
-->
</style>
</head>
<body>
<table width="542" border="3" align="center" cellpadding="1">
<tr>
<td><img src="images/qwfy.png" width="660" height="130"></td>
</tr>
<tr>
<td width=100% height=30 bgcolor="#FFFFcc">
<%if session("userid")=0 then%>
<%
response.write " <a href=logmain.asp>登陆</a> |"
response.write " <a href=regmain.asp>注册</a>"
%>
<%else%>
<%
set conn=server.createobject("adodb.connection")
conn.open session("constr")
sqlstr="select * from t_user where f_id=" & session("userid")
set rs=conn.execute(sqlstr)
response.write rs("f_name")&" |"
response.write " <a href=modusermain.asp>修改资料</a> |"
response.write " <a href=logout.asp>退出</a>"
%>
<%end if%>
</td>
</tr>
<tr>
<td width=100% height=30 bgcolor="#FFCC99">
<%
boardid=request("boardid")
set conn=server.createobject("adodb.connection")
conn.open session("constr")
sqlstr="select * from t_board where f_id=" & boardid
set rs=conn.execute(sqlstr)
%>
<a href=default.asp>首页</a>→<a href=showtopic.asp?boardid=<%=boardid%>><%=rs("f_boardname")%></a>→查看主题
</td>
</tr>
<%
pageno=request("pageno")
if pageno="" or pageno=0 then
pageno=1
end if
%>
<tr>
<td align=center valign=center bgcolor="#FFFFFF">
<table width=100% border=1 bgcolor="#FFFFcc">
<tr bgcolor=#FFCCCC>
<td align=center>标题</td>
<td align=center>作者</td>
<td align=center>发表时间</td>
<td align=center>浏览次数</td>
<td align=center>回复次数</td>
</tr>
<%
set conn=server.createobject("adodb.connection")
conn.open session("constr")
sqlstr="select * from t_topic where f_boardid=" & boardid
set rs=server.createobject("adodb.recordset")
rs.open sqlstr,conn,1,1
if rs.eof and rs.bof then%>
<tr bgcolor="#FFFFcc#000000">
<td>暂无主题</td>
</tr>
<% ="</table>"%>
<% else%>
<%
rs.pagesize=8
rs.absolutepage=pageno
pagenum=rs.pagecount
rownum=rs.pagesize
'pageno=pageno+1
'pageno=pageno-1
pageno=cint(pageno)
%>
<% while not rs.eof and rownum>0%>
<tr bgcolor="#FFFFcc">
<td align=center><a href=showtopiccontent.asp?boardid=<%=boardid%>&topicid=<%=rs("f_id")%>><%=rs("f_title")%></a></td>
<td align=center><%
sqlstr="select * from t_user where f_id=" & rs("f_userid")
set rs1=conn.execute(sqlstr)
response.write rs1("f_name")
%>
</td>
<td align=center><%=rs("f_releasetime")%></td>
<td align=center><%=rs("f_browsenum")%></td>
<td align=center><%=rs("f_replynum")%></td>
</tr>
<%
rownum=rownum-1
rs.movenext
wend
%>
</table>
共<%=pagenum%>页，跳转到第：[ <strong>
<%for i=1 to pagenum%>
<%if pageno=i then%>
<%=i%>
<%else%>
<a href="showtopic.asp?pageno=<%=i%>&boardid=<%=boardid%>"><font color=#0000FF><%=i%></font></a><%=" "%>
<%end if%>
<%next%>
</strong>]页
<% end if%> </td>
</tr>
<tr>
<td width=100% height=30 bgcolor="#FFFFcc" align=right>
<div align="center"><a href="releasetopicmain.asp?boardid=<%=boardid%>">发表新主题</a>
</div></td>
</tr>
<tr>
<td height="30" align="center" valign="middle" bgcolor="#CC6633">
<span class="style9">版权所有@<span class="style4">corner</span></span></td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -