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();
?>