⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 showtopiccontent.asp

📁 在开发大型软件的漫长过程中
💻 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="674" 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 height="597" align=center valign=center bgcolor="#FFFFFF">
    		<%
    			set conn=server.createobject("adodb.connection")
    			conn.open session("constr")
    			topicid=request("topicid")
    			sqlstr="update t_topic set f_browsenum=f_browsenum+1 where f_id=" & topicid
    			conn.execute sqlstr
    			sqlstr="select * from t_topic where f_id=" & topicid
    			set rs=conn.execute(sqlstr)
    			topictitle=rs("f_title")
    		%>
    		<table border=1 width=100% bgcolor=#FFFFcc>	
    			<tr>
    				<td align=center widht=20%>
    					<%
    					    sqlstr="select * from t_user where f_id=" & rs("f_userid")
    						set rs1=conn.execute(sqlstr)
    					%>
    					<p>用户名:<%=rs1("f_name")%></p>
    				</td>
    				<td width=80%>
    					<p align=left><%=rs("f_title")%></p>
    					<hr>
    					<p align=left><%=rs("f_content")%></p>
    					<p align=right>[发布时间:<%=rs("f_releasetime")%>]</p>
    				</td>
    			</tr>
   		  </table>
    		<%
    			set rs=server.createobject("adodb.recordset")
     			sqlstr="select * from t_reply where f_topicid=" & topicid
   				rs.open sqlstr,conn,1,1

   				if not(rs.eof and rs.bof) then 
    				rs.pagesize=4
					rs.absolutepage=pageno
					pagenum=rs.pagecount
					rownum=rs.pagesize
					'pageno=pageno+1
					'pageno=pageno-1	 
					pageno=cint(pageno)
    		%>
    		<table width=100% border=1 bordercolor="#FFFFcc">
    		<%		while not rs.eof and rownum>0%>
    			<tr bgcolor="#FFFFcc">
    				<td height="130" align=center widht=20% >
    					<%
    					    sqlstr="select * from t_user where f_id=" & rs("f_userid")
    						set rs1=conn.execute(sqlstr)
    					%>
				  <p>用户名:<%=rs1("f_name")%></p>   				  </td>
    				<td width=80%>
    					<p align=left><%=rs("f_title")%></p>
    					<hr>
    					<p align=left><%=rs("f_content")%></p>
				  <p align=right>[发布时间:<%=rs("f_releasetime")%>]</p>   				  </td>
    			</tr>
    		<%			rownum=rownum-1
    					rs.movenext
    				wend
    		%>
   		  </table>
    		    共<%=pagenum%>页,跳转到第:[ <strong>                                                                                                                                                         
    			<%for i=1 to pagenum%>                                                                                                                                      
        			<%if pageno=i then%>                                                                                                                                      
            			<%=i%>                                                                                                                                      
        			<%else%>                                                                                                                                      
            			<a href="showtopiccontent.asp?pageno=<%=i%>&boardid=<%=boardid%>&topicid=<%=topicid%>"><font color=#0000FF><%=i%></font></a><%=" "%>                                                                                                                                      
        			<%end if%>                                                                                                                                      
    			<%next%>                                                                                                                                      
    			</strong>]页                                                
    		<%	end if%>                                            
    		                            
			<%if session("userid")<>0 then%>                                    
    		<form action=releasereply.asp method=post>                                  
    		<table border=1 width=100%>                                           
    			<tr bgcolor="#FFFFcc">                                           
    				<td width=20% align=center>回复标题</td>                                 
   				  <td width=80%><input type=text name=title size="60" value=<%="回复:"&topictitle%>></td>                                           
    			</tr>                                           
    			<tr bgcolor="#FFFFcc">                                           
    				<td width=20% align=center>回复内容</td>                                           
   				  <td width=80% bgcolor="#FFFFcc"><textarea cols=60 rows=10 name=content></textarea></td>                                           
   			  </tr>                                           
    			<input type=hidden name=topicid value=<%=topicid%>>                             
    			<input type=hidden name=boardid value=<%=boardid%>>                               
    			<input type=hidden name=pageno value=<%=pageno%>>                               
    			<tr bgcolor="#FFFFcc">                                           
    				<td colspan=2 align=center>                                           
				  <input type=submit value=回复> <input type=reset value=重新输入>   				  </td>                                           
   			  </tr>                                           
    		</table>                                    
    		</form>                                                     
	        <%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 + -