Creating a Coaching Management System involves several components, including a MySQL database schema, file structure, layout design using Bootstrap 5, and complete PHP scripts for user authentication and management. Below is a comprehensive guide to help you set up your system.

Project Introduction

The Coaching Management System is a comprehensive web application designed to facilitate the management of coaching classes and student interactions. This platform allows administrators, teachers, and students to manage courses, enrollments, schedules, and assessments efficiently. With features for attendance tracking, payment processing, and feedback collection, the system aims to enhance the educational experience for students while providing teachers with the tools they need to manage their classes effectively.

Project Objectives

  • To develop a secure and user-friendly platform for managing coaching classes and student interactions.
  • To implement a comprehensive database schema that supports user management, course management, and student assessments.
  • To provide functionalities for tracking student attendance and managing course schedules.
  • To facilitate payment processing for course enrollments and manage financial transactions efficiently.
  • To create a feedback mechanism for students to evaluate courses and instructors.
  • To ensure a responsive design that enhances user experience across various devices.

Project Modules

  1. User Management: Handles user registration, authentication, and role assignments (admin, teacher, student).
  2. Course Management: Allows teachers to create, update, and manage courses, including descriptions and objectives.
  3. Enrollment Management: Facilitates student enrollments in courses and tracks enrollment dates.
  4. Schedule Management: Manages class schedules, including start and end times, locations, and instructors.
  5. Attendance Tracking: Records student attendance for each class session and tracks attendance status.
  6. Assessment Management: Allows teachers to create and manage assessments, including due dates and descriptions.
  7. Submission Management: Handles student submissions for assessments, including grading and feedback.
  8. Payment Processing: Manages payments for course enrollments, including payment methods and statuses.
  9. Notification System: Sends alerts and messages to users regarding important updates and events.
  10. Feedback Collection: Collects ratings and comments from students regarding courses and instructors.
  11. Resource Management: Allows teachers to upload and manage resources related to courses, such as documents and videos.

1. MySQL Database Schema


CREATE DATABASE coaching_management_system;
USE coaching_management_system;
-- Table for users
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL UNIQUE,
    password VARCHAR(255) NOT NULL,
    email VARCHAR(100) NOT NULL UNIQUE,
    role ENUM('admin', 'teacher', 'student') DEFAULT 'student',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
-- Table for courses
CREATE TABLE courses (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    description TEXT NOT NULL,
    objectives TEXT,
    created_by INT NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    FOREIGN KEY (created_by) REFERENCES users(id) ON DELETE CASCADE
);
-- Table for student enrollments
CREATE TABLE enrollments (
    id INT AUTO_INCREMENT PRIMARY KEY,
    student_id INT NOT NULL,
    course_id INT NOT NULL,
    enrollment_date DATE NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (student_id) REFERENCES users(id) ON DELETE CASCADE,
    FOREIGN KEY (course_id) REFERENCES courses(id) ON DELETE CASCADE
);
-- Table for schedules
CREATE TABLE schedules (
    id INT AUTO_INCREMENT PRIMARY KEY,
    course_id INT NOT NULL,
    instructor_id INT NOT NULL,
    start_time DATETIME NOT NULL,
    end_time DATETIME NOT NULL,
    location VARCHAR(255),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (course_id) REFERENCES courses(id) ON DELETE CASCADE,
    FOREIGN KEY (instructor_id) REFERENCES users(id) ON DELETE CASCADE
);
-- Table for attendance
CREATE TABLE attendance (
    id INT AUTO_INCREMENT PRIMARY KEY,
    student_id INT NOT NULL,
    schedule_id INT NOT NULL,
    attendance_date DATE NOT NULL,
    status ENUM('present', 'absent', 'late') DEFAULT 'present',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (student_id) REFERENCES users(id) ON DELETE CASCADE,
    FOREIGN KEY (schedule_id) REFERENCES schedules(id) ON DELETE CASCADE
);
-- Table for assessments
CREATE TABLE assessments (
    id INT AUTO_INCREMENT PRIMARY KEY,
    course_id INT NOT NULL,
    title VARCHAR(255) NOT NULL,
    description TEXT NOT NULL,
    due_date DATETIME NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (course_id) REFERENCES courses(id) ON DELETE CASCADE
);
-- Table for submissions
CREATE TABLE submissions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    assessment_id INT NOT NULL,
    student_id INT NOT NULL,
    submission_date DATETIME NOT NULL,
    grade DECIMAL(5, 2),
    feedback TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (assessment_id) REFERENCES assessments(id) ON DELETE CASCADE,
    FOREIGN KEY (student_id) REFERENCES users(id) ON DELETE CASCADE
);
-- Table for payments
CREATE TABLE payments (
    id INT AUTO_INCREMENT PRIMARY KEY,
    student_id INT NOT NULL,
    course_id INT NOT NULL,
    payment_date DATETIME NOT NULL,
    amount DECIMAL(10, 2) NOT NULL,
    payment_method ENUM('credit_card', 'bank_transfer', 'cash') NOT NULL,
    status ENUM('completed', 'pending', 'failed') DEFAULT 'pending',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (student_id) REFERENCES users(id) ON DELETE CASCADE,
    FOREIGN KEY (course_id) REFERENCES courses(id) ON DELETE CASCADE
);
-- Table for notifications
CREATE TABLE notifications (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    message TEXT NOT NULL,
    is_read BOOLEAN DEFAULT FALSE,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);
