array( 'q1' => $int_det_q1, 'q2' => $int_det_q2, 'q3' => $int_det_q3, 'q4' => $int_det_q4, 'q5' => $int_det_q5, 'q6' => $int_det_q6, 'q7' => $int_det_q7, 'q8' => $int_det_q8, 'q9' => $int_det_q9, 'q10' => $int_det_q10, 'q11' => $int_det_q11, 'q12' => $int_det_q12, 'q13' => $int_det_q13, 'q14' => $int_det_q14, 'q15' => $int_det_q15, 'q16' => $int_det_q16), 'interviewer' => array( 'name' => $int_det_interviewer, 'int_date' => $int_det_int_date, 'int_position' => $int_det_int_pos, 'sign' => $int_det_sign, 'sign_date' => $int_det_sign_date), 'verifier' => array( 'verify_name' => $int_det_verifier , 'verify_position' => $int_det_verifier_pos, 'verify_sign' => $int_det_sign_verify, 'verify_sign_date' => $int_det_sign_verify_date), 'approver' => array( 'approve_name' => $int_det_approver, 'approve_position' => $int_det_approver_pos, 'approve_sign' => $int_det_sign_approve, 'approve_sign_date' => $int_det_sign_approve_date), 'status' => $int_det_status ) ; $array_int_det = jsonEncodeDecode('encode', $array_int_det) ; // print_r($array_int_det);exit; $old_record = ''; $mysqli_record = $mysqli->query("select employment_interview_details from staff_employment where employment_id = '".$page."' limit 1"); if ($mysqli_record->num_rows > 0 ){ $old_record = $mysqli_record->fetch_array(MYSQLI_ASSOC)['employment_interview_details']; }else{ $old_record = '-'; } $record = array( "old_record" => $old_record, "new_record" => $array_int_det, ); $record = jsonEncodeDecode('encode', $record) ; if($mysqli->query("UPDATE staff_employment SET employment_interview_details = '".$array_int_det."' WHERE employment_id = '".$page."'")){ $descrition = $_SESSION['system_name'].'(username) update the employment interview details'; $mysqli->query("INSERT INTO system_log_employment (log_table, log_action, log_page_id, log_page_name, log_user_id, log_description, log_record, log_date) VALUES ('employment', 'update-interview_det', '200', 'AF-".$page."', '".$_SESSION["system_id"]."', '".$descrition."', '".$record."', NOW())"); } // refresh page header("Location:?page_mode=edit_interview_det&page=".$page."&success=1&select_worker=Local") ; exit ; } // start header here include 'requires/page_header.php' ; if ( $hide_title == false ){ include 'requires/page_top.php' ; } $user_profile = jsonEncodeDecode('decode', $row_page['employment_file']) ; $int_det_content = jsonEncodeDecode('decode', $row_page['employment_interview_details']) ; $int_det_question_con = $int_det_content['question']; $int_det_interviewer_con = $int_det_content['interviewer']; $int_det_verifier_con = $int_det_content['verifier']; $int_det_approver_con = $int_det_content['approver']; $int_det_status_con = $int_det_content['status']; if ( $hide_title == true && $_GET['success'] == '1' ){ echo ' ' ; } ?>