php--简单邮件列表的订阅与取消订阅

最新推荐文章于 2021-06-30 12:49:31 发布

虾米大王

最新推荐文章于 2021-06-30 12:49:31 发布

阅读量854

点赞数

分类专栏： php 文章标签： php

本文链接：https://blog.csdn.net/modern358/article/details/90611442

版权

php 专栏收录该内容

177 篇文章 19 订阅

订阅专栏

数据库连接文件inclulde1.php

<?php
/**
 * Created by PhpStorm.
 */

function doDB()
{
    global $conn;
    $conn = mysqli_connect('localhost','root','','php_project01');
    if(mysqli_connect_errno())
    {
        echo '数据库连接失败'.mysqli_connect_error()."<br>";
        exit();
    }

}


function emailchecker($email)
{
    global $conn,$safe_email,$check_result;
    $safe_email = mysqli_real_escape_string($conn,$email);  //防止sql注入攻击
    $sql = "select id from subcribers where email= '$email'";
    $check_result = mysqli_query($conn,$sql) or die(mysqli_error($conn));
}

manage.php

<?php
/**
 * Created by PhpStorm.
 */

include_once ('include1.php');
if(!$_POST)
{
    $display_block = <<< END_OF_BLOCK
    <form method="post" action="$_SERVER[PHP_SELF]">
    <p><label for="email">邮件地址:</label><br>
    <input type="email" id="email" name="email" size="40" maxlength="150"></p>
    <fieldset>
        <legend>执行动作：</legend>
        <input type="radio" id="action_sub" name="action" value="sub" checked="checked">
        <label for="action_sub">订阅</label>
        <input type="radio" id="action_unsub" name="action" value="unsub">
        <label for="action_unsub">取消订阅</label>
</fieldset>  
<button type="submit" name="submit" value="submit">提交</button>
&nbsp;&nbsp;&nbsp;&nbsp;<a href="../index.php">回到首页</a>
&nbsp;&nbsp;&nbsp;&nbsp;<a href="sendmymail.php">发送邮件</a>
</form>
END_OF_BLOCK;

}
else if(($_POST) && ($_POST['action'] == 'sub'))
{
    if($_POST['email'] == "")
    {
        header('location:manage.php');
        exit;
    }
    else
    {
        doDB();
        emailchecker($_POST['email']);

        if(mysqli_num_rows($check_result) < 1)
        {
            mysqli_free_result($check_result);
            $sql_add = "insert into subcribers(email) values ('$safe_email')";
            $result_add = mysqli_query($conn,$sql_add) or die(mysqli_error($conn));
            $display_block = "<p>感谢报名参与，已订阅成功!</p>";
            mysqli_close($conn);
        }
        else
        {
            $display_block = "<p>已经订阅过了！</p>";
        }
    }

}
else if(($_POST) && ($_POST['action'] == 'unsub'))
{
    if($_POST['email'] == "")
    {
        header('location:manage.php');
        exit;
    }
    else
    {
        doDB();
        emailchecker($_POST['email']);
        if(mysqli_num_rows($check_result) < 1)
        {
            mysqli_free_result($check_result);
            $display_block = "<p>没有找到该邮件地址！</p>";
        }
        else
        {
            while($row = mysqli_fetch_array($check_result))
            {
                $id = $row['id'];
                $sql_del = "delete from subcribers where id = $id";
                $result_del = mysqli_query($conn,$sql_del);
                $display_block = "<p>已取消订阅！</p>";
            }


        }
        mysqli_close($conn);


    }
}

?>

<html>
<head>
    <title>简单邮件列表的订阅与取消订阅操作</title>
</head>
<body>
<h1>简单邮件列表的订阅与取消订阅操作</h1>
<?php echo "$display_block"; ?>
</body>
</html>

sendmyemail.php

<?php
/**
 * Created by PhpStorm.
 */

include_once ('include1.php');
require_once ("src/PHPMailer.php");  //必须引入此3个文件，否则出错
require_once ('src/Exception.php');
require_once ('src/SMTP.php');

if(!$_POST)
{
    $display_block = <<< end_of_block
    <form method="post" action="$_SERVER[PHP_SELF]">
    <p><label for="subject">主题：</label><br>
    <input type="text" id="subject" name="subject" size="40"></p>
    <p><label for="message">邮件内容：</label><br>
    <textarea id="message" name="message" rows="10" cols="50"></textarea></p>
    <button type="submit" name="submit" value="submit">提交</button>
    &nbsp;&nbsp;&nbsp;&nbsp;<a href="manage.php">回到首页</a>
</form>
end_of_block;

}
else if($_POST)
{
    if(($_POST['subject'] == "") || ($_POST['message'] == ""))
    {
        header('Location:sendmymail.php');
        exit;

    }

    doDB();
    if(mysqli_connect_errno())
    {
        echo '数据库连接失败'.mysqli_connect_error()."<br>";
        exit();
    }
    else
    {
        $sql = 'select email from subcribers';
        $result = mysqli_query($conn,$sql) or die(mysqli_error($conn));

        $mail_header = "xxx@163.com";    //记得替换
        while ($row = mysqli_fetch_array($result))
        {
            set_time_limit(0);
            $email = $row['email'];
            $subject = $_POST['subject'];
            $message = $_POST['message'];
            $smtp = 'smtp.163.com';
            $port = 465;  //一般端口都是465
            $user_name = 'xxx@163.com';  // 记得替换
            $password = 'xxxx';     // 记得替换


            $mail = new \PHPMailer\PHPMailer\PHPMailer();
            $mail->isSMTP();
            $mail->SMTPAuth = true;
            $mail->SMTPSecure = 'ssl';
            $mail->Host = $smtp;
            $mail->Port = $port;
            $mail->CharSet = 'utf-8';
            $mail->Username = $user_name;
            $mail->Password = $password;
            $mail->From = $mail_header;
            $mail->FromName = $mail_header;
            $mail->Subject = $subject;
            $mail->Body = $message;
            $mail->isHTML(true);
            $mail->addAddress($email);

            if(!$mail->send())
            {
                echo "发送错误：".$mail->ErrorInfo."<br>";
            }
            else
            {
                @$display_block .= "已成功发送至：$email"."<br>";
            }



        }
        mysqli_free_result($result);
        mysqli_close($conn);
    }
}

?>

<html>
<head>
    <title>发送一封信件</title>

</head>
<body>
    <h1>发送一封信件</h1>
    <?php echo $display_block; ?>
</body>
</html>

数据库文件

-- phpMyAdmin SQL Dump
-- version 4.8.4
-- https://www.phpmyadmin.net/
--
-- 主机： 127.0.0.1
-- 生成日期： 2019-05-27 
-- 服务器版本： 10.1.37-MariaDB
-- PHP 版本： 7.3.1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- 数据库： `php_project01`
--
CREATE DATABASE IF NOT EXISTS `php_project01` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `php_project01`;

-- --------------------------------------------------------

--
-- 表的结构 `subcribers`
--

DROP TABLE IF EXISTS `subcribers`;
CREATE TABLE `subcribers` (
  `id` int(11) NOT NULL,
  `email` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 转储表的索引
--

--
-- 表的索引 `subcribers`
--
ALTER TABLE `subcribers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`);

--
-- 在导出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `subcribers`
--
ALTER TABLE `subcribers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;