price_edit_ok.asp
来自「新闻发布系统」· ASP 代码 · 共 80 行
ASP
80 行
<%@ LANGUAGE="VBSCRIPT" %>
<!--#include file=config.asp -->
<!--#include file="check.asp"-->
<html><head>
<meta http-equiv=Content-Language content=zh-cn>
<meta http-equiv=Content-Type content=text/html; charset=gb2312>
<meta http-equiv=Pragma content=no-cache>
<link href=../css/css.css rel=STYLESHEET type=text/css>
<title>广告发布管理系统</title>
<base target=_top>
</head><body marginwidth=0 marginheight=0>
<%
function changechr(str)
changechr=replace(replace(replace(replace(str,"<","<"),">",">"),chr(13),"<br>")," "," ")
changechr=replace(changechr,"'","´")
changechr=replace(changechr,mid(" "" ",2,1),""")
end function
dim pricename
dim ID
ID=request("ID")
pricename=changechr(trim(request("pricename")))
if pricename="" then
response.write "不能为空!请<a href=javascript:history.go(-1)>返回重新填写</a>!"
response.end
end if
adsconn.open adsdata
set adsrs=server.createobject("adodb.recordset")
adssql ="SELECT * From price"
adsrs.open adssql,adsConn,1,3
do while not adsrs.eof
if adsrs("price")=pricename then
response.write "<br><br><br><center>已经存在这个广告分类名称或没有做任何改动!请<a href=javascript:history.go(-1)>返回重新填写</a>!</center>"
response.end
end if
adsrs.movenext
loop
adsrs.close
'修改价格种类
set adsrs=server.createobject("adodb.recordset")
adssql="select * from price where priceID="&ID
adsrs.open adssql,adsconn,1,3
pricen=adsrs("price")
adsrs("price")=pricename
adsrs.update
adsrs.close
'修改广告位置
set adsrs=server.createobject("adodb.recordset")
adssql="select * from place where price='"&pricen&"'"
adsrs.open adssql,adsconn,1,3
do while not adsrs.eof
adsrs("price")=pricename
adsrs.update
adsrs.movenext
loop
adsrs.close
'修改广告条数据
set adsrs=server.createobject("adodb.recordset")
adssql="select * from ads where price='"&pricen&"'"
adsrs.open adssql,adsconn,1,3
do while not adsrs.eof
adsrs("price")=pricename
adsrs.update
adsrs.movenext
loop
adsrs.close
set adsrs=nothing
adsconn.close
set adsconn=nothing
response.redirect "mana.asp"
%>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?