dedecms联动筛选生成

<?php
// 假设这是后端处理代码
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $category = $_POST['category'];
    $price_range = $_POST['price_range'];

    // 构建SQL查询语句
    $sql = "SELECT * FROM products WHERE category = '$category' AND price BETWEEN $price_range[0] AND $price_range[1]";

    // 执行查询并返回结果
    $result = mysqli_query($conn, $sql);
    $data = mysqli_fetch_all($result, MYSQLI_ASSOC);

    echo json_encode($data);
}
?>

<!-- 假设这是前端代码 -->
<form id="filterForm">
    <select name="category" id="category">
        <option value="electronics">电子产品</option>
        <option value="clothing">服装</option>
    </select>
    <input type="range" name="price_range" id="price_range" min="0" max="1000" step="10">
</form>
<div id="result"></div>

<script>
document.getElementById('filterForm').addEventListener('submit', function(event) {
    event.preventDefault();
    var formData = new FormData(this);
    fetch('/filter', {
        method: 'POST',
        body: formData
    })
    .then(response => response.json())
    .then(data => {
        var resultDiv = document.getElementById('result');
        resultDiv.innerHTML = '';
        data.forEach(item => {
            var div = document.createElement('div');
            div.textContent = item.name + ' - ' + item.price;
            resultDiv.appendChild(div);
        });
    });
});
</script>