📄 modifynews3_update.asp

📁 一个不错的代码一个不错的代码一个不错的代码
💻 ASP
字号:
<!--#include file=conn.asp -->
<!--#include file=../include/config.asp -->

<%
NewsID=Request.QueryString("NewsID")

Title=replace(trim(Request.Form("Title")),"'","''")
if Title="" then
%>
<script language=javascript>
history.back()
alert("请填写新闻标题！")
</script>
<%
Response.End
end if
function changechr(str) 
    changechr=replace(replace(replace(replace(str,"<","&lt;"),">","&gt;"),chr(13),"<br>")," ","&nbsp;") 
    end function	
Author=replace(trim(Request.Form("Author")),"'","''")
Original=replace(trim(Request.Form("Original")),"'","''")
about=replace(trim(Request.Form("about")),"'","''")
Content=Request.Form("txtContent")
Content=replace(Content,chr(13),"<br>")
Content=replace(Content," ","&nbsp;")
if Content="" then
%>
<script language=javascript>
history.back()
alert("请输入新闻内容！")
</script>
<%
Response.End
end if

if request.Form("goodnews")="1" then
goodnews=1
else
goodnews=0
end if

if request.Form("hot")="1" then
hot=1
else
hot=0
end if

if request.Form("sypic")="1" then
sypic=1
else
sypic=0
end if

image=Request.Form("image")

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

set rs=server.createobject("adodb.recordset")
sql="select * from news where NewsID=" & NewsID
rs.open sql,conn,3,3
rs("title")=title
rs("Author")=Author
rs("content")=content
rs("Original")=Original
rs("hot")=hot
rs("goodnews")=goodnews
rs("sypic")=sypic
rs("image")=image
rs("SpecialID")=SpecialID
rs("EnCode")=EnCode
rs("about")=about
rs("UpdateTime")=now()
rs.update


if sypic=1 then
set rs=server.CreateObject("adodb.recordset")
rs.Source="select top " & PicNum &" NewsID,Title,BigClassName,SmallClassName,SpecialID,UpdateTime from News where sypic=1 order by NewsID DESC "
rs.Open rs.Source,conn,1,1

set fs=server.CreateObject("Scripting.FileSystemObject")

FilePath=server.MapPath("../LastPIC.js")

set JSFile=fs.CreateTextFile(FilePath)

JSFile.writeline("document.write(""<table cellpadding=3 cellspacing=0 border=0 >"")")

while not rs.EOF
JSFile.writeline("document.write(""   <tr>"")")
JSFile.writeline("document.write(""     <td width=100% align=center>"")")
strpic="<img border=0 src=http://" & xpurl & "/images/news/"&rs("NewsID" )&"-1.jpg width=125><br>"
JSFile.writeline("document.write(""" &  Strpic & """)")
JSFile.writeline("document.write(""     <td width=100% >"")")
JSFile.writeline("document.write(""   </tr>"")")
JSFile.writeline("document.write(""   <tr>"")")
JSFile.writeline("document.write(""     <td width=100% align=center>"")")
StrNews="<a href='http://" & xpurl & "/ReadNews.asp?NewsID=" & rs("NewsID") &  "&BigClassName=" & rs("BigClassName") & "&SmallClassName=" & rs("SmallClassName") & "&SpecialID=" & rs("SpecialID") & "' target=_blank>" & trim(rs("Title")) & "</a>"
JSFile.writeline("document.write(""" &  StrNews & """)")
JSFile.writeline("document.write(""     <td width=100% >"")")
JSFile.writeline("document.write(""   </tr>"")")
rs.MoveNext
wend
JSFile.writeline("document.write(""</table>"")")
set JSFile=nothing
set fs=nothing
end if

rs.Close
set rs=nothing
conn.close
set conn=nothing

%>

<html>

<head>
<meta http-equiv="refresh" content="2;url=ModifyNews1.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 bgcolor="#000000" cellpadding="0" cellspacing="1">
  <tr> 
    <td width="100%" align="center" bgcolor="#FFFFFF"> 
      <p>&nbsp;</p>
      <p>新闻已经修改！</p>
      <p>&nbsp;</p>
    </td>
  </tr>
<%if image<>0 then %>  
<tr> 
    <td width="100%" align="center" bgcolor="#FFFFFF" height="60"> 
      <p>请检查是否已经上传了新闻图片 </p>
    </td>
  </tr>        
  <%end if%>
</table>
</body>

</html>
⌨️ 快捷键说明

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