Arkadaşlar aşağıdaki kodlarda ne sorun olabilir ki 2 gündür uğraşıyorum yapamıyorum. $mail->Body = kısmından Mysql den çektiğim verileri mail olarak gönderemiyorum.
<?php
include("baglan.php");
use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\Exception;
require 'PHPMailer/src/Exception.php';
require 'PHPMailer/src/PHPMailer.php';
require 'PHPMailer/src/SMTP.php';
$mail = new PHPMailer();
$mail->SetLanguage("tr", "phpmailer/language");
$mail->CharSet ="utf-8";
$mail->Encoding="base64";
$mail->isSMTP();
$mail->SMTPKeepAlive = true;
$mail->SMTPAuth = true;
$mail->SMTPSecure = 'tls'; //ssl
$mail->Port = 587; //25 , 465 , 587
$mail->Host = "smtp.gmail.com";
$mail->Username = "****@gmail.com";
$mail->Password = "*****";
$mail->setFrom("****@gmail.com");
$mail->addAddress("*****@gmail.com");
$query = mysql_query("select Sum(kmfark) from guvenlik WHERE ctarih > DATE_SUB(CURDATE(), INTERVAL 2 DAY) ORDER BY `Sum(kmfark)` DESC limit 100");
$row = mysql_fetch_array($query);
$mail->isHTML(true);
$mail->Subject = date('d.m.Y').' - Güvenlik Kilometre Raporu : '.$row['Sum(kmfark)'].' Kilometre' ;
$mail->Body =
echo "<table width='600' border='1'>";
echo "<tr>";
echo "<th>Plaka</th>";
echo "<th>İsim Soyisim</th>";
echo "<th>Çıkış Tarihi</th>";
echo "<th>Geliş Tarihi</th>";
echo "<th>Gidilen Yer</th>";
echo "<th>Yapılan Km</th>";
echo "</tr>";
$querya = mysql_query("select * from guvenlik WHERE ctarih > DATE_SUB(CURDATE(), INTERVAL 2 DAY) order by kmfark desc");
while($rowa=mysql_fetch_array($querya))
{
echo "<tr>";
echo "<td>".$rowa['plaka']."</td>";
echo "<td>".$rowa['isimsoyisim']."</td>";
echo "<td>".$rowa['ctarih']."</td>";
echo "<td>".$rowa['gtarih']."</td>";
echo "<td>".$rowa['gyer']."</td>";
echo "<td>".$rowa['kmfark']."</td>";
echo " </tr>";
}
echo "</table>";
$mail->addAttachment("dosya.txt");
if ($mail->send())
echo "Mail gonderimi basarili.";
else
echo "Malesef olmadi.";
?>