mail.php

<?php

// include 'config.php';

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "users";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

//start
$email = $_POST['email'];

$data = mysqli_fetch_assoc(mysql_query($conn, "select b.email, a.password from company a join contact b on a.contactid=b.id where email like '$email'"));

$email = $data['email'];
$password = $data['password'];

if (!empty($email)) {
require("PHPMailer/PHPMailerAutoload.php");

//kandungan emel
$subject = "SISTEM: NOTIS KATA LALUAN";
$body ='<p>Tuan/Puan,</p>';
$body .='<p>Akaun pendaftaran telah dijumpai. Sila teruskan proses log masuk dengan menggunakan kata laluan seperti berikut: <br><br> Kata Laluan: ".$password." <br><br>Sekian. Harap Maklum<br>Terima Kasih";</p>';

// Enter Your Email Address Here To Receive Email
$email_to = "janedoe@example.com";
$email_from = "jackiechan@global.com"; // Enter Sender Email
$sender_name = "Jackie Chan"; // Enter Sender Name

$mail = new PHPMailer();
$mail->IsSMTP();
$mail->Host = "mail.global.com"; // Enter Your Host/Mail Server
$mail->SMTPAuth = true;
$mail->Username = "jackiechan@global.com"; // Enter Sender Email
$mail->Password = "xxxxx";

$mail->Port = 25;
$mail->IsHTML(true);
$mail->From = $email_from;
$mail->FromName = $sender_name;
$mail->Sender = $email_from; // indicates ReturnPath header
$mail->AddReplyTo($email_from, "No Reply"); // indicates ReplyTo headers
$mail->Subject = $subject;
$mail->Body = $body;
$mail->AddAddress($email_to);


if (!$mail->Send()){
    echo "Mailer Error: " . $mail->ErrorInfo;
    }else{
    echo "An email has been sent to your email address.";
}
}
?>