query("SELECT * FROM logo_setting WHERE id = 1"); if ($logo_query && $logo_query->num_rows > 0) { $logo_setting = $logo_query->fetch_assoc(); } // Marks Calculation with Division-by-Zero Fix $totalObtainMarks = 0; $totalMaxMarks = 0; $percentage_text = "0%"; $grade_text = "N/A"; $totalGet = $con->query("SELECT * FROM results WHERE enrollment_no = '" . mysqli_real_escape_string($con, $enroll_no) . "' "); if ($totalGet && $totalGet->num_rows > 0) { while ($row = $totalGet->fetch_assoc()) { $marks = $con->query("SELECT * FROM marks_table WHERE result_id = '" . $row['id'] . "'"); if ($marks && $marks->num_rows > 0) { while ($m = $marks->fetch_assoc()) { $sub_q = $con->query("SELECT * FROM subjects WHERE id = '" . $m['subject_id'] . "' "); if ($sub_q && $sub_q->num_rows > 0) { $sub = $sub_q->fetch_assoc(); $totalMaxMarks += ($sub['max_marks'] ?? 0); $totalObtainMarks += ($m['marks'] ?? 0); } } } } } if ($totalMaxMarks > 0) { $calc_pct = round(($totalObtainMarks / $totalMaxMarks) * 100, 2); $percentage_text = $calc_pct . '%'; if (function_exists('my_grade')) { $grade_text = my_grade($calc_pct); } } $admit_card_url = BASE_URL . "/get_certificate.php?enrollment_no=" . urlencode($enroll_no); ?>