Node-SQL is simple CRUD operation using Node.js as backend and for database used phpmyadmin
Client: React
Server: Node, Express
Client: React
Server: Node, Express
Project is created with:
- Context API
- React Hooks
- MUI
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
GET /api/users
GET /api/user/${id}
Parameter | Type | Description |
---|---|---|
id |
numbers |
Required. Id of user to 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 /api/user/delete/${id}
Parameter | Type | Description |
---|---|---|
id |
numbers |
Required. Id of user to delete |
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 |