Mysql den veri çekip Mail Gönderme Hakkında

20-11-2018, 10:44:08

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.";


?>

21-11-2018, 13:02:04

ugurylmz2121

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.";


?>