Student-Record-Management-System

Student Records Management System (PHP & MySQL)

A simple web application to manage student records, built with classic PHP (mysqli) and MySQL.

Features

• Add new students
• View all students
• Filter students by registration number or name
• Edit existing student records
• Delete student records

Database Structure

The database schema can be found in database_schema.sql.

-- (You can paste the content of database_schema.sql here if it's short, or just refer to the file)
CREATE DATABASE IF NOT EXISTS IS181;
USE IS181;
CREATE TABLE students (
 student_name VARCHAR(100),
 registration_no VARCHAR(20) PRIMARY KEY,
 gender ENUM('Male', 'Female', 'Other'),
 phone_number VARCHAR(15),
 programme VARCHAR(100),
 test1 FLOAT,
 test2 FLOAT,
 ue FLOAT,
 total FLOAT
);