kendimce sorunu hallettim, arşivlerde kalması amacıya çalışan kodu aşağıya yazıyorum.
<?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 1 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 =
$html_string =
'<html>
<body>
<h1 bgcolor="red"><b>'.date('d.m.Y').' <br> Yapılan Toplam Kilometre: <font color="red"> '.$row['Sum(kmfark)'].' </font> Km </b></h1>
<table width="600" border="2">
<thead>
<tr>
<th bgcolor="yellow">Plaka</th>
<th bgcolor="yellow">İsim Soyisim</th>
<th bgcolor="yellow">Çıkış Tarihi</th>
<th bgcolor="yellow">Geliş Tarihi</th>
<th bgcolor="yellow">Gidilen Yer</th>
<th bgcolor="yellow">Yapılan Km</th>
<tr>
</thead>
<tbody>';
$querya = mysql_query("select * from guvenlik WHERE ctarih > DATE_SUB(CURDATE(), INTERVAL 1 DAY) order by kmfark desc");
while($rowa=mysql_fetch_array($querya))
{
$html_string .=
'<tr>
<td>'.$rowa['plaka'].'</td>
<td>'.$rowa['isimsoyisim'].'</td>
<td>'.date('d-m-Y', strtotime ($rowa['ctarih'])).'</td>
<td>'.date('d-m-Y', strtotime ($rowa['gtarih'])).'</td>
<td>'.$rowa['gyer'].'</td>
<td>'.$rowa['kmfark'].'</td>
</tr>';
}
$mail->Body = $html_string .= '</tbody></table><br>
<h3>
<font color="red"> ** Bu Mail **** ERP Programı Tarafından Gönderilmektedir ** </font><br>
<font color="red"> ** UĞUR YILMAZ ** </font><br></h3>
</body></html>';
$mail->addAttachment("dosya.txt");
if ($mail->send())
echo "Mail gonderimi basarili.";
else
echo "Malesef olmadi.";
?>