How jharanasolanki/college-portal works
CollegePortal is a student-and-teacher college portal. The documented user workflow starts at the portal and login, then branches to class booking, requests for extra lectures, or mock-paper preparation from a question bank. The tree also indicates Excel-to-MySQL and Excel-to-paper processing, backed by PHPExcel readers and writers. The sampled portal source does not expose server-side wiring or persistence details, so those relations are shown only where the README or filenames support them.
Main entry points: students.php Student Area · PHPExcel.php PHPExcel · Login.php Login · requestsubject.php Request Lecture
Components 22
Portal and Access
- Portal Home
index.php - Login
Login.php - Login Entry
LoginEntry.php - Student Area
students.php - Teacher Area
teachers.php
Class Booking
- Book Class
guitable.php - Cancel Class
canceltable.php
Lecture Requests
- Request Lecture
requestsubject.php - Request Response
subjectrequestresp.php - Mail Teacher
Question Papers
- Paper Upload
uploadpt.php - Generator Form
papergeneratorform.php - Excel to Paper
exceltoqpaper.php - Excel Upload
uploadexcel.php - Excel to MySQL
exceltomysql.php - PHPExcel
Classes/PHPExcel.php - Excel Readers
Classes/PHPExcel/Reader - Excel Writers
Classes/PHPExcel/Writer - Question Bank
Other components
- Student
- Teacher
- Portal Data
Connections 21
- Student → Portal Home: visits
- Teacher → Portal Home: visits
- Portal Home → Login Entry: offers login
- Login Entry → Login: starts login
- Login → Student Area: student access
- Login → Teacher Area: teacher access
- Student Area → Book Class: books class
- Student Area → Cancel Class: cancels class
- Student Area → Request Lecture: requests lecture
- Request Lecture → Mail Teacher: mails teacher
- Request Lecture → Request Response: handles response
- Student Area → Paper Upload: opens papers
- Paper Upload → Generator Form: submits request
- Generator Form → Excel to Paper: prepares paper
- Excel to Paper → Question Bank: uses questions
- Excel Upload → Excel to MySQL: imports workbook
- Excel to MySQL → Portal Data: writes records
- Excel Upload → PHPExcel: reads workbook
- Excel to Paper → PHPExcel: processes workbook
- PHPExcel → Excel Readers: loads formats
- PHPExcel → Excel Writers: writes formats