Complete Online Learning Management System in PHP MySQL Source Code

January 3, 2020

About Online Learning Management System in PHP MySQL

This Complete Online Learning Management System is develop in PHP MySQL database, using JavaScript, HTML, CSS, Modal, Ajax, and Bootstrap, this system is easy to use and very friendly user in web application, it contain of admin and user, the user is represent as a student, before the student to make their own account we need sign up to login, and also the student can add everything in school like select courses, under the approval of admin, but for any inquires the student also can chat the admin using online chat. The admin can manage all transaction in online chat, approved, and delete user.

Admin Dashboard

The admin dashboard serves as the central hub for managing various aspects of the system. It includes modules for managing categories, courses, students, enrollments, reports, and messages.

Categories

  • Add new categories with customizable attributes such as category code, title, parent category, icon picker, and thumbnail.

Courses

  • View active, pending, free, and paid courses.
  • Filter courses based on categories, status, instructor, and price.

Student Management

  • Add, edit, and delete student profiles.
  • Search for students based on specific criteria.

Enrollment

  • Monitor enrollment history and enroll students in courses.

Reporting

  • Generate reports on admin and instructor revenue, enrolled courses, total amount, and enrollment status.

Settings

  • Configure system settings, website settings, payment settings, instructor settings, language settings, SMTP settings, and more.

Categories

  • Add New Categories, Category Code, Category Title, Parent, Icon Picker, Category, and Thumbnail.

Courses

  • Active Courses, Pending Courses, Free Courses, Paid Courses, Course ListCategories, Status, Instructor, Price and Filter.

Student

  • Add New Students, Show Entries, Photo, Name, Email, Enrolled Courses, Edit, Delete, and Search.

Enrollment

  • Enroll History, Enroll a Student, Enrollment Form, User, and Course, to Enroll.

Report

  • Admin Revenue, Instructor Revenue, Enrolled Course, Total Amount, Enrollment Date and Status.

READ ALSO:  Complete Academy LMS Student Mobile App in Android Studio

Setting

  • System Settings, Website Settings, Payment Settings, Payment Setting, Instructor Settings, Language Settings, SMTP Settings, About, Themes, Mobile App

System Setting

  • Website Name, Website Title, Website Keywords, Website Description, Author, Slogan, System Email, Address, Phone, You Tube Key, Vimeo, Api Key, Purchase Code, System Language, Student Email Verification, and Footer Link.

  • Banner Title, Banner Sub Title, About Us, Term of Condition, Privacy Policy

Payment Setting

  • System Currency, Currency Position, Active, Mode, Paypal Currency, Client ID.

Instructor

  • Instructor Setting, Allow Public Instructor, Instructor Revenue, Admin Revenue percentage.

Language Setting

  • Language List, Add Phrase, Add language, Edit, and Delete.

SMTP Setting

  • Protocol, SMTP Host, SMTP Port, Username, Password.

Online Learning Management System Flowchart

The flowchart depicts the comprehensive process flow of our Online Learning Management System (LMS). Here’s a detailed description of each component and the corresponding actions:

  1. User Access (A): The flow begins when a user accesses the system.
  2. Authenticated? (C): Upon accessing, the system checks whether the user is authenticated or not.
    • Yes: If the user is authenticated, they are directed to the Admin Dashboard (D).
    • No: If not authenticated, they are prompted to login/register (E).
  3. Admin Dashboard (D): This is the central hub for administrators to manage various aspects of the system.
    • Manage Categories (F): Admins can add, edit, and delete categories for organizing courses.
    • Manage Courses (G): Admins can add, edit, and delete courses, as well as manage course details.
    • Manage Students (H): Admins can add, edit, and delete student profiles.
    • Manage Enrollment (I): Admins can enroll students in courses and manage enrollment details.
    • Generate Reports (J): Admins can generate reports on various system activities and statistics.
    • Configure Settings (K): Admins can configure system-wide settings such as system, website, payment, instructor, language, and SMTP settings.
  4. Login/Register (E): Users are prompted to either login with existing credentials or register for a new account.
    • Login (L): Existing users can login to access the system.
    • Register (M): New users can register for a new account to access the system.
  5. Functionality Sub-flows:
    • Manage Categories (F): Admins can add new categories, enter category details, and save them.
    • Manage Courses (G): Admins can add new courses, enter course details, and save them.
    • Manage Students (H): Admins can add new students, enter student details, and save them.
    • Manage Enrollment (I): Admins can enroll students in courses by selecting users and courses, then proceeding to enroll them.
    • Generate Reports (J): Admins can select the type of report they want to generate and then proceed to generate the report.
    • Configure Settings (K): Admins can select the type of setting they want to configure (system, website, payment, etc.), enter the necessary details, and save the settings.
  6. Looping and Navigation:
    • Users can loop back to the main dashboard or navigate between different functionalities based on their requirements.

