Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/pennagaram.org/public_html

Free Space:

10.31 TB

🔧 Quick Actions

✏️ Editing: all-shops.php

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>All Shops - Pennagaram Official</title>
    <script src="https://cdn.tailwindcss.com"></script>
    <link rel="apple-touch-icon" sizes="180x180" href="assets/fav/apple-touch-icon.png">
    <link rel="icon" type="image/png" sizes="32x32" href="assets/fav/favicon-32x32.png">
    <link rel="icon" type="image/png" sizes="16x16" href="assets/fav/favicon-16x16.png">
    <link rel="manifest" href="assets/fav/site.webmanifest">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    <script>
        tailwind.config = {
            theme: {
                extend: {
                    colors: {
                        'primary': '#2E8B57',
                        'accent': '#FF6B35',
                        'secondary': '#1A5276',
                        'light': '#F8F9FA',
                        'neutral': '#495057',
                        'dark': '#212529',
                        'success': '#28A745',
                        'warning': '#FFC107',
                        'highlight': '#E9F5E9'
                    }
                }
            }
        }
    </script>
    <style>
        @import url('https://fonts.googleapis.com/css2?family=Inter:wght@300;400;500;600;700&display=swap');
        body {
            font-family: 'Inter', sans-serif;
        }
        .shop-card {
            transition: all 0.3s ease;
        }
        .shop-card:hover {
            transform: translateY(-5px);
        }
        .filter-active {
            background-color: #2E8B57 !important;
            color: white !important;
        }
    </style>
</head>
<body class="bg-light">
    <?php include('nav.php') ?>

<main class="min-h-screen py-6 mt-16">
        <div class="container mx-auto px-4">
            
            <div class="text-center mb-6">
                <h1 class="text-3xl font-bold text-secondary mb-3">Local Shops Directory</h1>
                <p class="text-neutral text-base max-w-2xl mx-auto">
                    Discover all the amazing shops in Pennagaram. Support local businesses and find everything you need right here in our community.
                </p>
            </div>

<div class="bg-white rounded-lg shadow-md p-5 mb-6">
                <div class="grid grid-cols-1 md:grid-cols-3 gap-4">
                    
                    <div class="relative">
                        <input type="text" 
                               id="searchInput" 
                               placeholder="Search shops..." 
                               class="w-full pl-10 pr-4 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-primary focus:border-transparent text-sm">
                        <i class="fas fa-search absolute left-3 top-3 text-neutral text-sm"></i>
                    </div>

<div class="relative">
                        <select id="categoryFilter" class="w-full pl-3 pr-10 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-primary focus:border-transparent appearance-none text-sm">
                            <option value="">All Categories</option>
                            <?php
                            require_once 'includes/db.php';
                            
                            // Check if shop_categories table exists and fetch categories
                            $categoryQuery = "SHOW TABLES LIKE 'shop_categories'";
                            $tableExists = mysqli_query($conn, $categoryQuery);
                            
                            if ($tableExists && mysqli_num_rows($tableExists) > 0) {
                                $categoryQuery = "SELECT id, name FROM shop_categories ORDER BY name";
                                $categoryResult = mysqli_query($conn, $categoryQuery);
                                
                                if ($categoryResult && mysqli_num_rows($categoryResult) > 0) {
                                    while ($category = mysqli_fetch_assoc($categoryResult)) {
                                        echo '<option value="' . $category['id'] . '">' . htmlspecialchars($category['name']) . '</option>';
                                    }
                                } else {
                                    // Fallback: Create basic category options based on your data
                                    echo '<option value="8">Textiles</option>';
                                    echo '<option value="10">Other</option>';
                                    echo '<option value="12">General Store</option>';
                                }
                            } else {
                                // Fallback categories if table doesn't exist
                                echo '<option value="8">Textiles</option>';
                                echo '<option value="10">Other</option>';
                                echo '<option value="12">General Store</option>';
                                echo '<option value="Education">Education</option>';
                                echo '<option value="Ecommerce">Ecommerce</option>';
                                echo '<option value="Beauty & Skincare">Beauty & Skincare</option>';
                            }
                            ?>
                        </select>
                        <i class="fas fa-chevron-down absolute right-3 top-3 text-neutral pointer-events-none text-sm"></i>
                    </div>

