<?php
include '../../../include/conf.php';
$emp_id = mysqli_real_escape_string($conn,$_POST['emp_id']);
$dateString = null;
$timestamp = strtotime($_POST['dor']);

if ($timestamp === false) {
    // Handle the case where strtotime returns false
    $formattedDate = '';
} else {
    // Format the date if strtotime is successful
    $formattedDate = date('d-m-Y', $timestamp);
}
$emp_name = mysqli_real_escape_string($conn,$_POST['emp_name']);
$dob = date('Y-m-d', strtotime($_POST['dob']));
$doj = date('Y-m-d', strtotime($_POST['doj']));
$contact_no = trim($_POST['contact_no']);
$qualification = mysqli_real_escape_string($conn,$_POST['qualification']);
$marital_status = mysqli_real_escape_string($conn,$_POST['marital_status']);
$blood_group = mysqli_real_escape_string($conn,$_POST['blood_group']);
$addr = removeBrTags($_POST['address']);
$address =  mysqli_real_escape_string($conn, $addr);
$salary = trim($_POST['salary']);
$designation = mysqli_real_escape_string($conn,$_POST['designation']);
$emp_status = mysqli_real_escape_string($conn,$_POST['emp_status']);
$update = "UPDATE tbl_employee
SET emp_name='$emp_name', dob='$dob', doj='$doj', dor='$formattedDate', contact_no='$contact_no', qualification='$qualification', marital_status='$marital_status', blood_group='$blood_group', address='$address', salary='$salary', designation='$designation', emp_status='$emp_status', updated_at=CURRENT_TIMESTAMP
WHERE id='$emp_id';";
if(mysqli_query($conn, $update)){
    echo 'success';
}else{
    echo 'failed';
}
function removeBrTags($string) {
    return preg_replace('/<br\s*\/?>/i', '', $string);
}
?>