Store App

A basic store application built using HTML, CSS, React, Node.js, and SQL. This project follows the CRUD principles, allowing users to create, read, update, and delete data in the portal.

Tech Stack

• Frontend: React, HTML, CSS, React Router
• Backend: Node.js, Express
• Database: SQL (using MySQL Workbench)

Features

• Create new store items
• Read and display existing items
• Update item details
• Delete items from the store

How to Run

1. Clone the repository: git clone [[email protected]:jenasuraj/CRUD-StoreApp.git]
2. Install dependencies in both frontend and backend directories: npm install
3. Set up your MySQL database using SQL Workbench and configure the database connection in the backend code.
4. Run the backend server: node index.js (or nodemon if installed)
5. Run the React frontend: npm start
6. Open http://localhost:3000 in your browser to view the app.

Routes

• /: Home page
• /add: Add new item
• /edit/:id: Edit item details
• /items: Delete items

Database Configuration

Make sure to set up a MySQL database in SQL Workbench. Update the database credentials (host, user, password, database name) in your backend configuration file.

Known Issues

• Ensure the backend server is running before accessing the frontend.
• Check for CORS issues and add middleware if needed.

Future Improvements

• Add authentication for secure item management.
• Implement better error handling and validation.
• Enhance UI with more interactive components.