userRecover.php

<?php
    include('session.php');
    require 'php/PHPMailerAutoLoad.php';
    include 'php/functions.php';
    
    $username=$_POST['username'];
    $username = stripslashes($username);
    $username = mysqli_real_escape_string($connection, $username);
    //$mailnome = mysqli_real_escape_string($_POST["username"]);
    $query_sql = "SELECT user_mail FROM users WHERE user_name='$username'";
    
    $query = mysqli_query($connection, $query_sql);
    $row = mysqli_fetch_assoc($query);
    $mailnome = $row['user_mail'];
    
    $mailpw = randomPassword();
    $query = "UPDATE users SET  user_pw='" . sha1($mailpw) . "' where user_name='" . $mailnome . "';";


$mail = new PHPMailer;

//$mail->SMTPDebug = 3;                               // Enable verbose debug output

$mail->isSMTP();                                      // Set mailer to use SMTP
$mail->Host = 'smtp.gmail.com;smtp-relay.gmail.com';  // Specify main and backup SMTP servers
$mail->SMTPAuth = true;                               // Enable SMTP authentication
$mail->Username = 'info.condominus@gmail.com';                 // SMTP username
$mail->Password = 'arkham2016';                           // SMTP password
$mail->SMTPSecure = 'tls';                            // Enable TLS encryption, `ssl` also accepted
$mail->Port = 587;                                    // TCP port to connect to

$mail->setFrom('info.condominus@gmail.com', 'Condominus SA');
$mail->addAddress($mailmail, $mailnome);     // Add a recipient
//$mail->addAddress('pedrofilipe_17@hotmail.com', 'Pedro Palha');               // Name is optional
$mail->addReplyTo('info.condominus@gmail.com', 'Information');
//$mail->addCC('cc@example.com');
//$mail->addBCC('bcc@example.com');

//$mail->addAttachment('/var/tmp/file.tar.gz');         // Add attachments
//$mail->addAttachment('/tmp/image.jpg', 'new.jpg');    // Optional name
$mail->isHTML(true);                                  // Set email format to HTML

$mail->Subject = 'Pedido de nova password';
$mail->Body    = 'This is the HTML message body <b>in bold!</b> and your new password is:' . $mailpw;
$mail->AltBody = 'This is the body in plain text for non-HTML mail clients';

    if (($mail->send())) {
        echo    "<script type=\"text/javascript\">".
                    "alert('Envio de nova password feito com sucesso');"
                .   "window.location = 'painel.php';".
                "</script>";

    } 
    else {
        echo "<script type=\"text/javascript\">".
                    "alert('Erro');".
             "</script>";
    }
    $connection->close();
   
?>