addnews3.asp

来自「这是一个学生毕业时做的教务系统」· ASP 代码 · 共 108 行

ASP
108
字号
<!--#include file=conn.asp -->

<%
IF not(Session("KEY")="super"  or Session("KEY")="input") THEN
response.redirect "login.asp"
response.end
END IF

Author=replace(trim(Request.Form("Author")),"'","''")
Original=replace(trim(Request.Form("Original")),"'","''")
hot=Request.Form("hot")
image=Request.Form("image")

BigClassName=trim(Request.Form("BigClassName"))

SmallClassName=trim(Request.Form("SmallClassName"))
if SmallClassName="" then
%>
<script language=javascript>
history.back()
alert("请选择该新闻所属小类")
</script>
<%
Response.End
end if

SpecialID=Request.Form("SpecialID")

title=request.form("Title")
if Title="" then
%>
<script language=javascript>
history.back()
alert("请填写新闻标题!")
</script>
<%
Response.End
end if

Content=replace(trim(Request.Form("Content")),"'","''")
'Content=replace(trim(Request.Form("Content")),"  ","&nbsp;&nbsp;")
Content=Request.Form("Content")

if Content="" then
%>
<script language=javascript>
history.back()
alert("请输入新闻内容!")
</script>
<%
Response.End
end if

EnCode=trim(Request.Form("EnCode"))

sql="INSERT INTO News (Title,Author,Original,Content,hot,image,BigClassName,SmallClassName,SpecialID,EnCode,UpdateTime) VALUES "
sql=sql & "(" & "'"& title & "'" & ","
sql=sql & "'"& Author &"'"&","
sql=sql & "'"& Original &"'"&","
sql=sql & "'"& Content &"'"&","
sql=sql & Hot &","
sql=sql & image & ","
sql=sql & "'"& BigClassName &"'"&","
sql=sql & "'"& SmallClassName &"'"&","
sql=sql & SpecialID &","
sql=sql & "'"& EnCode &"'"&","
sql=sql & "'" & Now() &"')"
conn.Execute (sql)
conn.close
set conn=nothing

%>

<html>

<head>
<meta http-equiv="refresh" content="2;url=AddNews1.asp">
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href=site.css rel=stylesheet>
</head>

<body>

<p> </p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<table border="0" width="450" align=center cellspacing="1" bgcolor="#000000">
<tr>
<td width="100%" bgcolor="#FFFFFF" align="center">
<p>&nbsp;</p>
<p>新闻已经添加!</p>
<p>&nbsp;</p>
</td>
</tr>
<%if image<>0 then %>
<tr>
<td width="100%" bgcolor="#CCCCCC" align="center">
<p>&nbsp;</p>
<p>请上传新闻图片!</p>
<p>&nbsp;</p>
</td>
</tr>
<%end if%>
</table>
</body>

</html>

⌨️ 快捷键说明

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