如何发送从数据库中检索电子邮件模板并向模板中插入变量PHPMailer

<?php
require 'path/to/PHPMailerAutoload.php';

// 连接到数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("数据库连接失败: " . $conn->connect_error);
}

// 检索电子邮件模板
$sql = "SELECT template FROM email_templates WHERE id = 1";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    $row = $result->fetch_assoc();
    $template = $row["template"];

    // 插入变量
    $name = "John Doe";
    $email = "johndoe@example.com";
    $message = "Hello, {{name}}! This is a test email.";

    $template = str_replace("{{name}}", $name, $template);
    $template = str_replace("{{email}}", $email, $template);
    $template = str_replace("{{message}}", $message, $template);

    // 配置PHPMailer
    $mail = new PHPMailer;
    $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($email, $name);
    $mail->Subject = 'Test Email';
    $mail->Body = $template;

    // 发送邮件
    if ($mail->send()) {
        echo '邮件发送成功';
    } else {
        echo '邮件发送失败: ' . $mail->ErrorInfo;
    }
} else {
    echo '未找到电子邮件模板';
}

$conn->close();
?>