Skip to content

School Management System Project With Source Code In Php «2026 Edition»

A robust system starts with a well-structured MySQL database. You will need tables for users, classes, subjects, and records.

: Stores credentials and role IDs (Admin, Teacher, Student, Parent). school management system project with source code in php

: Move your project directory into your local web root folder (e.g., C:/xampp/htdocs/school_system/ ). A robust system starts with a well-structured MySQL database

query($sql) === TRUE) echo "New student added successfully"; else echo "Error: " . $sql . " " . $conn->error; ?> Use code with caution. 5. Technology Stack PHP Database: MySQL Frontend: HTML5, CSS3, Bootstrap, JavaScript Server: Apache (XAMPP or WAMP) 6. How to Run This Project : Move your project directory into your local

CREATE DATABASE school_db; USE school_db; -- Users Table (Handles authentication for all roles) CREATE TABLE users ( id INT AUTO_INCREMENT PRIMARY KEY, username VARCHAR(50) NOT NULL UNIQUE, password VARCHAR(255) NOT NULL, role ENUM('admin', 'teacher', 'student') NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); -- Students Table CREATE TABLE students ( student_id INT AUTO_INCREMENT PRIMARY KEY, user_id INT, first_name VARCHAR(50) NOT NULL, last_name VARCHAR(50) NOT NULL, dob DATE, class_name VARCHAR(20), FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE ); -- Teachers Table CREATE TABLE teachers ( teacher_id INT AUTO_INCREMENT PRIMARY KEY, user_id INT, first_name VARCHAR(50) NOT NULL, last_name VARCHAR(50) NOT NULL, subject VARCHAR(50), FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE ); -- Attendance Table CREATE TABLE attendance ( attendance_id INT AUTO_INCREMENT PRIMARY KEY, student_id INT, status ENUM('Present', 'Absent', 'Late') NOT NULL, date DATE NOT NULL, FOREIGN KEY (student_id) REFERENCES students(student_id) ON DELETE CASCADE ); -- Grades Table CREATE TABLE grades ( grade_id INT AUTO_INCREMENT PRIMARY KEY, student_id INT, subject VARCHAR(50) NOT NULL, marks_obtained INT NOT NULL, total_marks INT NOT NULL, exam_date DATE, FOREIGN KEY (student_id) REFERENCES students(student_id) ON DELETE CASCADE ); Use code with caution. 💻 Core Source Code Implementation

-- 5. Teachers table CREATE TABLE teachers ( id INT(11) AUTO_INCREMENT PRIMARY KEY, teacher_name VARCHAR(100) NOT NULL, email VARCHAR(100) UNIQUE, mobile VARCHAR(15), subject_id INT(11), class_id INT(11), password VARCHAR(255) NOT NULL, FOREIGN KEY (subject_id) REFERENCES subjects(id), FOREIGN KEY (class_id) REFERENCES classes(id) );