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

📄 admin.asp

📁 W3C+HTML+AJAX_GuestBook
💻 ASP
字号:
🔍 
<!--#include file="conn.asp" -->
<%
dim pmcount,pageno
pmcount=25

dim rs,sql
set rs=server.createobject("adodb.recordset")

if request("action")="del" then
	sql="select * from admin where user='"&request("admin")&"' and pwd='"&request("pass")&"'"
	rs.open sql,conn,1,1

	if rs.bof or rs.eof then
		response.write "用户名/密码错误！新闻没有删除..."
	else
		response.cookies("admin")=request("admin")
		response.cookies("pass")=request("pass")
		sql="delete from news where id="&request("id")
		conn.execute sql
		response.write "新闻成功删除了..."
	end if
	rs.close
end if

	
%>
<html>
<head>
<title>QbTrade.com消息管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="style.css" type="text/css">
<script language="javascript">
function view(id){
var id;
window.open('view.asp?id='+id,'_blank','status=no,scrollbars=yes,top=20,left=110,width=580,height=420');
} 
</script>
</head>
<body bgcolor="#FFFFFF">
<div align="center"> 
  <script language="JavaScript">
function cdel(id,cata,page){
var id;
if (confirm("你真的要删除这条新闻吗？")){
	document.location.href="admin.asp?action=del&id="+id+"&admin="+form1.admin.value+"&pass="+form1.pass.value+"&cataid="+cata+"&pageno="+page;
	}
}
</script>
  <font color="#FF0000" face="Arial, Helvetica, sans-serif">QB</font><font face="Arial, Helvetica, sans-serif">Trade.com</font> 
  - 管理 </div>
<form name="form1" method="post" action="">
  <table width="38%" border="1" align="center" cellspacing="0" cellpadding="0" bordercolor="#FFFFCC">
    <tr> 
      <td> 
        <table width="100%" border="1" align="center" bgcolor="#FF9966" cellspacing="0" cellpadding="0" bordercolor="#FFCC66">
          <tr> 
            <td> 
              <div align="center">管理员名称： 
                <input type="text" name="admin" value="<%=request.cookies("admin")%>">
              </div>
              <div align="center">管理员密码： 
                <input type="password" name="pass" value="<%=request.cookies("pass")%>">
              </div>
              <div align="center">*注意：必须输入此密码才能修改类别</div>
            </td>
          </tr>
        </table>
      </td>
    </tr>
  </table>
</form>
<table width="686" border="0" align="center" cellspacing="3" cellpadding="3">
  <tr> 
    <td colspan="2"><font color="#000000"><font color="#FF0066"><font face="Arial, Helvetica, sans-serif">QB</font></font><font face="Arial, Helvetica, sans-serif">Trade.com</font></font>新闻中心 
      - <font color="#FF0000">QB<font color="#000000">Trade.com</font> N</font><font color="#FF9900">e</font><font color="#00CC00">w</font><font color="#0000FF">s</font> 
      center</td>
  </tr>
  <tr> 
    <td width="136" bgcolor="#FFCC00" valign="top"> 
      <table width="100%" border="0">
        <tr> 
          <td> 
            <div align="center"><font color="#FF0000">..::新闻分类::..</font></div>
          </td>
        </tr>
        <%
		'on error resume next
sql="select * from category"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
	response.write "<tr><td><div align='center'>没有分类</div></td></tr>"
else
	do while not rs.eof
%>
        <tr> 
          <td> 
            <div align="center"><a href="admin.asp?cataid=<%=rs("id")%>"><%=rs("title")%></a></div>
          </td>
        </tr>
        <%
		rs.movenext
	loop
end if
rs.close

dim cataid,catid
cataid=request("cataid")
if cataid="" then
	catid="最新消息"
 else
	sql="select * from category where id="&cstr(request("cataid"))
	rs.open sql,conn,1,1
	catid=rs("title")
	rs.close 
