Skip to content

Amey-Thakur/DIGITAL-BOOKSTORE

Repository files navigation

Digital Bookstore

License: MIT Status Platform Technology Developed by Amey Thakur and Mega Satish

A comprehensive web-based e-commerce platform facilitating seamless book discovery, secure user authentication, and persistent shopping cart management.

Source Code  ·  Technical Specification  ·  Video Demo  ·  Live Demo

Demo


Authors  ·  Overview  ·  Features  ·  Structure  ·  Results  ·  Quick Start  ·  Usage Guidelines  ·  License  ·  About  ·  Acknowledgments


Authors

Terna Engineering College | Computer Engineering | Batch of 2022

Amey Thakur
Amey Thakur

ORCID
Mega Satish
Mega Satish

ORCID

Important

🤝🏻 Special Acknowledgement

Special thanks to Mega Satish for her meaningful contributions, guidance, and support that helped shape this work.


Overview

The Digital Bookstore is a responsive full-stack e-commerce solution developed to facilitate the systematic discovery and acquisition of literary artifacts. It integrates a relational database architecture with a dynamic frontend, providing users with a seamless shopping experience.

Developed as a mini-project for the Software Engineering Laboratory curriculum, this system demonstrates the practical application of server-side logic (PHP), database management (MySQL), and responsive UI design (Bootstrap).

Note

Research Impact & Certification

This project was published as a research paper in International Journal for Research in Applied Science and Engineering Technology (IJRASET) (Volume 9, Issue 7) and is also available as a preprint on viXra. The project received an official Publication Certificate for its research contribution to software engineering education.

Resources

# Resource Description Date Marks
1 Source Code Complete web application source code May 2021
2 Technical Specification System architecture and specifications May 2021
3 Project Timeline Execution schedule and milestones March 2021
4 Publication Certificate Recognition for project excellence July 2021
5 Project Diagrams Planning and architectural visualizations May 2021
6 Software Engineering Lab Computer Engineering Laboratory Repository

Tip

Database Interaction Efficiency

To optimize search responsiveness and prevent SQL bottlenecks, ensure that the books table is indexed on book_title and author_name. This significantly enhances retrieval speeds during high-concurrency discovery operations in the storefront.


Features

Feature Description
Dynamic Catalog Real-time browsable inventory comprising diverse literary categories and author collections with high-resolution visual assets.
Intelligent Search Advanced query engine supporting multi-attribute filtering by title, author, and category for efficient discovery.
Authentication System Secure user enrollment and session management, providing personalized access to library resources and cart state.
Persistent Cart Database-backed shopping cart facilitating cross-session persistence of selected artifacts and real-time total calculation.
Sorting & Filtering Precision controls for organizing results based on price metrics (Low-to-High) and discount percentages.
Institutional Inquiries Integrated communication portal for dispatching technical or research queries to administrative staff via SMTP.

Tech Stack

  • Language: PHP 7.x+ (Procedural)
  • Database: MySQL 5.x+
  • Frontend: HTML5, CSS3, Bootstrap 3.3.6, jQuery
  • Server: Apache (XAMPP/WAMP)

Project Structure

