📄 detail.asp

📁 本系统为ASP版 1
💻 ASP
字号:
<%Admin="SysSee"%>
<!--#include file="check.asp"-->
<!--#include file="mdb_path_info.asp"-->

<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<style type="text/css">
body {font-size:13px}
td {font-size:13px}
input  {font-size:13px}
</style>
</HEAD>
<%
pn=request("pn")
dim rs(5)
function listunder(i)
	set rs(i)=server.createobject("adodb.recordset")
	rs(i).open "select classid,classname from feilei where topclass="&rs(i-1)("classid"),conn,1,3
	while not rs(i).eof
		dim topclassname
		topclassname=""
		for x=0 to i-1
			topclassname=topclassname&rs(x)("classname")&"＞"
		next
		response.write "<option value='"&rs(i)("classid")&"'>"&topclassname&rs(i)("classname")&"</option>"&vbCrLf
		if i<Ubound(rs) then
			call listunder(i+1)
		end if
		rs(i).movenext
	wend
end function
%>
<BODY>
<%
delete=request("delete")
if delete<>"" and session("lastdeleted")<>delete then
conn.execute "delete from detail where id="&delete
response.write "<big><big><font color='red'>已删除一条编号为"&delete&"的网站记录!</font></big></big><br><br>"
session("lastdeleted")=delete
end if
%>
<big>添加新网址</big>
<br>
<Script>
function wz_add() {
title=document.forms['form1'].title.value;
url=document.forms['form1'].url.value;
leibie=document.forms['form1'].leibie.value;
memo=document.forms['form1'].memo.value;
if (leibie==0) {
alert("请选择网站所属类别！");
return false;
}
window.open("wz_add.asp?title="+title+"&url="+url+"&leibie="+leibie+"&memo="+memo,"wz_add_1","width=300,height=100");
return false;
}
</Script>
<form action="wz_add.asp" method="post" onsubmit="return wz_add()" name="form1">
网站标题：<input name="title">
网站url：<input name="url" size="35">
类别名称：<select name="leibie">
<option selected value="0">请选择分类</option>
<%
set rs(0)=server.createobject("adodb.recordset")
rs(0).open "select classid,classname from feilei where topclass=0",conn,1,3
while not rs(0).eof
	response.write "<option value='"&rs(0)("classid")&"'>"&rs(0)("classname")&"</option>"&vbCrLf
	call listunder(1)
	rs(0).movenext
wend
%>
</select><br>
其他信息：<input name="memo" size="50"><br>
<input type="hidden" name="action" value="add">
<input type="submit" value="添加新网站">
</form>
<br>
<form action="wz_search.asp" method="post">
网站列表 &nbsp; &nbsp; &nbsp;&nbsp; <input name="word"><select name="by">根据：<option value='title'>网站名称</option><option value='url'>网站url</option>
</select>
<input type="hidden" name="action" value="delete"><input type="submit" value="搜索">
<table border="1" bordercolor="black" cellspacing="0"></form>
<tr>
<td nowrap>编号</td>
<td>网站名称</td>
<td>网站url</td>
<td width=70 align=center>所属分类</td>
<td width=35 align=center>编辑</td>
<td width=80 align=center>访问量</td>
<td width=85 align=center>加入时间</td>
</tr>
<%
if pn="" then pn=1
set r=server.createobject("adodb.recordset")
r.open "select * from detail",conn,1,3
r.pagesize=100
r.absolutepage=pn
rowcount=r.pagesize
do while not r.eof and rowcount>0
set rr=server.createobject("adodb.recordset")
rr.open "select * from feilei where classid="&r("classid"),conn,1,3
if rr.eof then
	classname=""
else
	classname=rr("classname")
end if
response.write "<td nowrap>"&r("id")&"</td>"
response.write "<td nowrap>&nbsp;"&r("title")&"</td>"
response.write "<td nowrap>&nbsp;"&left(r("url"),50)&"</td>"
response.write "<td align=center>"&classname&"</td>"
response.write "<td align=center><a href='wz_edit.asp?id="&r("id")&"' target='wz_edit'>编辑</a></td>"
response.write "<td align=right>"&r("hits")&"&nbsp;</td>"
response.write "<td align=center>"&year(r("date"))&"-"&month(r("date"))&"-"&day(r("date"))&"</td></tr>"
rr.close
set rr=nothing
rowcount=rowcount-1
r.movenext
loop
%>
</table>
<%
ppage=pn-1
npage=pn+1
totalpage=r.pagecount
if cint(totalpage)>cint(pn) then
%>
<a href='<%=request.servervariables("script_name")%>?pn=1'>首页</a>
<a href='<%=request.servervariables("script_name")%>?pn=<%=totalpage%>'>最后一页</a>
<a href='<%=request.servervariables("script_name")%>?pn=<%=ppage%>'>上一页</a>
<a href='<%=request.servervariables("script_name")%>?pn=<%=npage%>'>下一页</a>
每页显示<%=r.pagesize%>个网站，当前第<%=pn%>页，总共<%=totalpage%>页
<%
else
if pn=1 then
%>
<a href='<%=request.servervariables("script_name")%>?pn=1'>首页</a>
<a href='<%=request.servervariables("script_name")%>?pn=<%=totalpage%>'>最后一页</a>
<a href='<%=request.servervariables("script_name")%>?pn=<%=npage%>'>下一页</a>
每页显示<%=r.pagesize%>个网站，当前第<%=pn%>页，总共<%=totalpage%>页
<%
else
%>
<a href='<%=request.servervariables("script_name")%>?pn=1'>首页</a>
<a href='<%=request.servervariables("script_name")%>?pn=<%=totalpage%>'>最后一页</a>
<a href='<%=request.servervariables("script_name")%>?pn=<%=ppage%>'>上一页</a>
每页显示<%=r.pagesize%>个网站，当前第<%=pn%>页，总共<%=totalpage%>页
<%
end if
end if
%>
</BODY>
</HTML>
⌨️ 快捷键说明

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