📄 admin_infomodi.asp

📁 本实例为一个完整的网上购物商城的完整例子程序,里面有所以的源代码.希望对大家学习有用.
💻 ASP
字号:
<!--#include file="conn.asp"-->
<%
if session("admin_name")="" then
        response.redirect "error.asp?error=001"
end if
%>
<%
if request("no")="modi" then
        newsid=request("newsid")
title=request("title")
BigClassName=request("BigClassName")
SmallClassName=request("SmallClassName")
mContent = trim(Request.form("cnWords"))
mContent = Replace(mContent, "<script", "<sscript")
mContent = Replace(mContent, "/script>", "/scripts>")
mContent = Replace(mContent, "/script >", "/scripts>")
mimageNum = Request.form("imageNum")
firstImageName = trim(Request.form("editFirstImageName"))
user=request("user")
ok=request("ok")
set rs=server.createobject("adodb.recordset")
sql="select * from NEWS where id="&newsid
rs.open sql, conn, 1, 3
rs("title")=title
rs("content")=mcontent
rs("user")=user
rs("BigClassName")=BigClassName
rs("SmallClassName")=SmallClassName
if ok<>"" then rs("ok")= ok
        if mimageNum<>"" then rs("imageNum")= mimageNum
        if firstImageName<>"" then rs("firstImageName")= firstImageName
        rs.update
rs.close
set rs=nothing
response.write "<script language='javascript'>" & chr(13)
response.write "alert('专题修改成功！');" & Chr(13)
response.write "window.document.location.href='admin_info.asp';"&Chr(13)
response.write "</script>" & Chr(13)
Response.End
end if%>
<%
dim rs
dim sql
dim count
set rs=server.createobject("adodb.recordset")
sql = "select * from SmallClass order by SmallClassID asc"
rs.open sql, conn, 1, 1
%>
<script language = "JavaScript">
var onecount; 
subcat = new Array(); 
<%
count = 0
do while not rs.eof
%>
subcat[<%=count%>] = new Array("<%= trim(rs("SmallClassName"))%>", "<%= trim(rs("BigClassName"))%>", "<%= trim(rs("SmallClassName"))%>"); 
<%
count = count + 1
rs.movenext
loop
rs.close
%>
onecount=<%=count%>; 
function changelocation(locationid)
{ 
        document.addNEWS.SmallClassName.length = 1;
        var locationid=locationid;
        var i;
        for(i=0; i < onecount; i++)
        {
                if(subcat[i][1] == locationid)
                {
                        document.addNEWS.SmallClassName.options[document.addNEWS.SmallClassName.length] = new Option(subcat[i][0], subcat[i][2]);
                }
        }
}
function CheckForm()
{
        document.addNEWS.cnWords.value = document.frames.cnEditBox.getHTML(true);
        document.addNEWS.imageNum.value = document.frames.cnEditBox.document.all("editImageNum").value;
        document.addNEWS.editFirstImageName.value = document.frames.cnEditBox.document.all("editFirstImageName").value;
        if(document.addNEWS.title.value.length == 0)
        {
                alert("标题没有填写.");
                document.addNEWS.title.focus();
                return false;
        }
        if(document.addNEWS.user.value.length == 0)
        {
                alert("发布人没有填写");
                document.addNEWS.user.focus();
                return false;
        }
        return true;
}
</script>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../css.css" rel="stylesheet" type="text/css">
<title>添加新闻</title>
</head>
<body leftmargin="0" topmargin="0" bgcolor="#FFFFEE">
<%
newsid=request("id")
Set rso=Server.CreateObject("ADODB.RecordSet")
sql="select * from NEWS where  id="&newsid
rso.Open sql, conn, 1, 1
if rso.eof and rso.bof then
        response.Write("没有记录")
else
        %>