DIGITAL-BOOKSTORE/
│
├── docs/                                    # Formal Documentation
│   └── SPECIFICATION.md                     # Technical Architecture & Specification
│
├── Mega/                                    # Archival Attribution Assets
│   ├── Filly.jpg                            # Companion (Filly)
│   └── Mega.png                             # Author Profile Image (Mega Satish)
│
├── Mini-Project/                            # Research & Academic Assets
│   ├── Draft/                               # Preliminary Research Data
│   │   └── DIGITAL BOOKSTORE.docx           # Working Manuscript Draft
│   ├── Figures/                             # System Diagrams & Visualizations
│   │   ├── Database Tables.jpg              # Relational Schema Visualization
│   │   ├── Fig. (1) Process Model.png       # SDLC Process Representation
│   │   ├── Fig. (2) Zero Level DFD.jpg      # Context Level Data Flow Diagram
│   │   ├── Fig. (3) First Level DFD.jpg     # Level 1 Data Flow Diagram
│   │   ├── Fig. (4) Second Level DFD.jpg    # Level 2 Data Flow Diagram
│   │   ├── Fig. (5) Class Diagram.jpg       # Object-Oriented Class Hierarchy
│   │   ├── Fig. (6) Sequence Diagram.jpg    # System Interaction Timeline
│   │   ├── Fig. (7) Collaboration...        # Object Communication Model
│   │   ├── Fig. (8) Statechart Diagram.jpg  # Entity State Transitions
│   │   ├── Fig. (9) Activity Diagram.jpg    # Operational Logic Workflow
│   │   ├── Fig. (10) Gantt Chart.jpg        # Project Scheduling & Milestones
│   │   ├── Fig. (11) Use Case Diagram.jpg   # Actor-System Interaction Model
│   │   └── Fig. (12) Flow Graph.jpg         # Algorithmic Complexity Graph
│   ├── Amey_B-50_SE_Mini_Project_Timeline.pdf # Project Execution Schedule
│   ├── IJRASET-V9I7 - Digital Bookstore.pdf # Published Journal Research Paper
│   ├── IJRASET36609 - Digital Bookstore.pdf # Publication Certificate
│   └── Preprint - Digital Bookstore.pdf     # Scholarly preprint version (viXra)
│
├── Source Code/                             # Full Stack Web Application
│   ├── css/                                 # Presentation Layer Stylesheets
│   ├── fonts/                               # Typography & Iconography Assets
│   ├── img/                                 # UI Imagery & Inventory Assets
│   ├── js/                                  # Client-Side Logic & Libraries
│   ├── Author.php                           # Contributor-Specific Discovery
│   ├── Product.php                          # Taxonomy-Based Inventory View
│   ├── Result.php                           # Search Orchestration Layer
│   ├── bookstore.sql                        # Relational Database Schema
│   ├── cart.php                             # Shopping Cart Persistence
│   ├── dbconnect.php                        # Database Connection Liaison
│   ├── description.php                      # Artifact Detailed Presentation
│   ├── destroy.php                          # Session Lifecycle Termination
│   ├── index.php                            # Application Entry Gateway
│   ├── login.php                            # Identity Authentication Logic
│   ├── query.php                            # Inquiry Dispatch Pipeline
│   └── register.php                         # User Identity Provisioning
│
├── .gitattributes                           # Global Git LFS & Endpoint Config
├── .gitignore                               # Asset Exclusion Manifest
├── CITATION.cff                             # Scholarly Citation Metadata
├── codemeta.json                            # Machine-Readable Project Metadata
├── LICENSE                                  # Project Licensing Terms (MIT)
├── README.md                                # Comprehensive Archival Entrance
└── SECURITY.md                              # Vulnerability Exposure Policy

System Architecture & Design Gallery

Process Model (SDLC)

Process Model

Context Level Data Flow Diagram (Zero Level DFD)

Zero Level DFD

First Level Data Flow Diagram (Level 1 DFD)

First Level DFD

Second Level Data Flow Diagram (Level 2 DFD)

Second Level DFD

Class Diagram

Class Diagram

Sequence Diagram

Sequence Diagram

Collaboration Diagram

Collaboration Diagram

Statechart Diagram

Statechart Diagram

Activity Diagram

Activity Diagram

Project Scheduling (Gantt Chart)

Gantt Chart

Use Case Diagram

Use Case Diagram

Algorithmic Complexity (Flow Graph)

Flow Graph

Relational Schema (Database Tables)

Database Tables


Quick Start

1. Prerequisites

Ensure your local development environment meets the following requirements:

  • Web Server: Apache (via XAMPP or WAMP).
  • PHP: Version 7.x or higher.
  • Database: MySQL 5.x or higher.
  • Browser: Current production-grade web browser (Chrome, Firefox, Safari).

Warning

Legacy Dependencies & Security

This system is built using PHP 7.x and Bootstrap 3. For stable execution and educational reference, it is recommended to run this in a controlled local environment (e.g., XAMPP/WAMP) to align with the baseline server-side scripting and frontend framework requirements.

