ESH/save_sub_section.php
2024-10-23 18:28:06 +05:30

28 lines
1.1 KiB
PHP

<?php
include('includes/config/config.php');
include('log_entry.php');
$sub_section_id= $_POST['sub_section_id'];
$bu_id = $_POST['bu_id'];
$dept_id = $_POST['dept_name'];
$section_name =$_POST['section_name'];
$sub_section = $_POST['sub_section_name'];
$sub_section_head = $_POST['sub_section_head'];
$sub_section_email = $_POST['sub_section_email'];
if(!empty($sub_section_id)){
$query = "update sub_section set sub_section_id='$sub_section_id',section_id='$section_id',section_id = '$section_name',bu_id='$bu_id',dept_id='$dept_id',sub_section_headname ='$sub_section_head',sub_section_email='$sub_section_email',modified_by = '".$_SESSION['user_id']."' where sub_section_id = '".$sub_section_id."'";
error_log("sdcascd".$query);
}
else {
$query = "insert into sub_section(sub_section_name,section_id,bu_id,sub_section_headname,dept_id,sub_section_email,modified_by)
values ('$sub_section','$section_name','$bu_id','$sub_section_head','$dept_id ','$sub_section_email','".$_SESSION['user_id']."' )";
error_log("dcsfs".$query);
}
if (!$result = @mysqli_query($conn,$query)) {
exit(mysqli_error($conn));
}
?>