Student Database Management System

A PHP/MySQL web application for managing student records, courses, and subjects - featuring a dashboard, full CRUD operations, session-based authentication, and a Singleton database pattern.

Overview • Features • Tech Stack • Database • Architecture • Installation • Usage

---

📖 Overview

A full-stack web application for student information management, built with PHP and MySQL. The system allows administrators to manage students, courses, and subjects through a clean dashboard interface with complete Create, Read, Update, and Delete (CRUD) operations.

This was developed as a 3rd semester B.Tech project demonstrating practical database management, server-side scripting, MVC-like architecture, and the Singleton design pattern.

---

✨ Features

👨‍🎓 Student Management

• Register new students with personal and academic details (name, gender, guardian, income, category, phone, email, course, session)
• View all enrolled students in a tabular format
• Edit student records
• Delete student entries

📚 Course Management

• Add new courses with short name, full name, and date
• View all available courses
• Edit course details
• Delete courses
• Check course availability

📝 Subject Management

• Add subjects linked to courses (up to 3 subjects per entry)
• View all subjects
• Edit subject details
• Delete subjects

🔐 Authentication & Security

• Admin login with session management
• Session-based page protection
• Logout functionality
• Prepared statements for SQL injection prevention (bind_param)

📊 Dashboard

• Admin dashboard with statistics overview
• Morris.js and Flot data visualizations
• Quick access to all management modules

---

🛠 Tech Stack

Category	Technology	Purpose
Backend	PHP 7.x	Server-side logic and routing
Database	MySQL	Relational data storage
DB Pattern	Singleton (Database.php)	Single shared DB connection
Frontend	HTML5 / CSS3	Page structure and styling
UI Framework	Bootstrap (via Bower)	Responsive layout and components
Charts	Morris.js, Flot	Dashboard data visualizations
JavaScript	Vanilla JS	Client-side interactions and alerts
Server	Apache (XAMPP/WAMP/LAMP)	PHP-capable web server
Package Manager	Bower	Frontend dependency management

---

🗄️ Database Schema

Database name: schoolmanagement

The system manages the following data entities:

Entity	Key Fields	Operations
Login	loginid, password	Authentication
Courses	course_short, course_full, date	Full CRUD
Subjects	course_ref, subject1, subject2, subject3	Full CRUD
Students	name, gender, guardian, course, session, phone, email, income, category	Full CRUD
Sessions	session year/period	Reference data
Countries	country list	Reference data for registration

Default login credentials:

Username: admin
Password: admin

---

🏗 Architecture

┌──────────────────────────────────────────────────────────┐
│                  Browser (Client)                         │
│     Dashboard │ Students │ Courses │ Subjects │ Login     │
└───────────────────────┬──────────────────────────────────┘
                        │ HTTP
┌───────────────────────▼──────────────────────────────────┐
│                    PHP Backend                            │
│                                                           │
│  ┌──────────────────────────────────────────────────┐    │
│  │              pages/                               │    │
│  │  dashboard.php    login.php     session.php       │    │
│  │  register.php     view.php      edit-std.php      │    │
│  │  add-course.php   view-course.php  edit-course.php│    │
│  │  add-subject.php  view-subject.php edit-sub.php   │    │
│  │  leftbar.php      logout.php    dbcontroller.php  │    │
│  └────────────────────┬─────────────────────────────┘    │
│                       │                                   │
│  ┌────────────────────▼─────────────────────────────┐    │
│  │              config/                              │    │
│  │  Database.php  ──  Singleton connection manager   │    │
│  │  DbFunction.php ── All CRUD operations            │    │
│  │     • login()         • register()                │    │
│  │     • create_course() • edit_course()             │    │
│  │     • create_subject()• edit_subject()            │    │
│  │     • showStudents()  • del_course()              │    │
│  │     • showCourse()    • del_std()                 │    │
│  │     • showSubject()   • del_subject()             │    │
│  └────────────────────┬─────────────────────────────┘    │
│                       │                                   │
└───────────────────────┼──────────────────────────────────┘
                        │ mysqli
┌───────────────────────▼──────────────────────────────────┐
│                MySQL Database                             │
│               schoolmanagement                            │
│  tbl_login │ tbl_courses │ tbl_subjects │ tbl_students   │
│  tbl_session │ tbl_country                                │
└──────────────────────────────────────────────────────────┘

Design Patterns Used

Pattern	Implementation	Purpose
Singleton	Database.php	Ensures only one DB connection exists throughout the application
Data Access Object (DAO)	DbFunction.php	Centralizes all database queries in one class
Session Guard	session.php	Protects pages from unauthorized access

---

🚀 Installation

Prerequisites

• XAMPP / WAMP / LAMP (Apache + PHP + MySQL)
• Web browser

Setup Steps

# 1. Clone the repository
git clone https://github.com/zishnusarker/A-Student-Database-Management-System-.git

# 2. Copy the project to your web server directory
# The actual app code is inside this nested path:
#   Student Management System/std php/std php/

