📄 show.asp

📁 图利文章管理系统。毕业设计郑州科技学院2006级计算机系计算机信息管理专业
💻 ASP
字号:
<!--#include file="conn.asp"-->
<!--#include file="admin/ubbhtml.asp"-->
<%
id=request("id")
if id="" then 
   response.write "参数不足"
   response.end
end if     
%> <%
sql="select * from learning where articleid="&id
rs.open sql,conn,1,2
if rs.bof or rs.eof then
   response.write "该内容已经不删除或者不存在"
   rs.close
   set rs=nothing
   conn.close
   set conn=nothing
   response.end
end if 
today=rs("today")

rs("todayhits")=rs("todayhits")+71
rs("hits")=rs("hits")+71
rs.update

if datediff("d",today,date)>=1 then
	rs("today")=date()
	rs("todayhits")=100
	rs.update
end if

title=rs("title")
hits=rs("hits")
writer=rs("writer")
if writer="" then
	writer="ii86.com"
end if
url=rs("writer_url")
sort=rs("sort")
dateandtime=rs("dateandtime")
content=rs("content")
rs.close
response.write count
%> 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!-- saved from url=(0014)about:internet -->
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><%=title%> - 荆网笑话</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<style type="text/css">td img {display: block;}body {
	margin-left: 0px;
	margin-top: -1px;
	margin-right: 0px;
	margin-bottom: 0px;
	background-color: #1A85D7;
}
body,td,th {
	font-size: 13px;
}
</style>
<meta name="Keywords" content="<%=title%>,精彩笑话,荆网" />
</head>
<body>
<table width="600" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
   <td><img src="spacer.gif" width="75" height="1" border="0" alt="" /></td>
   <td><img src="spacer.gif" width="6" height="1" border="0" alt="" /></td>
   <td><img src="spacer.gif" width="76" height="1" border="0" alt="" /></td>
   <td><img src="spacer.gif" width="437" height="1" border="0" alt="" /></td>
   <td><img src="spacer.gif" width="6" height="1" border="0" alt="" /></td>
   <td><img src="spacer.gif" width="1" height="1" border="0" alt="" /></td>
  </tr>

  <tr>
   <td colspan="5"><img name="img/show_a" src="img/show_a.jpg" width="600" height="82" border="0" id="img/show_a" alt="" /></td>
   <td><img src="spacer.gif" width="1" height="82" border="0" alt="" /></td>
  </tr>
  <tr>
   <td colspan="5" background="img/show_b.jpg"></td>
   <td><img src="spacer.gif" width="1" height="134" border="0" alt="" /></td>
  </tr>
  <tr>
   <td colspan="3" background="img/show_c.jpg"></td>
   <td colspan="2" align="center" background="img/show_d.jpg"><b><%=title%></b></td>
   <td><img src="spacer.gif" width="1" height="77" border="0" alt="" /></td>
  </tr>
  <tr>
   <td background="img/show_e.jpg"></td>
   <td background="img/show_f.jpg"></td>
   <td height="281" colspan="2" valign="top" bgcolor="#FFFFFF" style="line-height: 20px;"><table width="100%" height="300" border="0" cellpadding="0" cellspacing="0">
     <tr>
       <td height="279" colspan="2" valign="top"><span style="line-height: 20px;"><%=content%> </span></td>
     </tr>
     <tr>
       <td width="23%" height="20">&nbsp;发表：<%=writer%></td>
       <td width="77%" align="right">上篇：
         <%
sql="select * from learning where syxs<>0 and articleid="&id-1
rs.open sql,conn,1,2
if rs.bof or rs.eof then
   response.write "无"
   else
   response.write "<a href=show.asp?id="&id-1&">"&rs("title")&"</a>"
   end if 
rs.close    
%>
下篇：
<%
sql="select * from learning where syxs<>0 and articleid="&id+1
rs.open sql,conn,1,2
if rs.bof or rs.eof then
   response.write "无"
   else
   response.write "<a href=show.asp?id="&id+1&">"&rs("title")&"</a>"
   end if 
rs.close    
%>
&nbsp; </td>
     </tr>
   </table></td>
   <td background="img/show_h.jpg"></td>
   <td><img src="spacer.gif" width="1" height="301" border="0" alt="" /></td>
  </tr>
  
  <tr>
   <td colspan="5" background="img/show_i.jpg"></td>
   <td><img src="spacer.gif" width="1" height="21" border="0" alt="" /></td>
  </tr>
  <tr>
   <td colspan="5" background="img/show_j.jpg"></td>
   <td><img src="spacer.gif" width="1" height="39" border="0" alt="" /></td>
  </tr>
  <tr>
   <td colspan="5"><img src="img/show_k.jpg" alt="" name="img/show_k" width="600" height="46" border="0" usemap="#img/show_kMap" id="img/show_k" /></td>
   <td><img src="spacer.gif" width="1" height="46" border="0" alt="" /></td>
  </tr>
</table>

<map name="img/show_kMap" id="img/show_kMap"><area shape="rect" coords="206,6,396,36" href="http://joke.ii86.com/" target="_self" />
</map>
<script src="img/copy.htm" type="text/javascript"></script>
</body>
</html>
⌨️ 快捷键说明

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