Help PHPMailer

0

I reconfigure my question as I solve the first problem

Here we have what we receive by POST and AJAX of the form and we put it in the SQL

<?php
 include "../conexion/conexion.php";

 mysqli_set_charset($mysqli, "utf8");
 $results = 'SELECT * FROM Usuarios';
 $rec = mysqli_query($mysqli, $results);

 if ($rec === false) {
 die('ERROR SQL: ' . htmlspecialchars(mysqli_error($mysqli)));
 }
 while ($results = mysqli_fetch_object($rec)) {

if(mb_strtolower($results->Username) == mb_strtolower($_POST['email'])) 
 {

die('<div class=\'form\'> 
     <div class="alert alert-danger" style="font-size: 14px;"> 
      <strong>¡Error!</strong> Este usuario ya esta en uso.</div>         
    </div>');
 }

 }

$name = mysqli_real_escape_string($mysqli, $_POST['name']);
$email = mysqli_real_escape_string($mysqli, $_POST['email']);
$telefono = mysqli_real_escape_string($mysqli, $_POST['telefono']);
$movil = mysqli_real_escape_string($mysqli, $_POST['movil']);
$nif = mysqli_real_escape_string($mysqli, $_POST['nif']);
$direccion = mysqli_real_escape_string($mysqli, $_POST['direccion']);
$postal = mysqli_real_escape_string($mysqli, $_POST['postal']);
$poblacion = mysqli_real_escape_string($mysqli, $_POST['poblacion']);
$provincia = mysqli_real_escape_string($mysqli, $_POST['provincia']);
$pass = mysqli_real_escape_string($mysqli, $_POST['pass']);
$sexo = mysqli_real_escape_string($mysqli, $_POST['sexo']);

$fecha = date('y,m,d');

$results = "
INSERT INTO Usuarios (
    Fecha,
    Sexo,
    Nombre,
    Password,
    Username,
    Direccion,
    Postal,
    Poblacion,
    Provincia,
    Telefono,
    Movil,
    Dni,
    intestado
) VALUES (
    '$fecha',
    '$sexo',
    '$name',
    '$pass',
    '$email',
    '$direccion',
    '$postal',
    '$poblacion',
    '$provincia',
    '$telefono',
    '$movil',
    '$nif',
    '1'
   )
  ";
 if (mysqli_query($mysqli, $results) === false) {
/* Aquí olvidaste poner como primer parámetro la conexión mysqli */
die('Error SQL: ' . htmlspecialchars(mysqli_error($mysqli)));
}

Then we have the PHPMailer

include "../PHPMailer/class.phpmailer.php";
include "../PHPMailer/class.smtp.php";

$email_user = "[email protected]";
$email_password = "churrero";
$the_subject = "Bienvenid@ $name";
$address_to = "[email protected]";
$from_name = "Depildiodo";
$body = file_get_contents("http://webnueva.depildiodo.com/plantillaEmail/template.html");
$phpmailer = new PHPMailer();

$phpmailer->Username = $email_user;
$phpmailer->Password = $email_password; 
$phpmailer->SMTPDebug = 1;
$phpmailer->SMTPSecure = 'ssl';
$phpmailer->Host = "mail.depildiodo.com"; // GMail
$phpmailer->Port = 465;
$phpmailer->IsSMTP(); // use SMTP
$phpmailer->SMTPAuth = true;
$phpmailer->setFrom($phpmailer->Username,$from_name);
$phpmailer->AddAddress($address_to); // recipients email
$phpmailer->Subject = $the_subject; 
$phpmailer->Body = $body;
//$phpmailer->Body .="<h1 style='color:#3498db;'>Hola $name!</h1>";
//$phpmailer->Body .= "<p>Mensaje personalizado</p>";
//$phpmailer->Body .= "<p>Fecha y Hora: ".date("d-m-Y h:i:s")."</p>";
$phpmailer->IsHTML(true);
$phpmailer->Send();

And then the template of the mail; / templateEmail/template.html (This is in another file)

And what I need is that the information I bring for POST to put in that template.

    
asked by Miguel 02.10.2018 в 10:35
source

0 answers