Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.34.1.lve.el8.x86_64

PHP Version:

8.1.34

User:

u823300664

Directory:

/home/u823300664/domains/allspikes.in/public_html

Free Space:

2 TB

🔧 Quick Actions

✏️ Editing: product-search.php

<?php
include "config.php";

if (isset($_GET['searchitem'])) {
    $searchitem = $_GET['searchitem'];
    $selectproduct = mysqli_query($conn, "SELECT * FROM `product` WHERE status='1' AND `name` LIKE '%$searchitem%' ");
}

$fas = array();
$nfas = [];

// // Check if filters are applied
$sizes = isset($_GET['size']) ? explode(',', $_GET['size']) : [];
$brands = isset($_GET['brand']) ? explode(',', $_GET['brand']) : [];
$genders = isset($_GET['gender']) ? explode(',', $_GET['gender']) : [];
$colors = isset($_GET['color']) ? explode(',', $_GET['color']) : [];

// // Fetch sizes for dropdown
$sas = mysqli_query($conn, "SELECT GROUP_CONCAT(size) AS sizes FROM product WHERE `name` LIKE '%$searchitem%' AND status = '1'");

if (mysqli_num_rows($sas) > 0) {
    $fas = mysqli_fetch_assoc($sas);

// Convert sizes string into an array
    $sizesArray = explode(',', $fas['sizes']);

$numericSizes = [];
    $nonNumericSizes = [];

// Separate numeric UK sizes and other sizes
    foreach ($sizesArray as $size) {
        $trimmedSize = trim($size); // Trim whitespace
        if (strpos($trimmedSize, 'UK ') === 0) {
            // Convert UK size to a float for sorting
            $numericSizes[] = (float) str_replace('UK ', '', $trimmedSize);
        } else {
            // Non-numeric sizes go into a separate array
            $nonNumericSizes[] = $trimmedSize;
        }
    }

// Sort numeric UK sizes
    sort($numericSizes);

// Reconstruct the UK size array
    $sortedUKSizes = array_map(function ($size) {
        return 'UK ' . $size;
    }, $numericSizes);

// Remove duplicates and merge both arrays
    $nfas = array_unique(array_merge($sortedUKSizes, $nonNumericSizes));
}

$filterConditions = ["name LIKE '%$searchitem%' AND status = '1'"];

if (!empty($sizes)) {
    // Escape the sizes
    $sizeList = array_map(function ($size) use ($conn) {
        return mysqli_real_escape_string($conn, $size);
    }, $sizes);

// Create the FIND_IN_SET condition
    $sizeConditions = array_map(function ($size) {
        return "FIND_IN_SET('$size', size)"; // Use each size with FIND_IN_SET
    }, $sizeList);

// Combine the conditions with OR
    $filterConditions[] = '(' . implode(' OR ', $sizeConditions) . ')';
}

if (!empty($brands)) {
    $brandList = array_map(function ($brand) use ($conn) {
        return "'" . mysqli_real_escape_string($conn, $brand) . "'";
    }, $brands);
    $filterConditions[] = "brand IN (" . implode(',', $brandList) . ")";
}

if (!empty($genders)) {
    $genderList = array_map(function ($gender) use ($conn) {
        return "'" . mysqli_real_escape_string($conn, $gender) . "'";
    }, $genders);
    $filterConditions[] = "gender IN (" . implode(',', $genderList) . ")";
}

if (!empty($colors)) {
    $colorList = array_map(function ($color) use ($conn) {
        return "'" . mysqli_real_escape_string($conn, $color) . "'";
    }, $colors);
    $filterConditions[] = "color IN (" . implode(',', $colorList) . ")";
}

// // Capture the sort option from URL parameters
$sortOption = isset($_GET['sort']) ? $_GET['sort'] : 'latest';

$orderBy = 'Date DESC';

switch ($sortOption) {
    case 'low-to-high':
        $orderBy = 'sellprice ASC'; // Sort by price low to high
        break;
    case 'high-to-low':
        $orderBy = 'sellprice DESC'; // Sort by price high to low
        break;
    case 'latest':
    default:
        $orderBy = 'Date DESC'; // Sort by latest arrival
        break;
}

$whereClause = implode(' AND ', $filterConditions);
$selectproduct = mysqli_query($conn, "SELECT * FROM product WHERE $whereClause GROUP BY name ORDER BY $orderBy");
$productCount = mysqli_num_rows($selectproduct);

require 'header.php';
?>

.color-thumbnail img {
        width: 50px;
        height: 50px;
        object-fit: contain;
        border: 1px solid #ccc;
        border-radius: 4px;
        transition: transform 0.2s;
        background: #eaeeef;
    }

