Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.19.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u802471691

Directory:

/home/u802471691/public_html

Free Space:

9.31 TB

🔧 Quick Actions

✏️ Editing: mobiles.php

<?php
include 'db.php';

// Get category ID from URL or assume 1 for mobiles
$category_id = isset($_GET['category_id']) ? (int)$_GET['category_id'] : 1;

// Pagination
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$per_page = 20;
$offset = ($page - 1) * $per_page;

// Filters
$brand_filter = isset($_GET['brand']) ? (array)$_GET['brand'] : [];
$ram_filter = isset($_GET['ram']) ? $_GET['ram'] : '';
$network_filter = isset($_GET['network']) ? $_GET['network'] : '';
$min_price = isset($_GET['min_price']) && $_GET['min_price'] !== '' ? (float)$_GET['min_price'] : null;
$max_price = isset($_GET['max_price']) && $_GET['max_price'] !== '' ? (float)$_GET['max_price'] : null;

// Sort
$sort = isset($_GET['sort']) ? $_GET['sort'] : 'name_asc';
$order_by = 'p.name ASC';
switch ($sort) {
    case 'name_desc': $order_by = 'p.name DESC'; break;
    case 'price_asc': $order_by = 'p.price ASC'; break;
    case 'price_desc': $order_by = 'p.price DESC'; break;
    case 'newest': $order_by = 'p.created_at DESC'; break;
}

// Build query
$query = "SELECT p.*, b.name as brand_name 
          FROM products p 
          JOIN brands b ON p.brand_id = b.id 
          WHERE p.category_id = ?";
$params = [$category_id];
$types = 'i';

if (!empty($brand_filter)) {
    $placeholders = implode(',', array_fill(0, count($brand_filter), '?'));
    $query .= " AND p.brand_id IN ($placeholders)";
    $params = array_merge($params, $brand_filter);
    $types .= str_repeat('i', count($brand_filter));
}

if ($min_price !== null) {
    $query .= " AND p.price >= ?";
    $params[] = $min_price;
    $types .= 'd';
}

if ($max_price !== null) {
    $query .= " AND p.price <= ?";
    $params[] = $max_price;
    $types .= 'd';
}

$query .= " ORDER BY $order_by LIMIT ? OFFSET ?";
$params[] = $per_page;
$params[] = $offset;
$types .= 'ii';

$stmt = $conn->prepare($query);
$stmt->bind_param($types, ...$params);
$stmt->execute();
$result = $stmt->get_result();
$products = $result->fetch_all(MYSQLI_ASSOC);

// Get total count for pagination
$count_query = "SELECT COUNT(*) as total FROM products p WHERE p.category_id = ?";
$count_params = [$category_id];
$count_types = 'i';

if (!empty($brand_filter)) {
    $placeholders = implode(',', array_fill(0, count($brand_filter), '?'));
    $count_query .= " AND p.brand_id IN ($placeholders)";
    $count_params = array_merge($count_params, $brand_filter);
    $count_types .= str_repeat('i', count($brand_filter));
}

if ($min_price !== null) {
    $count_query .= " AND p.price >= ?";
    $count_params[] = $min_price;
    $count_types .= 'd';
}

if ($max_price !== null) {
    $count_query .= " AND p.price <= ?";
    $count_params[] = $max_price;
    $count_types .= 'd';
}

$count_stmt = $conn->prepare($count_query);
$count_stmt->bind_param($count_types, ...$count_params);
$count_stmt->execute();
$count_result = $count_stmt->get_result();
$total_products = $count_result->fetch_assoc()['total'];
$total_pages = ceil($total_products / $per_page);

// Get brands for filter
$brands_query = "SELECT * FROM brands";
$brands_result = $conn->query($brands_query);
$brands = $brands_result->fetch_all(MYSQLI_ASSOC);

// Get rams for filter
$rams_query = "SELECT * FROM ram";
$rams_result = $conn->query($rams_query);
$rams = $rams_result->fetch_all(MYSQLI_ASSOC);

// Get connectivity for network
$networks_query = "SELECT * FROM connectivity";
$networks_result = $conn->query($networks_query);
$networks = $networks_result->fetch_all(MYSQLI_ASSOC);

include 'header.php';
?>

<div class="container mx-auto px-4 py-8">
    <div class="flex flex-col md:flex-row gap-8">
        
        <div class="w-full md:w-1/4 bg-white p-6 rounded-xl shadow h-fit">
            <h3 class="font-bold text-xl mb-4 border-b pb-2">Filters</h3>
            
            <form method="GET" action="">
                <input type="hidden" name="category_id" value="<?php echo $category_id; ?>">
                
                
                <div class="mb-6">
                    <h4 class="font-semibold mb-2 text-sm text-gray-500 uppercase">Price Range (₹)</h4>
                    <div class="flex gap-2 items-center">
                        <input type="number" name="min_price" placeholder="Min" value="<?php echo $min_price; ?>" class="w-full border border-gray-300 rounded p-2 text-sm focus:ring-red-900 focus:border-red-900">
                        <span class="text-gray-400">-</span>
                        <input type="number" name="max_price" placeholder="Max" value="<?php echo $max_price; ?>" class="w-full border border-gray-300 rounded p-2 text-sm focus:ring-red-900 focus:border-red-900">
                    </div>
                </div>

