0) { $sql = "SELECT s.*, g.name as gender, c.code as course_code, c.name as course_name, d.code as department_code, d.name as department_name, sc.code as school_code, sc.name as school_name FROM students s LEFT JOIN genders g ON s.gender_id = g.id LEFT JOIN courses c ON s.course_id = c.id LEFT JOIN departments d ON s.department_id = d.id LEFT JOIN schools sc ON s.school_id = sc.id WHERE s.id = ?"; $stmt = mysqli_prepare($conn, $sql); mysqli_stmt_bind_param($stmt, 'i', $student_id); mysqli_stmt_execute($stmt); $result = mysqli_stmt_get_result($stmt); if ($result && mysqli_num_rows($result) > 0) { $student = mysqli_fetch_assoc($result); } else { $message = 'Student not found!'; $message_type = 'danger'; header('Location: manage_students.php?msg=notfound'); exit(); } mysqli_stmt_close($stmt); } else { $message = 'Invalid student ID!'; $message_type = 'danger'; header('Location: manage_students.php?msg=invalid'); exit(); } include '../includes/header.php'; ?>

Student Details

Back to Students Edit Student
Student Photo

Active Inactive
Edit Profile
View QR
QR Code Information
QR Code
Generated
Preview QR Code
Personal Information
Student ID
Full Name
Gender

Birth Date

(y; ?> years old) Not set

Contact Information
Address

Not set

Academic Information
Year Level Year
School
Department
Course
Account Status Active

Student can log in and use the system

Inactive

Student cannot log in to the system

Date Created

Last Updated

Student Not Found

The student you're trying to view does not exist or has been deleted.

Back to Students List
$(document).ready(function() { // Print student information $("#printStudentBtn").click(function() { const printWindow = window.open("", "_blank"); printWindow.document.write(` Student Information - <?php echo htmlspecialchars($student[\'student_id\']); ?>

Student Information

Personal Information
Student ID:
Full Name:
Gender:
Birth Date:
Contact:
Email:
Address:
Academic Information
Year Level: Year
School:
Department:
Course:
Status:
QR Code:
System Information
Date Created:
Last Updated:
Student Management System - Generated on:
'; include '../includes/footer.php'; ?>