end if
%>
        <tr> 
          <td> 
            <div align="center"><font color="#FF0000">..:.<a href="admin.asp">全部新闻</a>.:..</font></div>
          </td>
        </tr>
        <tr> 
          <td> 
            <hr>
          </td>
        </tr>
        <tr> 
          <td> 
            <div align="center"><a href="addcata.asp">管理类别</a></div>
          </td>
        </tr>
        <tr> 
          <td> 
            <div align="center"><a href="addnews.asp?cata=<%=catid%>">增加新闻</a></div>
          </td>
        </tr>
        <tr> 
          <td>
            <div align="center"><a href="query.asp" target="_blank">高级管理</a></div>
          </td>
        </tr>
        <tr> 
          <td> 
            <div align="center"><a href="default.asp">返回首页</a></div>
          </td>
        </tr>
      </table>
    </td>
    <td width="547" bgcolor="#FFFFCC" nowrap> 
      <table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolordark="#FFFFFF" bordercolorlight="#000000">
        <tr bgcolor="#009900"> 
          <td colspan="4"> 
            <div align="right"><font color="#FFFFFF">...:: 
              <%
response.write catid
%>
              ::...</font></div>
          </td>
        </tr>
        <tr bgcolor="#CCFF99"> 
          <td width="14%"> 
            <div align="center">类别</div>
          </td>
          <td width="63%"> 
            <div align="center">标题</div>
          </td>
          <td width="15%"> 
            <div align="center">修改</div>
          </td>
          <td width="8%"> 
            <div align='center'>删除</div>
          </td>
        </tr>
        <%
if cataid="" then
	sql="select * from news order by id desc"
else
	sql="select * from news where cataid='"&catid&"' order by id desc"
end if
rs.open sql,conn,1,1

if pmcount="" or isempty(pmcount) or pmcount<1 then
        pmcount=25
end if
rs.pagesize=pmcount   	'设置每页数
mpage=rs.pagecount    	'得到总页数
pageno=request("pageno")
if isempty(pageno) or cint(pageno)<1 or cint(pageno)>mpage then
	pageno=1
end if


if rs.bof and rs.eof then
	response.write "<tr><td colspan='5'><div align='center'>没有新闻</div></td></tr>"
else

rs.absolutepage=pageno	'将指针移至指定页的第一条记录
loopno=pmcount

do while not rs.eof and loopno>0
%>
        <tr> 
          <td width="14%"> 
            <div align='center'><%=rs("cataid")%></div>
          </td>
          <td width="63%"><a href="javascript:view(<%=rs("id")%>)"> 
            <%response.write rs("title")
	if rs("image")<>"" then
		response.write "<img src='images/news.gif' border=0>"
	end if
	select case right(rs("linkurl"),4)
		case ".zip"
			response.write "<img src='images/zip.gif' border=0>"
		case ".rar"
			response.write "<img src='images/rar.gif' border=0>"
		case ".exe"
			response.write "<img src='images/exe.gif' border=0>"
	end select%>
            </a></td>
          <td width="15%"> 
            <div align='center'><a href="editnews.asp?id=<%=rs("id")%>">修改</a></div>
          </td>
          <td width="8%"> 
            <div align='center'><a href="javascript:cdel('<%=rs("id")%>','<%=cataid%>','<%=pageno%>')">删除</a></div>
          </td>
        </tr>
        <%
rs.movenext
loopno=loopno-1
loop
end if
rs.close
set rs=Nothing
endconnection
%>
      </table>
      <table width="100%" border="0" cellspacing="2" cellpadding="2" class=buinput>
        <tr align="right"> 
          <td> 
            <%
if cint(pageno)>1 then%>
            [<a href='admin.asp?cataid=<%=cataid%>&pageno=<%=pageno-1%>'>上一页</a>] 
            <%
end if
if cint(pageno)<cint(mpage) then
%>
            [<a href='admin.asp?cataid=<%=cataid%>&pageno=<%=pageno+1%>'>下一页</a>] 
            <%end if%>
            共<%=cstr(pageno)&"/"&cstr(mpage)%>页 </td>
        </tr>
      </table>
    </td>
  </tr>
  <tr bgcolor="#99CCFF"> 
    <td colspan="2" valign="top"> 
      <div align="center"><font color="#660099">爆料有奖！凡是跟上面有关的其他新闻，请发到<a href="mailto:qbtrade@21cn.com">qbtrade@21cn.com</a>来，根据新闻价值赠送10～100Q币不等。</font></div>
    </td>
  </tr>
</table>
<script language="JavaScript" src="http://www.qbtrade.com/showlink.asp?user=qbtrade&style=1"></script>
<script language="JavaScript" src="copyright.js">
</script>
</body>
</html>

⌨️ 快捷键说明

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