在PHPMailer中使用数据库中的电子邮件和名称数组

<?php
// 引入PHPMailer库
require 'path/to/PHPMailer/PHPMailerAutoload.php';

// 连接数据库
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

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

// 检查数据库连接是否成功
if ($conn->connect_error) {
    die("数据库连接失败: " . $conn->connect_error);
}

// 查询数据库
$sql = "SELECT email, name FROM users";
$result = $conn->query($sql);

// 检查查询结果是否为空
if ($result->num_rows > 0) {
    // 遍历结果
    while ($row = $result->fetch_assoc()) {
        $email = $row["email"];
        $name = $row["name"];

        // 使用PHPMailer发送邮件
        $mail = new PHPMailer;
        $mail->isSMTP();
        $mail->Host = 'smtp.qq.com';
        $mail->SMTPAuth = true;
        $mail->Username = 'your_email@example.com';
        $mail->Password = 'your_email_password';
        $mail->SMTPSecure = 'ssl';
        $mail->Port = 465;

        $mail->setFrom('your_email@example.com', 'Your Name');
        $mail->addAddress($email, $name);
        $mail->Subject = '邮件主题';
        $mail->Body = '邮件正文';

        // 发送邮件
        if (!$mail->send()) {
            echo '邮件发送失败: ' . $mail->ErrorInfo;
        } else {
            echo '邮件发送成功';
        }
    }
} else {
    echo "没有找到任何电子邮件和名称数据";
}

// 关闭数据库连接
$conn->close();
?>