从sql查询结果创建动态html表以用于phpmailer的邮件列表

SELECT email FROM users WHERE subscribed = 1;

$result = mysqli_query($connection, "SELECT email FROM users WHERE subscribed = 1");

if (mysqli_num_rows($result) > 0) {
    $table = '<table>';
    while ($row = mysqli_fetch_assoc($result)) {
        $email = $row['email'];
        $table .= '<tr><td>' . $email . '</td></tr>';
    }
    $table .= '</table>';
} else {
    $table = 'No results found.';
}

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

require 'vendor/autoload.php';

$mail = new PHPMailer(true);

try {
    $mail->isSMTP();
    $mail->Host = 'smtp.example.com';
    $mail->SMTPAuth = true;
    $mail->Username = 'your_email@example.com';
    $mail->Password = 'your_password';
    $mail->SMTPSecure = 'tls';
    $mail->Port = 587;

    $mail->setFrom('your_email@example.com', 'Your Name');
    $mail->addAddress('recipient@example.com', 'Recipient Name');

    $mail->isHTML(true);
    $mail->Subject = 'Email List';
    $mail->Body = $table;

    $mail->send();
    echo 'Email sent successfully.';
} catch (Exception $e) {
    echo 'Email could not be sent. Error: ' . $mail->ErrorInfo;
}