Datas-employee is a Rest API developed using Node.js(Express), React.js and MySQL where different types of queries to can be made to a database such as create, update, get an delete the data of the 3 employees registered in the db.

Getting Started

First, run the development server directory: npm run dev
Open http://localhost:5000/api/welcome with your browser to see the result.

Then, run the development client directory: npm start
Open http://localhost:3000 with your browser to see the result.

Requirements

• React v18.2.0
• React-dom v18.2.0
• Node v18.7.0
• npm v8.15.0
• MySQL v8.0.30

Dependencies

• Express v4.18.2
• mysql2 v2.3.3
• Add this "type": "module" to your package.json from server

Dev dependencies

• Nodemon v2.0.20
• logplease 2.0.20

Preview query result

Welcome

http://localhost:5000/api/welcome

Get all datas of all employees

http://localhost:5000/api/alldataemployees

Get Salaries employees from table 'employee'

http://localhost:5000/api/allsalaryemployees

Get id employee, full name and salary of an employee by their name

http://localhost:5000/api/salarybyname

404 not found