.color-thumbnail:hover img {
        transform: scale(1.1);
    }

.product-item:hover .color-thumbnails-container {
        display: flex;
    }

.filter-section {
        margin: 20px 0;
    }

.filter-group {
        margin-bottom: 20px;
    }

.filter-title {
        cursor: pointer;
        padding: 10px;
        background-color: #f1f1f1;
        border: 1px solid #ccc;
        border-radius: 4px;
        display: flex;
        justify-content: space-between;
    }

.filter-options {
        display: none;
        border: 1px solid #ccc;
        border-radius: 4px;
        padding: 10px;
        background-color: #fff;
    }

.filter-options label {
        display: block;
        cursor: pointer;
    }

.filter-options input {
        margin-right: 10px;
    }

.filter-pill {
        display: inline-block;
        padding: 5px 10px;
        margin: 5px;
        border: 1px solid #ccc;
        border-radius: 4px;
        cursor: pointer;
    }

.filter-pill.active-filter {
        background-color: #007bff;
        color: #fff;
    }

.filter-color {
        display: inline-block;
        width: 30px;
        height: 30px;
        border: 1px solid #ccc;
        border-radius: 50%;
        margin: 5px;
        cursor: pointer;
        transition: border 0.3s, box-shadow 0.3s;
    }

.filter-color.active-filter {
        border: 3px solid #007bff;
        box-shadow: 0 0 5px rgba(0, 123, 255, 0.5);
        background-color: rgba(0, 123, 255, 0.2);
    }

/* Apply Filters Button */
    #applyFilters {
        display: inline-block;
        padding: 10px 20px;
        /* Adjust padding for button size */
        margin-top: 10px;
        /* Space above the button */
        background-color: #007bff;
        /* Primary color for the button */
        color: #fff;
        /* Text color */
        border: none;
        /* Remove default border */
        border-radius: 4px;
        /* Rounded corners */
        font-size: 16px;
        /* Font size */
        cursor: pointer;
        /* Pointer cursor on hover */
        transition: background-color 0.3s, transform 0.2s;
        /* Transition for hover effect */
    }

#applyFilters:hover {
        background-color: #0056b3;
        /* Darker shade on hover */
        transform: translateY(-2px);
        /* Slight lift effect on hover */
    }

#applyFilters:active {
        transform: translateY(0);
        /* Reset lift effect on click */
    }

/* Clear Filters Button */
    #clearFilters {
        display: inline-block;
        padding: 10px 20px;
        /* Adjust padding for button size */
        margin-top: 10px;
        /* Space above the button */
        background-color: #dc3545;
        /* Red background for clear button */
        color: #fff;
        /* Text color */
        border: none;
        /* Remove default border */
        border-radius: 4px;
        /* Rounded corners */
        font-size: 16px;
        /* Font size */
        cursor: pointer;
        /* Pointer cursor on hover */
        transition: background-color 0.3s, transform 0.2s;
        /* Transition for hover effect */
    }

#clearFilters:hover {
        background-color: #c82333;
        /* Darker red on hover */
        transform: translateY(-2px);
        /* Slight lift effect on hover */
    }

#clearFilters:active {
        transform: translateY(0);
        /* Reset lift effect on click */
    }

.filter-section {
        display: block;
        /* Always show on desktop */
    }

.mob-filter-btn {
        display: none;
        /* Hide button on desktop */
    }

/* Show pointer cursor on hover */
    .mob-filter-btn:hover {
        cursor: pointer;
        /* Change cursor to pointer on hover */
    }

/* Mobile Styles */
    @media (max-width: 768px) {
        .filter-section {
            display: none;
            /* Hide by default on mobile */
        }

.mob-filter-btn {
            display: inline-block;
            /* Show button on mobile */
        }
    }
</style>

<section class="inner-top">
    <div class="container">
        <div class="row">
            <div class="col-lg-12">
                <div class="breadcrumb">
                    <a href="index.php" class="hover">Home</a>
                    <span>| Search Results</span>
                </div>
            </div>
        </div>
    </div>
</section>

<section class="products-sec">
    <div class="container">
        <div class="row">
            <div class="col-lg-12">
                <a class="mob-filter-btn" onclick="toggleFilterSection()">
                    <i class="fa fa-filter"></i> Filters
                </a>
            </div>
            <div class="col-lg-3 col-md-3 col-12">
                <div class="filter-section" id="filterSection">
                    <h3>Filter By</h3>

<div class="filter-group">
                        <div class="filter-title" onclick="toggleFilter('sizeOptions')">
                            Size <span>&#9662;</span>
                        </div>
                        <div class="filter-options" id="sizeOptions">
                            <?php if (!empty($nfas)) {
                                foreach ($nfas as $size) {
                                    $active = in_array($size, $sizes) ? 'active-filter' : '';
                                    echo "<span class='filter-pill $active' data-value='{$size}' onclick='selectFilter(this, \"size\")'>{$size}</span>";
                                }
                            } ?>
                        </div>
                    </div>

<div class="filter-group">
                        <div class="filter-title" onclick="toggleFilter('brandOptions')">
                            Brand <span>&#9662;</span>
                        </div>
                        <div class="filter-options" id="brandOptions">
                            <?php
                            $brandQuery = "SELECT DISTINCT brand FROM product WHERE `name` LIKE '%$searchitem%' AND status = '1'";
                            $brandResult = mysqli_query($conn, $brandQuery);
                            while ($brandRow = mysqli_fetch_array($brandResult)) {
                                $active = in_array($brandRow['brand'], $brands) ? 'active-filter' : '';
                                echo "<span class='filter-pill $active' data-value='{$brandRow['brand']}' onclick='selectFilter(this, \"brand\")'>{$brandRow['brand']}</span>";
                            }
                            ?>
                        </div>
                    </div>

<div class="filter-group">
                        <div class="filter-title" onclick="toggleFilter('genderOptions')">
                            Gender <span>&#9662;</span>
                        </div>
                        <div class="filter-options" id="genderOptions">
                            <?php
                            // Replace this with your actual gender query logic
                            $genderQuery = "SELECT DISTINCT gender FROM product WHERE `name` LIKE '%$searchitem%' AND status = '1'";
                            $genderResult = mysqli_query($conn, $genderQuery);
                            while ($genderRow = mysqli_fetch_array($genderResult)) {
                                $active = in_array($genderRow['gender'], $genders) ? 'active-filter' : ''; // Assume $genders holds the selected gender values
                                echo "<span class='filter-pill $active' data-value='{$genderRow['gender']}' onclick='selectFilter(this, \"gender\")'>{$genderRow['gender']}</span>";
                            }
                            ?>
                        </div>
                    </div>

<div class="filter-group">
                        <div class="filter-title" onclick="toggleFilter('colorOptions')">
                            Color <span>&#9662;</span>
                        </div>
                        <div class="filter-options" id="colorOptions">
                            <?php
                            $colorQuery = "SELECT DISTINCT color FROM product WHERE `name` LIKE '%$searchitem%' AND status = '1'";
                            $colorResult = mysqli_query($conn, $colorQuery);
                            while ($colorRow = mysqli_fetch_array($colorResult)) {
                                $active = in_array($colorRow['color'], $colors) ? 'active-filter' : '';
                                echo "<span class='filter-color $active' data-value='{$colorRow['color']}' style='background-color: {$colorRow['color']};' onclick='selectFilter(this, \"color\")'></span>";
                            }
                            ?>
                        </div>
                    </div>

<button id="applyFilters">Apply Filters</button>
                    <button id="clearFilters">Clear Filters</button>
                </div>
            </div>