-- Table for feedback
CREATE TABLE feedback (
    id INT AUTO_INCREMENT PRIMARY KEY,
    course_id INT NOT NULL,
    student_id INT NOT NULL,
    rating INT CHECK (rating >= 1 AND rating <= 5),
    comments TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (course_id) REFERENCES courses(id) ON DELETE CASCADE,
    FOREIGN KEY (student_id) REFERENCES users(id) ON DELETE CASCADE
);
-- Table for resources
CREATE TABLE resources (
    id INT AUTO_INCREMENT PRIMARY KEY,
    course_id INT NOT NULL,
    resource_type ENUM('document', 'link', 'video') NOT NULL,
    file_path VARCHAR(255) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (course_id) REFERENCES courses(id) ON DELETE CASCADE
);

2. File and Folder Structure


coaching_management_system/
│
├── config/
│   └── db.php
│
├── public/
│   ├── index.php
│   ├── login.php
│   ├── register.php
│   ├── dashboard.php
│   ├── courses.php
│   ├── enrollments.php
│   ├── schedules.php
│   ├── attendance.php
│   ├── assessments.php
│   ├── payments.php
│   ├── notifications.php
│   ├── feedback.php
│   ├── resources.php
│   └── admin_dashboard.php
│
├── includes/
│   ├── header.php
│   ├── footer.php
│   └── functions.php
│
├── assets/
│   ├── css/
│   │   └── styles.css
│   ├── js/
│   │   └── scripts.js
│   └── images/
│
└── vendor/
    └── (Bootstrap and other libraries)

3. Layout Based Design with Bootstrap 5

Header (includes/header.php)


<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
    <link rel="stylesheet" href="assets/css/styles.css">
    <title>Coaching Management System</title>
</head>
<body>
    <div class="container">
        <header class="my-4">
            <h1>Coaching Management System</h1>
        </header>
        <nav class="navbar navbar-expand-lg navbar-light bg-light">
            <div class="container-fluid">
                <a class="navbar-brand" href="index.php">Home</a>
                <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
                    <span class="navbar-toggler-icon"></span>
                </button>
                <div class="collapse navbar-collapse" id="navbarNav">
                    <ul class="navbar-nav">
                        <li class="nav-item">
                            <a class="nav-link" href="courses.php">Courses</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="enrollments.php">Enrollments</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="schedules.php">Schedules</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="attendance.php">Attendance</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="assessments.php">Assessments</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="payments.php">Payments</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="notifications.php">Notifications</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="feedback.php">Feedback</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="resources.php">Resources</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="login.php">Login</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="register.php">Register</a>
                        </li>
                    </ul>
                </div>
            </div>
        </nav>
        <main class="my-4">

Footer (includes/footer.php)


        </main>
        <footer class="text-center my-4">
            <p>© 2023 Coaching Management System. All rights reserved.</p>
        </footer>
    </div>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>

4. PHP Code for User Authentication

Registration (public/register.php)


<?php
require '../config/db.php';
require '../includes/header.php';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $username = $_POST['username'];
    $email = $_POST['email'];
    $password = password_hash($_POST['password'], PASSWORD_DEFAULT);
    $role = $_POST['role'];
    $stmt = $conn->prepare("INSERT INTO users (username, email, password, role) VALUES (?, ?, ?, ?)");
    $stmt->bind_param("ssss", $username, $email, $password, $role);
    $stmt->execute();
    $stmt->close();
    header("Location: login.php");
}
?>
<form method="POST" action="">
    <div class="mb-3">
        <label for="username" class="form-label">Username</label>
        <input type="text" class="form-control" id="username" name="username" required>
    </div>
    <div class="mb-3">
        <label for="email" class="form-label">Email</label>
        <input type="email" class="form-control" id="email" name="email" required>
    </div>
    <div class="mb-3">
        <label for="password" class="form-label">Password</label>
        <input type="password" class="form-control" id="password" name="password" required>
    </div>
    <div class="mb-3">
        <label for="role" class="form-label">Role</label>
        <select class="form-select" id="role" name="role">
            <option value="student">Student</option>
            <option value="teacher">Teacher</option>
            <option value="admin">Admin</option>
        </select>
    </div>
    <button type="submit" class="btn btn-primary">Register</button>
