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.