PHP中通过多选框从数据库获取邮件地址并发送邮件的教程

<form action="send_emails.php" method="post">
    <table>
        <thead>
            <tr>
                <th>选择</th>
                <th>用户ID</th>
                <th>姓名</th>
                <th>邮箱</th>
            </tr>
        </thead>
        <tbody>
            <?php
            // 假设 $users 是从数据库查询到的用户数组
            // 示例数据，实际应用中应从数据库获取
            $users = [
                ['id_user' => 1, 'name' => '张三', 'surname' => '张', 'email' => 'zhangsan@example.com'],
                ['id_user' => 2, 'name' => '李四', 'surname' => '李', 'email' => 'lisi@example.com'],
                ['id_user' => 3, 'name' => '王五', 'surname' => '王', 'email' => 'wangwu@example.com'],
            ];

            foreach ($users as $row) {
                echo '<tr>';
                echo '<td><input type="checkbox" name="emails[]" value="' . htmlspecialchars($row['email']) . '"></td>';
                echo '<td>' . htmlspecialchars($row['id_user']) . '</td>';
                echo '<td>' . htmlspecialchars($row['name']) . '</td>';
                echo '<td>' . htmlspecialchars($row['email']) . '</td>';
                echo '</tr>';
            }
            ?>
        </tbody>
    </table>
    <button type="submit">发送邮件</button>
</form>

<?php

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // 检查是否有邮件被选中
    if (isset($_POST['emails']) && is_array($_POST['emails']) && !empty($_POST['emails'])) {
        $selectedEmails = $_POST['emails'];
        $emailId = "";

        // 遍历选中的邮件地址数组，拼接成逗号分隔的字符串
        foreach ($selectedEmails as $email) {
            // 对每个邮箱地址进行基本的验证和清理
            $cleanedEmail = filter_var($email, FILTER_SANITIZE_EMAIL);
            if (filter_var($cleanedEmail, FILTER_VALIDATE_EMAIL)) {
                if (!empty($emailId)) {
                    $emailId .= ","; // 添加逗号分隔符
                }
                $emailId .= $cleanedEmail;
            } else {
                // 可以记录无效邮箱或跳过
                error_log("Invalid email detected: " . $email);
            }
        }

        // 只有当有有效的邮件地址时才尝试发送
        if (!empty($emailId)) {
            $from = "sender@example.com"; // 发件人邮箱
            $subject = "来自您的网站的通知"; // 邮件主题
            $message = "这是一封测试邮件，PHP邮件功能运行正常。"; // 邮件内容

            // 设置邮件头
            $headers = "From: " . $from . "\r\n";
            $headers .= "Reply-To: " . $from . "\r\n";
            $headers .= "MIME-Version: 1.0\r\n";
            $headers .= "Content-Type: text/html; charset=UTF-8\r\n"; // 如果邮件内容是HTML格式

            // 使用mail()函数发送邮件
            if (mail($emailId, $subject, $message, $headers)) {
                echo "邮件已成功发送给以下收件人：" . htmlspecialchars($emailId);
            } else {
                echo "邮件发送失败，请检查服务器配置。";
                error_log("Mail sending failed to: " . $emailId); // 记录错误日志
            }
        } else {
            echo "没有选择有效的收件人邮件地址。";
        }
    } else {
        echo "请至少选择一个收件人。";
    }
} else {
    echo "非法请求方法。";
}

?>