<div class="mb-6">
                    <h4 class="font-semibold mb-2 text-sm text-gray-500 uppercase">Brands</h4>
                    <div class="space-y-2 max-h-48 overflow-y-auto">
                        <?php foreach ($brands as $brand): ?>
                            <label class="flex items-center gap-2 cursor-pointer">
                                <input type="checkbox" name="brand[]" value="<?php echo $brand['id']; ?>" class="form-checkbox text-red-900 rounded" <?php if (in_array($brand['id'], $brand_filter)) echo 'checked'; ?>>
                                <span class="text-gray-700"><?php echo htmlspecialchars($brand['name']); ?></span>
                            </label>
                        <?php endforeach; ?>
                    </div>
                </div>

<div class="mb-6">
                    <h4 class="font-semibold mb-2 text-sm text-gray-500 uppercase">RAM</h4>
                    <select name="ram" class="w-full border border-gray-300 rounded p-2 text-sm focus:ring-red-900 focus:border-red-900">
                        <option value="">Any</option>
                        <?php foreach ($rams as $ram): ?>
                            <option value="<?php echo $ram['id']; ?>" <?php if ($ram_filter == $ram['id']) echo 'selected'; ?>><?php echo htmlspecialchars($ram['name']); ?></option>
                        <?php endforeach; ?>
                    </select>
                </div>

<div class="mb-6">
                    <h4 class="font-semibold mb-2 text-sm text-gray-500 uppercase">Network</h4>
                    <div class="space-y-2">
                        <?php foreach ($networks as $network): ?>
                            <label class="flex items-center gap-2 cursor-pointer">
                                <input type="radio" name="network" value="<?php echo $network['id']; ?>" class="form-radio text-red-900" <?php if ($network_filter == $network['id']) echo 'checked'; ?>>
                                <span class="text-gray-700"><?php echo htmlspecialchars($network['name']); ?></span>
                            </label>
                        <?php endforeach; ?>
                    </div>
                </div>
                
                <button type="submit" class="w-full bg-red-900 hover:bg-red-800 text-white font-bold py-2 px-4 rounded transition duration-200">
                    Apply Filters
                </button>
                
                <?php if(!empty($brand_filter) || $ram_filter || $network_filter || $min_price !== null || $max_price !== null): ?>
                    <a href="?category_id=<?php echo $category_id; ?>" class="block text-center mt-2 text-sm text-gray-500 hover:text-gray-700 underline">Clear Filters</a>
                <?php endif; ?>
            </form>
        </div>