</form>
<?php require '../includes/footer.php'; ?>

Login (public/login.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $username = $_POST['username'];
    $password = $_POST['password'];
    $stmt = $conn->prepare("SELECT * FROM users WHERE username = ?");
    $stmt->bind_param("s", $username);
    $stmt->execute();
    $result = $stmt->get_result();
    $user = $result->fetch_assoc();
    if ($user && password_verify($password, $user['password'])) {
        $_SESSION['user_id'] = $user['id'];
        $_SESSION['role'] = $user['role'];
        header("Location: dashboard.php");
    } else {
        echo "Invalid credentials.";
    }
}
?>
<form method="POST" action="">
    <div class="mb-3">
        <label for="username" class="form-label">Username</label>
        <input type="text" class="form-control" id="username" name="username" required>
    </div>
    <div class="mb-3">
        <label for="password" class="form-label">Password</label>
        <input type="password" class="form-control" id="password" name="password" required>
    </div>
    <button type="submit" class="btn btn-primary">Login</button>
</form>
<?php require '../includes/footer.php'; ?>

5. Additional PHP Scripts

Dashboard (public/dashboard.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit();
}
$user_id = $_SESSION['user_id'];
$stmt = $conn->prepare("SELECT * FROM users WHERE id = ?");
$stmt->bind_param("i", $user_id);
$stmt->execute();
$result = $stmt->get_result();
$user = $result->fetch_assoc();
?>
<h2>Welcome, <?php echo $user['username']; ?></h2>
<p>Your role: <?php echo ucfirst($user['role']); ?></p>
<?php require '../includes/footer.php'; ?>

Course Management (public/courses.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id']) || $_SESSION['role'] !== 'admin') {
    header("Location: login.php");
    exit();
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $title = $_POST['title'];
    $description = $_POST['description'];
    $objectives = $_POST['objectives'];
    $stmt = $conn->prepare("INSERT INTO courses (title, description, objectives, created_by) VALUES (?, ?, ?, ?)");
    $stmt->bind_param("sssi", $title, $description, $objectives, $_SESSION['user_id']);
    $stmt->execute();
    $stmt->close();
    header("Location: courses.php");
}
?>
<h2>Manage Courses</h2>
<form method="POST" action="">
    <div class="mb-3">
        <label for="title" class="form-label">Course Title</label>
        <input type="text" class="form-control" id="title" name="title" required>
    </div>
    <div class="mb-3">
        <label for="description" class="form-label">Description</label>
        <textarea class="form-control" id="description" name="description" required></textarea>
    </div>
    <div class="mb-3">
        <label for="objectives" class="form-label">Objectives</label>
        <textarea class="form-control" id="objectives" name="objectives" required></textarea>
    </div>
    <button type="submit" class="btn btn-primary">Add Course</button>
</form>
<?php require '../includes/footer.php'; ?>

Enrollment Management (public/enrollments.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit();
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $student_id = $_SESSION['user_id'];
    $course_id = $_POST['course_id'];
    $stmt = $conn->prepare("INSERT INTO enrollments (student_id, course_id, enrollment_date) VALUES (?, ?, NOW())");
    $stmt->bind_param("ii", $student_id, $course_id);
    $stmt->execute();
    $stmt->close();
    header("Location: enrollments.php");
}
// Fetch courses for the form
$stmt = $conn->prepare("SELECT * FROM courses");
$stmt->execute();
$result = $stmt->get_result();
$courses = $result->fetch_all(MYSQLI_ASSOC);
?>
<h2>Enroll in Courses</h2>
<form method="POST" action="">
    <div class="mb-3">
        <label for="course_id" class="form-label">Select Course</label>
        <select class="form-select" id="course_id" name="course_id" required>
            <?php foreach ($courses as $course): ?>
            <option value="<?php echo $course['id']; ?>"><?php echo $course['title']; ?></option>
            <?php endforeach; ?>
        </select>
    </div>
    <button type="submit" class="btn btn-primary">Enroll</button>
