AWS-FCJ-Management - Nodejs, Express, MySQL & Handlebars

Demo

1. Homepage

2. View User

3. Add User

4. Edit User

5. Delete User

How to usage

1. Git clone repository

https://github.com/Van-Hoang-Kha/AWS-FCJ-Management

2. Go to folder project
3. Dependencies Installation
4. Configuration Server
5. Restarting Express server
6. Start our local server

Dependencies Installation

npm install express dotenv express-handlebars body-parser mysql

Configuration Server

Create a .env file and add your database credentials like this:

DB_HOST = 'localhost'
DB_NAME = 'DB_NAME'
DB_USER = 'root'
DB_PASS = 'password'

Restarting Express server

npm install --save-dev nodemon

Start our local server

npm start

SQL Schema

CREATE TABLE `lib'.`user` ( `id` INT NOT NULL AUTO_INCREMENT , `first_name` VARCHAR(45) NOT NULL , `last_name` VARCHAR(45) NOT NULL , `email` VARCHAR(45) NOT NULL , `phone` VARCHAR(45) NOT NULL , `comments` TEXT NOT NULL , `status` VARCHAR(10) NOT NULL DEFAULT 'active' , PRIMARY KEY (`id`)) ENGINE = InnoDB;

SQL Dummy Data

INSERT INTO `user` 
(`id`, `first_name`,  `last_name`,    `email`,                 `phone`,         `comments`, `status`) VALUES
(NULL, 'Amanda',      'Nunes',        '[email protected]',        '012345 678910', '',          'active'),
(NULL, 'Alexander',   'Volkanovski',  '[email protected]',  '012345 678910', '',          'active'),
(NULL, 'Khabib',      'Nurmagomedov', '[email protected]', '012345 678910', '',          'active'),
(NULL, 'Kamaru',      'Usman',        '[email protected]',        '012345 678910', '',          'active'),
(NULL, 'Israel',      'Adesanya',     '[email protected]',     '012345 678910', '',          'active'),
(NULL, 'Henry',       'Cejudo',       '[email protected]',       '012345 678910', '',          'active'),
(NULL, 'Valentina',   'Shevchenko',   '[email protected]',   '012345 678910', '',          'active'),
(NULL, 'Tyron',       'Woodley',      '[email protected]',      '012345 678910', '',          'active'),
(NULL, 'Rose',        'Namajunas ',   '[email protected]',    '012345 678910', '',          'active'),
(NULL, 'Tony',        'Ferguson ',    '[email protected]',     '012345 678910', '',          'active'),
(NULL, 'Jorge',       'Masvidal ',    '[email protected]',     '012345 678910', '',          'active'),
(NULL, 'Nate',        'Diaz ',        '[email protected]',         '012345 678910', '',          'active'),
(NULL, 'Conor',       'McGregor ',    '[email protected]',     '012345 678910', '',          'active'),
(NULL, 'Cris',        'Cyborg ',      '[email protected]',       '012345 678910', '',          'active'),
(NULL, 'Tecia',       'Torres ',      '[email protected]',       '012345 678910', '',          'active'),
(NULL, 'Ronda',       'Rousey ',      '[email protected]',       '012345 678910', '',          'active'),
(NULL, 'Holly',       'Holm ',        '[email protected]',         '012345 678910', '',          'active'),
(NULL, 'Joanna',      'Jedrzejczyk ', '[email protected]',  '012345 678910', '',          'active')

Reference

Nodejs Documents

MySQL Documents

Simple User Management System – Nodejs, Express, MySQL & Handlebars