<div class="w-full md:w-3/4">
            <div class="flex flex-col md:flex-row justify-between items-center mb-6">
                <h2 class="text-2xl font-bold text-gray-800 mb-4 md:mb-0">Available Items</h2>
                
                
                <form method="GET" action="" class="inline-flex items-center">
                    <input type="hidden" name="category_id" value="<?php echo $category_id; ?>">
                    <?php 
                    // Preserve filters in sort form
                    foreach($brand_filter as $bf) echo '<input type="hidden" name="brand[]" value="'.$bf.'">'; 
                    if($ram_filter) echo '<input type="hidden" name="ram" value="'.$ram_filter.'">';
                    if($network_filter) echo '<input type="hidden" name="network" value="'.$network_filter.'">';
                    if($min_price !== null) echo '<input type="hidden" name="min_price" value="'.$min_price.'">';
                    if($max_price !== null) echo '<input type="hidden" name="max_price" value="'.$max_price.'">';
                    ?>
                    
                    <label class="mr-2 text-gray-600 font-medium">Sort by:</label>
                    <select name="sort" onchange="this.form.submit()" class="border border-gray-300 rounded p-2 text-sm focus:ring-red-900 focus:border-red-900 bg-white">
                        <option value="name_asc" <?php if ($sort == 'name_asc') echo 'selected'; ?>>Name (A-Z)</option>
                        <option value="name_desc" <?php if ($sort == 'name_desc') echo 'selected'; ?>>Name (Z-A)</option>
                        <option value="price_asc" <?php if ($sort == 'price_asc') echo 'selected'; ?>>Price (Low to High)</option>
                        <option value="price_desc" <?php if ($sort == 'price_desc') echo 'selected'; ?>>Price (High to Low)</option>
                        <option value="newest" <?php if ($sort == 'newest') echo 'selected'; ?>>Newest First</option>
                    </select>
                </form>
            </div>
            
            <?php if (count($products) > 0): ?>
                <div class="grid grid-cols-1 md:grid-cols-2 lg:grid-cols-3 gap-6">
                    <?php foreach ($products as $product): ?>
                        <div class="bg-white rounded-xl shadow-md hover:shadow-lg transition-shadow duration-300 overflow-hidden border border-gray-100 flex flex-col h-full card-hovering">
                            
                            <div class="p-6 bg-white flex items-center justify-center h-48 relative">
                                <img 
                                    data-src="<?php echo !empty($product['image']) ? $product['image'] : 'https://placehold.co/400x400?text=No+Image'; ?>" 
                                    src="data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 100 100'%3E%3Crect width='100%25' height='100%25' fill='%23f3f4f6'/%3E%3C/svg%3E" 
                                    alt="<?php echo htmlspecialchars($product['name']); ?>" 
                                    class="max-h-full max-w-full object-contain lazy transition-opacity duration-300 opacity-0"
                                    onload="this.classList.remove('opacity-0')"
                                >
                            </div>
                            
                            
                            <div class="p-4 flex flex-col flex-grow">
                                <h3 class="font-bold text-lg text-gray-800 mb-1 line-clamp-2" title="<?php echo htmlspecialchars($product['name']); ?>">
                                    <?php echo htmlspecialchars($product['name']); ?>
                                </h3>
                                <p class="text-sm text-gray-500 mb-4"><?php echo htmlspecialchars($product['brand_name']); ?></p>
                                
                                <div class="mt-auto flex justify-between items-center pt-3 border-t border-gray-100">
                                    <div class="text-left">
                                        <p class="text-gray-500 text-xs uppercase font-semibold">Price</p>
                                        <p class="text-red-900 font-bold text-xl">₹<?php echo number_format($product['price'], 2); ?></p>
                                    </div>
                                    <div>
                                        <a href="product_detail.php?id=<?php echo $product['id']; ?>" class="inline-block bg-red-900 hover:bg-red-800 text-white font-medium py-2 px-6 rounded-lg transition-colors shadow-sm">
                                            View
                                        </a>
                                    </div>
                                </div>
                            </div>
                        </div>
                    <?php endforeach; ?>
                </div>
            
                
                <?php if ($total_pages > 1): ?>
                    <div class="mt-10 flex justify-center">
                        <nav class="inline-flex rounded-md shadow-sm -space-x-px" aria-label="Pagination">
                            <?php 
                            // Reuse query params for pagination links
                            $queryParams = $_GET;
                            unset($queryParams['page']);
                            $queryString = http_build_query($queryParams);
                            ?>
                            
                            <?php if ($page > 1): ?>
                                <a href="?<?php echo $queryString; ?>&page=<?php echo $page - 1; ?>" class="px-3 py-2 border border-gray-300 rounded-l-md bg-white text-sm font-medium text-gray-500 hover:bg-gray-50">
                                    Previous
                                </a>
                            <?php endif; ?>
                            
                            <?php 
                            for ($i = 1; $i <= $total_pages; $i++): 
                            ?>
                                <a href="?<?php echo $queryString; ?>&page=<?php echo $i; ?>" class="px-4 py-2 border border-gray-300 bg-white text-sm font-medium <?php echo $i == $page ? 'text-red-900 border-red-900 bg-red-50 z-10' : 'text-gray-500 hover:bg-gray-50'; ?>">
                                    <?php echo $i; ?>
                                </a>
                            <?php endfor; ?>
                            
                            <?php if ($page < $total_pages): ?>
                                <a href="?<?php echo $queryString; ?>&page=<?php echo $page + 1; ?>" class="px-3 py-2 border border-gray-300 rounded-r-md bg-white text-sm font-medium text-gray-500 hover:bg-gray-50">
                                    Next
                                </a>
                            <?php endif; ?>
                        </nav>
                    </div>
                <?php endif; ?>
                
            <?php else: ?>
                <div class="bg-gray-50 rounded-xl p-12 text-center">
                    <svg class="mx-auto h-12 w-12 text-gray-400" fill="none" stroke="currentColor" viewBox="0 0 24 24" xmlns="http://www.w3.org/2000/svg">
                        <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M9.172 16.172a4 4 0 015.656 0M9 10h.01M15 10h.01M21 12a9 9 0 11-18 0 9 9 0 0118 0z"></path>
                    </svg>
                    <h3 class="mt-2 text-sm font-medium text-gray-900">No items found</h3>
                    <p class="mt-1 text-sm text-gray-500">Try adjusting your filters or search criteria.</p>
                </div>
            <?php endif; ?>
        </div>
    </div>
</div>

lazyImages.forEach(img => {
            imageObserver.observe(img);
        });
    } else {
        // Fallback for older browsers
        lazyImages.forEach(img => {
            img.src = img.dataset.src;
            img.classList.remove('opacity-0');
        });
    }
});
</script>

<?php include 'footer.php'; ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: mobiles.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation