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

<?php 
include 'db.php';
include 'header.php';

$brand_id = isset($_GET['brand_id']) ? (int)$_GET['brand_id'] : 0;
$series_id = isset($_GET['series_id']) ? (int)$_GET['series_id'] : 0;
?>

<?php if ($brand_id): ?>
    <?php
    // Fetch current brand info
    $stmt = $conn->prepare("SELECT * FROM brands WHERE id = ?");
    $stmt->bind_param("i", $brand_id);
    $stmt->execute();
    $current_brand = $stmt->get_result()->fetch_assoc();
    
    if (!$current_brand) {
        echo "<script>window.location.href='parts.php';</script>";
        exit;
    }

// Fetch all brands for dropdown
    $brands_result = $conn->query("SELECT * FROM brands WHERE brand_type IN ('All', 'Parts') ORDER BY name ASC");
    $all_brands = $brands_result->fetch_all(MYSQLI_ASSOC);

// Fetch series for this brand
    $series_stmt = $conn->prepare("SELECT * FROM series WHERE brand_id = ? ORDER BY name ASC");
    $series_stmt->bind_param("i", $brand_id);
    $series_stmt->execute();
    $all_series = $series_stmt->get_result()->fetch_all(MYSQLI_ASSOC);

// Fetch products
    // Fetch products
    $query = "SELECT p.* FROM products p LEFT JOIN categories c ON p.category_id = c.id WHERE p.brand_id = ? AND (c.id != 4 AND (c.parent_id != 4 OR c.parent_id IS NULL))";
    $params = [$brand_id];
    $types = "i";

if ($series_id) {
        $query .= " AND p.series_id = ?";
        $params[] = $series_id;
        $types .= "i";
    }
    
    $query .= " ORDER BY p.order_no DESC, p.name DESC";
    $prod_stmt = $conn->prepare($query);
    $prod_stmt->bind_param($types, ...$params);
    $prod_stmt->execute();
    $products = $prod_stmt->get_result()->fetch_all(MYSQLI_ASSOC);
    ?>

<div class="flex justify-between items-center mb-8 bg-white p-4 rounded-lg shadow-sm">
        <h1 class="text-2xl font-bold text-gray-800">
            <?php echo htmlspecialchars($current_brand['name']); ?> Parts
        </h1>
        <div class="flex items-center gap-3">
            <span class="text-gray-600 font-medium">Change Brand:</span>
            <select onchange="if(this.value) window.location.href='parts.php?brand_id='+this.value" class="border border-gray-300 rounded px-3 py-2 text-gray-700 focus:outline-none focus:ring-2 focus:ring-red-900">
                <?php foreach ($all_brands as $brand): ?>
                    <option value="<?php echo $brand['id']; ?>" <?php echo $brand['id'] == $brand_id ? 'selected' : ''; ?>>
                        <?php echo htmlspecialchars($brand['name']); ?>
                    </option>
                <?php endforeach; ?>
            </select>
        </div>
    </div>

<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 text-gray-800">Series</h3>
            <div class="space-y-2">
                <a href="parts.php?brand_id=<?php echo $brand_id; ?>" 
                   class="block px-3 py-2 rounded transition <?php echo !$series_id ? 'bg-red-50 text-red-900 font-bold' : 'text-gray-600 hover:bg-gray-50'; ?>">
                    All Models
                </a>
                <?php foreach ($all_series as $series): ?>
                    <a href="parts.php?brand_id=<?php echo $brand_id; ?>&series_id=<?php echo $series['id']; ?>" 
                       class="block px-3 py-2 rounded transition <?php echo $series_id == $series['id'] ? 'bg-red-50 text-red-900 font-bold' : 'text-gray-600 hover:bg-gray-50'; ?>">
                        <?php echo htmlspecialchars($series['name']); ?>
                    </a>
                <?php endforeach; ?>
                <?php if (empty($all_series)): ?>
                    <p class="text-gray-400 text-sm italic">No series found.</p>
                <?php endif; ?>
            </div>
        </div>

<div class="w-full md:w-3/4">
            <?php if (count($products) > 0): ?>
                <div class="grid grid-cols-2 md:grid-cols-3 lg:grid-cols-4 gap-6">
                    <?php foreach ($products as $product): ?>
                        <a href="product_parts.php?product_id=<?php echo $product['id']; ?>" class="block bg-white rounded-xl shadow-md hover:shadow-lg transition flex flex-col items-center p-6 border border-gray-100 h-full">
                            <div class="h-40 w-full flex items-center justify-center mb-4">
                                <img src="<?php echo !empty($product['image']) ? $product['image'] : 'https://placehold.co/300x300?text=No+Image'; ?>" 
                                     alt="<?php echo htmlspecialchars($product['name']); ?>" 
                                     class="max-h-full max-w-full object-contain">
                            </div>
                            <h3 class="font-bold text-gray-800 text-center text-lg mt-auto">
                                <?php echo htmlspecialchars($product['name']); ?>
                            </h3>
                        </a>
                    <?php endforeach; ?>
                </div>
            <?php else: ?>
                <div class="bg-gray-50 rounded-xl p-12 text-center border-2 border-dashed border-gray-200">
                    <i class="fa-solid fa-mobile-screen text-4xl text-gray-300 mb-3"></i>
                    <p class="text-gray-500 font-medium">No models found for this selection.</p>
                </div>
            <?php endif; ?>
        </div>
    </div>

<?php else: ?>
    
    <h1 class="text-3xl font-bold text-center mb-2">Parts Zone</h1>
    <p class="text-center text-gray-500 mb-12">Select a brand to find compatible parts</p>
    
    <div class="grid grid-cols-2 md:grid-cols-4 gap-6 max-w-4xl mx-auto">
    <?php
        $sql = "SELECT * FROM brands WHERE brand_type IN ('All', 'Parts') ORDER BY name ASC";
        $result = $conn->query($sql);

if ($result->num_rows > 0) {
            while($row = $result->fetch_assoc()) {
                $logo = $row['logo'] ? $row['logo'] : 'https://placehold.co/150x150?text=No+Logo';
                echo '
                <a href="parts.php?brand_id=' . $row["id"] . '" class="block bg-white p-8 rounded-xl shadow hover:shadow-xl transition flex flex-col items-center justify-center aspect-square border hover:border-red-500">
                    <img src="' . $logo . '" alt="' . htmlspecialchars($row["name"]) . '" class="h-16 w-16 object-contain mb-4">
                    <h3 class="font-bold text-xl text-center">' . htmlspecialchars($row["name"]) . '</h3>
                </a>
                ';
            }
        } else {
            echo '<p class="text-center col-span-full text-gray-500">No brands found.</p>';
        }
    ?>
    </div>
<?php endif; ?>

</div>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: parts.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation