www.gusucode.com > 528人才招聘网整站源代码-蓝色经典 精简版 2.0源码程序 > add_guest_db.asp

    <!--#include file="info.asp"-->
<!--#include file="conn.asp"-->
<%
if trim(request("title"))="" then
response.write "<script language=JavaScript>" & chr(13) & "alert('主题不能为空!');" & "history.back()" & "</script>" 
Response.End
end if
if trim(request("content"))="" then
response.write "<script language=JavaScript>" & chr(13) & "alert('内容不能为空!');" & "history.back()" & "</script>" 
Response.End
end if
if len(request("content"))>300 then
response.write "<script language=JavaScript>" & chr(13) & "alert('内容不能超过150个汉字!');" & "history.back()" & "</script>" 
Response.End
end if
if trim(request("username"))="" then
response.write "<script language=JavaScript>" & chr(13) & "alert('姓名不能为空!');" & "history.back()" & "</script>" 
Response.End
end if
call codeistrue("add_guest.asp")
title=Trim(Request("title"))
content=Request("content")
username=Trim(request("username"))
email=request("email")
qq=request("qq")
homepage=request("homepage")
show=request("show")
addtime=now()
sex=request("sex")
sql="insert into guest(title,content,username,email,qq,addtime,homepage,sex) values('"&title&"','"&content&"','"&username&"','"&email&"','"&qq&"','"&addtime&"','"&homepage&"',"&sex&")"
rs.open sql,conn,1,1
set rs=nothing
set conn=nothing
response.write ("<Script Language=Javascript>window.alert('添加留言成功,我们将会在最短的时间内对您的问题作出回答,谢谢你对本站的支持!');location.href='guest.asp';</Script>")

%>