php - 从数据库中获取数据并通过 phpMailer 发送到邮件

Question

我正在尝试获取发布到数据库的数据并使用 phpMailer 发送到邮件。下面是获取和发送相同数据的代码。

问题是，我无法获取和发送

<?php

$mail = new PHPMailer(true);
         $mail->SMTPDebug = false;                                       // Enable verbose debug output
   // $mail->isSMTP();                                            // Set mailer to use SMTP
        $mail->Host = gethostbyname('smtp.bluehost.com');  // Specify main and backup SMTP servers
        $mail->SMTPAuth   = true;                                   // Enable SMTP authentication
        $mail->Username   = '****@gmail.com';                     // SMTP username
        $mail->Password   = '*****';                               // SMTP password
        $mail->SMTPSecure = 'tls';                                  // Enable TLS encryption, `ssl` also accepted
        $mail->Port       = 587; 
        $mail->addAddress('****@gmail.com', 'title');
        require_once("config.php");
        $sql = "SELECT * FROM order";
        $result = mysqli_query($conn, $sql);
        $email = $_POST['email'];
        $mail->setFrom($email, 'title');
        $mail->Subject = 'Test email!';
        $mail->isHTML(true);
        $message ='
        echo "<br>";
        echo "<table border='1'>";
        while ($row = mysqli_fetch_assoc($result)) { 
        echo "<tr>";
        foreach ($row as $field => $value) {  foreach($row as $value) {
        echo "<td>" . $value . "</td>";  
        }
        echo "</tr>";
        }
        echo "</table>";
        '
        $mail->Body = ($message);

       if( !$mail->send() ) echo 'wrong';
        else echo 'Mail sent';

}
?>

结果应该是，使用表容器获取数据并发送到数据库

标签： phpsqlphpmailer