PHP および PHPMAILER を使用して Web サイトにメール送信のグループ管理機能を実装する方法を学習します。

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

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();