Learning Managment System

Step 1: Project Setup

Create a new directory for your project and navigate into it.

mkdir learning-management-app
cd learning-management-app

Initialize a new Node.js project.

npm init -y

Install necessary dependencies.

npm install express mysql ejs bcryptjs express-session express-validator
npm install ejs
npm install sqlite3

Step 2: Set up the Backend

Create a `server.js` file in your project directory.

Create a MySQL database named `learning_management`

Create users table

-- Create users table
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(255) UNIQUE,
    password VARCHAR(255),
    email VARCHAR(255) UNIQUE,
    full_name VARCHAR(255)
);

Create courses table

-- Create courses table
CREATE TABLE courses (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255)
);

-- Insert sample data into courses table
INSERT INTO courses (name) VALUES
('Introduction to HTML'),
('CSS Fundamentals'),
('JavaScript Basics');

Create leaderboard table

-- Create leaderboard table
CREATE TABLE leaderboard (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255),
    score INT
);

-- Insert sample data into leaderboard table
INSERT INTO leaderboard (name, score) VALUES
('John Doe', 100),
('Jane Smith', 90),
('Michael Brown', 85),
('Emily Jones', 80),
('solo ondul', 99);

Run the server.

node server.js

Step 3: Frontend Setup

Create an `index.html` file for the frontend.

Create a `course-content.html` file for the course content.

Create a `leader-board.html` file for the leader board.

Create a `style.css` file to style your HTML.

Create a `script.js` file to handle frontend interactions.

Step 4: Testing

Open your web browser and navigate to http://localhost:3000.

Hackathon Instructions

Finish up the project by:

creating functionality for the user to select their preferred courses.
storing the selection in the database
create a page where the selected courses for each student is displayed

Submission Guidelines

Fork this repository and clone it to your local machine. Create a new branch with your GitHub username (git checkout -b username). Complete the tasks. Commit your changes and push them to your forked repository. Submit a pull request to the main repository for review.

Happy hacking! 🚀

Slozzyondul/lms