School Fees Payment System using PHP/MySQLi with Source Code

Project: School Fees Payment System using PHP/MySQLi with Source Code

About

The School Fees Payment System is a simple PHP/MySQLi project that may help a certain school manage their student's fee payments. This project stores fees per course and level. Talking about the fees per course and level, each course and level list the detailed calculation of the school fees, which means the fees per course and level can have multiple lists such as the tuition, miscellaneous, and other types of fees for the certain course and level. The school fees payment system also stores the student list and the list of student fees which means on the Student Fees list, it is possible that a certain student has a double entry which is not because they have a different Enrollment Number or EF. No. and this field are to identify the payable fee of the student per semester although there is no section or feature in this project for managing the semester of the school which is why I only use the enrollment number. The payment feature in this project has only a simple process which is enough for managing the payment, generate a receipt, and generate the payment summary per student's semester. This project also generates monthly payment reports for school management reference purposes.

Features

• Login Page
  • The page where the system admin or user submit their system credential to access the data and functionalities of the school fees payment system.
• Home Page
  • The page where the system users will be redirected by default when logging into the system.
• Students Page
  • The page where the school students are listed and managed.
• Courses & Fees Page
  • The page where the courses per level are listed and managed along with the fees for each course and level.
• Student Fess Page
  • The page where the list of students per school year with the help of the enrollment ID is listed and managed.
• Payments Page
  • The page where the payments are listed and managed.
• Payments Report Page
  • The page where the monthly report of payments is shown and ready to print.
• Users Page
  • The page where the system admin manages the list of school fees payment system users.

The School Fees Payment System was developed using HTML, PHP/MySQLi, CSS, JavaScript (jQuery/Ajax), and Bootstrap for the design. The source code is fully functional and easy to modify or enhance. Follow the instruction below to have an actual experience using this simple project.

How to Run

1. Download the source code and extract the zip file.
2. Download or set up any local web server that runs PHP script.
3. Open the web-server database and create a new database name it sfps_db.
4. Import the SQL file located in the database folder of the source code.
5. Copy and paste the source code to the location where your local web server accessing your local projects. Example for XAMPP('C:\xampp\htdocs')
6. Open a web browser and browse the project. E.g [http://localhost/school-fees-payment-system]

Admin Default Access

Username: admin

Password: admin123

I hope this simple School Fees Payment System will help you with what you are looking for, feel free to download and modify the source code.

Explore more on this website for more source codes and tutorials.

Enjoy!