A complete, professional pet shop e-commerce platform with modern UI/UX built using PHP, MySQL, and Tailwind CSS.

• Features
• Screenshots
• Installation
• Usage
• Project Structure
• Technologies
• Security
• Documentation
• Troubleshooting
• License

• 🏠 Modern Homepage - Hero banner, featured pets, categories showcase, testimonials
• 🛍️ Advanced Shop - Category filters, price range, search, pagination (12 items/page)
• 🛒 Smart Shopping Cart - AJAX updates, real-time quantity management, no page reload
• 💳 Secure Checkout - Multi-step process, multiple payment methods (COD, Card, UPI)
• 👨‍💼 User Dashboard - Profile management, complete order history with status tracking
• 📱 Fully Responsive - Mobile-first design, works on all devices

• 📊 Analytics Dashboard - Real-time statistics (orders, revenue, customers, pets sold)
• 🐕 Pet Management - Full CRUD operations with image upload and stock tracking
• 📁 Category Management - Add/Edit/Delete categories with pet count display
• 📦 Order Management - 7-stage status tracking (Pending → Confirmed → Processing → Packed → Out for Delivery → Delivered)
• 📈 Sales Reports - Comprehensive analytics with CSV export
  • Overall statistics
  • Monthly sales breakdown (12 months)
  • Top 10 best-selling pets
  • Category-wise performance
  • Recent orders (last 20)
• 🎨 Modern UI - Sidebar navigation, color-coded status badges, responsive tables

