📄 joinserver.asp

📁 《Web数据库技术》-高晗-vod点播系统程序源代码
💻 ASP
字号:
<!--#include file="conn.asp"-->
<%
if Replace(request("userid"), "'", "''")="" or Replace(request("password"), "'", "''")="" or request("myemail")="" then
response.write "<script>alert('表单未填完整不能注册！');history.back();</Script>"
response.end
end if
email=request("myemail")
if instr(email,"@")=0 or right(email,1)="@" or left(email,1)="@" then
   response.write "<script>alert('email字段错误，请重新输入！');history.back();</Script>"
   response.end
end if
if request("green")=no then
response.write "<script>alert('不接受本站服务条款不能注册！');history.back();</Script>"
response.end
end if
%>
<%
set rs=server.createobject("adodb.recordset")
sql="select userid from users where userid='"&Replace(request("userid"), "'", "''")&"' or  email='"&request("myemail")&"' "
rs.open sql,conn,1,2
if not rs.eof then
   response.write "<script>alert('您的“用户名称”已被占用，或者您的EMAIL已注册过了，请重新输入！');history.back();</Script>"
   response.end
end if
dim rs
dim sql1
set rs=server.createobject("adodb.recordset")
sql1="select * from users"
rs.open sql1,conn,1,3
rs.addnew
rs("userid")=Replace(request("userid"), "'", "''")
rs("password")=Replace(request("password"), "'", "''")
rs("name")=request("name")
rs("Province")=request("Province")
rs("sex")=request("sex")
rs("phone")=request("phone")
rs("email")=email
rs("times")=0
rs("date")=date()
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>注册成功</title>
<link rel="stylesheet" type="text/css" href="../css/style.css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
.style1 {
	font-size: 16px;
	font-weight: bold;
}
-->
</style>
</head>
<body bgcolor="#0066CC" text="0" leftmargin="0">
<TABLE width=350 border=1 align="center" cellPadding=0 cellSpacing=0 bgcolor="#FFFFFF">
  <TR> 
    <TD height="147" valign="top"  > 
    <table width="90%" border="1" align="center">
        <tr>
             <td width="100%" height="94">
               <p align="center"><span class="style1">恭喜你！注册成功！</span></p>
		           </td>
        </tr>
        <tr>
            <td width="400" height="16">
              <form method="POST" action="buy.asp">
                <p align="center">            　
                <input type="reset" name="Submit2" value="关闭窗口" class="button1" onclick="window.open('../index.html','','');self.close();">
                </p>
             </form> 
           </td>
        </tr>
    </table>
   </TD>
  </TR>
  <tr> 
    <td>　</td>
  </tr>
</TABLE>
</center>
</div>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -