University Management System Using PHP & MySql

Krupa Patel
6 min readSep 15, 2021

--

Today, with an increasing number of students each year, managing everything manually has become quite hectic for the universities. Luckily, technology has extended its hands to curb this problem with ease. The option of a University Management System has stood out to be a great solution in such a situation.

About University Management System Project

Moving on, this university management system project in PHP focuses mainly on dealing with a number of records regarding student attendance, markings, faculties, etc. Also, the system displays all the available records of available faculties, students, and their marks, etc. This project is divided into three categories: Admin, Student, and Faculty. In an overview of this web app, the admin has all the main control of the system that includes student attendance management under different dates. In addition, the admin has the right to set marks under each subject of students. After setting up student’s marks, the admin can view the overall result of each student with their CGPA. Besides, an admin can download student and faculty records.

Student and Faculty Panel

On the other hand, a user can simply register as student by entering details such as name, university id, address, course, date of birth, and set up login details. Here, a student account has access to view his/her overall results on each subjects and edit their own user profile. In order to view results, the admin should first set marks on a particular student’s record. Similarly, faculty members can simply register and log into the system. A faculty member can take attendance of students, view overall attendance and update their profiles. So, the only responsibility of an faculty account is to maintain the attendance.

Last but not least, a clean and responsive dashboard is presented with simple color combinations for greater user experience while using this university management system project in PHP source code. For its UI elements, there is no involvement of UI Frameworks instead, the Vanilla CSS is on board. Presenting a new online university management system project in PHP MySQL source code that contains all the essential features to follow up, and a knowledgeable resource for learning purposes.

You will ask what is the scope for developing this project? so, The requirement of the user is to: Access information, Log in to the system through the first page of the application, Change the password after logging the system, View/change details, Can get help through the help option to view different property of the system, If not registered then, students or faculty can create account, Student is able to edit their profile, Also students can put their profile image, Faculty is able to delete or add student.

There are 2 main modules of this system.

  1. Admin Specification

· Admin can do the following things:

· Admin can login by their login details

ADMIN LOGIN

Manage Student information:

· View all students, update student details, Delete single student.

· Search student by their Name, ID, contact, email.

Admin can see both students and faculty details
View All students & its details
Student can update profile
Search particular student by their Name or ID
It will display that particular search student

Manage Student Attendance Sheet:

· Add student in attendance sheet

· Delete student from attendance sheet

· Update attendance sheet data date wise.

Select date for taking attendance
View attendance
It will show attendance of that particular date

Manage Student Result:

· Can add result to all students

· Adding marks subject wise and semester wise.

· View their marks, grades, credit hour, SGPA by selecting semester

· When view the result it’s also show the status of subject (pass, fail, retake).

· Update marks of single student by subject wise.

· Can view all completed course and total CGPA of all the semester.

Here, faculty can add or view result of students
Faculty can add marks of particular subject as well as semester wise
Faculty can edit & update marks
Admin can view result

Download option:

· Admin can download Student list with their information and also faculty list

Admin can download faculty list

2. Users Specification

Students Can do:

· Students can register themselves by their ID which is provided by department

· Can login by their ID and password which is given during registration

· Student can see own profile.

· They can edit own information

· Change password option also available to menu bar.

· Students are able to see their result (SGPA & CGPA both)

· They also can see their marks and grade.

Student Login
Student Profile
Students can edit & update their profile
Student can view their result
View CGPA & Complete Course
Student can Change & Update their Password

Cannot do:

· First of all student cannot change their ID.

· They are unable to update their marks & grade.

· Student cannot see another student profile and details.

· Cannot delete themselves and also other.

Faculty Can do:

· Faculty also can login with their username and password

· View their profile and Update information.

· The main thing is they can take attendance of student. At first select date and take attendance.

· Another option is they can update attendance sheet data.

Faculty Login
Faculty Profile
Faculty can take attendance
View Attendance Date wise

Cannot do:

· They cannot add marks directly by this software.

· Faculty cannot add and delete student from attendance sheet.

Conclusion

It provides high security and a system that reduces the work and resources required in the traditional process. University Management System is customizable and is rated very satisfactory in terms of functionality, user-friendliness, usability, and performance, it is implied that other colleges may adopt this system for more efficient information management and more effective management decisions.

Future Enhancement

· Online examination module would be introduced to conduct online examination.

· Scheduling of the staff. i.e., time table setting of the staff.

· Further, the faculty can upload the videos of their lectures on to this site and students who had missed those classes can view those videos.

--

--

Krupa Patel
Krupa Patel

Written by Krupa Patel

AWS Cloud Practitioner Certified, AWS Cloud Enthusiastic

Responses (3)