<?php
//session_start();
require_once("../connect.php");
$db=db_connect();
extract($_POST);
//die($userN);
$matNo=strtoupper($userN);
$aspoa="select * from realdata where matNo='$matNo'";
$aspoa=$db->query($aspoa);
$aspoa_count=$aspoa->rowCount();
//die();
// support functions
require('../PHPMailer/src/PHPMailer.php');
require('../PHPMailer/src/SMTP.php');
require('../PHPMailer/src/Exception.php');

$mail = new PHPMailer\PHPMailer\PHPMailer();
//
//

function SendSMTPLoginMail($email,$username,$pwd,$usern) {
    $mailmsg = "<strong><u>STUDENT PORTAL LOGIN INFORMATION</u></strong><BR>";
    $mailmsg .= "<p>Dear $username,</p>Please find below the access credential to FPE ePortal.<br>";
    $mailmsg .= "<br>Username: $usern";
    $mailmsg .= "<br>Password: $pwd";
    $mailmsg .= "<br><br>Please make sure you change this password immediately you logged in.";
    $mailmsg .= "<br><br>Thanks you.";
    //
    $reply = SMTPSendMail($email, $mailmsg);
    return $reply;
}
//

function SMTPSendMail($email,$mailmsg)
{
    //Create a new PHPMailer instance
    global $mail;
    //Tell PHPMailer to use SMTP
    $mail->isSMTP();
    $mail->Host = 'mail.federalpolyede.edu.ng';
    //Set the SMTP port number - likely to be 25, 465 or 587
    $mail->Port = 25;
    //Whether to use SMTP authentication
    $mail->SMTPAuth = true;
    //Do not  use SSL
    $mail->SMTPAutoTLS = false;
    // Set email format to HTML
    $mail->isHTML(true);
    //Username to use for SMTP authentication
    $mail->Username = '[email protected]';
    //Password to use for SMTP authentication
//    $mail->Password = 'eih1V15&';
    $mail->Password = '5yJn0c^19';
    //Set who the message is to be sent from
    $mail->setFrom('[email protected]', 'FedPolyEde ICT Support');
    //Set who the message is to be sent to
    $mail->addAddress($email, 'User Feedback');
    //Set the subject line
    $mail->Subject = 'Students\' Profile Access Information';
    //Read an HTML message body from an external file, convert referenced images to embedded,
    //convert HTML into a basic plain-text alternative body
    $mail->msgHTML($mailmsg);
    //Replace the plain text body with one created manually
    $retvalue = "";


    if (!$mail->send())
        echo $retvalue = 'Mailer Error: ' . $mail->ErrorInfo;
    else

        $retvalue = "OK";
    //
    return $retvalue;
//            echo ("here");

}
//
//$_SESSION['sendMailID']=1;
if ($aspoa_count==1) {
    $aspoa_fetch = $aspoa->fetch(PDO::FETCH_BOTH);
      $email = $aspoa_fetch['email'];
//   echo $email = '[email protected]';
     $names = $aspoa_fetch['names'];
     $password = $aspoa_fetch['passworda'];
     $usern = $aspoa_fetch['usernamea'];
     $atNo = $aspoa_fetch['matNo'];
//die();
    SendSMTPLoginMail($email, $names, $password,$usern);
//echo "here";

      header('location:login_Consult.php?sendMailID=1');

} else {
     header('location:login_Consult.php?sendMailID=2');
}

?>