zyzn_insert.asp

来自「小型房产中介源码」· ASP 代码 · 共 44 行

<%
if session("cjuser")="" and session("pwdd")="" then
response.write"<SCRIPT language=JavaScript>alert('你没有登录，无权进入！');"
response.write"this.location.href='error.htm';</SCRIPT>" 
response.end 
end if
%>
<!--#include file="../conn/adodb1.asp"-->
<%
dim title,lx,link,content,dd
title=trim(REQUEST.form("title"))
lx=trim(REQUEST.form("lx"))
link=trim(REQUEST.form("link"))
content=trim(REQUEST.form("content"))

set rs=server.createobject("adodb.recordset")
sql="news"
rs.open sql,db,3,2
rs.addnew
if link="" then
rs("title")=title
rs("lx")=lx
rs("content")=content
rs("timm")=now()
rs.update
else
rs.addnew
rs("title")=title
rs("lx")=lx
rs("link")=link
rs("timm")=now()
rs.update
end if
%>
<%
rs.close
db.close
set db=nothing
response.write"<SCRIPT language=JavaScript>alert('恭喜你添加成功！！');"
response.write"this.location.href='zyzn_manage.asp';</SCRIPT>" 
response.end 
%>