📄 showbook.asp

📁 图文管理。1,新闻动态 2,网址导航(含有60个著名设计网址) 3,图片展示 4,会员注册管理等

💻 ASP

字号:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="sub/config.asp"-->
<!--#include file="sub/conn.asp"-->
<!--#include file="sub/inc.asp"-->
<!--#include file="sub/getType2.asp"-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title><%=SiteName%>--设计文章</title>
<link href="img/dex.css" rel="stylesheet" type="text/css" />
<link href="img/dex2.css" rel="stylesheet" type="text/css" />

</head>
<body>
<!--TOP-->
<!--#include file="top.asp"-->
<!--TOP END-->
<div  id="box">
    <div id="boxleft">
    <div id="dclass">
	<ul><%
	Set RS = Server.CreateObject("ADODB.Recordset")
	SQL = "Select * from bookclass"
	RS.Open SQL, cn, 1,1,1
	Do while not RS.EOF%>
	    <li><a href="books.asp?class=<%=RS("class")%>"><%=RS("classname")%></a></li>
<% RS.movenext
	Loop
	set RS = nothing%>
	</ul>	
	</div>
<div id="wsearch">
	<% call websearch() %>
	</div>
	<!--全站搜索结束-->
	<div id="newstop">
		<ul>
					<%Set rs = Server.CreateObject("ADODB.Recordset")
		SQL = "Select top 10 * from book order by click desc"
		rs.Open SQL, cn, 1,1
		   do while not rs.eof
			Response.Write "<li><a href='showbook.asp?id="&rs("id")&"'>"&left(rs("title"),13)&"...</a></li>"
			rs.movenext
            loop
          rs.close
           set rs=nothing%>
	    </ul>
	</div></div>
<!--点击排行结束-->
    <div id="boxright">
    <div id="ad1">
	<%=ad4%>
	</div>
<!--广告结束-->
    <div id="newstitle">

	<%
	if Request.QueryString("id")<>"" then
		Set rs1 = Server.CreateObject("ADODB.Recordset")
		SQL1 = "Select * from book where id=" & Request.QueryString("id")
		rs1.Open SQL1, cn, 1,2,1
    %>
	<h1><%=rs1("title")%></h1>
	<hr />
	<span class="date">发布日期:&nbsp;<%=rs1("date")%>&nbsp;&nbsp;&nbsp;作者:&nbsp;<%=rs1("writer")%>&nbsp;&nbsp;&nbsp;版权:&nbsp;<%=rs1("copyright")%></span>
	<p>&nbsp;</p>
	<%=rs1("content")%>
	<%rs1("click")=rs1("click")+1
  rs1.update
		set rs1 = nothing
	end if
%>
	</div>	
</div>
</div>
<!--#include file="bottom.asp"-->

 </body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -