📄 addcata.asp
字号:
<!--#include file="conn.asp" -->
<%
dim rs,sql,action
set rs=server.createobject("adodb.recordset")
action=request("action")
if action<>"" 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
action="error"
else
response.cookies("admin")=request("admin")
response.cookies("pass")=request("pass")
end if
rs.close
end if
select case action
case "add"
if request("title")="" then
response.write "<center>没有填写完必须的内容！没有保存...</center>"
else
sql="select * from category where id is null"
rs.open sql,conn,1,3
rs.addnew
rs("title")=request("title")
rs.update
rs.close
response.write "<center>已经成功保存了...</center>"
end if
case "modify"
if request("title")="" then
response.write "<center>没有填写完必须的内容！没有保存...</center>"
else
sql="select * from category where id="&cstr(request("id"))
rs.open sql,conn,1,3
oldtitle=rs("title")
rs("title")=request("title")
rs.update
rs.close
sql="update news set cataid='"&request("title")&"' where cataid='"&oldtitle&"'"
conn.execute sql
response.write "<center>已经成功保存了...</center>"
end if
case "del"
sql="select * from category where id="&cstr(request("id"))
rs.open sql,conn,1,1
cata=rs("title")
rs.close
sql="delete from category where id="&cstr(request("id"))
conn.execute sql
sql="delete from news where cataid='"&cata&"'"
conn.execute sql
response.write "<center>已经成功删除了...</center>"
case "error"
response.write "<center>用户名/密码错！没有保存...</center>"
end select
%>
<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">
</head>
<body bgcolor="#FFFFFF">
<form name="form1" method="post" action="addcata.asp">
<div align="center"><font color="#FF0000" face="Arial, Helvetica, sans-serif">QB</font><font face="Arial, Helvetica, sans-serif">Trade.com</font>
- 管理新闻类别</div>
<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>
<table width="54%" border="0" align="center">
<tr>
<td width="45%" valign="top">
<table width="100%" border="1" bordercolor="#339900">
<tr>
<td bgcolor="#CCCCCC">已有类别</td>
</tr>
<%
sql="select * from category"
rs.open sql,conn,1,1
if rs.bof and rs.eof then
response.write "<tr><td>没有类别</td></tr>"
else
do while not rs.eof
%>
<tr>
<td><%=rs("title")%> - <a href="javascript:setvalue('<%=rs("title")%>',<%=rs("id")%>)">修改</a>
<a href="javascript:cdel('<%=rs("id")%>')">删除</a></td>
</tr>
<%
rs.movenext
loop
end if
rs.close
set rs=Nothing
endconnection
%>
<tr>
<td>
<div align="right"><a href="javascript:newc()"";form1.action.value="add";form1.id.value="0"">+新增类别+</a>
<script language="JavaScript">
function setvalue(v,id){
var v;
var id;
form1.title.value=v;
form1.action.value='modify';
form1.id.value=id;
}
</script>
<script language="JavaScript">
function newc(){
form1.title.value="";
form1.action.value="add";
form1.id.value="0";
}
</script>
<script language="JavaScript">
function cdel(id){
var id;
if (confirm("你真的要删除这个类别和这个类别下的所有新闻吗？")){
document.location.href="addcata.asp?action=del&id="+id+"&admin="+form1.admin.value+"&pass="+form1.pass.value;
}
}
</script>
</div>
</td>
</tr>
</table>
</td>
<td width="55%" valign="top">
<div align="center">
<p>新增/修改类别： <br>
<input type="text" name="title" size="12">
<br>
动作：
<input type="text" name="action" readonly value="add" size="6" style="border:none">
<input type="hidden" name="id">
<br>
<input type="submit" name="Submit" value="确定">
<input type="reset" name="Submit2" value="取消">
</p>
</div>
</td>
</tr>
</table>
<div align="center">[<a href="admin.asp">返回管理</a>] [<a href="default.asp">返回主页</a>]
[<a href="addnews.asp">增加新闻</a>]</div>
</form>
<script language="JavaScript" src="copyright.js">
</script>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -