connect_error) { die("Connection failed: " . $conn->connect_error); } // Enable error reporting mysqli_report(MYSQLI_REPORT_ERROR); // Retrieve registration number from URL parameter $registration_no = isset($_GET['registration_no']) ? $_GET['registration_no'] : ''; // Initialize variables $fullname = $father = $mother = $parents_address = $student_age = $date_of_birth_formatted = $registration_date = ''; $subject_results = []; $cgpa = 0; if (!empty($registration_no)) { // Fetch student information $sql_user = "SELECT fullname, father, mother, parents_address, age, registration_date FROM tbl_user WHERE registration_no = ?"; $stmt_user = $conn->prepare($sql_user); $stmt_user->bind_param("s", $registration_no); $stmt_user->execute(); $result_user = $stmt_user->get_result(); if ($result_user->num_rows > 0) { $row_user = $result_user->fetch_assoc(); $fullname = $row_user['fullname']; $father = $row_user['father']; $mother = $row_user['mother']; $parents_address = $row_user['parents_address']; // Calculate age from date of birth $date_of_birth = new DateTime($row_user['age']); $now = new DateTime(); $student_age = $date_of_birth->diff($now)->y; // Format dates $date_of_birth_formatted = $date_of_birth->format('Y-m-d'); $registration_date = $row_user['registration_date']; // Fetch student results $sql_results = "SELECT subject, year, class, SUM(total) AS total, COUNT(DISTINCT term) AS terms_count FROM tbl_student_results WHERE registration_no = ? GROUP BY subject, year ORDER BY year"; $stmt_results = $conn->prepare($sql_results); $stmt_results->bind_param("s", $registration_no); $stmt_results->execute(); $result_results = $stmt_results->get_result(); // Process results if ($result_results->num_rows > 0) { while ($row_results = $result_results->fetch_assoc()) { $subject = $row_results['subject']; $year = $row_results['year']; $class = $row_results['class']; preg_match('/\b([a-zA-Z]+ \d+)\b/', $class, $matches); $base_class = isset($matches[1]) ? $matches[1] : $class; $total = $row_results['total']; $terms_count = $row_results['terms_count']; // Calculate GPA $gpa = calculateGPA($total / $terms_count); $grade = calculateGrade($gpa); // Store subject-wise results $subject_results[$subject][$year] = [ 'total' => $total, 'gpa' => $gpa, 'grade' => $grade, 'terms_count' => $terms_count, 'class' => $base_class ]; } } } else { $error_message = "No student found with the provided registration number."; } } else { $error_message = "No registration number provided."; } // Close database connection $conn->close(); // Function to calculate GPA function calculateGPA($average_score) { if ($average_score >= 70) return 5.0; elseif ($average_score >= 60) return 4.0; elseif ($average_score >= 50) return 3.0; elseif ($average_score >= 45) return 2.0; elseif ($average_score >= 40) return 0.8; else return 0; } // Function to calculate grade based on GPA function calculateGrade($gpa) { if ($gpa == 5.0) return 'A'; elseif ($gpa == 4.0) return 'B'; elseif ($gpa == 3.0) return 'C'; elseif ($gpa == 2.0) return 'D'; elseif ($gpa == 0.8) return 'E'; else return 'F'; } // Function to calculate grade based on GPA for GPA row function calculateGradeForGPA($gpa) { if ($gpa <= 0.7) return 'F'; elseif ($gpa > 0.7 && $gpa <= 1.5) return 'E'; elseif ($gpa > 1.5 && $gpa <= 2.3) return 'D'; elseif ($gpa > 2.3 && $gpa <= 3.1) return 'C'; elseif ($gpa > 3.1 && $gpa <= 3.9) return 'B'; else return 'A'; } // Function to calculate grade based on CGPA function calculateGradeForCGPA($cgpa) { if ($cgpa >= 3.6) return 'A'; elseif ($cgpa >= 3.2 && $cgpa < 3.6) return 'B'; elseif ($cgpa >= 2.4 && $cgpa < 3.2) return 'C'; elseif ($cgpa >= 1.6 && $cgpa < 2.4) return 'D'; elseif ($cgpa >= 0.8 && $cgpa < 1.6) return 'E'; else return 'F'; } // Function to retrieve class for a given year function getClassForYear($year, $subject_results) { foreach ($subject_results as $subject => $years_data) { foreach ($years_data as $year_data => $result) { if ($year_data === $year) { return $result['class']; } } } return ''; } // Calculate CGPA if (!empty($subject_results)) { $total_gpa = 0; $total_subjects = 0; foreach ($subject_results as $subject => $years) { foreach ($years as $year => $result) { $total_gpa += $result['gpa']; $total_subjects++; } } $cgpa = $total_subjects > 0 ? $total_gpa / $total_subjects : 0; } ?> Transcript for <?php echo $fullname ? $fullname : 'Student'; ?>

Academic Transcript

Admission Number:
Admission Date:
Father's Name:
Mother's Name:
Parents' Address:
Age: years
Date of Birth:
Academic Summary
Subjects
Academic Years
CGPA
Overall Grade
$years_data) { foreach ($years_data as $year => $result) { $years[$year] = true; } } ksort($years); foreach ($years as $year => $_) { echo ""; } ?> $_) { $class = getClassForYear($year, $subject_results); echo ""; } ?> $_) { echo ""; echo ""; echo ""; } ?> $years_data) { echo ""; echo ""; foreach ($years as $year => $_) { if (isset($years_data[$year])) { $result = $years_data[$year]; echo ""; echo ""; echo ""; } else { echo ""; echo ""; echo ""; } } echo ""; } // Display GPA row echo ""; echo ""; foreach ($years as $year => $_) { $total_total = 0; $total_gpa = 0; $total_subjects = 0; foreach ($subject_results as $subject => $years_data) { foreach ($years_data as $year_data => $result) { if ($year_data === $year) { $total_total += $result['total'] / $result['terms_count']; $total_gpa += $result['gpa']; $total_subjects++; } } } $average_total = $total_subjects > 0 ? $total_total / $total_subjects : 0; $average_gpa = $total_subjects > 0 ? $total_gpa / $total_subjects : 0; echo ""; echo ""; echo ""; } echo ""; ?>
SUBJECT $year
$class
% ScoreGrade Point (G.P.)Grade
$subject" . number_format($result['total'] / $result['terms_count'], 2) . "" . number_format($result['gpa'], 2) . "{$result['grade']}---
G.P.A." . number_format($average_total, 2) . "" . number_format($average_gpa, 2) . "" . calculateGradeForGPA($average_gpa) . "
C.G.P.A.
No academic records found for this student.