通过PHP和PHPMAILER学习如何在网站中实现邮件发送的分组管理功能

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

composer require phpmailer/phpmailer

<?php
require 'vendor/autoload.php';

// 获取所有分组
function getAllGroups($pdo) {
  $stmt = $pdo->prepare("SELECT * FROM `groups`");
  $stmt->execute();

  return $stmt->fetchAll();
}

// 获取指定分组的所有用户
function getUsersByGroup($pdo, $groupId) {
  $stmt = $pdo->prepare("SELECT * FROM `users` WHERE `group_id` = ?");
  $stmt->execute([$groupId]);

  return $stmt->fetchAll();
}

// 发送邮件
function sendEmail($sender, $receiver, $subject, $content) {
  $mail = new PHPMailerPHPMailerPHPMailer();
  
  $mail->CharSet = 'UTF-8';
  $mail->isSMTP();
  $mail->SMTPDebug  = 0;
  $mail->Host       = 'smtp.gmail.com'; // 邮件服务器地址
  $mail->SMTPAuth   = true;
  $mail->Username   = 'your-email@gmail.com'; // 发件人邮箱地址
  $mail->Password   = 'your-email-password'; // 发件人邮箱密码
  $mail->SMTPSecure = 'ssl';
  $mail->Port       = 465;

  $mail->setFrom($sender); // 发件人邮箱地址
  $mail->addAddress($receiver); // 收件人邮箱地址
  $mail->isHTML(true);
  $mail->Subject = $subject;
  $mail->Body    = $content;

  return $mail->send();
}

// 发送分组邮件
function sendGroupEmail($groupId, $subject, $content) {
  global $pdo;

  $users = getUsersByGroup($pdo, $groupId);
  
  foreach ($users as $user) {
    $receiver = $user['email'];
    sendEmail('your-email@gmail.com', $receiver, $subject, $content);
  }
}

// 测试发送邮件
function testSendEmail() {
  sendEmail('your-email@gmail.com', 'receiver-email@gmail.com', '测试邮件', '这是一封测试邮件。');
}

// 测试发送分组邮件
function testSendGroupEmail() {
  sendGroupEmail(1, '测试分组邮件', '这是一封测试分组邮件。');
}

// 测试代码
testSendEmail();
testSendGroupEmail();