PHPMAILER library sending duplicate emails

Question

I have a PHP code that sends data to Phpmailer (data resulting from a query in the database).

The problem is that when Phpmailer fires the email, it arrives duplicated in the inbox of who should receive the email.

public function editarChamados()
{   
  try 
  {
      $c = new Conexao();
      $db = $c->conectar();                                 

      if($this->descricao <> "")
      {                                 
          $descricao = "Olá";
            
        $query = "START TRANSACTION;
        SET @responsavel := (SELECT usuario FROM usuarios_ti WHERE id = :responsavel_ti);
        UPDATE chamados SET id_usuario_ti = :responsavel_ti, titulo = :titulo WHERE id = :id;
        INSERT INTO dialogo_chamados(id_chamado,dialogo,remetente)VALUE(:id,'$descricao',@responsavel);                                     
      COMMIT;
      ";

      $stmt = $db->prepare($query);
      $stmt->bindValue(":responsavel_ti",$this->responsavel_ti);    
      $stmt->bindValue(":titulo",$this->titulo);                        
      $stmt->bindValue(":id",$this->id);    

      if($stmt->execute())
      {
      //Chamando método que envia o email
      $this->enviarEmail();
      echo "sucesso";
      die();                            
      }
      else
      {
      print_r($stmt->errorInfo());
      }


      }                                                 

  } 
  catch(PDOException $e) 
  {
    echo "Erro: ".$e->getCode()." Mensagem: ".$e->getMessage();             
  }
}

//Método de envio de email
public function enviarEmail()
{

    $c = new Conexao();
    $db = $c->conectar();

    $query = "SELECT a.dialogo, a.remetente, a.data_dialogo, b.solicitante FROM dialogo_chamados AS a 
    INNER JOIN chamados AS b ON b.id = a.id_chamado WHERE b.id = :id ORDER BY a.data_dialogo";

    $stmt = $db->prepare($query);
    $stmt->bindValue(":id",$this->id);                  
    $stmt->execute();           

    $dialogos = $stmt->fetchAll(PDO::FETCH_ASSOC);


    require 'PHPMailer/src/Exception.php';
    require 'PHPMailer/src/PHPMailer.php';
    require 'PHPMailer/src/SMTP.php';

    $mailer = new PHPMailer();

    try
    {

        $nome_remetente = $this->nome_responsavel_ti;
        $email_remetente = $this->email_responsavel_ti;
        $email_destinatario = $this->email_solicitante;
        $titulo_chamado = $this->titulo;
        $data_abertura_chamado = $this->data_abertura_chamado;

        $mailer->setLanguage('br');
        $mailer->CharSet = "utf8";
        $mailer->IsSMTP();
        //$mailer->SMTPDebug = 4;
        $mailer->SMTPAuth = true;
        $mailer->SMTPSecure = "tls";
        $mailer->Host = "smtp.skymail.net.br";
        $mailer->Port = 587;
        $mailer->Username = '[email protected]';
        $mailer->Password = "54h54fg6j4g6j";
        $mailer->Priority = 1;
        $mailer->addReplyTo($email_remetente, $nome_remetente);
        $mailer->setFrom('[email protected]', "JCA - Suporte Tecnico");
        $mailer->AddAddress($email_destinatario);
        $mailer->IsHTML(true);
        $mailer->Subject = 'Mensagem do Suporte Tecnico';
      
        $mensagem = "CONTEÚDO DO EMAIL";
     
        $mailer->Body = $mensagem;

        if($mailer->Send())
        { 
          $mailer->ClearAllRecipients();
          $mailer->ClearAttachments();
        } 
        else 
        { 
          echo "Mailer Error: " . $mailer->ErrorInfo;
          die();
        }   

    } 
    catch(PDOException $e) 
    {
       echo "Erro: ".$e->getCode()." Mensagem: ".$e->getMessage();
    }                           
}

Answer 1

• I solved the problem using the PHPMAILER method, ClearAddresses().
• I have been reading and I saw that this method is used to delete the destination addresses that were previously passed in the method AddAddress().

The part of the code I changed was like this:

if($mailer->Send())
{ 
    $mailer->ClearAllRecipients();
    $mailer->ClearAttachments();
    $mailer->ClearAddresses(); 
} 

Reference: Programacion.net