</form>
<?php require '../includes/footer.php'; ?>

Schedule Management (public/schedules.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id']) || $_SESSION['role'] !== 'admin') {
    header("Location: login.php");
    exit();
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $course_id = $_POST['course_id'];
    $instructor_id = $_POST['instructor_id'];
    $start_time = $_POST['start_time'];
    $end_time = $_POST['end_time'];
    $location = $_POST['location'];
    $stmt = $conn->prepare("INSERT INTO schedules (course_id, instructor_id, start_time, end_time, location) VALUES (?, ?, ?, ?, ?)");
    $stmt->bind_param("iiss", $course_id, $instructor_id, $start_time, $end_time, $location);
    $stmt->execute();
    $stmt->close();
    header("Location: schedules.php");
}
// Fetch courses and instructors for the form
$stmt = $conn->prepare("SELECT * FROM courses");
$stmt->execute();
$result = $stmt->get_result();
$courses = $result->fetch_all(MYSQLI_ASSOC);
$stmt = $conn->prepare("SELECT * FROM users WHERE role = 'teacher'");
$stmt->execute();
$result = $stmt->get_result();
$instructors = $result->fetch_all(MYSQLI_ASSOC);
?>
<h2>Manage Schedules</h2>
<form method="POST" action="">
    <div class="mb-3">
        <label for="course_id" class="form-label">Select Course</label>
        <select class="form-select" id="course_id" name="course_id" required>
            <?php foreach ($courses as $course): ?>
            <option value="<?php echo $course['id']; ?>"><?php echo $course['title']; ?></option>
            <?php endforeach; ?>
        </select>
    </div>
    <div class="mb-3">
        <label for="instructor_id" class="form-label">Select Instructor</label>
        <select class="form-select" id="instructor_id" name="instructor_id" required>
            <?php foreach ($instructors as $instructor): ?>
            <option value="<?php echo $instructor['id']; ?>"><?php echo $instructor['username']; ?></option>
            <?php endforeach; ?>
        </select>
    </div>
    <div class="mb-3">
        <label for="start_time" class="form-label">Start Time</label>
        <input type="datetime-local" class="form-control" id="start_time" name="start_time" required>
    </div>
    <div class="mb-3">
        <label for="end_time" class="form-label">End Time</label>
        <input type="datetime-local" class="form-control" id="end_time" name="end_time" required>
    </div>
    <div class="mb-3">
        <label for="location" class="form-label">Location</label>
        <input type="text" class="form-control" id="location" name="location" required>
    </div>
    <button type="submit" class="btn btn-primary">Add Schedule</button>
</form>
<?php require '../includes/footer.php'; ?>

Attendance Management (public/attendance.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id']) || $_SESSION['role'] !== 'teacher') {
    header("Location: login.php");
    exit();
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $student_id = $_POST['student_id'];
    $schedule_id = $_POST['schedule_id'];
    $status = $_POST['status'];
    $stmt = $conn->prepare("INSERT INTO attendance (student_id, schedule_id, status) VALUES (?, ?, ?)");
    $stmt->bind_param("iis", $student_id, $schedule_id, $status);
    $stmt->execute();
    $stmt->close();
    header("Location: attendance.php");
}
// Fetch students and schedules for the form
$stmt = $conn->prepare("SELECT * FROM users WHERE role = 'student'");
$stmt->execute();
$result = $stmt->get_result();
$students = $result->fetch_all(MYSQLI_ASSOC);
$stmt = $conn->prepare("SELECT * FROM schedules");
$stmt->execute();
$result = $stmt->get_result();
$schedules = $result->fetch_all(MYSQLI_ASSOC);
?>
<h2>Manage Attendance</h2>
<form method="POST" action="">
    <div class="mb-3">
        <label for="student_id" class="form-label">Select Student</label>
        <select class="form-select" id="student_id" name="student_id" required>
            <?php foreach ($students as $student): ?>
            <option value="<?php echo $student['id']; ?>"><?php echo $student['username']; ?></option>
            <?php endforeach; ?>
        </select>
    </div>    
    <div class="mb-3">
        <label for="schedule_id" class="form-label">Select Schedule</label>
        <select class="form-select" id="schedule_id" name="schedule_id" required>
            <?php foreach ($schedules as $schedule): ?>
            <option value="<?php echo $schedule['id']; ?>"><?php echo $schedule['start_time'] . ' - ' . $schedule['end_time']; ?></option>
            <?php endforeach; ?>
        </select>
    </div>
    <div class="mb-3">
        <label for="status" class="form-label">Attendance Status</label>
        <select class="form-select" id="status" name="status" required>
            <option value="present">Present</option>
            <option value="absent">Absent</option>
            <option value="late">Late</option>
        </select>
    </div>
    <button type="submit" class="btn btn-primary">Mark Attendance</button>
