<?php

$servername = "localhost";
$username = "id2511919_azwan96";
$password = "azwan9669";
$dbname = "id2511919_azwan96";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname );

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} else{
echo "Connected successfully";
}

$sql = "SELECT * FROM User";
$result = $conn->query($sql);
while($row = $result->fetch_assoc()) {
                if ($row["Username"] == $_GET["username"]){
			$name = $row["Name"];
                }
                if ($row["Department"] == "Department of Human Resource"){
			$email= $row["Email"];
                }

}
$start_date = $_GET["start_date"];
$end_date = $_GET["end_date"];
echo $start_date;
echo $end_date;
$sql = "UPDATE Leave_Application SET HR_Approval='Approved' WHERE Name='".$name."' AND Start_Date='".$start_date."' AND End_Date='".$end_date."'";
if ($conn->query($sql) === TRUE) {
    echo "Record updated successfully";
} else {
    echo "Error updating record: " . $conn->error;
}

$sql = "SELECT * FROM Leave_Application";
$result = $conn->query($sql);
while($row = $result->fetch_assoc()) {
                if ($row["Name"] == $name && $row["Start_Date"] == $start_date && $row["End_Date"] == $end_date){
			$reason = $row["Reason"];
                }
}

$msg = "The below information of application is approved.\n\nName: ".$name."\nStart date:".$start_date."\nEnd date: ".$end_date."\nReason: ".$reason."";

// use wordwrap() if lines are longer than 70 characters
$msg = wordwrap($msg,70);

// send email
mail($email,"My subject",$msg);
echo "HR Department have been notified.";
?>