Student Result Management system using PHP & MySQL

• Admin dashboard for this final year project with students, faculty, courses, subjects, published marks, pending marks, and recent activity
• Admin profile update with name, email, mobile, photo, and password change
• Student CRUD with user and student profile management
• Faculty CRUD with employee ID and department details
• Department CRUD with code, name, and description
• Course/class management linked to departments
• Subject management with max marks, passing marks, and component ceilings
• Academic session and semester management
• Exam type management
• Faculty-to-subject allocation with optional semester
• Student enrollment management with course, semester, section, batch, and status
• Grade scale management with letter grades, percentage bands, and grade points
• Result approval workflow with approve, reject, publish, unpublish, and lock actions
• All-results search and filtering
• Delete non-locked, non-published marks where allowed
• Attendance eligibility management per student-subject
• Class-wise, subject-wise, toppers, and pass/fail reports
• Notice create, edit, delete, and audience targeting
• Student/faculty query reply, status update, and delete
• Activity log viewing
• Optional extra admin creation using ADMIN_CREATION_SECRET

• Student login and signup in this final year project
• Student dashboard with summary cards and navigation
• My subjects overview
• Published result viewing by subject and exam
• Printable marksheet view
• Performance/history view over time
• Attendance and eligibility information
• Student-visible notices
• Query/recheck request submission
• Query reply/status tracking
• Student profile update and password change
• Faculty dashboard in this final year project with summary and quick links
• My subjects list based on faculty allocation
• Marks entry per student, exam type, and mark components
• Bulk marks entry for faster result processing
• Submitted and draft result tracking
• Student eligibility viewing where applicable
• Student query management for allocated subjects
• Institution notices viewing
• Faculty profile update and password change

• Public landing page included in this final year project
• Multi-role login with portal selection
• Student and faculty self-service registration
• Password hashing with password_hash() and password_verify()
• PDO prepared statements
• Session cookie settings with HttpOnly and SameSite=Lax
• Bootstrap 5.3 and Bootstrap Icons UI
• Profile photo upload support
• Configurable BASE_URL for subfolder deployment
• Default timezone set to Asia/Kolkata
• SQL install file with schema and seed data
• Activity logging for common actions
• Suitable for final year project demo, viva, source code review, and report preparation

• Copy the final year project folder into your web root or configure it as a virtual host.
• Edit config.php and set BASE_URL:
  • Root deployment: /
  • Subfolder example: /srms/
• Align the database name between config.php and sql/install.sql.
  • Either change SQL to use srms_db, or set DB_NAME to bosvesedst_student_result_management_system.
• Import the SQL file:
  mysql -u root -p < sql/install.sql
• Configure database credentials in config.php:
  • DB_HOST
  • DB_NAME
  • DB_USER
  • DB_PASS
• Ensure uploads/ exists and is writable for profile photos.
• Run locally using PHP built-in server:
  php -S localhost:8080
• Open the application at:
  http://localhost:8080/
• On login, select the correct portal: Administrator, Faculty, or Student.

Administrator

• Username: admin
• Email: [email protected]

Faculty

• Username: faculty_sarah
• Email: [email protected]
• Username: faculty_james
• Email: [email protected]

Students

• Username: stu_emily
• Email: [email protected]
• Username: stu_michael
• Email: [email protected]
• Username: stu_priya
• Email: [email protected]
• Username: stu_david
• Email: [email protected]
• Username: stu_anna
• Email: [email protected]