Creating a Training 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 Training Management System is designed to facilitate the organization and management of training programs. This system allows trainers to create and manage courses, schedule training sessions, and assess trainee performance. Trainees can enroll in courses, participate in assessments, and provide feedback on their training experiences. With a robust MySQL database backend, the platform ensures secure data management and a user-friendly experience for all roles, including administrators, trainers, and trainees.
Project Objectives
- To create a secure user registration and login system for administrators, trainers, and trainees.
- To enable trainers to create and manage courses, including course details and objectives.
- To schedule training sessions and manage enrollments for trainees.
- To facilitate assessments for trainees and track their performance through assessment results.
- To collect feedback from trainees regarding courses and training sessions.
- To issue certifications to trainees upon successful completion of courses.
- To provide resources related to courses, such as documents, videos, and presentations.
Project Modules
- User Management: Handles user registration, login, and role-based access for admins, trainers, and trainees.
- Course Management: Allows trainers to create, edit, and manage courses, including details and objectives.
- Training Session Management: Facilitates the scheduling and management of training sessions.
- Enrollment Management: Manages trainee enrollments in training sessions and tracks their status.
- Assessment Management: Enables the creation and management of assessments for trainees.
- Feedback System: Collects and manages feedback from trainees regarding courses and training sessions.
- Certification Management: Issues and tracks certifications for trainees upon course completion.
- Resource Management: Provides access to course-related resources, including documents and videos.
1. MySQL Database Schema
CREATE DATABASE training_management;
USE training_management;
-- 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', 'trainer', 'trainee') DEFAULT 'trainee',
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,
duration INT NOT NULL, -- Duration in hours
prerequisites TEXT,
category VARCHAR(100),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);
-- Table for training sessions
CREATE TABLE training_sessions (
id INT AUTO_INCREMENT PRIMARY KEY,
course_id INT NOT NULL,
session_date DATETIME NOT NULL,
location VARCHAR(255),
trainer_id INT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (course_id) REFERENCES courses(id) ON DELETE CASCADE,
FOREIGN KEY (trainer_id) REFERENCES users(id) ON DELETE SET NULL
);
-- Table for enrollments
CREATE TABLE enrollments (
id INT AUTO_INCREMENT PRIMARY KEY,
trainee_id INT NOT NULL,
session_id INT NOT NULL,
status ENUM('enrolled', 'waitlisted', 'completed') DEFAULT 'enrolled',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (trainee_id) REFERENCES users(id) ON DELETE CASCADE,
FOREIGN KEY (session_id) REFERENCES training_sessions(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,
total_marks INT NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (course_id) REFERENCES courses(id) ON DELETE CASCADE
);
-- Table for assessment results
CREATE TABLE assessment_results (
id INT AUTO_INCREMENT PRIMARY KEY,
assessment_id INT NOT NULL,
trainee_id INT NOT NULL,
marks_obtained INT NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (assessment_id) REFERENCES assessments(id) ON DELETE CASCADE,
FOREIGN KEY (trainee_id) REFERENCES users(id) ON DELETE CASCADE
);
-- Table for feedback
CREATE TABLE feedback (
id INT AUTO_INCREMENT PRIMARY KEY,
course_id INT NOT NULL,
trainee_id INT NOT NULL,
comments TEXT,
rating INT CHECK (rating >= 1 AND rating <= 5),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (course_id) REFERENCES courses(id) ON DELETE CASCADE,
FOREIGN KEY (trainee_id) REFERENCES users(id) ON DELETE CASCADE
);
-- Table for certifications
CREATE TABLE certifications (
id INT AUTO_INCREMENT PRIMARY KEY,
trainee_id INT NOT NULL,
course_id INT NOT NULL,
issue_date DATE NOT NULL,
expiration_date DATE,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (trainee_id) REFERENCES users(id) ON DELETE CASCADE,
FOREIGN KEY (course_id) REFERENCES courses(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', 'video', 'presentation') 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
training_management_system/
│
├── config/
│ └── db.php
│
├── public/
│ ├── index.php
│ ├── login.php
│ ├── register.php
│ ├── dashboard.php
│ ├── create_course.php
│ ├── edit_course.php
│ ├── view_course.php
│ ├── enrollments.php
│ ├── assessments.php
│ ├── feedback.php
│ ├── notifications.php
│ ├── certifications.php
│ └── admin_dashboard.php
│
├── includes/
│ ├── header.php
│ ├── footer.php
│ └── functions.php
│
├── assets/
│ ├── css/
│ │ └── styles.css
│ ├── js/
│ │ └── javascript
└── 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>Training Management System</title>
</head>
<body>
<div class="container">
<header class="my-4">
<h1>Training 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="create_course.php">Create Course</a>
</li>
<li class="nav-item">
<a class="nav-link" href="enrollments.php">My Enrollments</a>
</li>
<li class="nav-item">
<a class="nav-link" href="assessments.php">My Assessments</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="certifications.php">My Certifications</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 Training 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="trainee">Trainee</option>
<option value="trainer">Trainer</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'; ?>
Create Course (public/create_course.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'];
$duration = $_POST['duration'];
$prerequisites = $_POST['prerequisites'];
$category = $_POST['category'];
$stmt = $conn->prepare("INSERT INTO courses (title, description, objectives, duration, prerequisites, category) VALUES (?, ?, ?, ?, ?, ?)");
$stmt->bind_param("ssssss", $title, $description, $objectives, $duration, $prerequisites, $category);
$stmt->execute();
$stmt->close();
header("Location: dashboard.php");
}
?>
<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>
<div class="mb-3">
<label for="duration" class="form-label">Duration (in hours)</label>
<input type="number" class="form-control" id="duration" name="duration" required>
</div>
<div class="mb-3">
<label for="prerequisites" class="form-label">Prerequisites</label>
<textarea class="form-control" id="prerequisites" name="prerequisites"></textarea>
</div>
<div class="mb-3">
<label for="category" class="form-label">Category</label>
<input type="text" class="form-control" id="category" name="category" required>
</div>
<button type="submit" class="btn btn-primary">Create Course</button>
</form>
<?php require '../includes/footer.php'; ?>
Enrollments (public/enrollments.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 enrollments.*, training_sessions.session_date, courses.title AS course_title FROM enrollments JOIN training_sessions ON enrollments.session_id = training_sessions.id JOIN courses ON training_sessions.course_id = courses.id WHERE enrollments.trainee_id = ?");
$stmt->bind_param("i", $user_id);
$stmt->execute();
$result = $stmt->get_result();
$enrollments = $result->fetch_all(MYSQLI_ASSOC);
?>
<h2>My Enrollments</h2>
<table class="table">
<thead>
<tr>
<th>ID</th>
<th>Course</th>
<th>Session Date</th>
<th>Status</th>
</tr>
</thead>
<tbody>
<?php foreach ($enrollments as $enrollment): ?>
<tr>
<td><?php echo $enrollment['id']; ?></td>
<td><?php echo $enrollment['course_title']; ?></td>
<td><?php echo $enrollment['session_date']; ?></td>
<td><?php echo ucfirst($enrollment['status']); ?></td>
</tr>
<?php endforeach; ?>
</tbody>
</table>
<?php require '../includes/footer.php'; ?>
Assessments (public/assessments.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 assessments.*, courses.title AS course_title FROM assessments JOIN courses ON assessments.course_id = courses.id");
$stmt->execute();
$result = $stmt->get_result();
$assessments = $result->fetch_all(MYSQLI_ASSOC);
?>
<h2>Assessments</h2>
<table class="table">
<thead>
<tr>
<th>ID</th>
<th>Course</th>
<th>Title</th>
<th>Total Marks</th>
</tr>
</thead>
<tbody>
<?php foreach ($assessments as $assessment): ?>
<tr>
<td><?php echo $assessment['id']; ?></td>
<td><?php echo $assessment['course_title']; ?></td>
<td><?php echo $assessment['title']; ?></td>
<td><?php echo $assessment['total_marks']; ?></td>
</tr>
<?php endforeach; ?>
</tbody>
</table>
<?php require '../includes/footer.php'; ?>
Feedback (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'];
$trainee_id = $_SESSION['user_id'];
$comments = $_POST['comments'];
$rating = $_POST['rating'];
$stmt = $conn->prepare("INSERT INTO feedback (course_id, trainee_id, comments, rating) VALUES (?, ?, ?, ?)");
$stmt->bind_param("iisi", $course_id, $trainee_id, $comments, $rating);
$stmt->execute();
$stmt->close();
header("Location: feedback.php");
}
$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">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="comments" class="form-label">Comments</label>
<textarea class="form-control" id="comments" name="comments" required></textarea>
</div>
<div class="mb-3">
<label for="rating" class="form-label">Rating</label>
<input type="number" class="form-control" id="rating" name="rating" min="1" max="5" required>
</div>
<button type="submit" class="btn btn-primary">Submit Feedback</button>
</form>
<?php require '../includes/footer.php'; ?>
Certifications (public/certifications.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 certifications.*, courses.title AS course_title FROM certifications JOIN courses ON certifications.course_id = courses.id WHERE certifications.trainee_id = ?");
$stmt->bind_param("i", $user_id);
$stmt->execute();
$result = $stmt->get_result();
$certifications = $result->fetch_all(MYSQLI_ASSOC);
?>
<h2>My Certifications</h2>
<table class="table">
<thead>
<tr>
<th>ID</th>
<th>Course</th>
<th>Issue Date</th>
<th>Expiration Date</th>
</tr>
</thead>
<tbody>
<?php foreach ($certifications as $certification): ?>
<tr>
<td><?php echo $certification['id']; ?></td>
<td><?php echo $certification['course_title']; ?></td>
<td><?php echo $certification['issue_date']; ?></td>
<td><?php echo $certification['expiration_date'] ? $certification['expiration_date'] : 'N/A'; ?></td>
</tr>
<?php endforeach; ?>
</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();
}
$stmt = $conn->prepare("SELECT COUNT(*) AS user_count FROM users");
$stmt->execute();
$result = $stmt->get_result();
$user_count = $result->fetch_assoc()['user_count'];
$stmt = $conn->prepare("SELECT COUNT(*) AS course_count FROM courses");
$stmt->execute();
$result = $stmt->get_result();
$course_count = $result->fetch_assoc()['course_count'];
$stmt = $conn->prepare("SELECT COUNT(*) AS session_count FROM training_sessions");
$stmt->execute();
$result = $stmt->get_result();
$session_count = $result->fetch_assoc()['session_count'];
?>
<h2>Admin Dashboard</h2>
<p>Total Users: <?php echo $user_count; ?></p>
<p>Total Courses: <?php echo $course_count; ?></p>
<p>Total Training Sessions: <?php echo $session_count; ?></p>
<?php require '../includes/footer.php'; ?>
6. Additional Features to Consider
User Profiles: Allow users to edit their profiles and manage their settings.
Notifications: Implement a notification system to alert users about upcoming sessions and new courses.
Mobile Application: Develop a mobile application for users to access the platform on the go.
7. Security Measures
Data 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 Recommendations: Implement machine learning algorithms to provide personalized course recommendations based on user preferences.
Community Features: Create forums or discussion boards for users to share insights and experiences related to training.
Integration with Other Systems: Consider integrating with existing HR or learning management systems for a more comprehensive solution.
This structured approach will help you build a robust Training Management System that meets user needs and adapts to future requirements.
AI 
ASP.NET API 
ASP.NET CLI 
ASP.NET Core 
ASP.NET MVC 
ASP.NET Projects With Source Code 
ASP.NET Web Forms 
ASP.NET Web Pages 
AWS 
Angular 10 
Bash 
Bitcoin 
Blockchain 
C Tutorial 
C# 
CPP 
Chat GPT 
Cheat Sheet 
Cyber Security 
Dart 
Django 
Docker 
Ether.js 
Ethereum 
Flask 
Flask Projects With Source Code 
GEN AI 
Git 
Go Language 
Google Cloud Platform 
GraphQL 
Hardhat 
INI 
JSON 
Java 
JavaScript 
Kotlin 
Kubernetes 
LaTeX 
Laravel 
Laravel 10 E-Commerce Project 
Laravel 11 E-Commerce Project 
Laravel 9 E-Commerce Project 
Laravel 9 React Tutorial 
Laravel E-Commerce Project 
Laravel Home Services Project 
Laravel Projects With Source Code 
Laravel Tutorial Advanced 
Laravel Tutorial Beginners 
Livewire 
Markdown 
Matlab 
Metamask 
Microsoft Azure 
MongoDB Tutorial Advanced 
MongoDB Tutorial Beginners 
MySql Tutorial Advanced 
MySql Tutorial Beginners 
NextJS 
Node JS 
Node JS Projects With Source Code 
PHP Projects With Source Code 
PHP Tutorial Advanced 
PHP Tutorial Beginners 
Project Database Schema 
Python 
React JS 
Ruby 
Rust 
SQL Server Queries 
SQL Server Tutorial Advanced 
SQL Server Tutorial Beginners 
Sass 
Solidity 
Spring Boot 
Truffle 
TypeScript 
VueJS 
Web3.js 
WordPress Tutorial Advanced 
WordPress Tutorial Beginners 
YAML