<div class="relative">
                        <select id="sortFilter" class="w-full pl-3 pr-10 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-primary focus:border-transparent appearance-none text-sm">
                            <option value="newest">Newest First</option>
                            <option value="oldest">Oldest First</option>
                            <option value="name_asc">Name A-Z</option>
                            <option value="name_desc">Name Z-A</option>
                        </select>
                        <i class="fas fa-sort absolute right-3 top-3 text-neutral pointer-events-none text-sm"></i>
                    </div>
                </div>
            </div>

<div id="shopsContainer">
                <?php
                // Fetch all approved shops with better error handling
                $query = "
                    SELECT s.id, s.shop_name, s.owner_name, s.business_type, s.address, s.front_image, s.slug, 
                           s.created_at
                    FROM shops1 s 
                    WHERE s.status = 'approved'
                    ORDER BY s.created_at DESC
                ";
                
                $result = mysqli_query($conn, $query);
                
                if (!$result) {
                    echo '<div class="text-center text-red-500 py-10 text-sm">Error loading shops: ' . mysqli_error($conn) . '</div>';
                } elseif (mysqli_num_rows($result) == 0) {
                    echo '<div class="text-center py-10">
                        <div class="bg-white rounded-lg shadow-md p-6 max-w-md mx-auto">
                            <i class="fas fa-store text-5xl text-neutral mb-3"></i>
                            <h3 class="text-lg font-semibold text-dark mb-2">No Shops Available</h3>
                            <p class="text-neutral mb-4 text-sm">There are no shops listed yet. Be the first to register your shop!</p>
                            <a href="register-your-shop.php" class="bg-primary text-white px-5 py-2 rounded-lg hover:bg-green-600 transition-colors inline-flex items-center text-sm">
                                <i class="fas fa-plus mr-2 text-xs"></i>
                                Register Your Shop
                            </a>
                        </div>
                    </div>';
                } else {
                    echo '<div class="grid grid-cols-1 md:grid-cols-2 lg:grid-cols-3 xl:grid-cols-4 gap-5" id="shopsGrid">';
                    
                    // Create a simple mapping for business types
                    $businessTypes = [
                        '8' => 'Textiles',
                        '10' => 'Other',
                        '12' => 'General Store',
                        'Education' => 'Education',
                        'Ecommerce' => 'Ecommerce',
                        'Beauty & Skincare' => 'Beauty & Skincare'
                    ];
                    
                    while ($shop = mysqli_fetch_assoc($result)) {
                        // Get category name
                        $categoryName = $businessTypes[$shop['business_type']] ?? $shop['business_type'];
                        
                        // Truncate address for preview
                        $address = strip_tags($shop['address']);
                        $addressPreview = strlen($address) <= 60 ? $address : substr($address, 0, 60) . '...';
                        
                        echo '
                        <div class="shop-card bg-white rounded-lg shadow-md overflow-hidden border border-light hover:shadow-lg" 
                             data-name="' . strtolower(htmlspecialchars($shop['shop_name'])) . '"
                             data-category="' . htmlspecialchars($shop['business_type']) . '"
                             data-created="' . $shop['created_at'] . '">
                            <div class="h-40 bg-gray-100 overflow-hidden">
                                ' . ($shop['front_image'] ? 
                                    '<img src="' . htmlspecialchars($shop['front_image']) . '" 
                                         alt="' . htmlspecialchars($shop['shop_name']) . '" 
                                         class="w-full h-full object-cover hover:scale-105 transition-transform duration-300">' : 
                                    '<div class="w-full h-full flex items-center justify-center text-neutral">
                                        <i class="fas fa-store text-3xl"></i>
                                     </div>') . '
                            </div>
                            <div class="p-4">
                                <div class="flex items-center justify-between mb-2">
                                    <span class="bg-primary text-white px-2 py-1 rounded text-xs font-medium">
                                        ' . htmlspecialchars($categoryName) . '
                                    </span>
                                    <span class="text-xs text-neutral">
                                        ' . date('M j, Y', strtotime($shop['created_at'])) . '
                                    </span>
                                </div>
                                <h3 class="text-base font-semibold text-dark mb-2 hover:text-primary transition-colors">
                                    ' . htmlspecialchars($shop['shop_name']) . '
                                </h3>
                                <p class="text-neutral text-xs mb-3 flex items-start">
                                    <i class="fas fa-map-marker-alt mr-2 mt-0.5 text-primary text-xs"></i>
                                    ' . htmlspecialchars($addressPreview) . '
                                </p>
                                <div class="flex justify-between items-center">
                                    <span class="text-xs text-neutral">By ' . htmlspecialchars($shop['owner_name']) . '</span>
                                    <a href="shop-details.php?slug=' . $shop['slug'] . '" 
                                       class="bg-primary text-white px-3 py-1 rounded text-xs hover:bg-green-600 transition-colors flex items-center">
                                        View <i class="fas fa-arrow-right ml-1 text-xs"></i>
                                    </a>
                                </div>
                            </div>
                        </div>';
                    }
                    echo '</div>';
                }
                ?>
            </div>

