$val) {
$param_query = "select a.*,b.* from checkup_form_key_value a left join checkup_parameter b on a.checkup_form_key = b.column_name where a.checkup_form_id = '" . $row['checkup_id'] . "' and checkup_form_section_id = '$val'";
$param_result = @mysqli_query($conn, $param_query);
while ($row_param = @mysqli_fetch_assoc($param_result)) {
array_push($param_name, $row_param['parameter_name']);
if ($row_param['input_type'] == 'select') {
array_push($pre_param_value, getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $row_param['checkup_form_value']));
} else if ($row_param['input_type'] == 'multiselect') {
array_push($pre_param_value, getCommaSeperatedValuesForInClause("select parameter_value_name from checkup_parameter_value", 'parameter_value_id', $row_param['checkup_form_value']));
} else {
array_push($pre_param_value, $row_param['checkup_form_value']);
}
}
}
?>
$val) {
$param_query = "select a.*,b.* from checkup_form_key_value a left join checkup_parameter b on a.checkup_form_key = b.column_name where a.checkup_form_id = '" . $row['checkup_id'] . "' and checkup_form_section_id = '$val'";
$param_result = @mysqli_query($conn, $param_query);
while ($row_param = @mysqli_fetch_assoc($param_result)) {
if ($row_param['input_type'] == 'select') {
array_push($post_param_value, getFieldFromTable('parameter_value_name', 'checkup_parameter_value', 'parameter_value_id', $row_param['checkup_form_value']));
} else if ($row_param['input_type'] == 'multiselect') {
array_push($post_param_value, getCommaSeperatedValuesForInClause("select parameter_value_name from checkup_parameter_value", 'parameter_value_id', $row_param['checkup_form_value']));
} else {
array_push($post_param_value, $row_param['checkup_form_value']);
}
}
}
?>
| Sr No. |
Key Parameter Name |
Pre Program Parameter Value
|
Post Program Parameter Value
|
|
|
|
|