School Management System (SMS) is a web application commonly used in schools to manage teachers, students, classes, subjects, sections, student attendance, etc.
So if you are a PHP developer and want to develop School Management System with PHP, you are here at the right place. This tutorial will teach how to develop a School Management System with PHP and MySQL.
We will cover this tutorial in easy steps, from developing a live demo of the school management system to covering major functionalities like managing teachers, students, classes, subjects, sections, student attendance, etc. This is a straightforward school management system for learning purposes and can be enhanced according to the requirement to develop a perfect advanced level system. The download link is at the end of the tutorial to download the complete project with database tables.
Read Also: How to Create a Histogram in Excel (Step-by-Step Guide)
School Management Systems manage all the information of the students and/or faculty in a particular school.
In our project, we will only use it to manage some basic personal information of the students of a school.
So let us start implementing School Management System with PHP and MySQL. Before we begin, take a look at the files structure for this example.
Read Also: Uses Of Function Keys [F1-F12] In Windows | The Time-Saving Function Key Shortcuts you need to know
• PHP 5.5
• MYSQL 4.6
• Text Editor Software
First, we will use MySQL database tables for all the features of our project like admin, chat, classroom, events, exam, grade, group message, parents, payment notifications, student etc. The table structure and data are available in the project download zip file.
You can change or update the Database settings in config.php file located in controller folder
$servername = "localhost"; $username = "Enter Database Username"; $password = "Exter Database Password"; $dbname = "Enter Database Name"; // Create connection $conn = mysqli_connect($servername, $username, $password, $dbname); // Check connection if (!$conn) { die("Connection failed: " . mysqli_connect_error()); }
Don’t forget to change username, password and dbname (database name).
In the index.php file, we will create a login form to implement an admin login to allow access to the logged-in user only.
<div class="modal fade" id="loginFrom" tabindex="-1" role="dialog" aria-labelledby="loginFrom" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content "> <div class="modal-header bg-aqua-gradient"> <h4>User Login...!</h4> </div> <div class="modal-body bgColorWhite"> <form role="form" action="../index.php" method="post"> <div class="box-body"> <div class="form-group" id="divEmail"> <label for="">Email</label> <input type="text" class="form-control" id="email" placeholder="Enter email address" name="email" autocomplete="off"> </div> <div class="form-group" id="divPassword"> <label for="">Password</label> <input type="password" class="form-control" id="password" placeholder="Enter password" name="password" autocomplete="off"> </div> </div><!-- /.box-body --> <div class="box-footer"> <input type="hidden" name="do" value="user_login" /> <button type="submit" class="btn btn-info" id="btnSubmit">Submit</button> </div> </form> </div> </div> </div> </div><!--/.Modal-->
We will implement user login on the login form by calling the method Login() in login.php
function login(){ //document.ready(function{ $('#loginFrom').modal({ backdrop: 'static', keyboard: false }); $('#loginFrom').modal('show'); }; $("form").submit(function (e) { //MSK-000098-form submit var uname = $('#email').val(); var password = $('#password').val(); if(uname == ''){ //MSK-00099-name $("#btnSubmit").attr("disabled", true); $('#divEmail').addClass('has-error has-feedback'); $('#divEmail').append('<span id="spanEmail" class="glyphicon glyphicon-remove form-control-feedback msk-set-color-tooltip" data-toggle="tooltip" title="The user name is required" ></span>'); $("#email").keydown(function() { //MSK-00100-name $("#btnSubmit").attr("disabled", false); $('#divEmail').removeClass('has-error has-feedback'); $('#spanEmail').remove(); }); } if(password == ''){ //MSK-00099-name $("#btnSubmit").attr("disabled", true); $('#divPassword').addClass('has-error has-feedback'); $('#divPassword').append('<span id="spanPassword" class="glyphicon glyphicon-remove form-control-feedback msk-set-color-tooltip" data-toggle="tooltip" title="The password is required" ></span>'); $("#password").keydown(function() { //MSK-00100-name $("#btnSubmit").attr("disabled", false); $('#divPassword').removeClass('has-error has-feedback'); $('#spanPassword').remove(); }); } if(uname == '' || password == ''){ //MSK-000098- form validation failed $("#btnSubmit").attr("disabled", true); e.preventDefault(); return false; }else{ $("#btnSubmit").attr("disabled", false); } });
School Management System supports different type of users login like
You can find the code for all user in the /view folder.
My Profile
Classroom
Grade
Subject
Add Teacher
All Teacher
Add Student
All Student
Student Payment
Add Attenddance
Student Attendance History
Teacher Attendance History
Create Exam
Exam Timetable
Student Exam Marks
Student Exam Marks History
Add Friends
My Friends
My Events
All Events
My Subject
All Subject
My Timetable
All Timetable
My Attendance
My Attendance History
My Petty Cash
My Student Exam Marks
My Student Exam Marks History
Exam Timetable
Add Friends
My Friends
My Events
All Events
My Teacher
All Teacher
My Subject
All Subject
My Timetable
All Timetable
My Attendance
My Attendance History
My Exam Marks
My Exam Marks History
My Exam Timetable
Add Friends
My Friends
My Profile
My Son’s Profile
My Son’s Teacher
All Teacher
My Son’s Subject
All Subject
My Son’s Timetable
All Timetable
My Son’s Attendance
My Son’s Attendance History
My Son’s Exam Marks
My Son’s Exam Marks History
My Son’s Exam Timetable
Insert
Update
Delete
Insert
Update
Delete
Insert
Update
Delete
Insert
Update
Delete
Insert
Update
Delete
Insert
All Student Update
Delete
Insert
Update
Delete
Login Page (Index)
Admin View
Teacher View
Student View
Parent View
Download source code of School Management System with PHP & MySQL project: School Management System with PHP & MySQL
Login Details for Demo Purpose only. Please note: Demo users, you are not able to change the details
Admin User
Username: admin@getprojects.org
Password: 12345
Parent User
Username: dad1@gmail.com
Password: 12345
Teacher User
Username: t1@gmail.com
Password: 12345
Student User
Username: std1@gmail.com
Password: 12345
We have successfully developed the Create School Management System with PHP & MySQL Project. We learn different features of School Management System like Student Management, Teacher Management, Attendance Management, Salary Management, Timetable Management, Exam Management and many more..
In this way we successfully made a School Management System with PHP & MySQL. I hope you enjoyed building School Management System with PHP & MySQL.
Other Useful Projects
1. Create School Management System in Python, Download Source Code
2. Create Notepad using Java, Download Source Code
3. Create Calculator Program in Python, Download Source Code
4. Create Fruit Ninja Game in Python, Download Source Code
Search Keywords
Welcome to "How To Build A Quiz App With JavaScript for Beginners"! In the vast…
Welcome to the exciting world of Python programming! Whether you're a complete beginner or looking…
The ability to identify and classify different species of flowers is a valuable skill for…
Artificial intelligence (AI) has become a transformative technology with applications in various domains, from healthcare…
Are you a Btech Computer Science or MCA student looking for project ideas to showcase…
ChatGPT is a powerful tool for generating human-like text, but there is still room for…
View Comments
Can I use this project for business purpose without any copyright issue?
can i use this project for business purpose without any copyright issue?