$value ) { $requestStr.=$key . " : " . $value . "\n"; error_log ( $key . " : " . $value . "
\r\n" ); } error_log ( "End Printing Request Attributes" ); save_log($requestStr,'save_training_status','SAVE','save_training_status.php'); error_reporting(E_ALL & ~E_WARNING & ~E_NOTICE); begin(); $training_date=$_POST['training_date']; $emp_id=$_POST['emp_id']; $assign_training_id=$_POST['assign_training_id']; // $shift_status= implode(',',$_POST['shift_status']); $query_initial=""; $endquery=""; if(!empty($training_date) && !empty($emp_id) && !empty($assign_training_id)){ $sql_del = "delete from training_status where assign_training_id='$assign_training_id' and emp_id='$emp_id' and training_date=STR_TO_DATE('".$_POST['training_date']."','%d-%m-%Y') and ohc_type_id = '".$_SESSION['current_ohcttype']."' "; error_log("Ambulance paramters query details".$sql_del); mysqli_query($conn,$sql_del); } $query="insert into training_status set training_date=STR_TO_DATE('".$_POST['training_date']."','%d-%m-%Y'),assign_training_id='$assign_training_id', emp_id='$emp_id',training_status='".$_POST["training_status"]."' ,training_remarks='".$_POST["training_remarks"]."' ,ohc_type_id = '".$_SESSION['current_ohcttype']."' ,modified_by = '".$_SESSION['user_id']."' ".$endquery; error_log("Ambulance paramters query details".$query); //echo $query; if (!$result = mysqli_query($conn,$query)) { error_log ( "Exception:" . mysqli_error($conn) ); error_log ( "Failed to Execute the Personal info Query::: " . $query ); rollback(); exit(mysqli_error($conn)); } commit(); ?>