Student Record System Using PHP and MySQL
Student Record System is a web-based technology that manages student databases and provides rights to update the details. In this web application, Students must be registered by admin. This web application provides a way to effectively control records & track student details.
Student Record System is software which is helpful for students as well as the school authorities. In the current system all the activities are done manually. It is very time-consuming and costly. Our Student Management System deals with the various activities related to the students.
Project Requirements
| Project Name | Students Record Management Project in PHP |
|---|---|
| Language Used | PHP5.6, PHP7.x |
| Database | MySQL 5.x |
| User Interface Design | HTML, AJAX,JQUERY,JAVASCRIPT |
| Web Browser | Mozilla, Google Chrome, IE8, OPERA |
| Software | XAMPP / Wamp / Mamp/ Lamp (anyone) |
| Last Updated | Feb 2024 |
Project Modules
In this project, we use PHP and MySQL database and it has one module i.e. Admin.
Admin Module:
- Admin Secure login.
- Dashboard: In this section, admin can view the total no Courses, Subjects Student, Countries, States and cities also.
- Course: In this section admin can manage the courses (Add, edit, delete).
- Subject: In this section, admin can manage the subjects course wise (Add, edit, delete).
- Register: In this section, admin can add student’s details.
- View Students: In this section, admin can view, edit and delete student details.
- Session: In this section, admin can update the academic session.
- Change password: in this section, admin can change their password.
- Admin Profile: In this section, admin can update the profile details.
- Logout
Database tables
| cities |
| countries |
| registration |
| session |
| states |
| subject |
| tbl_course |
| tbl_login |
Some of the Project Screens
Admin Login
Admin Dashboard
Add Subjects
Register Students
How to run the Student Record System Project using PHP and MySQL
1. Download the project zip file
2. Extract the file and copy studentrecordms folder
3.Paste inside root directory(for xampp xampp/htdocs, for wamp wamp/www, for lamp var/www/Html)
4.Open PHPMyAdmin (http://localhost/phpmyadmin)
5. Create a database with the name studentrecorddb
6. Import studentrecorddb.sql file(given inside the zip package in SQL file folder)
7. Run the script http://localhost/studentrecordms
Admin Credential
Username: admin
Password: Test@12345