Online Learning Management System Flowchart

Online  Learning Management System Flowchart

This flowchart provides a detailed overview of the entire process flow within our Online Learning Management System, guiding users through various actions and functionalities available within the system.

READ ALSO:  Complete Multi Hospital Management System in PHP MySQL Free Source Code

Online Learning Management System ER Diagram

Here’s a detailed description of the entities and their attributes in the ER diagram for the Online Learning Management System:

  1. USER Entity:
    • UserID: Unique identifier for each user.
    • Username: User’s username for authentication.
    • Password: User’s password for authentication.
    • Email: User’s email address for communication.
    • Role: Role of the user in the system (e.g., student, instructor, admin).
  2. CATEGORY Entity:
    • CategoryID: Unique identifier for each category.
    • CategoryCode: Code representing the category.
    • CategoryTitle: Title or name of the category.
    • ParentCategoryID: Identifier indicating the parent category (if any).
  3. COURSE Entity:
    • CourseID: Unique identifier for each course.
    • CourseTitle: Title or name of the course.
    • Description: Description providing details about the course content.
    • Status: Status of the course (e.g., active, inactive).
    • InstructorID: Identifier of the instructor associated with the course.
    • CategoryID: Identifier of the category to which the course belongs.
    • Price: Price of the course.
    • Currency: Currency in which the course price is specified.
  4. STUDENT Entity:
    • StudentID: Unique identifier for each student.
    • Name: Name of the student.
    • Email: Email address of the student.
    • PhotoURL: URL pointing to the student’s profile photo.
    • EnrolledCoursesIDs: List of course IDs in which the student is enrolled.
  5. ENROLLMENT Entity:
    • EnrollmentID: Unique identifier for each enrollment record.
    • StudentID: Identifier of the student enrolled in the course.
    • CourseID: Identifier of the course in which the student is enrolled.
    • EnrollmentDate: Date when the student enrolled in the course.
    • Status: Status of the enrollment (e.g., pending, completed).
  6. REPORT Entity:
    • ReportID: Unique identifier for each report.
    • ReportType: Type or category of the report.
    • GeneratedDate: Date when the report was generated.
    • Details: Additional details or information included in the report.
  7. INSTRUCTOR Entity:
    • InstructorID: Unique identifier for each instructor.
    • Name: Name of the instructor.
    • Email: Email address of the instructor.
    • Bio: Biography or profile description of the instructor.
    • Specialization: Area of specialization or expertise of the instructor.
    • PhotoURL: URL pointing to the instructor’s profile photo.

Online Learning Management System ER Diagram

Online Learning Management System ER Diagram

This highly detailed ER diagram provides an exhaustive view of the data model for the Online Learning Management System. It includes specific attributes for each entity, such as user details, course information, enrollment records, and instructor profiles. This level of detail ensures a comprehensive understanding of the system’s data structure and relationships.

READ ALSO:  Complete Bitcoin Wallet System in PHP MySQL Free Source Code Download

Online Learning Management System Project

  • Name of Project:     Online Learning Management System
  • Language Used:      PHP
  •  Database Used:      MySQL
  • Design Interface:    Bootstrap JavaScript, HTML, Ajax, JQuery,
  • Browser:                  Opera Mozilla Google Chrome IE8,
  • Software:                 WAMP/ XAMPP/ LAMP/MAMP

Comments 0

Leave a Reply

Your email address will not be published. Required fields are marked *