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: mobile_category.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']) ? $_GET['brand'] : '';
$ram_filter = isset($_GET['ram']) ? $_GET['ram'] : '';
$network_filter = isset($_GET['network']) ? $_GET['network'] : '';

// 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 ($brand_filter) {
    $query .= " AND p.brand_id = ?";
    $params[] = $brand_filter;
    $types .= 'i';
}

// For ram, network, need to join product_parts or something, but for simplicity, assume filters are on products table, but products don't have ram, etc.
// Products have description or something, but to simplify, perhaps add columns or assume.

$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 WHERE category_id = ?";
$count_stmt = $conn->prepare($count_query);
$count_stmt->bind_param('i', $category_id);
$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">Brands</h4>
                    <div class="space-y-2">
                        <?php foreach ($brands as $brand): ?>
                            <label class="flex items-center gap-2">
                                <input type="checkbox" name="brand[]" value="<?php echo $brand['id']; ?>" class="form-checkbox text-blue-600" <?php if (in_array($brand['id'], (array)$brand_filter)) echo 'checked'; ?>>
                                <?php echo $brand['name']; ?>
                            </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 rounded p-2 text-sm">
                        <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 $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">
                                <input type="radio" name="network" value="<?php echo $network['id']; ?>" class="form-radio text-blue-600" <?php if ($network_filter == $network['id']) echo 'checked'; ?>>
                                <?php echo $network['name']; ?>
                            </label>
                        <?php endforeach; ?>
                    </div>
                </div>
                
                <button type="submit" class="w-full bg-blue-600 text-white py-2 rounded hover:bg-blue-700 transition">Apply Filters</button>
            </form>
        </div>

<div class="w-full md:w-3/4">
            <h2 class="text-2xl font-bold mb-6">Available Mobiles</h2>
            
            
            <div class="mb-4">
                <form method="GET" action="" class="inline">
                    <input type="hidden" name="category_id" value="<?php echo $category_id; ?>">
                    <label class="mr-2">Sort by:</label>
                    <select name="sort" onchange="this.form.submit()" class="border rounded p-2">
                        <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</option>
                    </select>
                </form>
            </div>
            
            <div class="grid md:grid-cols-2 lg:grid-cols-3 gap-6">
                <?php foreach ($products as $product): ?>
                    <div class="bg-white rounded-xl shadow p-4 card-hovering flex flex-col">
                        <div class="flex-1 flex items-center justify-center p-4 bg-gray-50 rounded-lg mb-4">
                            <img data-src="<?php echo $product['image'] ?: 'placeholder.jpg'; ?>" alt="<?php echo $product['name']; ?>" class="max-h-48 object-contain lazy">
                        </div>
                        <div>
                            <h3 class="font-bold text-lg text-gray-800"><?php echo $product['name']; ?></h3>
                            <div class="flex justify-between items-center mt-2">
                                <p class="text-blue-600 font-bold text-xl">$<?php echo number_format($product['price'], 2); ?></p>
                                <button class="bg-blue-600 text-white px-4 py-2 rounded hover:bg-blue-700">View</button>
                            </div>
                        </div>
                    </div>
                <?php endforeach; ?>
            </div>
            
            
            <div class="mt-8 flex justify-center">
                <?php if ($page > 1): ?>
                    <a href="?category_id=<?php echo $category_id; ?>&page=<?php echo $page - 1; ?>&sort=<?php echo $sort; ?>" class="px-4 py-2 bg-gray-200 rounded-l">Previous</a>
                <?php endif; ?>
                <?php for ($i = 1; $i <= $total_pages; $i++): ?>
                    <a href="?category_id=<?php echo $category_id; ?>&page=<?php echo $i; ?>&sort=<?php echo $sort; ?>" class="px-4 py-2 <?php if ($i == $page) echo 'bg-blue-600 text-white'; else echo 'bg-gray-200'; ?>"><?php echo $i; ?></a>
                <?php endfor; ?>
                <?php if ($page < $total_pages): ?>
                    <a href="?category_id=<?php echo $category_id; ?>&page=<?php echo $page + 1; ?>&sort=<?php echo $sort; ?>" class="px-4 py-2 bg-gray-200 rounded-r">Next</a>
                <?php endif; ?>
            </div>
        </div>
    </div>
</div>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: mobile_category.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation