HR Management
connect_error) {
die("Connection fail".$conn->connect_error);
}
//Get form data
$brn=$_POST['branch'];
$FsY=$_POST['fy'];
$empID=$_POST['employee_id'];
$empName=$_POST['employee_name'];
$lvType=$_POST['leave_type'];
$sDate=$_POST['startDate'];
$eDate=$_POST['endDate'];
$lDays=$_POST['leave_days'];
$lBalance=$_POST['leave_balance'];
$reson=$_POST['reason'];
$sql="INSERT INTO `leave_entry` (`sn`, `branches`, `fyear`, `employeeid`, `employeename`, `leavetype`, `StartDate`, `EndDate`, `leavedays`, `leavebalance`, `Reason`, `regdate`) VALUES (NULL, '$brn', '$FsY', '$empID', '$empName', '$lvType', '$sDate', '$eDate', '$lDays', '$lBalance', '$reson', current_timestamp())";
if ($conn->query($sql)===true) {
echo "";
}
else {
echo "Error";
}
$conn->close();
?>