<div id="noResults" class="hidden text-center py-10">
                <div class="bg-white rounded-lg shadow-md p-6 max-w-md mx-auto">
                    <i class="fas fa-search text-5xl text-neutral mb-3"></i>
                    <h3 class="text-lg font-semibold text-dark mb-2">No Shops Found</h3>
                    <p class="text-neutral mb-4 text-sm">Try adjusting your search or filter criteria.</p>
                    <button onclick="resetFilters()" class="bg-primary text-white px-5 py-2 rounded-lg hover:bg-green-600 transition-colors text-sm">
                        Reset Filters
                    </button>
                </div>
            </div>

<div class="bg-gradient-to-r from-primary to-secondary rounded-lg shadow-lg p-6 mt-10 text-center text-white">
                <h2 class="text-xl font-bold mb-3">Want to List Your Shop?</h2>
                <p class="mb-4 max-w-2xl mx-auto text-sm">Join our growing community of local businesses and reach more customers in Pennagaram.</p>
                <a href="register-your-shop.php" class="bg-white text-primary px-6 py-2 rounded-lg font-semibold hover:bg-gray-100 transition-colors inline-flex items-center text-sm">
                    <i class="fas fa-plus mr-2 text-xs"></i>
                    Register Your Shop Now
                </a>
            </div>
        </div>
    </main>

<?php include('footer.php') ?>

// Function to filter shops
            function filterShops() {
                const searchTerm = searchInput.value.toLowerCase();
                const categoryValue = categoryFilter.value;
                const sortValue = sortFilter.value;
                
                const shopCards = shopsGrid.querySelectorAll('.shop-card');
                let visibleCount = 0;

shopCards.forEach(card => {
                    const shopName = card.getAttribute('data-name');
                    const shopCategory = card.getAttribute('data-category');
                    
                    const matchesSearch = shopName.includes(searchTerm);
                    const matchesCategory = !categoryValue || shopCategory === categoryValue;
                    
                    if (matchesSearch && matchesCategory) {
                        card.style.display = 'block';
                        visibleCount++;
                    } else {
                        card.style.display = 'none';
                    }
                });

// Sort shops
                sortShops(sortValue);

// Show/hide no results message
                if (visibleCount === 0) {
                    shopsGrid.style.display = 'none';
                    noResults.classList.remove('hidden');
                } else {
                    shopsGrid.style.display = 'grid';
                    noResults.classList.add('hidden');
                }
            }

// Function to sort shops
            function sortShops(sortValue) {
                const shopCards = Array.from(shopsGrid.querySelectorAll('.shop-card'));
                
                shopCards.sort((a, b) => {
                    switch(sortValue) {
                        case 'newest':
                            return new Date(b.getAttribute('data-created')) - new Date(a.getAttribute('data-created'));
                        case 'oldest':
                            return new Date(a.getAttribute('data-created')) - new Date(b.getAttribute('data-created'));
                        case 'name_asc':
                            return a.getAttribute('data-name').localeCompare(b.getAttribute('data-name'));
                        case 'name_desc':
                            return b.getAttribute('data-name').localeCompare(a.getAttribute('data-name'));
                        default:
                            return 0;
                    }
                });

// Re-append sorted cards
                shopCards.forEach(card => shopsGrid.appendChild(card));
            }

// Function to reset filters
            function resetFilters() {
                searchInput.value = '';
                categoryFilter.value = '';
                sortFilter.value = 'newest';
                filterShops();
            }

// Event listeners
            searchInput.addEventListener('input', filterShops);
            categoryFilter.addEventListener('change', filterShops);
            sortFilter.addEventListener('change', filterShops);
        });
    </script>
</body>
</html>

<?php
// Close database connection
if (isset($conn)) {
    mysqli_close($conn);
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: all-shops.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation