<?php
require_once("../connect.php");
$db=db_connect();
extract($_POST);
//die($userN);
//$matNo=strtoupper($userN)='AC201405398DPT';
//$matNo='AC201405398DPT';
$aspoa="select * from realdata where matNo='$matNo'";
$aspoa=$db->query($aspoa);
$aspoa_count=$aspoa->rowCount();

// 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)
{
    $mailmsg = "<strong><u>PORTAL LOGIN INFORMATION</u></strong><BR>";
    $mailmsg .= "<p>Dear $username,</p>Please find below the access credential to ICT Portal.<br>";
    $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;
    // 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 = 'Ku~8h1m9';
    //Set who the message is to be sent from
    $mail->setFrom('[email protected]', 'ICT Tech Support');
    //Set who the message is to be sent to
    $mail->addAddress($email, 'User Feedback');
    //Set the subject line
    $mail->Subject = 'User 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 "am here";
        $retvalue = 'Mailer Error: ' . $mail->ErrorInfo;
    else

        $retvalue = "OK";
    //
    return $retvalue;
}

//
if ($aspoa_count==1) {
    $aspoa_fetch = $aspoa->fetch(PDO::FETCH_BOTH);
    $email = $aspoa_fetch['email'];
     $email = '[email protected]';
     $names = $aspoa_fetch['names'];
     $password = $aspoa_fetch['passworda'];
    $atNo = $aspoa_fetch['matNo'];

    SendSMTPLoginMail($email, $names, $password);
    header('location:login.php?sendMailID=1');

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

?>