• ✅ Warm pet-themed color palette (Orange #FF8C42, Cream #FFF4E6, Brown #8B4513)
• ✅ Smooth animations and hover effects
• ✅ Card-based modern layouts
• ✅ Loading spinners and notifications
• ✅ Auto-dismissing flash messages
• ✅ Mobile-responsive navigation

• ✅ SQL injection prevention (prepared statements)
• ✅ Password hashing (bcrypt via password_hash())
• ✅ XSS protection (htmlspecialchars())
• ✅ Secure file uploads (type/size validation)
• ✅ Session-based authentication
• ✅ Role-based access control (admin/user)
• ✅ CSRF token generation ready

• Homepage: Modern hero banner with featured pets
• Shop Page: Advanced filtering and responsive grid layout
• Shopping Cart: Real-time AJAX updates
• Checkout: Multi-step secure checkout process

• Dashboard: Comprehensive statistics and analytics
• Pet Management: CRUD operations with image preview
• Order Management: Enhanced status tracking with 7 stages
• Reports: Visual analytics with CSV export

• XAMPP/WAMP/LAMP (Apache + MySQL + PHP 7.4+)
• Web Browser (Chrome, Firefox, Edge, Safari)
• Text Editor (Optional - VS Code, Sublime, etc.)

# Place the Petshop folder in your htdocs directory
C:\xampp\htdocs\Petshop

Option A - phpMyAdmin (Recommended):

1. Open http://localhost/phpmyadmin
2. Create new database: petshop
3. Select the database
4. Go to Import tab
5. Choose file: database/petshop.sql
6. Click Go

Option B - MySQL Command Line:

mysql -u root -p
CREATE DATABASE petshop;
USE petshop;
SOURCE C:/xampp/htdocs/Petshop/database/petshop.sql;

Open includes/config.php and verify:

define('DB_HOST', 'localhost');
define('DB_USER', 'root');
define('DB_PASS', '');  // Your MySQL password
define('DB_NAME', 'petshop');
define('SITE_URL', 'http://localhost/Petshop');

Run the image setup script:

http://localhost/Petshop/update_images.php

This will:

• Copy images to assets/uploads/pets/
• Update database with image paths
• Show preview of all pets

Import the status migration:

1. Open phpMyAdmin → petshop database → SQL tab
2. Import: database/add_order_statuses.sql
3. Click Go

• User Panel: http://localhost/Petshop
• Admin Panel: http://localhost/Petshop/admin/login.php

Username: admin
Password: admin123
Email: admin@petshop.com

Register a new account at:

http://localhost/Petshop/user/register.php

1. Browse Pets

   • Visit homepage or shop page
   • Use filters (category, price, search)
   • View pet details

2. Purchase Process

   • Add pets to cart
   • Update quantities as needed
   • Register/Login
   • Complete checkout with shipping details
   • Choose payment method

3. Track Orders

   • View order history in dashboard
   • Check order status
   • Update profile information

1. Login

   • Access: http://localhost/Petshop/admin/login.php
   • Use admin credentials

2. Manage Pets

   • Add new pets with images
   • Edit existing pet details
   • Update stock and prices
   • Delete pets

3. Process Orders

   • View all orders with filters
   • Update order status:
     • Pending → Confirmed
     • Confirmed → Processing
     • Processing → Packed
     • Packed → Out for Delivery
     • Out for Delivery → Delivered
   • View customer details

4. Generate Reports

   • View analytics dashboard
   • Export comprehensive CSV reports
   • Track monthly sales
   • Identify best sellers

Petshop/
├── admin/                      # Admin panel
│   ├── includes/              # Admin components
│   │   ├── sidebar.php        # Navigation sidebar
│   │   └── footer.php         # Admin footer
│   ├── dashboard.php          # Analytics dashboard
│   ├── login.php              # Admin login
│   ├── manage_pets.php        # Pet CRUD operations
│   ├── manage_categories.php  # Category management
│   ├── manage_orders.php      # Order management
│   └── reports.php            # Sales reports & CSV export
│
├── assets/
│   ├── css/
│   │   └── style.css          # Custom styles & animations
│   ├── js/
│   │   └── main.js            # JavaScript utilities
│   └── uploads/
│       └── pets/              # Pet images (auto-created)
│
├── database/
│   ├── petshop.sql            # Main database schema
│   ├── add_order_statuses.sql # Order status migration
│   └── update_images.sql      # Image update script
│
├── includes/
│   ├── config.php             # Database & site config
│   ├── functions.php          # Utility functions
│   ├── header.php             # HTML head
│   ├── navbar.php             # Navigation bar
│   └── footer.php             # Footer
│
├── user/
│   ├── ajax/                  # AJAX endpoints
│   │   ├── add_to_cart.php    # Add to cart
│   │   └── update_cart.php    # Update cart
│   ├── cart.php               # Shopping cart
│   ├── categories.php         # Category browsing
│   ├── checkout.php           # Checkout process
│   ├── dashboard.php          # User dashboard
│   ├── login.php              # User login
│   ├── logout.php             # Logout
│   ├── order_success.php      # Order confirmation
│   ├── register.php           # User registration
│   └── shop.php               # Product listing
│
├── images/                     # Source images
├── index.php                   # Homepage
├── check_system.php            # System diagnostic
├── debug_admin.php             # Admin debug tool
├── update_images.php           # Image setup script
├── README.md                   # This file
├── IMAGE_SETUP_GUIDE.md        # Image setup guide
└── ORDER_STATUS_GUIDE.md       # Order status guide

• PHP 7.4+ - Core programming language
• MySQL 5.7+ - Database management
• mysqli - Database connectivity (prepared statements)

• HTML5 - Structure
• Tailwind CSS 3.0 - Utility-first CSS framework
• JavaScript (Vanilla) - Client-side interactivity
• AJAX - Asynchronous updates

• Font Awesome 6.4 - Icons
• Google Fonts (Poppins) - Typography

// All queries use prepared statements
$stmt = $conn->prepare("SELECT * FROM users WHERE username = ?");
$stmt->bind_param("s", $username);

// Hashing on registration
$hashed = password_hash($password, PASSWORD_DEFAULT);

// Verification on login
password_verify($password, $stored_hash);

// All user inputs sanitized
function sanitize_input($data) {
    return htmlspecialchars(strip_tags(trim($data)));
}

• File type validation (MIME type checking)
• File size limits (5MB max)
• Unique filename generation
• Secure storage path
• Extension whitelist

• IMAGE_SETUP_GUIDE.md - Image integration instructions
• ORDER_STATUS_GUIDE.md - Order management guide
• walkthrough.md - Complete feature walkthrough

• users - User accounts with role-based access
• categories - Pet categories
• pets - Pet inventory with images
• orders - Customer orders
• order_items - Order line items

Located in includes/functions.php:

• sanitize_input() - Input sanitization
• is_logged_in() - Authentication check
• is_admin() - Admin role check
• add_to_cart() - Cart management
• upload_image() - Secure file upload
• format_price() - Currency formatting

❌ Database Connection Error

Solution: Check config.php credentials and ensure MySQL is running

❌ Images Not Showing

Solution: Run http://localhost/Petshop/update_images.php

❌ Admin Login Not Working

Solution: Run http://localhost/Petshop/debug_admin.php

❌ Order Modal Not Opening

Solution: Clear browser cache and refresh page

❌ Page Not Found (404)

Solution: Verify SITE_URL in config.php matches your setup

Run comprehensive system check:

http://localhost/Petshop/check_system.php

This checks:

• PHP version and extensions
• Database connection and tables
• Admin user existence
• File permissions
• Image availability
• Order status configuration
• Page accessibility

✅ One-click add to cart
✅ Real-time cart updates (no page reload)
✅ Advanced product filtering
✅ Secure checkout process
✅ Order tracking
✅ Profile management

✅ Complete pet inventory control
✅ 7-stage order status tracking
✅ Comprehensive sales analytics
✅ CSV export for reports
✅ Category management
✅ Real-time statistics

✅ SQL injection prevention
✅ XSS protection
✅ Password hashing
✅ Secure file uploads
✅ Session management
✅ Mobile-responsive design

The system includes:

• ✅ 1 Admin user (admin/admin123)
• ✅ 5 Categories (Dogs, Cats, Birds, Fish, Small Pets)
• ✅ 8 Sample pets with images
• ✅ Complete database schema

# 1. Start XAMPP
# Open XAMPP Control Panel
# Start Apache and MySQL

# 2. Import Database
mysql -u root -p petshop < database/petshop.sql

# 3. Setup Images
# Visit: http://localhost/Petshop/update_images.php

# 4. Enable Order Statuses
# Import: database/add_order_statuses.sql in phpMyAdmin

# 5. Access Application
# User: http://localhost/Petshop
# Admin: http://localhost/Petshop/admin/login.php

This project is open-source and available under the MIT License.

• Colors: Edit Tailwind config in includes/header.php
• Styles: Modify assets/css/style.css
• Functions: Add to includes/functions.php
• Database: Extend schema as needed

• Always use prepared statements
• Sanitize all user inputs
• Hash passwords with bcrypt
• Validate file uploads
• Test on multiple devices

Built with ❤️ for pet lovers and e-commerce enthusiasts.

Key Technologies:

• PHP for robust backend
• MySQL for reliable data storage
• Tailwind CSS for modern UI
• Vanilla JavaScript for performance

For issues or questions:

1. Check Troubleshooting section
2. Run system diagnostic: check_system.php
3. Review documentation files
4. Check browser console for JavaScript errors

🐾 Enjoy managing your pet shop! 🐾

Last Updated: February 15, 2026
Version: 1.0.0
Status: Production Ready ✅