# For XAMPP (Windows):
xcopy "Student Management System\std php\std php" C:\xampp\htdocs\student-mgmt /E /I

# For XAMPP (Linux/Mac):
cp -r "Student Management System/std php/std php/" /opt/lampp/htdocs/student-mgmt

Database Setup

1. Start Apache and MySQL from XAMPP/WAMP control panel
2. Open phpMyAdmin at http://localhost/phpmyadmin
3. Create a new database:

   CREATE DATABASE schoolmanagement;

4. Import the schema:
   • Click on schoolmanagement database
   • Go to Import tab
   • Select schoolmanagement.sql from the project folder
   • Click Go

Access the Application

http://localhost/student-mgmt/index.php

Login with:

Username: admin
Password: admin

---

📋 Usage

Dashboard

After login, the dashboard provides an overview with quick access links to all modules.

Managing Students

• Add Student - Fill in personal details, select course and session, submit
• View Students - Browse all enrolled students in a table
• Edit Student - Click edit on any record, modify fields, save
• Delete Student - Remove a student record permanently

Managing Courses

• Add Course - Enter course short name, full name, and date
• View Courses - List all courses with edit/delete actions
• Course Availability - Check which courses are currently active

Managing Subjects

• Add Subject - Link up to 3 subjects to a course
• View Subjects - See all subject entries
• Edit/Delete - Modify or remove subject records

---

📁 Project Structure

A-Student-Database-Management-System-/
├── README.md
├── .gitattributes
│
└── Student Management System/
    └── std php/std php/                    # Main application root
        ├── index.php                       # Entry point
        ├── schoolmanagement.sql            # Database schema
        ├── READ ME FIRST !!!!.txt          # Original setup instructions
        │
        ├── config/                         # Database layer
        │   ├── Database.php                # Singleton DB connection
        │   └── DbFunction.php             # All CRUD operations (18 functions)
        │
        ├── pages/                          # Application pages (17 files)
        │   ├── login.php                   # Admin login
        │   ├── logout.php                  # Session destroy
        │   ├── session.php                 # Session guard
        │   ├── dashboard.php               # Main dashboard
        │   ├── leftbar.php                 # Sidebar navigation
        │   ├── dbcontroller.php            # Form action handler
        │   ├── register.php                # Student registration
        │   ├── view.php                    # View all students
        │   ├── edit-std.php                # Edit student
        │   ├── add-course.php              # Add course
        │   ├── view-course.php             # View courses
        │   ├── edit-course.php             # Edit course
        │   ├── course_availability.php     # Check availability
        │   ├── add-subject.php             # Add subject
        │   ├── view-subject.php            # View subjects
        │   ├── edit-sub.php                # Edit subject
        │   └── subject.php                 # Subject details
        │
        ├── dist/                           # Static assets (CSS, JS, images)
        ├── bower_components/               # Frontend libraries (Bootstrap, etc.)
        └── js/                             # Chart data files
            ├── flot-data.js                # Flot chart data
            └── morris-data.js              # Morris chart data

---

🎓 Key Concepts Demonstrated

What is the Singleton Design Pattern?

The Singleton pattern ensures a class has only one instance and provides a global access point to it. In this project, Database.php uses Singleton to maintain a single MySQL connection throughout the application - preventing multiple redundant connections that waste server resources.

Key elements: private constructor, private static instance variable, public getInstance() method, and a private __clone() to prevent duplication.

Why use Prepared Statements?

DbFunction.php uses prepared statements ($mysqli->prepare() + $stmt->bind_param()) instead of concatenating user input into SQL strings. This prevents SQL injection attacks - one of the most common web vulnerabilities (OWASP Top 10). The database treats bound parameters as data, never as executable SQL code.

What is Session-Based Authentication?

PHP sessions store user state between page requests. After a successful login, a session variable is set. The session.php guard checks for this variable on every protected page - redirecting unauthenticated users back to the login page. logout.php destroys the session.

What is the DAO pattern?

The Data Access Object (DAO) pattern separates database operations from business logic. DbFunction.php serves as the DAO - all SQL queries are centralized in one class with clearly named functions (create_course(), showStudents(), del_subject(), etc.). This makes the code maintainable and changes to the database only affect one file.

---

🔮 Future Improvements

• Migrate from Bower to npm or CDN-based dependencies
• Add password hashing (bcrypt) instead of plaintext storage
• Implement CSRF token protection on forms
• Add input sanitization and server-side validation
• Implement role-based access control (admin vs teacher vs student)
• Add search and filtering on list views
• Implement pagination for large datasets
• Add student attendance and grade tracking modules
• Migrate to PDO from mysqli for better portability
• Add responsive mobile layout improvements
• Implement RESTful API endpoints for future frontend integration

---

⚠️ Security Note

This is an educational project. It uses default credentials (admin/admin) and plaintext password storage. For production use, you would need to implement password hashing, CSRF protection, input sanitization, HTTPS, and proper access controls.

---

📄 License

This project is available as open source.

---

Made with ❤️ as a B.Tech 3rd Semester Database Project