ikan Uploader :
Directory : /home/ni05r7l36tus/www/sabksolutions.com/admin/pages/
Upload File : |
| Current File : /home/ni05r7l36tus/www/sabksolutions.com/admin/pages/rangefilter.php |
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Search by Price Range</title>
</head>
<body>
<h2>Filter Products by Price Range</h2>
<form method="GET" action="rangefilter.php">
<label for="price-range">Price Range:
<span id="price-range-label">500</span>
</label>
<input type="range" id="price-range" name="price-range" min="0" max="1000" step="1"
value="<?php echo isset($_GET['price-range']) ? $_GET['price-range'] : '0'; ?>"
oninput="updatePriceLabel(this.value)">
<br>
<span>Selected Price: $<span id="selected-price">500</span></span>
<button type="submit">Apply Filter</button>
</form>
<h3>Product List</h3>
<table border="1">
<tr>
<th>ID</th>
<th>Name</th>
<th>Price</th>
</tr>
<?php
$conn = new mysqli("localhost", "root", "", "rangefilter");
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
if (isset($_GET['price-range'])) {
$priceRange = $conn->real_escape_string($_GET['price-range']);
$sql = "SELECT * FROM products WHERE price <= '$priceRange'";
} else {
$sql = "SELECT * FROM products";
}
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
echo "<tr>";
echo "<td>" . $row["id"] . "</td>";
echo "<td>" . $row["name"] . "</td>";
echo "<td>" . $row["price"] . "</td>";
echo "</tr>";
}
} else {
echo "<tr><td colspan='3'>No products found</td></tr>";
}
$conn->close();
?>
</table>
<script>
function updatePriceLabel(value) {
document.getElementById('price-range-label').textContent = value;
document.getElementById('selected-price').textContent = value;
}
</script>
</body>
</html>
........