?? joinserver.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 + -