<html>
<link rel="stylesheet" href="css.css" type="text/css">
</head>
<body bgcolor="#FFFFCC" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0" cellspacing="1" cellpadding="2" vspace="0" hspace="0">
<tr bgcolor="#FFCC33">
<td height="27" bgcolor="#FFCC33" background="images/admin_bg_1.gif">.:: 您可以在这里进行用户相关操作</td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="2">
<form name="addNEWS" method="post" action="admin_infomodi.asp?no=modi" onSubmit="return CheckForm();">
<tr>
<td width="50%" valign="top" bgcolor="#E8F1FF">　
<font color="#FF0000">*</font>标题：<input name="title" type="text" class="input" value="<%=rso("title")%>" size="30"></td>
<td valign="top" bgcolor="#E8F1FF">
　<fontcolor="#FF0000">*</font>类别：<%
if session("aleave")="check" then
        response.write rso("BigClassName")& "<input name='BigClassName' type='hidden' value='" & rso("BigClassName") & "'>&gt;&gt; "
else
        sql = "select * from BigClass"
rs.open sql, conn, 1, 1
if rs.eof and rs.bof then
        response.write "请先添加栏目。"
else
        %>
<select name="BigClassName" onChange="changelocation(document.addNEWS.BigClassName.options[document.addNEWS.BigClassName.selectedIndex].value)" size="1">
<%
do while not rs.eof
%>
<option <% if rs("BigClassName")=rso("BigClassName")then response.Write("selected")end if%> value="<%=trim(rs("BigClassName"))%>"><%=trim(rs("BigClassName"))%></option>
<%
rs.movenext
loop
end if
rs.close
%>
</select>
<%
end if
if session("aleave")="check" then
        response.write rso("SmallClassName")& "<input name='SmallClassName' type='hidden' value='" & rso("SmallClassName") & "'>"
else
        %>
<select name="SmallClassName">
<option value="" <%if rso("SmallClassName")="" then response.write "selected"%>>不指定小类</option>
<%
sql="select * from SmallClass where BigClassName='" & rso("BigClassName") & "'"
rs.open sql, conn, 1, 1
if not(rs.eof and rs.bof)then
        do while not rs.eof %>
<option <% if rs("SmallClassName")=rso("SmallClassName")then response.Write("selected")end if%> value="<%=rs("SmallClassName")%>"><%=rs("SmallClassName")%></option>
<%
rs.movenext
loop
end if
rs.close
%>
</select>
<%
end if
%>      </td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="2">
<tr>
<td valign="top" bgcolor="#E8F1FF">
<IFRAME STYLE="border: none" NAME=cnEditBox src="EditBox.asp?newsId=<%=newsId%>" WIDTH=100% HEIGHT=330></IFRAME></td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="2">
<tr>
<td valign="top" bgcolor="#E8F1FF">　
<font color="#FF0000">*</font>发布人：<input name="user" type="text" class="input" size="10" value="<%=rso("user")%>"></td>
<td bgcolor="#E8F1FF">　
是否设为首页图片新闻：<inputtype="radio"value="True"<%ifrso("ok")=TruethenResponse.Write"checked"%>name="ok">是
<input type="radio" value="False" <%if rso("ok")=False then Response.Write "checked"%> name="ok">
否</td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="2">
<tr align="center">
<td height="35" colspan="2" bgcolor="#FFFFEE">
<input type="submit" name="Submit" value="提交" class="input">
<input type="hidden" name="newsId" value="<%=newsId%>">　
<input type="reset" name="Submit2" value="重置" class="input">
<!--获取EditBox的内容-->
<input name=cnWords type=hidden ID="cnWords" value=""> <input name=imageNum type=hidden ID="imageNum" value="<%=mImageNum%>">
<input name=editFirstImageName type=hidden ID="editFirstImageName" value="">
<!--获取EditBox的内容-->
</td>
</tr>
</form>
</table>
<% End If
rso.close
set rso=nothing
%>
</body>
</html>
⌨️ 快捷键说明

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