</form>
<h3>Attendance Records</h3>
<table class="table">
    <thead>
        <tr>
            <th>ID</th>
            <th>Student</th>
            <th>Schedule</th>
            <th>Status</th>
            <th>Date</th>
        </tr>
    </thead>
    <tbody>
        <?php
        $stmt = $conn->prepare("SELECT a.*, u.username, s.start_time, s.end_time FROM attendance a JOIN users u ON a.student_id = u.id JOIN schedules s ON a.schedule_id = s.id");
        $stmt->execute();
        $result = $stmt->get_result();
        while ($attendance = $result->fetch_assoc()): ?>
        <tr>
            <td><?php echo $attendance['id']; ?></td>
            <td><?php echo $attendance['username']; ?></td>
            <td><?php echo date('Y-m-d H:i', strtotime($attendance['start_time'])) . ' - ' . date('H:i', strtotime($attendance['end_time'])); ?></td>
            <td><?php echo ucfirst($attendance['status']); ?></td>
            <td><?php echo date('Y-m-d', strtotime($attendance['created_at'])); ?></td>
        </tr>
        <?php endwhile; ?>
    </tbody>
</table>
<?php require '../includes/footer.php'; ?>

Assessment Management (public/assessments.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id']) || $_SESSION['role'] !== 'teacher') {
    header("Location: login.php");
    exit();
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $course_id = $_POST['course_id'];
    $title = $_POST['title'];
    $description = $_POST['description'];
    $due_date = $_POST['due_date'];
    $stmt = $conn->prepare("INSERT INTO assessments (course_id, title, description, due_date) VALUES (?, ?, ?, ?)");
    $stmt->bind_param("isss", $course_id, $title, $description, $due_date);
    $stmt->execute();
    $stmt->close();
    header("Location: assessments.php");
}
// Fetch courses for the form
$stmt = $conn->prepare("SELECT * FROM courses");
$stmt->execute();
$result = $stmt->get_result();
$courses = $result->fetch_all(MYSQLI_ASSOC);
?>
<h2>Create Assessment</h2>
<form method="POST" action="">
    <div class="mb-3">
        <label for="course_id" class="form-label">Select Course</label>
        <select class="form-select" id="course_id" name="course_id" required>
            <?php foreach ($courses as $course): ?>
            <option value="<?php echo $course['id']; ?>"><?php echo $course['title']; ?></option>
            <?php endforeach; ?>
        </select>
    </div>
    <div class="mb-3">
        <label for="title" class="form-label">Assessment Title</label>
        <input type="text" class="form-control" id="title" name="title" required>
    </div>
    <div class="mb-3">
        <label for="description" class="form-label">Description</label>
        <textarea class="form-control" id="description" name="description" required></textarea>
    </div>
    <div class="mb-3">
        <label for="due_date" class="form-label">Due Date</label>
        <input type="datetime-local" class="form-control" id="due_date" name="due_date" required>
    </div>
    <button type="submit" class="btn btn-primary"> Create Assessment</button>
</form>
<h3>Existing Assessments</h3>
<table class="table">
    <thead>
        <tr>
            <th>ID</th>
            <th>Course</th>
            <th>Title</th>
            <th>Description</th>
            <th>Due Date</th>
        </tr>
    </thead>
    <tbody>
        <?php
        $stmt = $conn->prepare("SELECT a.*, c.title AS course_title FROM assessments a JOIN courses c ON a.course_id = c.id");
        $stmt->execute();
        $result = $stmt->get_result();
        while ($assessment = $result->fetch_assoc()): ?>
        <tr>
            <td><?php echo $assessment['id']; ?></td>
            <td><?php echo $assessment['course_title']; ?></td>
            <td><?php echo $assessment['title']; ?></td>
            <td><?php echo $assessment['description']; ?></td>
            <td><?php echo date('Y-m-d H:i', strtotime($assessment['due_date'])); ?></td>
        </tr>
        <?php endwhile; ?>
    </tbody>
</table>
<?php require '../includes/footer.php'; ?>

