Tedira Hacker Academy - Student Results

Check Your Exam Results

prepare(" SELECT s.name, s.dob, s.student_id, r.result_status, r.exam_code, e.exam_name FROM students s JOIN results r ON s.student_id = r.student_id JOIN exams e ON r.exam_code = e.exam_code WHERE s.student_id = ? AND s.dob = ? "); $stmt->execute([$studentId, $dob]); $result = $stmt->fetch(PDO::FETCH_ASSOC); if ($result) { echo '

Student Details

Name: '.htmlspecialchars($result['name']).'

Student ID: '.htmlspecialchars($result['student_id']).'

Date of Birth: '.htmlspecialchars($result['dob']).'

Exam Code: '.htmlspecialchars($result['exam_code']).'

Exam Name: '.htmlspecialchars($result['exam_name']).'

Exam Result

Status: '.ucfirst(htmlspecialchars($result['result_status'])).'

Subject-wise Marks

'; $stmt2 = $pdo->prepare(" SELECT sr.subject_name, sr.total_marks, sr.obtained_marks FROM subject_results sr JOIN results r ON sr.result_id = r.id WHERE r.student_id = ? AND r.exam_code = ? "); $stmt2->execute([$studentId, $result['exam_code']]); $subjects = $stmt2->fetchAll(PDO::FETCH_ASSOC); foreach ($subjects as $subject) { echo ' '; } echo '

Subject	Total Marks	Marks Obtained
'.htmlspecialchars($subject['subject_name']).'	'.htmlspecialchars($subject['total_marks']).'	'.htmlspecialchars($subject['obtained_marks']).'/'.htmlspecialchars($subject['total_marks']).'

'; } else { echo '

Student not found or invalid credentials. Please check your Student ID and Date of Birth.

'; } } catch (PDOException $e) { echo '

Error retrieving results. Please try again later.

'; } } ?>