php邮件订阅系统

require 'vendor/autoload.php';

use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\Exception;

$mail = new PHPMailer(true);

try {
    // Server settings
    $mail->SMTPDebug = 0;                      // Enable verbose debug output
    $mail->isSMTP();                                            // Send using SMTP
    $mail->Host       = 'smtp.example.com';                     // Set the SMTP server to send through
    $mail->SMTPAuth   = true;                                   // Enable SMTP authentication
    $mail->Username   = 'user@example.com';                     // SMTP username
    $mail->Password   = 'password';                               // SMTP password
    $mail->SMTPSecure = PHPMailer::ENCRYPTION_STARTTLS;         // Enable TLS encryption; `PHPMailer::ENCRYPTION_SMTPS` encouraged
    $mail->Port       = 587;                                    // TCP port to connect to, use 465 for `PHPMailer::ENCRYPTION_SMTPS` above

    // Recipients
    $mail->setFrom('from@example.com', 'Mailer');
    $mail->addAddress('recipient@example.com', 'Joe User');     // Add a recipient

    // Content
    $mail->isHTML(true);                                  // Set email format to HTML
    $mail->Subject = 'Here is the subject';
    $mail->Body    = 'This is the HTML message body <b>in bold!</b>';
    $mail->AltBody = 'This is the body in plain text for non-HTML mail clients';

    $mail->send();
    echo 'Message has been sent';
} catch (Exception $e) {
    echo "Message could not be sent. Mailer Error: {$mail->ErrorInfo}";
}

// 假设确认链接格式为 /confirm-subscription.php?token=xxxxxx
if (isset($_GET['token'])) {
    $token = $_GET['token'];

    // 验证令牌并更新数据库中的确认状态
    $stmt = $pdo->prepare("SELECT * FROM subscriptions WHERE token = ?");
    $stmt->execute([$token]);
    $subscription = $stmt->fetch();

    if ($subscription && !$subscription['confirmed']) {
        $stmt = $pdo->prepare("UPDATE subscriptions SET confirmed = 1 WHERE token = ?");
        $stmt->execute([$token]);
        echo "Subscription confirmed successfully!";
    } else {
        echo "Invalid or expired confirmation link.";
    }
}