Payment Management (public/payments.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit();
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $student_id = $_SESSION['user_id'];
    $course_id = $_POST['course_id'];
    $amount = $_POST['amount'];
    $payment_method = $_POST['payment_method'];
    $stmt = $conn->prepare("INSERT INTO payments (student_id, course_id, payment_date, amount, payment_method, status) VALUES (?, ?, NOW(), ?, ?, 'pending')");
    $stmt->bind_param("iisd", $student_id, $course_id, $amount, $payment_method);
    $stmt->execute();
    $stmt->close();
    header("Location: payments.php");
}
// Fetch courses for the form
$stmt = $conn->prepare("SELECT * FROM courses");
$stmt->execute();
$result = $stmt->get_result();
$courses = $result->fetch_all(MYSQLI_ASSOC);
?>
<h2>Make a Payment</h2>
<form method="POST" action="">
    <div class="mb-3">
        <label for="course_id" class="form-label">Select Course</label>
        <select class="form-select" id="course_id" name="course_id" required>
            <?php foreach ($courses as $course): ?>
            <option value="<?php echo $course['id']; ?>"><?php echo $course['title']; ?></option>
            <?php endforeach; ?>
        </select>
    </div>
    <div class="mb-3">
        <label for="amount" class="form-label">Amount</label>
        <input type="number" class="form-control" id="amount" name="amount" required>
    </div>
    <div class="mb-3">
        <label for="payment_method" class="form-label">Payment Method</label>
        <select class="form-select" id="payment_method" name="payment_method" required>
            <option value="credit_card">Credit Card</option>
            <option value="bank_transfer">Bank Transfer</option>
            <option value="cash">Cash</option>
        </select>
    </div>
    <button type="submit" class="btn btn-primary">Submit Payment</button>
</form>
<h3>Your Payment History</h3>
<table class="table">
    <thead>
        <tr>
            <th>ID</th>
            <th>Course</th>
            <th>Amount</th>
            <th>Payment Method</th>
            <th>Status</th>
            <th>Date</th>
        </tr>
    </thead>
    <tbody>
        <?php
        $stmt = $conn->prepare("SELECT p.*, c.title AS course_title FROM payments p JOIN courses c ON p.course_id = c.id WHERE p.student_id = ?");
        $stmt->bind_param("i", $_SESSION['user_id']);
        $stmt->execute();
        $result = $stmt->get_result();
        while ($payment = $result->fetch_assoc()): ?>
        <tr>
            <td><?php echo $payment['id']; ?></td>
            <td><?php echo $payment['course_title']; ?></td>
            <td><?php echo $payment['amount']; ?></td>
            <td><?php echo ucfirst($payment['payment_method']); ?></td>
            <td><?php echo ucfirst($payment['status']); ?></td>
            <td><?php echo date('Y -m-d H:i', strtotime($payment['payment_date'])); ?></td>
        </tr>
        <?php endwhile; ?>
    </tbody>
</table>
<?php require '../includes/footer.php'; ?>

Notification Management (public/notifications.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit();
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $message = $_POST['message'];
    $user_id = $_SESSION['user_id'];
    $stmt = $conn->prepare("INSERT INTO notifications (user_id, message) VALUES (?, ?)");
    $stmt->bind_param("is", $user_id, $message);
    $stmt->execute();
    $stmt->close();
    header("Location: notifications.php");
}
?>
<h2>Send Notification</h2>
<form method="POST" action="">
    <div class="mb-3">
        <label for="message" class="form-label">Message</label>
        <textarea class="form-control" id="message" name="message" required></textarea>
    </div>
    <button type="submit" class="btn btn-primary">Send Notification</button>
</form>
<h3>Your Notifications</h3>
<table class="table">
    <thead>
        <tr>
            <th>ID</th>
            <th>Message</th>
            <th>Status</th>
            <th>Date</th>
        </tr>
    </thead>
    <tbody>
        <?php
        $stmt = $conn->prepare("SELECT * FROM notifications WHERE user_id = ?");
        $stmt->bind_param("i", $_SESSION['user_id']);
        $stmt->execute();
        $result = $stmt->get_result();
        while ($notification = $result->fetch_assoc()): ?>
        <tr>
            <td><?php echo $notification['id']; ?></td>
            <td><?php echo $notification['message']; ?></td>
            <td><?php echo $notification['is_read'] ? 'Read' : 'Unread'; ?></td>
            <td><?php echo date('Y-m-d H:i', strtotime($notification['created_at'])); ?></td>
        </tr>
        <?php endwhile; ?>
    </tbody>
</table>
<?php require '../includes/footer.php'; ?>

Feedback Management (public/feedback.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit();
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $course_id = $_POST['course_id'];
    $rating = $_POST['rating'];
    $comments = $_POST['comments'];
    $student_id = $_SESSION['user_id'];
    $stmt = $conn->prepare("INSERT INTO feedback (course_id, student_id, rating, comments) VALUES (?, ?, ?, ?)");
    $stmt->bind_param("iiis", $course_id, $student_id, $rating, $comments);
    $stmt->execute();
    $stmt->close();
    header("Location: feedback.php");
}
// Fetch courses for the form
$stmt = $conn->prepare("SELECT * FROM courses");
$stmt->execute();
$result = $stmt->get_result();
$courses = $result->fetch_all(MYSQLI_ASSOC);
?>
<h2>Provide Feedback</h2>
<form method="POST" action="">
    <div class="mb-3">
        <label for="course_id" class="form-label">Select Course</label>
        <select class="form-select" id="course_id" name="course_id" required>
            <?php foreach ($courses as $course): ?>
            <option value="<?php echo $course['id']; ?>"><?php echo $course['title']; ?></option>
            <?php endforeach; ?>
        </select>
    </div>
    <div class="mb-3">
        <label for="rating" class="form-label">Rating</label>
        <select class="form-select" id="rating" name="rating" required>
            <option value="1">1</option>
            <option value="2">2</option>
            <option value="3">3</option>
            <option value="4">4</option>
            <option value="5">5</option>
        </select>
    </div>
    <div class="mb-3">
        <label for="comments" class="form-label">Comments</label>
        <textarea class="form-control" id="comments" name="comments"></textarea>
    </div>
    <button type="submit" class="btn btn-primary">Submit Feedback</button>
</form>
<h3>Your Feedback </h3>
<table class="table">
    <thead>
        <tr>
            <th>ID</th>
            <th>Course</th>
            <th>Rating</th>
            <th>Comments</th>
            <th>Date</th>
        </tr>
    </thead>
    <tbody>
        <?php
        $stmt = $conn->prepare("SELECT f.*, c.title AS course_title FROM feedback f JOIN courses c ON f.course_id = c.id WHERE f.student_id = ?");
        $stmt->bind_param("i", $_SESSION['user_id']);
        $stmt->execute();
        $result = $stmt->get_result();
        while ($feedback = $result->fetch_assoc()): ?>
        <tr>
            <td><?php echo $feedback['id']; ?></td>
            <td><?php echo $feedback['course_title']; ?></td>
            <td><?php echo $feedback['rating']; ?></td>
            <td><?php echo $feedback['comments']; ?></td>
            <td><?php echo date('Y-m-d H:i', strtotime($feedback['created_at'])); ?></td>
        </tr>
        <?php endwhile; ?>
    </tbody>
</table>
<?php require '../includes/footer.php'; ?>

Resource Management (public/resources.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id']) || $_SESSION['role'] !== 'teacher') {
    header("Location: login.php");
    exit();
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $course_id = $_POST['course_id'];
    $resource_type = $_POST['resource_type'];
    $file_path = $_POST['file_path'];
    $stmt = $conn->prepare("INSERT INTO resources (course_id, resource_type, file_path) VALUES (?, ?, ?)");
    $stmt->bind_param("iss", $course_id, $resource_type, $file_path);
    $stmt->execute();
    $stmt->close();
    header("Location: resources.php");
}
// Fetch courses for the form
$stmt = $conn->prepare("SELECT * FROM courses");
$stmt->execute();
$result = $stmt->get_result();
$courses = $result->fetch_all(MYSQLI_ASSOC);
?>
<h2>Manage Resources</h2>
<form method="POST" action="">
    <div class="mb-3">
        <label for="course_id" class="form-label">Select Course</label>
        <select class="form-select" id="course_id" name="course_id" required>
            <?php foreach ($courses as $course): ?>
            <option value="<?php echo $course['id']; ?>"><?php echo $course['title']; ?></option>
            <?php endforeach; ?>
        </select>
    </div>
    <div class="mb-3">
        <label for="resource_type" class="form-label">Resource Type</label>
        <select class="form-select" id="resource_type" name="resource_type" required>
            <option value="document">Document</option>
            <option value="link">Link</option>
            <option value="video">Video</option>
        </select>
    </div>
    <div class="mb-3">
        <label for="file_path" class="form-label">File Path/URL</label>
        <input type="text" class="form-control" id="file_path" name="file_path" required>
    </div>
    <button type="submit" class="btn btn-primary">Add Resource</button>
