148 lines
6.9 KiB
PHP
148 lines
6.9 KiB
PHP
<?php
|
|
include('includes/config/config.php');
|
|
$id = $_REQUEST['hiddenId'];
|
|
$emp_id = $_REQUEST['emp_id'];
|
|
//echo $emp_id;
|
|
$sbp=$_POST['sbp'];
|
|
$dbp=$_POST['dbp'];
|
|
$dvrt=$_POST['dvrt'];
|
|
$nvrt=$_POST['nvrt'];
|
|
$nvlt=$_POST['nvlt'];
|
|
$cv=$_POST['cv'];
|
|
$fundoscopy=$_POST['fundoscopy'];
|
|
$urine_albumin=$_POST['urine_albumin'];
|
|
$urine_sugar=$_POST['urine_sugar'];
|
|
$urine_bile_pigments=$_POST['urine_bile_pigments'];
|
|
$urine_ketones=$_POST['urine_ketones'];
|
|
$urine_pus_cells=$_POST['urine_pus_cells'];
|
|
$urine_epithelial_cells=$_POST['urine_epithelial_cells'];
|
|
$hb=$_POST['hb'];
|
|
$wbc=$_POST['wbc'];
|
|
$rbc=$_POST['rbc'];
|
|
$pcv=$_POST['pcv'];
|
|
$mcv=$_POST['mcv'];
|
|
$mch=$_POST['mch'];
|
|
$mchc=$_POST['mchc'];
|
|
$neutrophils=$_POST['neutrophils'];
|
|
$lymphocytes=$_POST['lymphocytes'];
|
|
$eosinophils=$_POST['eosinophils'];
|
|
$monocytes=$_POST['monocytes'];
|
|
$basophils=$_POST['basophils'];
|
|
$platelets=$_POST['platelets'];
|
|
$esr=$_POST['esr'];
|
|
$rbs=$_POST['rbs'];
|
|
$bloodurea=$_POST['bloodurea'];
|
|
$creatinine=$_POST['creatinine'];
|
|
$uric_acid=$_POST['uric_acid'];
|
|
$total_cholesterol=$_POST['total_cholesterol'];
|
|
$hdl=$_POST['hdl'];
|
|
$ldl=$_POST['ldl'];
|
|
$triglycerides=$_POST['triglycerides'];
|
|
$total_bilirubin=$_POST['total_bilirubin'];
|
|
$direct_bilirubin=$_POST['direct_bilirubin'];
|
|
$indirect_bilirubin=$_POST['indirect_bilirubin'];
|
|
$sgot=$_POST['sgot'];
|
|
$sgpt=$_POST['sgpt'];
|
|
$alp=$_POST['alp'];
|
|
$fvc=$_POST['fvc'];
|
|
$fev1=$_POST['fev1'];
|
|
$fev1 =$_POST['fev1_fvc'];
|
|
$FEF_25_75=$_POST['FEF_25_75'];
|
|
$PEFR=$_POST['PEFR'];
|
|
$PFT_result=$_POST['PFT_result'];
|
|
$Chest_X_ray=$_POST['Chest_X_ray'];
|
|
$ECG=$_POST['ECG'];
|
|
$HBsAg=$_POST['HBsAg'];
|
|
$Widal_test=$_POST['Widal_test'];
|
|
$Mantoux_test=$_POST['Mantoux_test'];
|
|
$Notes=$_POST['Notes'];
|
|
$ACRt500Hz=$_POST['ACRt500Hz'];
|
|
$ACRt1000Hz=$_POST['ACRt1000Hz'];
|
|
$ACRt2000Hz=$_POST['ACRt2000Hz'];
|
|
$ACRt4000Hz=$_POST['ACRt4000Hz'];
|
|
$ACRt8000Hz=$_POST['ACRt8000Hz'];
|
|
$ACLt500Hz=$_POST['ACLt500Hz'];
|
|
$ACLt1000Hz=$_POST['ACLt1000Hz'];
|
|
$ACLt2000Hz=$_POST['ACLt2000Hz'];
|
|
$ACLt4000Hz=$_POST['ACLt4000Hz'];
|
|
$ACLt8000Hz=$_POST['ACLt8000Hz'];
|
|
$BCRt500Hz=$_POST['BCRt500Hz'];
|
|
$BCRt1000Hz=$_POST['BCRt1000Hz'];
|
|
$BCRt2000Hz=$_POST['BCRt2000Hz'];
|
|
$BCRt4000Hz=$_POST['BCRt4000Hz'];
|
|
$BCRt8000Hz=$_POST['BCRt8000Hz'];
|
|
$BCLt500Hz=$_POST['BCLt500Hz'];
|
|
$BCLt1000Hz=$_POST['BCLt1000Hz'];
|
|
$BCLt2000Hz=$_POST['BCLt2000Hz'];
|
|
$BCLt4000Hz=$_POST['BCLt4000Hz'];
|
|
$BCLt8000Hz=$_POST['BCLt8000Hz'];
|
|
$BCRt4000Hz=$_POST['BCRt4000Hz'];
|
|
$BCRt8000Hz=$_POST['BCRt8000Hz'];
|
|
$Audiometry_result=$_POST['Audiometry_result'];
|
|
$ECHO=$_POST['ECHO'];
|
|
$Ultrasound=$_POST['Ultrasound'];
|
|
$PAP_Smear=$_POST['PAP_Smear'];
|
|
$Mammogram=$_POST['Mammogram'];
|
|
$Vitamin_B12=$_POST['Vitamin_B12'];
|
|
$Vitamin_D=$_POST['Vitamin_D'];
|
|
$HbA1C=$_POST['HbA1C'];
|
|
$Bone_density=$_POST['Bone_density'];
|
|
$CT_Scan=$_POST['CT_Scan'];
|
|
$MRI=$_POST['MRI'];
|
|
$Other_tests=$_POST['Other_tests'];
|
|
$health_risk_name=$_POST['health_risk_name'];
|
|
$health_risk_id=implode(',',$health_risk_name);
|
|
error_reporting(E_ERROR | E_PARSE);
|
|
|
|
if(!empty($id)){
|
|
$sql1 = "update checkup_form set sbp='$sbp',dbp = '$dbp',dvrt ='$dvrt',nvrt ='$nvrt',nvlt ='$nvlt',cv ='$cv',fundoscopy ='$fundoscopy'
|
|
,urine_albumin ='$urine_albumin',
|
|
urine_sugar ='$urine_sugar',urine_bile_pigments ='$urine_bile_pigments',urine_ketones ='$urine_ketones',urine_pus_cells ='$urine_pus_cells'
|
|
,urine_epithelial_cells ='$urine_epithelial_cells',hb ='$hb',wbc ='$wbc',rbc ='$rbc',pcv ='$pcv',mcv ='$mcv',
|
|
mch ='$mch',mchc ='$mchc',neutrophils ='$neutrophils',lymphocytes ='$lymphocytes',eosinophils ='$eosinophils',monocytes ='$monocytes',
|
|
basophils ='$basophils',platelets ='$platelets',esr ='$esr',rbs ='$rbs',
|
|
bloodurea ='$bloodurea',creatinine ='$creatinine',uric_acid ='$uric_acid',total_cholesterol ='$total_cholesterol',hdl ='$hdl',ldl ='$ldl',
|
|
triglycerides ='$triglycerides',total_bilirubin ='$total_bilirubin',direct_bilirubin ='$direct_bilirubin',indirect_bilirubin ='$indirect_bilirubin',
|
|
sgot ='$sgot',sgpt ='$sgpt',alp ='$alp',fvc ='$fvc',fev1 ='$fev1',fev1_fvc ='$fev1',FEF_25_75 ='$FEF_25_75',PEFR ='$PEFR',
|
|
PFT_result ='$PFT_result',Chest_X_ray ='$Chest_X_ray',ECG ='$ECG',HBsAg='$HBsAg',Widal_test='$Widal_test',Mantoux_test='$Mantoux_test',
|
|
Notes='$Notes',ACRt500Hz='$ACRt500Hz',ACRt1000Hz='$ACRt1000Hz',ACRt2000Hz='$ACRt2000Hz',ACRt4000Hz='$ACRt4000Hz',ACRt8000Hz='$ACRt8000Hz',
|
|
ACLt500Hz='$ACLt500Hz',ACLt1000Hz='$ACLt1000Hz',ACLt2000Hz='$ACLt2000Hz',ACLt4000Hz='$ACLt4000Hz',ACLt8000Hz='$ACLt8000Hz',BCRt500Hz='$BCRt500Hz',
|
|
BCRt1000Hz='$BCRt1000Hz',BCRt2000Hz='$BCRt2000Hz',BCRt4000Hz='$BCRt4000Hz',BCRt8000Hz='$BCRt8000Hz',BCLt500Hz='$BCLt500Hz',BCLt1000Hz='$BCLt1000Hz',
|
|
BCLt2000Hz='$BCLt2000Hz',BCLt4000Hz='$BCLt4000Hz',BCLt8000Hz='$BCLt8000Hz',Audiometry_result='$Audiometry_result',ECHO='$ECHO',Ultrasound='$Ultrasound',
|
|
PAP_Smear='$PAP_Smear',Mammogram='$Mammogram',Vitamin_B12='$Vitamin_B12',Vitamin_D='$Vitamin_D',HbA1C='$HbA1C',Bone_density='$Bone_density',
|
|
CT_Scan='$CT_Scan',MRI='$MRI',Other_tests='$Other_tests',emp_id='$emp_id',health_risk_id='$health_risk_id'
|
|
where id = '".$id."'";
|
|
//echo $sql1;
|
|
|
|
|
|
|
|
} else{
|
|
$sql1 = "insert into checkup_form (sbp,dbp,dvrt,nvrt,nvlt,cv,fundoscopy,urine_albumin,urine_sugar,urine_bile_pigments,urine_ketones,urine_pus_cells,
|
|
urine_epithelial_cells
|
|
,hb,wbc,rbc,pcv,mcv,mch,mchc,neutrophils,lymphocytes,eosinophils,monocytes,basophils,platelets,esr,rbs,bloodurea,creatinine,uric_acid,
|
|
total_cholesterol
|
|
,hdl,ldl,triglycerides,total_bilirubin,direct_bilirubin,indirect_bilirubin,sgot,sgpt,alp,fvc,fev1,fev1_fvc,FEF_25_75,PEFR,PFT_result,
|
|
Chest_X_ray,ECG,HBsAg,Widal_test,Mantoux_test,Notes,ACRt500Hz,ACRt1000Hz,ACRt2000Hz,ACRt4000Hz,ACRt8000Hz,ACLt500Hz,ACLt1000Hz,ACLt2000Hz,
|
|
ACLt4000Hz,
|
|
ACLt8000Hz,
|
|
BCRt500Hz,BCRt1000Hz,BCRt2000Hz,
|
|
BCRt4000Hz,BCRt8000Hz,BCLt500Hz,BCLt1000Hz,BCLt2000Hz,BCLt4000Hz,BCLt8000Hz,Audiometry_result,ECHO,Ultrasound,PAP_Smear,Mammogram,
|
|
Vitamin_B12,Vitamin_D,HbA1C,Bone_density,CT_Scan,MRI,Other_tests,emp_id,health_risk_id)
|
|
values('$sbp','$dbp','$dvrt','$nvrt','$nvlt','$cv','$fundoscopy','$urine_albumin',
|
|
'$urine_sugar','$urine_bile_pigments','$urine_ketones','$urine_pus_cells','$urine_epithelial_cells'
|
|
,'$hb','$wbc','$rbc','$pcv','$mcv','$mch','$mchc','$neutrophils','$lymphocytes','$eosinophils','$monocytes','$basophils','$platelets','$esr','$rbs','$bloodurea',
|
|
'$creatinine','$uric_acid','$total_cholesterol'
|
|
,'$hdl','$ldl','$triglycerides','$total_bilirubin','$direct_bilirubin','$indirect_bilirubin','$sgot','$sgpt','$alp','$fvc'
|
|
,'$fev1','$fev1','$FEF_25_75','$PEFR','$PFT_result',
|
|
'$Chest_X_ray','$ECG','$HBsAg','$Widal_test','$Mantoux_test','$Notes','$ACRt500Hz','$ACRt1000Hz','$ACRt2000Hz','$ACRt4000Hz','$ACRt8000Hz','$ACLt500Hz'
|
|
,'$ACLt1000Hz','$ACLt2000Hz','$ACLt4000Hz','$ACLt8000Hz',
|
|
'$BCRt500Hz','$BCRt1000Hz','$BCRt2000Hz',
|
|
'$BCRt4000Hz','$BCRt8000Hz','$BCLt500Hz','$BCLt1000Hz','$BCLt2000Hz','$BCLt4000Hz','$BCLt8000Hz','$Audiometry_result','$ECHO','$Ultrasound','$PAP_Smear'
|
|
,'$Mammogram',
|
|
'$Vitamin_B12','$Vitamin_D','$HbA1C','$Bone_density','$CT_Scan','$MRI','$Other_tests','$emp_id','$health_risk_id')";
|
|
//echo $sql1;
|
|
}
|
|
$result=mysqli_query($conn,$sql1);
|
|
//echo $sql1;
|
|
//echo json_encode($emp_id);
|
|
?>
|