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: shops.php

<section id="shops" class="py-4 px-4 bg-white relative overflow-hidden">
    <div class="container mx-auto">
        
        <div class="flex items-center justify-between mb-4">
            <div class="flex items-center">
                <h2 class="text-xl font-semibold text-secondary mr-3">Local Shops</h2>
            </div>
            <div class="flex items-center space-x-2">
                
                <a href="register-your-shop.php" class="bg-accent text-white px-3 py-1.5 rounded-full font-medium text-xs shadow hover:shadow-md transition-all duration-300 hover:bg-orange-500 inline-flex items-center group">
                    <i class="fas fa-plus-circle mr-1 text-xs"></i>
                    Register Shop
                </a>
                
                <a href="all-shops.php" class="bg-primary text-white px-3 py-1.5 rounded-full font-medium text-xs shadow hover:shadow-md transition-all duration-300 hover:bg-green-600 inline-flex items-center group">
                    View All
                    <i class="fas fa-arrow-right ml-1 text-xs group-hover:translate-x-0.5 transition-transform duration-300"></i>
                </a>
            </div>
        </div>
        
        
        <div class="grid grid-cols-1 md:grid-cols-2 lg:grid-cols-3 gap-4">
            <?php
            // Include database connection
            require_once 'includes/db.php';
            
            // Fetch latest shops from database (limit to 3 for grid)
            $query = "
                SELECT id, shop_name, owner_name, business_type, address, front_image, slug 
                FROM shops1 
                WHERE status = 'approved'
                ORDER BY created_at DESC 
                LIMIT 3
            ";
            
            $result = mysqli_query($conn, $query);
            
            if (!$result) {
                echo '<div class="col-span-3 text-center text-red-500 py-8">Error loading shops. Please try again later.</div>';
                error_log("Database error: " . mysqli_error($conn));
            } elseif (mysqli_num_rows($result) == 0) {
                echo '<div class="col-span-3 text-center text-neutral py-8">No shops available at the moment.</div>';
            } else {
                // Get category names for display
                $categoryQuery = "SELECT id, name FROM shop_categories";
                $categoryResult = mysqli_query($conn, $categoryQuery);
                $categories = [];
                while ($cat = mysqli_fetch_assoc($categoryResult)) {
                    $categories[$cat['id']] = $cat['name'];
                }
                
                while ($shop = mysqli_fetch_assoc($result)) {
                    // Get category name
                    $categoryName = isset($categories[$shop['business_type']]) ? 
                                   $categories[$shop['business_type']] : 'General Store';
                    
                    // Clean and format address - handle escaped backslash patterns
                    $address = strip_tags($shop['address']);
                    
                    // Replace the specific pattern "\\ \\" with a single space
                    $address = str_replace('\\ \\', ' ', $address);
                    
                    // Also handle other possible newline patterns
                    $address = str_replace(array("\\r\\n", "\\r", "\\n", "\r\n", "\r", "\n"), ' ', $address);
                    
                    // Remove multiple consecutive spaces and trim
                    $address = preg_replace('/\s+/', ' ', $address);
                    $address = trim($address);
                    
                    // Truncate address for preview
                    $addressPreview = strlen($address) <= 80 ? $address : substr($address, 0, 80) . '...';
                    
                    echo '
                    <div class="bg-white rounded-lg p-4 transition-all duration-300 group border border-light hover:border-primary/20 hover:shadow-md">
                        <div class="mb-3 h-40 bg-gray-100 rounded overflow-hidden">
                            ' . ($shop['front_image'] ? 
                                '<img src="' . htmlspecialchars($shop['front_image']) . '" alt="' . htmlspecialchars($shop['shop_name']) . '" class="w-full h-full object-cover group-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-4xl"></i></div>') . '
                        </div>
                        <div class="flex items-center mb-2">
                            <div class="w-6 h-6 rounded-full bg-highlight flex items-center justify-center mr-2">
                                <i class="fas fa-store text-primary text-xs"></i>
                            </div>
                            <span class="text-xs text-neutral">' . htmlspecialchars($categoryName) . '</span>
                        </div>
                        <h3 class="text-base font-semibold text-dark mb-2 group-hover:text-primary transition-colors">' . htmlspecialchars($shop['shop_name']) . '</h3>
                        <p class="text-neutral text-sm mb-2 leading-tight 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 mt-3">
                            <span class="text-sm text-neutral">By ' . htmlspecialchars($shop['owner_name']) . '</span>
                            <a href="shop-details.php?slug=' . $shop['slug'] . '" class="text-primary text-sm font-medium flex items-center group-hover:underline">
                                View Details <i class="fas fa-arrow-right ml-1 text-xs group-hover:translate-x-0.5 transition-transform"></i>
                            </a>
                        </div>
                    </div>';
                }
                // Free result set
                mysqli_free_result($result);
            }

?>
        </div>
    </div>
</section>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: shops.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation