?? editnews.asp
字號:
<!--#include file="conn.asp" -->
<%
function htmlencode(str)
htmlencode=replace(replace(str,chr(13),"<br>"),"'","''")
end function
function htmldecode(str)
htmldecode=replace(replace(str,"<br>",chr(13)),"''","'")
end function
'on error resume next
dim rs,sql
set rs=server.createobject("adodb.recordset")
if request.querystring="save" 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 "<center>用戶名/密碼錯!新聞沒有保存...</center>"
rs.close
else
response.cookies("admin")=request("admin")
response.cookies("pass")=request("pass")
rs.close
if request("title")="" or request("content")="" then
response.write "<center>沒有填寫完必須的內容!新聞沒有保存...</center>"
else
sql="select * from news where id ="&request("id")
rs.open sql,conn,1,3
rs("cataid")=request("cataid")
rs("title")=request("title")
if request("linktitle")<>"" then rs("linktitle")=request("linktitle")
if request("linkurl")<>"" then rs("linkurl")=request("linkurl")
if request("image")<>"" then rs("image")=request("image")
rs("addtime")=date()
rs("special")=request("special")
rs("content")=htmlencode(request("content"))
rs("hits")=1
rs.update
rs.close
response.write "<center>新聞已經成功保存了...</center>"
end if
end if
end if
if request("id")="" then
response.redirect "addnews.asp"
else
sql="select * from news where id="&request("id")
rs.open sql,conn,1,1
'response.write err.description
cataid=rs("cataid")
title=rs("title")
linktitle=rs("linktitle")
linkurl=rs("linkurl")
image=rs("image")
content=rs("content")
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">
</head>
<body bgcolor="#FFFFFF">
<form name="form1" method="post" action="editnews.asp?save">
<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" 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>
<table width="80%" border="0" align="center">
<tr>
<td>新聞類別:</td>
<td>
<select name="cataid">
<%
sql="select * from category"
rs.open sql,conn,1,1
if rs.bof and rs.eof then
response.write "<option value='沒有類別'>沒有類別</option>"
else
do while not rs.eof
response.write "<option value='"&rs("title")&"'"
if rs("title")=cataid then response.write " selected"
response.write ">"&rs("title")&"</option>"
rs.movenext
loop
end if
rs.close
set rs=Nothing
endconnection
%>
</select>
<input type="hidden" name="id" value="<%=request("id")%>">
</td>
</tr>
<tr>
<td>新聞標題:</td>
<td>
<input type="text" name="title" size="66" value="<%=title%>">
</td>
</tr>
<tr>
<td>圖片鏈接:</td>
<td>
<input type="text" name="image" size="66" value="<%=image%>">
</td>
</tr>
<tr>
<td valign="top">新聞內容:</td>
<td>
<textarea name="content" cols="66" rows="8" wrap="VIRTUAL"><%=htmldecode(content)%></textarea>
</td>
</tr>
<tr>
<td>鏈接標題:</td>
<td>
<input type="text" name="linktitle" size="66" value="<%=linktitle%>">
</td>
</tr>
<tr>
<td>鏈接地址:</td>
<td>
<input type="text" name="linkurl" size="66" value="<%=linkurl%>">
</td>
</tr>
<tr>
<td>特別消息: </td>
<td>
<input type="checkbox" name="special" value="true" checked>
注意:以上新聞標題和新聞內容必須填寫,其他可以不填,可以使用html語言。</td>
</tr>
<tr>
<td colspan="2">
<div align="center">
<input type="submit" name="Submit" value="保存">
<input type="reset" name="Submit2" value="取消">
<input type="button" name="Submit3" value="返回" onclick="location.href='default.asp'">
</div>
</td>
</tr>
</table>
<div align="center">[<a href="admin.asp">返回管理</a>] [<a href="default.asp">返回主頁</a>]
[<a href="addcata.asp">管理類別</a>] </div>
</form>
<script language="JavaScript" src="copyright.js">
</script>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -