PHP实现邮件订阅功能的技巧

<fORM action="subscribe.php" method="post">
    <label for="email">请输入您的邮箱地址：</label>
    <input type="text" id="email" name="email" required>
    <input type="submit" value="订阅">
</form>

CREATE TABLE `subscribe` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL DEFAULT '',
  `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

$email = $_POST['email'];
$message = '订阅成功！';
try {
    $conn = new PDO('Mysql:host=localhost;dbname=your_db_name;charset=utf8mb4', 'your_db_username', 'your_db_passWord');
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $stmt = $conn->prepare("INSERT INTO subscribe (email) VALUES (:email)");
    $stmt->bindParam(':email', $email);
    $stmt->execute();
    $conn = null;
} catch(PDOException $e) {
    $message = '订阅失败，请稍后再试！';
}

echo $message;

require '../PHPMailer/PHPMailerAutoload.php';

// 获取订阅数据
try {
    $conn = new PDO('mysql:host=localhost;dbname=your_db_name;charset=utf8mb4', 'your_db_username', 'your_db_password');
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $stmt = $conn->prepare("SELECT email FROM subscribe");
    $stmt->execute();
    $result = $stmt->fetchAll();
    $conn = null;
} catch(PDOException $e) {
    die($e->getMessage());
}

// 发送邮件
$mail = new PHPMailer();
$mail->ISSMTP();
$mail->CharSet = 'UTF-8';

$mail->SMTPDebug = 0;
$mail->SMTPAuth = true;
$mail->SMTPSecure = 'ssl';
$mail->Host = 'smtp.gmail.com';
$mail->Port = 465;
$mail->Username = 'your_email_address';
$mail->Password = 'your_email_password';

$mail->From = 'your_email_address';
$mail->FromName = 'your_WEBsite_name';
$mail->Subject = '最新资讯';
$mail->AltBody = '';
$mail->WordWrap = 50;

foreach ($result as $row) {
    $mail->AddAddress($row['email'], '');
}

$mail->Ishtml(true);
$mail->Body = '最新资讯内容';

if(!$mail->Send()) {
    echo '发送邮件失败！';
} else {
    echo '发送邮件成功！';
}