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/domains/thetechnozone.in/public_html

Free Space:

9.31 TB

🔧 Quick Actions

✏️ Editing: accessories.php

<?php
include 'db.php';

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

// 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;
$search = isset($_GET['search']) ? trim($_GET['search']) : '';

// 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;
}

// Get all subcategory IDs if it's a parent category
$category_ids = [$category_id];
$sub_query = "SELECT id FROM categories WHERE parent_id = ?";
$sub_stmt = $conn->prepare($sub_query);
$sub_stmt->bind_param("i", $category_id);
$sub_stmt->execute();
$sub_res = $sub_stmt->get_result();
while ($sub_row = $sub_res->fetch_assoc()) {
    $category_ids[] = (int)$sub_row['id'];
}

// Build query
$cat_placeholders = implode(',', array_fill(0, count($category_ids), '?'));
$query = "SELECT p.*, b.name as brand_name 
          FROM products p 
          JOIN brands b ON p.brand_id = b.id 
          JOIN categories c ON p.category_id = c.id
          WHERE (c.id = 4 OR c.parent_id = 4)
          AND p.category_id IN ($cat_placeholders)";
$params = $category_ids;
$types = str_repeat('i', count($category_ids));

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 (!empty($search)) {
    $query .= " AND (p.name LIKE ? OR b.name LIKE ?)";
    $search_param = "%" . $search . "%";
    $params[] = $search_param;
    $params[] = $search_param;
    $types .= 'ss';
}

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 JOIN categories c ON p.category_id = c.id JOIN brands b ON p.brand_id = b.id WHERE (c.id = 4 OR c.parent_id = 4) AND p.category_id IN ($cat_placeholders)";
$count_params = $category_ids;
$count_types = str_repeat('i', count($category_ids));

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 (!empty($search)) {
    $count_query .= " AND (p.name LIKE ? OR b.name LIKE ?)";
    $search_param = "%" . $search . "%";
    $count_params[] = $search_param;
    $count_params[] = $search_param;
    $count_types .= 'ss';
}

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 WHERE brand_type IN ('All', 'Accessories') ORDER BY name ASC";
$brands_result = $conn->query($brands_query);
$brands = $brands_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 flex flex-col gap-6">
            
            <div class="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; ?>">
                    <?php if(!empty($search)): ?>
                        <input type="hidden" name="search" value="<?php echo htmlspecialchars($search); ?>">
                    <?php endif; ?>
                    
                    
                    <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>
                    
                    <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) || $min_price !== null || $max_price !== null || !empty($search)): ?>
                        <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="bg-white p-6 rounded-xl shadow h-fit">
                <h3 class="font-bold text-xl mb-4 border-b pb-2">Search</h3>
                <form method="GET" action="">
                    <input type="hidden" name="category_id" value="<?php echo $category_id; ?>">
                    <?php 
                    // Preserve filters when searching
                    foreach($brand_filter as $bf) echo '<input type="hidden" name="brand[]" value="'.$bf.'">'; 
                    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.'">';
                    ?>
                    
                    <div class="mb-4">
                        <input type="text" name="search" placeholder="Search by name, brand..." value="<?php echo htmlspecialchars($search); ?>" class="w-full border border-gray-300 rounded p-2 text-sm focus:ring-red-900 focus:border-red-900">
                    </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">
                        Search
                    </button>
                </form>
            </div>
        </div>

<div class="w-full md:w-3/4">
            
            <?php
            $sub_sql = "SELECT id, name FROM categories WHERE parent_id = 4";
            $sub_result = $conn->query($sub_sql);
            if ($sub_result && $sub_result->num_rows > 0):
            ?>
            <div class="flex flex-wrap gap-2 mb-8 bg-white p-4 rounded-xl shadow-sm border border-gray-100">
                <a href="accessories.php?category_id=4" class="px-4 py-2 rounded-full text-sm font-medium <?php echo $category_id == 4 ? 'bg-red-900 text-white' : 'bg-gray-100 text-gray-700 hover:bg-gray-200'; ?> transition">All Accessories</a>
                <?php while($sub = $sub_result->fetch_assoc()): ?>
                    <a href="accessories.php?category_id=<?php echo $sub['id']; ?>" class="px-4 py-2 rounded-full text-sm font-medium <?php echo $category_id == $sub['id'] ? 'bg-red-900 text-white' : 'bg-gray-100 text-gray-700 hover:bg-gray-200'; ?> transition"><?php echo htmlspecialchars($sub['name']); ?></a>
                <?php endwhile; ?>
            </div>
            <?php endif; ?>

<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">
                    <?php 
                    if ($category_id == 4) {
                        echo "All Accessories";
                    } else {
                        $cat_name_sql = "SELECT name FROM categories WHERE id = $category_id";
                        $cat_name_res = $conn->query($cat_name_sql);
                        if ($cat_name_res && $row = $cat_name_res->fetch_assoc()) {
                            echo htmlspecialchars($row['name']);
                        } else {
                            echo "Accessories";
                        }
                    }
                    ?>
                </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($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.'">';
                    if(!empty($search)) echo '<input type="hidden" name="search" value="'.htmlspecialchars($search).'">';
                    ?>
                    
                    <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>
                                        <?php if (isset($product['stock_status']) && $product['stock_status'] === 'out_of_stock'): ?>
                                            <p class="text-red-600 font-bold text-lg">Out of Stock</p>
                                        <?php else: ?>
                                            <p class="text-red-900 font-bold text-xl">₹<?php echo number_format($product['price'], 2); ?></p>
                                        <?php endif; ?>
                                    </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: accessories.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation