README.md

Node-SQL

Node-SQL is simple CRUD operation using Node.js as backend and for database used phpmyadmin

Screenshots

Home

Add User

Edit User

Delete User

Database

Tech Stack

Client: React

Server: Node, Express

Tech Stack

Client: React

Server: Node, Express

Technologies

Project is created with:

• Context API
• React Hooks
• MUI

Run Locally

Clone the project

  git clone https://github.com/MrHadik/Node-SQL.git

Go to the project directory for Backend

  cd Node-SQL

Install dependencies

  npm install

Start the server

  npm run start

Go to the project directory for Front end

  cd Node-SQL/client

Install dependencies

  npm install

Start the server

  npm run start

API Reference

Get all Users

  GET /api/users

Get Single User

  GET /api/user/${id} 

Parameter	Type	Description
id	numbers	Required. Id of user to user

Add Single User

  POST /api/user/add

Body	Type	Description
email	string	Required. email of user to add user
passwd	string	Required. password of user to add user
name	string	Required. name of user to add user
gender	string	Required. gender of user to add user
mobile	numbers	Required. mobile of user to add user
city	string	Required. city of user to add user
address	string	Required. address of user to add user

Delete Single User

  DELETE /api/user/delete/${id}

Parameter	Type	Description
id	numbers	Required. Id of user to delete

Update Single User

  PUT /api/user/update

Body	Type	Description
email	string	Required. email of user to add user
passwd	string	Required. password of user to add user
name	string	Required. name of user to add user
gender	string	Required. gender of user to add user
mobile	numbers	Required. mobile of user to add user
city	string	Required. city of user to add user
address	string	Required. address of user to add user