?? publishsuccess.asp
字號(hào):
<%@ language="vbscript"%>
<%response.Expires = 0%>
<%
DbPath = SERVER.MapPath("bazhu.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DbPath
set rs=server.createobject("adodb.recordset")
sqltext="select * from bazhu where name='" & request.form("name") & "'"
rs.open sqltext,conn,1,1
set rs=server.createobject("adodb.recordset")
sqltext="select * from bazhu"
rs.open sqltext,conn,3,3
'添加數(shù)據(jù)到數(shù)據(jù)庫
rs.addnew
rs("xz")=request.form("xz")
rs("city")=request.form("city")
rs("district")=request.form("district")
rs("wlwz")=request.form("wlwz")
rs("house_pro")=request.form("house_pro")
rs("house_type")=request.form("house_type")
rs("house_type_other")=request.form("house_type_other")
rs("living_room")=request.form("living_room")
rs("sitting_room")=request.form("sitting_room")
rs("toilet")=request.form("toilet")
rs("room_demand")=request.form("room_demand")
rs("is_month")=request.form("is_month")
rs("price_beg")=request.form("price_beg")
rs("price_end")=request.form("price_end")
rs("unit_beg")=request.form("unit_beg")
rs("unit_end")=request.form("unit_end")
rs("unit")=request.form("unit")
rs("is_con")=request.form("is_con")
rs("con_beg")=request.form("con_beg")
rs("con_end")=request.form("con_end")
rs("use_beg")=request.form("use_beg")
rs("properties")=request.form("properties")
rs("req_description")=request.form("req_description")
rs("zxiu")=request.form("zxiu")
rs("jiaot")=request.form("jiaot")
rs("sp_req")=request.form("sp_req")
rs("expiry")=request.form("expiry")
rs("name")=request.form("name")
rs("namezj")=request.form("namezj")
rs("address")=request.form("address")
rs("tele1")=request.form("tele1")
rs("tele2")=request.form("tele2")
rs("email")=request.form("email")
rs("oicq")=request.form("oicq")
'rs("DJ")=1
rs.update
rs.close
conn.close
response.write "<p align='center'><big><big><font color='#ff0000'><b>霸豬樂園bazhu.com</b></font></big></big><br><br><br><br>歡迎您!</p>"
response.write"<SCRIPT language=JavaScript>alert('信息發(fā)布成功，正在添加到數(shù)據(jù)庫中...，請(qǐng)稍候！');"
response.write"this.location.href='fbcg.htm';</SCRIPT>"
%>
<%
xz=request.form("xz")
city=request.form("city")
district=Request.Form("district")
wlwz=request.form("wlwz")
house_pro=Request.Form ("house_pro")
house_type=request.form("house_type")
house_type_other=request.form("house_type_other")
living_room=request.form("living_room")
sitting_room=request.form("sitting_room")
toilet=request.form("toilet")
room_demand=request.form("room_demand")
is_month=request.form("is_month")
price_beg=request.form("price_beg")
price_end=request.form("price_end")
unit_beg=request.form("unit_beg")
unit_end=request.form("unit_end")
unit=request.form("unit")
is_con=request.form("is_con")
con_beg=request.form("con_beg")
con_end=request.form("con_end")
use_beg=request.form("use_beg")
properties=request.form("properties")
req_description=request.form("req_description")
zxiu=request.form("zxiu")
jiaot=request.form("jiaot")
sp_req=request.form("sp_req")
expiry=request.form("expiry")
name=request.form("name")
namezj=request.form("namezj")
address=request.form("address")
tele1=request.form("tele1")
tele2=request.form("tele2")
email=request.form("email")
oicq=request.form("oicq")
%>
<html>
<head>
<title>信息發(fā)布成功！</title>
<!-- 霸豬樂園 E-mail：webmaster@bazhu.com 主頁：http://www.bazhu.com QQ:309412-->
<meta content="text/html; charset=gb2312" http-equiv="Content-Type">
<style>A:link {
FONT-SIZE: 14px; TEXT-DECORATION: none
}
A:visited {
FONT-SIZE: 14px; TEXT-DECORATION: none
}
A:active {
FONT-SIZE: 14px; TEXT-DECORATION: none
}
A:hover {
COLOR: red; FONT-SIZE: 14px; TEXT-DECORATION: underline
}
TD {
FONT-SIZE: 14px
}
TH {
FONT-SIZE: 14px; FONT-WEIGHT: bold; font-color: #0022aa
}
P {
FONT-SIZE: 14px
}
INPUT {
FONT-SIZE: 14px
}
SELECT {
FONT-SIZE: 14px
}
</style>
<meta content="MSHTML 5.00.2614.3500" name="GENERATOR">
</head>
<body bgColor="#ffffff">
</body>
</html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -