📄 emaillist.asp

📁 体育商城

💻 ASP

字号:

<%@LANGUAGE="VBSCRIPT"%> 
<!--#include file="Connections/conn.asp" -->
<%

if(request("email") <> "") then Command1__aa = request("email")

%>
<%

if(request("email") <> "") then Command2__ddd = request("email")

%>


<html>
<head>
<title>邮件订阅</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="ddd.css" type="text/css">
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<!--#include file="top.asp" -->
<table width="771" border="0" cellspacing="0" cellpadding="0" align="center" height="76" class="bk1">
  <tr> 
    <td height="80"> 
      <div align="center"> 
        <p>
<%if request("email")="" then
response.write "请输入您的邮箱。"&"<a href=default.asp>回到首页</a>"
else
if request("sfding")="-1" then
set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_conn_STRING
Command1.CommandText = "INSERT INTO  emaillist( email)  VALUES ('" + Replace(Command1__aa, "'", "''") + "') "
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()
response.write "您已成功订阅了本站的最新信息。谢谢您对我们的支持。"&"<a href=default.asp>回到首页</a>"
else
set Command2 = Server.CreateObject("ADODB.Command")
Command2.ActiveConnection = MM_conn_STRING
Command2.CommandText = "DELETE FROM emaillist WHERE email='" + Replace(Command2__ddd, "'", "''") + "'"
Command2.CommandType = 1
Command2.CommandTimeout = 0
Command2.Prepared = true
Command2.Execute()
response.write "您已取消订阅了本站的最新信息。谢谢您对我们的支持。"&"<a href=default.asp>回到首页</a>"
end if
end if
%></p>
        <p>&nbsp;</p>
      </div>
    </td>
  </tr>
</table>
<br>
<!--#include file="bottom.asp" -->
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -