ProcessingFee

connect_error) {
die(“Connection failed: ” . $conn->connect_error);
}
echo “Connected successfully”;

$prn = $_GET[‘prn’];

$candidate_name = $conn->real_escape_string($_GET[‘candidateName’]);

$programme = $conn->real_escape_string($_GET[‘programme’]);

$mobile_number = $_GET[‘mobileNumber’];

if(isset($_GET[‘improvementCount’]))
$improvement_count = $_GET[‘improvementCount’];
else
$improvement_count = 0;

$improvement_papers = $conn->real_escape_string($_GET[‘improvementSubjects’]);

if(isset($_GET[‘supplementaryCount’]))
$supplementary_count = $_GET[‘supplementaryCount’];
else
$suppementary_count = 0;

$supplementary_papers = $conn->real_escape_string($_GET[‘supplementarySubjects’]);
if(isset($_GET[‘internalCount’]))
$internal_count = $_GET[‘internalCount’];
else
$internal_count = 0;

$internal_papers = $conn->real_escape_string($_GET[‘internalSubjects’]);

$exam_fee = $improvement_count * 80;
$exam_fee += $supplementary_count * 55;
$exam_fee += $internal_count * 105;

$cost_of_application = 30;

$cv_camp_fee = ($supplementary_count + $improvement_count) * 35;

$registration_fee = 55;

$processing_fee = 15;

$mark_list_fee = 55;

$total_fee = $exam_fee + $cost_of_application + $cv_camp_fee + $registration_fee + $processing_fee + $mark_list_fee;

$stmt = $conn->prepare(“INSERT INTO fee_table(prn, name, mobile, improvement_count, improvement_papers, supplementary_count, supplementary_papers, internal_count, internal_papers, total_fee, programme) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)”);

$stmt->bind_param(“isiisisisis”, $prn, $candidate_name, $mobile_number, $improvement_count , $improvement_papers, $supplementary_count, $supplementary_papers, $internal_count, $internal_papers, $total_fee, $programme);

$stmt->execute();

$conn->close();

?>