2. Setup & Deployment

  1. Clone the Repository:
    git clone https://github.com/Amey-Thakur/DIGITAL-BOOKSTORE.git
  2. Deploy Source Code:
    • Locate the Source Code directory.
    • Transfer the entire contents of Source Code to your server's deployment directory (e.g., C:\xampp\htdocs\digital-bookstore\).

3. Database Initialization

  1. Start Services: Launch Apache and MySQL via your environment control panel.
  2. Access phpMyAdmin: Navigate to http://localhost/phpmyadmin/.
  3. Create Database:
    • Identifier: digital_bookstore
    • Collation: utf8_general_ci
  4. Import Schema:
    • Select the digital_bookstore database.
    • Import the Source Code/bookstore.sql script into the repository.

4. Configuration

Update the database connection parameters in Source Code/dbconnect.php to match your local credentials.

$con = mysqli_connect("localhost", "root", "", "digital_bookstore");

5. Launch

Access the platform via your local gateway: http://localhost/digital-bookstore/

Tip

Full-Stack Digital Bookstore E-Commerce Platform

Experience the IJRASET-published research simulation featuring a comprehensive full-stack e-commerce ecosystem, detailed UML system architecture, and robust relational database management optimized for scalable book discovery.

Launch Live Demo


Usage Guidelines

This repository is openly shared to support learning and knowledge exchange across the academic community.

For Students
Use this mini-project as a reference for understanding full-stack e-commerce development, relational database integration with PHP/MySQL, and responsive UI design principles. The source code and research assets are documented to support self-paced learning and exploration of scalable web applications.

For Educators
This project may serve as a practical example or supplementary teaching resource for Software Engineering courses (CSC601 & CSL601). Attribution is appreciated when utilizing content.

For Researchers
The published paper and preprint provide insights into the system's architecture, the application of software engineering methodologies in e-commerce, and the researchers' approach to developing persistent digital marketplaces.


License

This repository and all linked academic content are made available under the MIT License. See the LICENSE file for complete terms.

Note

Summary: You are free to share and adapt this content for any purpose, even commercially, as long as you provide appropriate attribution to the original author.

Copyright © 2021 Amey Thakur, Mega Satish


About This Repository

Created & Maintained by: Amey Thakur & Mega Satish
Academic Journey: Bachelor of Engineering in Computer Engineering (2018-2022)
Institution: Terna Engineering College, Navi Mumbai
University: University of Mumbai

This project features the Digital Bookstore, a web-based e-commerce utility developed as a 6th Semester Mini-Project. It explores the synergy between dynamic web interfaces and relational data management in a commercial context.

Connect: GitHub  ·  LinkedIn  ·  ORCID

Acknowledgments

Grateful acknowledgment to Mega Satish for her exceptional collaboration and scholarly partnership during the development of this project. Her constant support, technical clarity, and dedication to software quality were instrumental in achieving the system's functional objectives. Learning alongside her was a transformative experience; her thoughtful approach to problem-solving and steady encouragement turned complex requirements into meaningful learning moments. This work reflects the growth and insights gained from our side-by-side academic journey. Thank you, Mega, for everything you shared and taught along the way.

Grateful acknowledgment to the faculty members of the Department of Computer Engineering at Terna Engineering College for their guidance and instruction in Software Engineering. Their expertise in system modeling and lifecycle management helped me develop a strong understanding of professional software development methodologies.

Special thanks to the mentors and peers whose encouragement, discussions, and support contributed meaningfully to this learning endeavor.


↑ Back to Top

Authors  ·  Overview  ·  Features  ·  Structure  ·  Results  ·  Quick Start  ·  Usage Guidelines  ·  License  ·  About  ·  Acknowledgments


🔬 Software Engineering Laboratory  ·  📚 Digital Bookstore


Presented as part of the 6th Semester Mini-Project @ Terna Engineering College


Computer Engineering (B.E.) - University of Mumbai

Semester-wise curriculum, laboratories, projects, and academic notes.

Releases

No releases published

Packages

 
 
 

Contributors