| Server IP : 147.79.69.218 / Your IP : 216.73.216.200 Web Server : LiteSpeed System : Linux in-mum-web669.main-hosting.eu 5.14.0-503.23.2.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Wed Feb 12 05:52:18 EST 2025 x86_64 User : u479334040 ( 479334040) PHP Version : 8.2.27 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/u479334040/domains/fossilstyle.com/public_html/ |
Upload File : |
<?php
include('includes/config.php');
$category_filter = isset($_GET['category_id']) ? base64_decode($_GET['category_id']) : '';
$price_filter = isset($_GET['price_range']) ? $_GET['price_range'] : '';
$color_filter = isset($_GET['color']) ? $_GET['color'] : [];
$size_filter = isset($_GET['size']) ? $_GET['size'] : [];
$type_filter = isset($_GET['type']) ? $_GET['type'] : [];
$shape_filter = isset($_GET['shape']) ? $_GET['shape'] : [];
$capacity_filter = isset($_GET['capacity']) ? $_GET['capacity'] : [];
if (!empty($price_filter)) {
list($min_price, $max_price) = explode(';', $price_filter);
$min_price = intval($min_price);
$max_price = intval($max_price);
} else {
$min_price = 0;
$max_price = 1000000;
}
$capacity_ranges = [
'0-50' => '0 - 50 ml',
'51-150' => '51 - 150 ml',
'151-300' => '151 - 300 ml',
'301-500' => '301 - 500 ml',
'501+' => '500 ml+'
];
$capacity_conditions = [];
foreach ((array) $capacity_filter as $range) {
if ($range === '501+') {
$capacity_conditions[] = "capacity >= 501";
} else {
list($min, $max) = explode('-', $range);
$capacity_conditions[] = "(capacity BETWEEN $min AND $max)";
}
}
$capacity_sql = !empty($capacity_conditions) ? ' AND (' . implode(' OR ', $capacity_conditions) . ')' : '';
$where_clause = $category_filter ? "WHERE category = " . intval($category_filter) : '';
function getDistinctValues($con, $column, $where) {
$sql = "SELECT DISTINCT $column FROM products $where AND $column IS NOT NULL AND $column != ''";
$result = $con->query($sql);
$values = [];
while ($row = $result->fetch_assoc()) {
$values[] = $row[$column];
}
return $values;
}
$colors = getDistinctValues($con, 'color', $where_clause);
$sizes = getDistinctValues($con, 'size', $where_clause);
$types = getDistinctValues($con, 'type', $where_clause);
$shapes = getDistinctValues($con, 'shape', $where_clause);
$sql = "SELECT id, productName, price, productImage FROM products WHERE 1";
if ($category_filter) {
$sql .= " AND category = " . intval($category_filter);
}
$sql .= " AND price BETWEEN $min_price AND $max_price";
if (!empty($color_filter)) {
$escaped_colors = "'" . implode("','", array_map([$con, 'real_escape_string'], $color_filter)) . "'";
$sql .= " AND color IN ($escaped_colors)";
}
if (!empty($size_filter)) {
$escaped_sizes = "'" . implode("','", array_map([$con, 'real_escape_string'], $size_filter)) . "'";
$sql .= " AND size IN ($escaped_sizes)";
}
if (!empty($type_filter)) {
$escaped_types = "'" . implode("','", array_map([$con, 'real_escape_string'], $type_filter)) . "'";
$sql .= " AND type IN ($escaped_types)";
}
if (!empty($shape_filter)) {
$escaped_shapes = "'" . implode("','", array_map([$con, 'real_escape_string'], $shape_filter)) . "'";
$sql .= " AND shape IN ($escaped_shapes)";
}
$sql .= $capacity_sql;
$result = $con->query($sql);
$products = [];
while ($row = $result->fetch_assoc()) {
$products[] = $row;
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Filtered Products</title>
<?php include 'assets.php'; ?>
</head>
<body>
<?php include 'header.php'; ?>
<section class="section-b-space shop-section">
<div class="container-fluid-lg">
<div class="row">
<div class="col-custom-3">
<div class="left-box wow fadeInUp">
<div class="shop-left-sidebar">
<form action="products.php" method="GET">
<?php if ($category_filter): ?>
<input type="hidden" name="category_id" value="<?php echo base64_encode($category_filter); ?>">
<?php endif; ?>
<div class="accordion custom-accordion" id="accordionExample">
<!-- Price -->
<div class="accordion-item">
<h2 class="accordion-header"><button class="accordion-button" type="button" data-bs-toggle="collapse" data-bs-target="#price">Price</button></h2>
<div id="price" class="accordion-collapse collapse show">
<div class="accordion-body">
<input type="text" name="price_range" class="form-control" placeholder="e.g. 10;500" value="<?php echo htmlspecialchars($price_filter); ?>">
</div>
</div>
</div>
<!-- Color -->
<div class="accordion-item">
<h2 class="accordion-header"><button class="accordion-button" type="button" data-bs-toggle="collapse" data-bs-target="#color">Color</button></h2>
<div id="color" class="accordion-collapse collapse show">
<div class="accordion-body">
<ul class="category-list custom-padding">
<?php foreach ($colors as $color): ?>
<li><input type="checkbox" class="checkbox_animated" name="color[]" value="<?= htmlspecialchars($color); ?>" <?= in_array($color, (array)$color_filter) ? 'checked' : '' ?>><label><?= ucfirst($color); ?></label></li>
<?php endforeach; ?>
</ul>
</div>
</div>
</div>
<!-- Size -->
<div class="accordion-item">
<h2 class="accordion-header"><button class="accordion-button" type="button" data-bs-toggle="collapse" data-bs-target="#size">Size</button></h2>
<div id="size" class="accordion-collapse collapse show">
<div class="accordion-body">
<ul class="category-list custom-padding">
<?php foreach ($sizes as $size): ?>
<li><input type="checkbox" class="checkbox_animated" name="size[]" value="<?= htmlspecialchars($size); ?>" <?= in_array($size, (array)$size_filter) ? 'checked' : '' ?>><label><?= ucfirst($size); ?> mm</label></li>
<?php endforeach; ?>
</ul>
</div>
</div>
</div>
<!-- Type -->
<div class="accordion-item">
<h2 class="accordion-header"><button class="accordion-button" type="button" data-bs-toggle="collapse" data-bs-target="#type">Type</button></h2>
<div id="type" class="accordion-collapse collapse show">
<div class="accordion-body">
<ul class="category-list custom-padding">
<?php foreach ($types as $type): ?>
<li><input type="checkbox" class="checkbox_animated" name="type[]" value="<?= htmlspecialchars($type); ?>" <?= in_array($type, (array)$type_filter) ? 'checked' : '' ?>><label><?= ucfirst($type); ?></label></li>
<?php endforeach; ?>
</ul>
</div>
</div>
</div>
<!-- Shape -->
<div class="accordion-item">
<h2 class="accordion-header"><button class="accordion-button" type="button" data-bs-toggle="collapse" data-bs-target="#shape">Shape</button></h2>
<div id="shape" class="accordion-collapse collapse show">
<div class="accordion-body">
<ul class="category-list custom-padding">
<?php foreach ($shapes as $shape): ?>
<li><input type="checkbox" class="checkbox_animated" name="shape[]" value="<?= htmlspecialchars($shape); ?>" <?= in_array($shape, (array)$shape_filter) ? 'checked' : '' ?>><label><?= ucfirst($shape); ?></label></li>
<?php endforeach; ?>
</ul>
</div>
</div>
</div>
<!-- Capacity -->
<div class="accordion-item">
<h2 class="accordion-header"><button class="accordion-button" type="button" data-bs-toggle="collapse" data-bs-target="#capacity">Capacity</button></h2>
<div id="capacity" class="accordion-collapse collapse show">
<div class="accordion-body">
<ul class="category-list custom-padding">
<?php foreach ($capacity_ranges as $key => $label): ?>
<li><input type="checkbox" class="checkbox_animated" name="capacity[]" value="<?= $key ?>" <?= in_array($key, (array)$capacity_filter) ? 'checked' : '' ?>><label><?= $label; ?></label></li>
<?php endforeach; ?>
</ul>
</div>
</div>
</div>
<div class="apply-filter-button">
<button type="submit" class="btn theme-bg-color text-white btn-md fw-bold mt-sm-3 mt-1">Apply Filters</button>
</div>
</div>
</form>
</div>
</div>
</div>
<!-- Product List -->
<div class="col-custom-">
<div class="row g-sm-4 g-3 row-cols-xxl-4 row-cols-xl-3 row-cols-lg-2 row-cols-md-3 row-cols-2 product-list-section">
<?php if (!empty($products)) {
foreach ($products as $row) {
$images = explode(',', $row['productImage']);
$encoded_id = base64_encode($row['id']);
?>
<div class="col">
<div class="product-box-3 h-100 wow fadeInUp">
<div class="product-header">
<div class="product-image">
<a href="product_details.php?id=<?= $encoded_id ?>">
<img src="product-admin/<?= trim($images[0]) ?>" class="product-images" alt="<?= $row['productName'] ?>">
</a>
</div>
</div>
<div class="product-footer">
<div class="product-detail">
<h5 class="name"><?= $row['productName'] ?></h5>
<h5 class="price"><span class="theme-color">₹<?= $row['price'] ?></span></h5>
<div class="add-to-cart-box">
<a href="product_details.php?id=<?= $encoded_id ?>" class="btn btn-add-cart">View Details</a>
</div>
</div>
</div>
</div>
</div>
<?php }
} else {
echo '<p>No products found for the selected filters.</p>';
} ?>
</div>
</div>
</div>
</div>
</section>
<?php include 'footer.php'; ?>