📚 BuDi Book Store (Buku Digital)

A modern, feature-rich e-commerce bookstore web application with role-based access control, built using PHP, MySQL, and Bootstrap 5.

---

📋 Table of Contents

• Overview
• Features
• Technology Stack
• Project Structure
• Installation
• Database Setup
• Usage
• Security Features
• Screenshots
• Contributing
• License

---

🎯 Overview

BuDi Book Store is a comprehensive e-commerce platform designed specifically for digital books. The application provides separate interfaces for administrators and customers, with robust role-based access control. Admins can manage products, orders, users, and view detailed analytics, while customers can browse products, manage their shopping cart, and place orders seamlessly.

---

✨ Features

👨‍💼 Admin Features

• Dashboard Analytics: Real-time statistics including pending orders, completed payments, total products, and user counts
• Product Management: Add, edit, and delete products with image uploads
• Order Management: View and manage all customer orders with different status tracking
• User Management: Monitor and manage user accounts with role assignments
• Message Management: View and respond to customer inquiries
• Search Functionality: Quick search for products across the platform

👤 User Features

• Product Browsing: Browse through the complete catalog of digital books
• Shopping Cart: Add products to cart with quantity selection
• Secure Checkout: Complete orders with detailed information
• Order History: View all past orders and their status
• Search: Find specific books quickly
• Responsive Design: Seamless experience across all devices

🔒 General Features

• Role-Based Access: Separate admin and user authentication
• Secure Authentication: Password hashing and session management
• Image Upload: Support for product images (JPG, JPEG, PNG, WEBP)
• Responsive UI: Bootstrap 5 powered modern design
• Real-time Updates: Dynamic content updates without page reload

---

🛠 Technology Stack

Technology	Purpose
PHP	Backend server-side scripting
MySQL	Database management
Bootstrap 5	Frontend framework
Bootstrap Icons	Icon library
jQuery	JavaScript library
HTML5/CSS3	Structure and styling

---

📁 Project Structure

Budi-BookStore/
│
├── admin/                      # Admin panel
│   ├── dashboard.php          # Admin dashboard
│   ├── products.php           # Product management
│   ├── orders.php             # Order management
│   ├── users.php              # User management
│   ├── contact.php            # Message management
│   ├── edit.php               # Edit functionality
│   ├── delete.php             # Delete functionality
│   └── header.php             # Admin header
│
├── user/                       # User interface
│   ├── home.php               # Homepage with featured products
│   ├── shop.php               # Product catalog
│   ├── cart.php               # Shopping cart
│   ├── checkout.php           # Checkout process
│   ├── orders.php             # Order placement
│   ├── order_list.php         # Order history
│   ├── search_page.php        # Search functionality
│   ├── contact.php            # Contact form
│   ├── about.php              # About page
│   ├── header.php             # User header
│   └── footer.php             # User footer
│
├── css/                        # Stylesheets
│   └── style.css              # Custom styles
│
├── js/                         # JavaScript files
│   └── script.js               # Custom scripts
│
├── img/                        # Static images
│   └── book/                   # Book cover images
│
├── uploaded_img/               # User-uploaded product images
│
├── config.php                  # Database configuration
├── login.php                   # Login page
├── register.php                # Registration page
├── logout.php                  # Logout functionality
└── README.md                   # Project documentation

---

🚀 Installation

Prerequisites

• XAMPP (Apache + MySQL + PHP) or similar LAMP/WAMP environment
• PHP 7.4 or higher
• MySQL 5.7 or higher
• Web Browser (Chrome, Firefox, Safari, Edge)

Step-by-Step Installation

1. Clone or Download the Repository

   git clone https://github.com/yourusername/Budi-BookStore.git
   # or download as ZIP and extract
   

2. Move to XAMPP htdocs Directory

   # Copy the Budi-BookStore folder to:
   C:\xampp\htdocs\Budi-BookStore
   # or
   /Applications/XAMPP/htdocs/Budi-BookStore (Mac)
   # or
   /opt/lampp/htdocs/Budi-BookStore (Linux)
   

3. Configure Database

   • Open XAMPP Control Panel
   • Start Apache and MySQL services
   • Navigate to http://localhost/phpmyadmin

4. Import Database

   • Create a new database named db_book_store
   • Import the SQL file (if available) or follow the database setup below

5. Verify Installation

   • Open your browser
   • Navigate to http://localhost/Budi-BookStore/
   • You should see the login page

---

💾 Database Setup

Create Database Tables

Execute the following SQL commands in phpMyAdmin or MySQL command line:

-- Create Database
CREATE DATABASE IF NOT EXISTS db_book_store;

USE db_book_store;

-- Users Table
CREATE TABLE IF NOT EXISTS users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(100) NOT NULL UNIQUE,
    password VARCHAR(255) NOT NULL,
    role ENUM('user', 'admin') DEFAULT 'user',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Products Table
CREATE TABLE IF NOT EXISTS products (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    price DECIMAL(10, 2) NOT NULL,
    image VARCHAR(255) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Cart Table
CREATE TABLE IF NOT EXISTS cart (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    name VARCHAR(255) NOT NULL,
    price DECIMAL(10, 2) NOT NULL,
    quantity INT NOT NULL DEFAULT 1,
    image VARCHAR(255) NOT NULL,
    FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);

-- Orders Table
CREATE TABLE IF NOT EXISTS orders (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(100) NOT NULL,
    method VARCHAR(50) NOT NULL,
    address VARCHAR(255) NOT NULL,
    total_products INT NOT NULL,
    total_price DECIMAL(10, 2) NOT NULL,
    placed_on TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    payment_status ENUM('pending', 'completed') DEFAULT 'pending',
    FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);

-- Messages Table
CREATE TABLE IF NOT EXISTS messages (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(100) NOT NULL,
    number VARCHAR(20) NOT NULL,
    message TEXT NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);

Create Default Admin Account

INSERT INTO users (name, email, password, role) 
VALUES ('Admin', 'admin@budi-bookstore.com', '$2y$10$YourHashedPasswordHere', 'admin');

Note: Replace $2y$10$YourHashedPasswordHere with a properly hashed password. Use the registration page to create an admin account, or use PHP's password_hash() function.

---

📱 Usage

For Users

1. Registration

   • Go to register.php
   • Fill in your details and select "User" role
   • Complete registration

2. Login

   • Go to login.php
   • Enter your credentials
   • Click "Login"

3. Browse Products

   • View latest products on homepage
   • Browse all products in "Shop"

4. Add to Cart

   • Select quantity
   • Click "Add to Cart"
   • View cart at any time from header

5. Checkout

   • Review cart items
   • Enter shipping details
   • Place order

6. View Orders

   • Check order history
   • Track order status

For Administrators

1. Login as Admin

   • Use admin credentials
   • Access dashboard

2. Manage Products

   • Add new books with images
   • Edit existing products
   • Delete outdated items

3. Manage Orders

   • View all customer orders
   • Track payment statuses
   • Update order information

4. Manage Users

   • View registered users
   • Manage user accounts

5. Analytics

   • Monitor sales statistics
   • Track pending payments
   • View total products and users

---

🔐 Security Features

• ✅ Prepared Statements: SQL injection prevention
• ✅ Password Hashing: PHP password_hash() and password_verify()
• ✅ Session Management: Secure session handling
• ✅ Input Sanitization: Data cleaning and validation
• ✅ XSS Protection: HTML special character encoding
• ✅ File Upload Validation: Image type and size restrictions
• ✅ Role-Based Access Control: Admin/User separation
• ✅ Path Traversal Protection: Secure file uploads

---

📸 Screenshots

Add screenshots of your application here (if available)

• Admin Dashboard
• Product Management
• Shopping Cart
• Checkout Process
• Order Management

---

🤝 Contributing

Contributions are welcome! Please follow these guidelines:

1. Fork the repository
2. Create a feature branch (git checkout -b feature/AmazingFeature)
3. Commit your changes (git commit -m 'Add some AmazingFeature')
4. Push to the branch (git push origin feature/AmazingFeature)
5. Open a Pull Request

---

📝 License

This project is licensed under the MIT License - see the LICENSE file for details.

---

👨‍💻 Developer

BuDi Development Team

• Email: contact@budi-bookstore.com
• GitHub: @Sultonisky

---

📞 Support

For support, email support@budi-bookstore.com or create an issue in the GitHub repository.

---

Made with ❤️ by BuDi Development Team

⭐ Star this repo if you find it helpful!