Skip to content

Latest commit

 

History

History
51 lines (32 loc) · 1.7 KB

README.md

File metadata and controls

51 lines (32 loc) · 1.7 KB
Raw

A CRUD based Employee-Management-System using ReactJS, NodeJS, ExpressJS and MySQL

  • Prerequisites

    Make sure you have the following installed:

    • Node.js (v14.0.0 or higher)

    • React (v16.8.0 or higher)

    • MySQL (v5.7 or higher)

    Clone the repository:

    git clone https://github.com/your-username/simple-crud.git
cd simple-crud

  • About

    This is a simple CRUD app using ReactJS, NodeJS, ExpressJS and MySQL.
    As this was my learning project I have used MySQL as the Database due to familiarity with this DB more over I have used NodeJS as the backend server.

  • Implementation

    1. If you want to run this application on your machine, you need to have ReactJS, NodeJS and MySQL installed on your PC.

    2. After Installing MySQL client and NodeJS, you need to create a database named "db_name" and create a table named "db_name_table" on it.

    3. Then insert some required data like "name", "email", "position" etc (things you want to store in the db via clientSide) in the table.

    4. Make sure to change the "db_name" and "db_name_table" in the "index.js" file. 

     const db = mysql.createConnection({ 
 user: 'root',
 host: 'localhost',
 password: 'password',
 database: 'DB_NAME',
 });

    1. Install the required dependencies by running npm install command.

    2. Run the server by running npm start/yarn start command.

  • Demo Video

    https://www.loom.com/share/17bae782b09844c197df971b717e5303?sid=b55aa837-852c-449c-8d78-633df4d1d02d

  • MySQL DB Snippets image