• Implemented secure login and registration systems using Flask sessions, ensuring data integrity and user session management.
• Stored user credentials and information securely in the user table within the MySQL database.

2. Product Management with Full CRUD Functionality:

• Enabled administrators to perform CRUD operations (Create, Read, Update, Delete) on product data, allowing for easy management of the store’s inventory.
• Product details, including names, prices, and descriptions, are stored and managed in the product table.

3. Shopping Cart with Real-Time Updates:

• Developed a dynamic shopping cart system where users can add, update, or remove products, with changes reflected in real-time.
• The cart table in the database tracks all items added by each user, ensuring accurate order processing.

4. Order Processing and Management:

• Facilitated smooth order placement by integrating a comprehensive order management system, allowing users to review their cart items and finalize purchases.
• Implemented features to store and retrieve order details in the order table, with automatic total price calculation.

5. Responsive and User-Centric Design:

• Designed the frontend using Bootstrap to ensure the application is fully responsive and optimized for various devices, providing a consistent user experience across desktops, tablets, and smartphones.
• Created an intuitive user interface that enhances the shopping experience, making navigation and interaction effortless.

6. Efficient Database Interaction with MySQL:

• Connected the application to a MySQL database using a custom Python module (mysqlConn.py), enabling efficient data handling.
• Wrote optimized SQL queries to perform operations on the user, product, cart, and order tables, ensuring fast and reliable data processing.

7. Seamless API Integration for Frontend-Backend Communication:

• Built and integrated custom APIs to handle data requests and responses between the frontend and backend, enabling real-time data interaction and smooth user experiences.

Tools and Technologies Used: 🛠

• Frontend: HTML , CSS , Bootstrap
• Backend: Python
• Web Framework: Flask - Used for backend logic, routing URLs, and integrating with the frontend.
• Database: MySQL - Stores user data securely.

Installation Instructions 🛣

1. Clone the repository:

  git clone <Paste repository link here>

2. Install dependencies:

  pip install -r requirements.txt

3. Set up MySQL:

• Download and install MySQL on your local system.
• Update the MySQL connection details in app.py with your credentials.

Usage Instructions 🛣

1. Run the application:

  python app.py

2. Access the application:

• Open a web browser and go to http://localhost:5000 or http://127.0.0.1:5000.
• You will see the login page.

3. Login or Register:

• If you have an account, log in using your credentials to visit the Grocery Store.
• If you don't have an account, click on "Create Account" to register.
• After registration, you will be redirected to the login page.

Results: 🙌

Project Demo Link : https://github.com/user-attachments/assets/7b42ce49-023c-4615-99ac-48062d5f1f2c

Webapplication Screenshots:

• Login Yourself , if you don't have any account click on create account.
• Register yourself
• Now login yourself
• Now you're Welcome to the Grocery Shop home page.
• Click on Shop to see the available products.
• By filling the quantity, you can add items into your cart.
• to view the cart items , click on orders.
• Here you can remove any item if you want and can place the order by clicking on place order button.
• Now you will be receive an invoice of your order.
• By clicking on logout , you can successfully logout yourself from this web application