</form>
<h3>Existing Resources</h3>
<table class="table">
    <thead>
        <tr>
            <th>ID</th>
            <th>Course</th>
            <th>Resource Type</th>
            <th>File Path</th>
            <th>Date Added</th>
        </tr>
    </thead>
    <tbody>
        <?php
        $stmt = $conn->prepare("SELECT r.*, c.title AS course_title FROM resources r JOIN courses c ON r.course_id = c.id");
        $stmt->execute();
        $result = $stmt->get_result();
        while ($resource = $result->fetch_assoc()): ?>
        <tr>
            <td><?php echo $resource['id']; ?></td>
            <td><?php echo $resource['course_title']; ?></td>
            <td><?php echo ucfirst($resource['resource_type']); ?></td>
            <td><?php echo $resource['file_path']; ?></td>
            <td><?php echo date('Y-m-d H:i', strtotime($resource['created_at'])); ?></td>
        </tr>
        <?php endwhile; ?>
    </tbody>
</table>
<?php require '../includes/footer.php'; ?>

Admin Dashboard (public/admin_dashboard.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id']) || $_SESSION['role'] !== 'admin') {
    header("Location: login.php");
    exit();
}
// Fetch statistics
$stmt = $conn->prepare("SELECT COUNT(*) AS total_students FROM users WHERE role = 'student'");
$stmt->execute();
$result = $stmt->get_result();
$total_students = $result->fetch_assoc()['total_students'];
$stmt = $conn->prepare("SELECT COUNT(*) AS total_teachers FROM users WHERE role = 'teacher'");
$stmt->execute();
$result = $stmt->get_result();
$total_teachers = $result->fetch_assoc()['total_teachers'];
$stmt = $conn->prepare("SELECT COUNT(*) AS total_courses FROM courses");
$stmt->execute();
$result = $stmt->get_result();
$total_courses = $result->fetch_assoc()['total_courses'];
$stmt = $conn->prepare("SELECT COUNT(*) AS total_enrollments FROM enrollments");
$stmt->execute();
$result = $stmt->get_result();
$total_enrollments = $result->fetch_assoc()['total_enrollments'];
?>
<h2>Admin Dashboard</h2>
<div class="row">
    <div class="col-md-3">
        <div class="card text-white bg-primary mb-3">
            <div class="card-header">Total Students</div>
            <div class="card-body">
                <h5 class="card-title"><?php echo $total_students; ?></h5>
            </div>
        </div>
    </div>
    <div class="col-md-3">
        <div class="card text-white bg-success mb-3">
            <div class="card-header">Total Teachers</div>
            <div class="card-body">
                <h5 class="card-title"><?php echo $total_teachers; ?></h5>
            </div>
        </div>
    </div>
    <div class="col-md-3">
        <div class="card text-white bg-warning mb-3">
            <div class="card-header">Total Courses</div>
            <div class="card-body">
                <h5 class="card-title"><?php echo $total_courses; ?></h5>
            </div>
        </div>
    </div>
    <div class="col-md-3">
        <div class="card text-white bg-danger mb-3">
            <div class="card-header">Total Enrollments</div>
            <div class="card-body">
                <h5 class="card-title"><?php echo $total_enrollments; ?></h5>
            </div>
        </div>
    </div>
</div>
<?php require '../includes/footer.php'; ?>

6. Additional Features to Consider

User Roles Management: Implement role-based access control for different functionalities.

Course Analytics: Provide detailed analytics for courses, including enrollment trends and student performance.

Mobile Responsiveness: Ensure the application is fully responsive for mobile users.

7. Security Measures

Input Validation: Ensure all user inputs are validated to prevent SQL injection and XSS attacks.

Password Security: Use strong hashing algorithms for storing passwords.

Session Security: Implement secure session management practices to protect user sessions.

8. Testing and Deployment

Unit Testing: Conduct unit tests for individual components to ensure they function correctly.

Integration Testing: Test the integration of different modules to ensure they work together seamlessly.

Deployment: Choose a reliable hosting provider and deploy the application, ensuring all configurations are optimized for performance.

9. Documentation

User Documentation: Create a user manual to guide users through the platform's features and functionalities.

Developer Documentation: Document the codebase and architecture for future reference and maintenance.

10. Future Enhancements

AI-Powered Insights: Implement machine learning algorithms to provide insights into student behavior and preferences.

Mobile Application: Develop a mobile application for users to access the platform on the go.

Integration with Other Systems: Consider integrating with existing payment gateways or marketing platforms for a more comprehensive solution.

This structured approach will help you build a comprehensive Coaching Management System that meets user needs and adapts to future requirements.