Guest User

Untitled

a guest
Oct 14th, 2018
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.16 KB | None | 0 0
  1. $query = query("SELECT email FROM emails");
  2.  
  3. while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
  4.  
  5. $query1 = query("SELECT enviado FROM emails WHERE email = '".$row['email']."'");
  6. $row1 = $query1->fetch();
  7.  
  8. $query2 = query("SELECT * FROM msg WHERE id = '".$row1['enviado']."'");
  9. $row2 = $query2->fetch();
  10.  
  11. include "settings/mail.php";
  12. require 'PHPMailer/class.phpmailer.php';
  13.  
  14. // Iniciar o SMTP
  15. $mail= new PHPMailer;
  16.  
  17. // Define Charset
  18. $mail->CharSet = 'UTF-8';
  19.  
  20. // Ativar SMTP
  21. $mail->IsSMTP();
  22.  
  23. // Debugar: 1 = erros e mensagens, 2 = mensagens apenas
  24. $mail->SMTPDebug = false;
  25.  
  26. // Autenticação ativada
  27. $mail->SMTPAuth = true;
  28.  
  29. // SSL REQUERIDO pelo GMail
  30. $mail->SMTPSecure = 'ssl';
  31.  
  32. // SMTP utilizado
  33. $mail->Host = $host_smtp;
  34. $mail->Port = $port_smtp;
  35.  
  36. // Conta SMTP
  37. $mail->Username = $user_smtp;
  38. $mail->Password = $pass_smtp;
  39.  
  40. // Enviador
  41. $mail->SetFrom($user_smtp, "❤ Quero Emagrecer");
  42.  
  43. // Recptor
  44. $mail->addAddress($row['email']);
  45.  
  46. // Mensagem
  47. $mail->Subject = $row2['title'];
  48. $mail->msgHTML($row2['msg']);
  49.  
  50. // Enviar mensagem
  51. $mail->send();
  52. }
Add Comment
Please, Sign In to add comment