Project: Fees RecordBook Module PHP/MySQLi with Source Code
About Fees RecordBook is a simple PHP/MySQLi project that may help, manage their student's fee payments module. 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 Download the source code and extract the zip file. Download or set up any local web server that runs PHP script. Open the web-server database and create a new database name it sfps_db. Import the SQL file located in the database folder of the source code. Copy and paste the source code to the location where your local web server accessing your local projects. Example for XAMPP('C:\xampp\htdocs') Open a web browser and browse the project. E.g [http://localhost/schoolfees]
Admin Default Access
Username: admin
Password: admin123
.[screenshots:]
with Regards, Pem Tshering
Enjoy!