<div class="col-lg-9 col-md-9 col-12">
                <div class="products-main">
                    <div class="row g-2">
                        <div class="col-lg-12">
                            <div class="products-title mb-2">
                                <h1><?php echo !empty($subcat2Name) ? $subcat2Name : (!empty($subcatName) ? $subcatName : 'Products');
                                    echo " (" . $productCount . ")"; ?></h1>
                            </div>
                            <div class="sort-by d-flex align-items-center">
                                <label for="sortOptions" class="me-2">Sort By:</label>
                                <select id="sortOptions" onchange="sortProducts()">
                                    <option value="latest" <?php echo $sortOption == 'latest' ? 'selected' : ''; ?>>Latest
                                        Arrival</option>
                                    <option value="low-to-high" <?php echo $sortOption == 'low-to-high' ? 'selected' : ''; ?>>Price: Low to High</option>
                                    <option value="high-to-low" <?php echo $sortOption == 'high-to-low' ? 'selected' : ''; ?>>Price: High to Low</option>
                                </select>
                            </div>
                        </div>
                        <?php while ($fetchproduct = mysqli_fetch_array($selectproduct)) { ?>
                            <div class="col-lg-4 col-md-6 col-6">
                                <div class="product-item products">
                                    <a id="productLink<?php echo $fetchproduct['id']; ?>"
                                        href="product-details.php?idpro=<?php echo str_replace(' ', '-', $fetchproduct['name']); ?>&pid=<?php echo $fetchproduct['id']; ?>&ssid=<?php echo $ssid; ?>&sid=<?php echo $sid; ?>">

<div class="product-thumb" style="background:#eaeeef;">
                                            <?php
                                            $image = explode(",", $fetchproduct['image']);
                                            // Store the main image to use it for hover
                                            $mainImage = "admin/image/" . $image[0];
                                            echo "<img id='mainImage{$fetchproduct['id']}' src='{$mainImage}' alt='product thumb'>";
                                            ?>
                                        </div>
                                    </a>
                                    <div class="product-content">
                                        <div class="color-thumbnails-container">
                                            <?php
                                            $name = $fetchproduct['name'];
                                            $productColors = mysqli_query($conn, "SELECT * FROM product WHERE name = '$name' AND status = '1'");
                                            while ($colorData = mysqli_fetch_array($productColors)) {
                                                $colorImages = explode(",", $colorData['image']);
                                                $colorName = $colorData['color'];
                                                $idpro = str_replace(' ', '-', $colorData['name']);
                                                $pid = $colorData['id'];
                                                $ssid = $colorData['subcategory2'];
                                                $sid = $colorData['subcategory'];
                                                $productUrl = "product-details.php?idpro=$idpro&pid=$pid&ssid=$ssid&sid=$sid";
                                                // Change the image on hover
                                                echo "<a href='$productUrl' class='color-thumbnail' onmouseover=\"changeImage('admin/image/{$colorImages[0]}', {$fetchproduct['id']}, '$productUrl')\">
                                                <img src='admin/image/{$colorImages[0]}' alt='$colorName' title='$colorName' style='width: 60px; height: 60px; object-fit: contain;' /></a>";
                                            }
                                            ?>
                                        </div>
                                        <div class="name">
                                            <h2><?php echo strlen($fetchproduct['name']) > 22 ? substr($fetchproduct['name'], 0, 22) . "..." : $fetchproduct['name']; ?>
                                            </h2>
                                        </div>
                                        <div class="price">
                                            <div>
                                                <span class="sale">&#8377
                                                    <?php echo $fetchproduct['sellprice']; ?>.00</span>
                                                <span class="real">&#8377 <?php echo $fetchproduct['mrp']; ?>.00</span>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        <?php } ?>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>

// Update the href link
        const productLink = document.getElementById(`productLink${productId}`);
        productLink.href = newHref;
    }

function toggleFilterSection() {
        const filterSection = document.getElementById('filterSection');
        const currentDisplay = window.getComputedStyle(filterSection).display;

if (window.innerWidth < 768) {
            if (currentDisplay === 'none') {
                filterSection.style.display = 'block';
            } else {
                filterSection.style.display = 'none';
            }
        }
    }

function toggleFilter(id) {
        const filterOptions = document.getElementById(id);
        filterOptions.style.display = filterOptions.style.display === 'block' ? 'none' : 'block';
    }

function selectFilter(element, type) {
        element.classList.toggle('active-filter');
    }

document.getElementById('applyFilters').addEventListener('click', function() {
        // Get selected sizes
        const selectedSizes = Array.from(document.querySelectorAll('#sizeOptions .filter-pill.active-filter'))
            .map(option => option.getAttribute('data-value'));

// Get selected brands
        const selectedBrands = Array.from(document.querySelectorAll('#brandOptions .filter-pill.active-filter'))
            .map(option => option.getAttribute('data-value'));

const selectedGenders = Array.from(document.querySelectorAll('#genderOptions .filter-pill.active-filter'))
            .map(option => option.getAttribute('data-value'));

// Get selected colors
        const selectedColors = Array.from(document.querySelectorAll('#colorOptions .filter-color.active-filter'))
            .map(option => option.getAttribute('data-value'));

// Update URL with selected filters
        const params = new URLSearchParams(window.location.search);

if (selectedSizes.length) {
            params.set('size', selectedSizes.join(','));
        } else {
            params.delete('size');
        }

if (selectedBrands.length) {
            params.set('brand', selectedBrands.join(','));
        } else {
            params.delete('brand');
        }

if (selectedGenders.length) {
            params.set('gender', selectedGenders.join(','));
        } else {
            params.delete('gender');
        }

if (selectedColors.length) {
            params.set('color', selectedColors.join(','));
        } else {
            params.delete('color');
        }

// Redirect with updated query parameters
        window.location.href = window.location.pathname + '?' + params.toString();
    });

// Clear filters without reloading the page
    document.getElementById('clearFilters').addEventListener('click', function() {
        window.location.href = window.location.pathname + `?searchitem=<?php echo $searchitem; ?>`;
    });

function sortProducts() {
        const sortOption = document.getElementById('sortOptions').value;
        const params = new URLSearchParams(window.location.search);
        params.set('sort', sortOption); // Set the sort parameter
        window.location.search = params.toString(); // Reload the page with updated query
    }
</script>
<?php include "footer.php"; ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: product-search.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation