个人中心
gpt4 book ai didi

javascript - 如何使用 PHP、AJAX 和 JS 的复选框来过滤类似产品？

转载 作者：行者123 更新时间：2023-11-29 12:05:09 24 4
gpt4 key购买 nike

这是我想要实现的目标的图像 - enter image description here

我的数据库表示例 - enter image description here

我的目标是在不刷新页面的情况下获得与当前显示的产品类似的产品。我试图通过使用复选框来查找类似的产品。

我首先使用 $_GET['id'] 获取 id，它应该等于我表中的值之一。

然后，我使用 PDO Fetch 获取该特定 ID 的产品名称、品牌、数量和价格，并将其存储为字符串。

我需要帮助的是使用 JQuery/AJAX 获取选中的复选框，然后将信息发送到 PHP 文件，该文件将检查过滤器结果是否与表中的任何数据匹配。

我该怎么做？

这是我的product.php 文件

 <?php
    require ('includes/db.php');

    $id = $_GET['id']; //Getting the ID in URL. ex products.php?id=12

    $stmt = $handler->prepare("SELECT * FROM products WHERE id = '$id' ");
    $result = $stmt->execute(array());
    $products   = $stmt->fetch(PDO::FETCH_ASSOC);

    $prod_name = $products['prod_name']; //Product Name

    $brand = $products['brand']; //Product Brand
    $quantity = $products['quantity']; //Product Quantity
    $calories = $products['calories'];  //Product Calories
    $price = $products['price'];    //Product Price


?>

    <!DOCTYPE html>
     <html>
    <head>
        <title><?php echo "$brand $prod_name"; ?></title>
    </head>

    <body>
        <h1><?php echo $prod_name; ?></h1>
        <br />

        <p>Brand = <?php echo " $brand"; ?></p>
        <p>Quantity = <?php echo " $quantity"; ?></p>
        <p>Calories = <?php echo " $calories"; ?></p>
        <p>Price = <?php echo " $price"; ?></p>

        <br />

        <p style="text-align: center;">Find Similar Products</p>

        <form> 
        <div class="checkboxes">
            <label>
                <input name="brand" type="checkbox" value="<?php echo $brand; ?>">
                <span>Brand</span> <!--Brand Checkbox-->
            </label>
        </div>
        <div class="checkboxes">
            <label>
                <input name="quanitity" type="checkbox" value="<?php echo $quantity; ?>">
                <span>Quantity</span> <!--Quantity Checkbox-->
            </label>
        </div>
        <div class="checkboxes">
            <label>
                <input name="calories" type="checkbox" value="<?php echo $calories; ?>">
                <span>Calories</span> <!--Calories Checkbox-->
            </label>
        </div>
        <div class="checkboxes">
            <label>
                <input name="price" type="checkbox" value="<?php echo $price; ?>">
                <span>Price</span>  <!--Price Checkbox-->
            </label>
        </div>
    </form>

    </body>
</html>

最佳答案

我设法解决了这个问题，很高兴我没有放弃。

我的product.php文件

<?php
require ('/db.php');

$id = $_GET['id']; //Getting the ID in URL. ex products.php?id=12

$stmt = $handler->prepare("SELECT * FROM products WHERE id = '$id' ");
$result = $stmt->execute(array());
$products   = $stmt->fetch(PDO::FETCH_ASSOC);

$prod_name = $products['prod_name']; //Product Name

$brand = $products['brand']; //Product Brand
$quantity = $products['quantity']; //Product Quantity
$calories = $products['calories'];  //Product Calories
$price = $products['price'];    //Product Price


?>

<!DOCTYPE html>
 <html>
<head>
    <title><?php echo "$brand $prod_name"; ?></title>
</head>

<body>
    <h1><?php echo $prod_name; ?></h1>
    <br />

    <p>Brand = <?php echo " $brand"; ?></p>
    <p>Quantity = <?php echo " $quantity"; ?></p>
    <p>Calories = <?php echo " $calories"; ?></p>
    <p>Price = <?php echo " $price"; ?></p>

    <br />

    <p style="text-align: center;">Find Similar Products</p>

    <form method="post" action=""> 
    <div class="checkboxes">
        <label>
            <input name="brand" type="checkbox" value="<?php echo $brand; ?>">
            <span>Brand</span> <!--Brand Checkbox-->
        </label>
    </div>
    <div class="checkboxes">
        <label>
            <input name="quanitity" type="checkbox" value="<?php echo $quantity; ?>">
            <span>Quantity</span> <!--Quantity Checkbox-->
        </label>
    </div>
    <div class="checkboxes">
        <label>
            <input name="calories" type="checkbox" value="<?php echo $calories; ?>">
            <span>Calories</span> <!--Calories Checkbox-->
        </label>
    </div>
    <div class="checkboxes">
        <label>
            <input name="price" type="checkbox" value="<?php echo $price; ?>">
            <span>Price</span>  <!--Price Checkbox-->
        </label>
    </div>
</form>
<div class="filter_container">

    <div style="clear:both;"></div>
</div>
<script type="text/javascript" src="/js/filter.js"></script>

<input name="prod_name" value="<?php echo $prod_name ?>" style="display:none;"/>
<!--Hidden product name-->
</body>
</html>

这是我的 JS 文件

$(document).ready(function() {
function showValues() {


    var brand;  
    var quantity;   
    var calories;       
    var price;      

    //Gets product name
    var prod_name = $('input[name="prod_name"]').val(); 

    //Gets brand
    if($('input[name="brand"]').is(':checked')) 
        {brand = $('input[name="brand"]').val();} else {brand = ""}

    //Gets quantity
    if($('input[name="quantity"]').is(':checked')) 
        {quantity = $('input[name="quantity"]').val();} else {quantity = ""}

    //Gets calories
    if($('input[name="calories"]').is(':checked')) 
        {calories = $('input[name="calories"]').val();} else {calories = ""}

    //Gets price
    if($('input[name="price"]').is(':checked'))  
        {price = $('input[name="price"]').val();} else {price = ""}


        $.ajax({
        type: "POST",
        url: "/query.php",
        data: {'brand':brand, 'quantity':quantity, 'calories':calories, 'prod_name':prod_name}, 
        cache: false,
        success: function(data){
            $('.filter_container').html(data)
                }
            });


}

//Call function when checkbox is clicked
$("input[type='checkbox']").on( "click", showValues );

//Remove checked when checkbox is checked
$(".checkboxes").click(function(){
    $(this).removeAttr('checked');      
    showValues();
});
});

这是我的 PHP 文件

<?php
include('/db.php');

$prod_name = $_POST['prod_name'];

$Cbrand = $_POST['brand'];
$Cquantity = $_POST['quantity'];
$Ccalories = $_POST['calories'];
$Cprice = $_POST['price'];


if(!empty($Cbrand))
{
    $data1 = "brand = '$Cbrand' AND";
}else{
    $data1 = "";
}
if(!empty($Cquantity))
{
    $data2 = "quantity = '$Cquantity' AND";
}else{
    $data2 = "";
}
if(!empty($Ccalories))
{
    $data3 = "calories = '$Ccalories' AND";
}else{
    $data3 = "";
}
if(!empty($Cprice))
{
    $data4 = "price = '$Cprice'";
}else{
    $data4 = "";
}


$main_string = "WHERE $data1 $data2 $data3 $data4"; //All details

$stringAnd = "AND"; //And

$main_string = trim($main_string); //Remove whitespaces from the beginning and end of the main string

$endAnd = substr($main_string, -3); //Gets the AND at the end

if($stringAnd == $endAnd)
{
$main_string = substr($main_string, 0, -3);
}else if($main_string == "WHERE"){
    $main_string = "";
}
else{
    $main_string = "WHERE $data1 $data2 $data3 $data4";
}

if($main_string == ""){ //Doesn't show all the products

}else{

$sql = "SELECT COUNT(*) FROM products $main_string";

if ($res = $handler->query($sql)) {

/* Check the number of rows that match the SELECT statement */
if ($res->fetchColumn() > 0) {
  $sql = "SELECT * FROM products $main_string";
foreach ($handler->query($sql) as $pro) {

if(($pro['prod_name'] == $prod_name) && ($res->fetchColumn() < 2))
{
    //The product currently being displayed is blank when using the filter
}
else{
    ?>

    <!------------------------------------------------------------------------------------------------------------------------------------------------->    

    <div class="form-result">
        <td><?=strtoupper($pro['brand']) + " " + strtoupper($pro['prod_name']); ?></td>
    </div>

    <!------------------------------------------------------------------------------------------------------------------------------------------------->


    <?php
}
}
}    /* No rows matched -- do something else */
    else {
        ?>
        <div align="center"><h2 style="font-family:'Arial Black', Gadget, sans-serif;font-size:30px;color:#0099FF;">No Results with this filter</h2></div>
        <?php
        }
    }
}
$handler = null;
$res = null;
?>

关于javascript - 如何使用 PHP、AJAX 和 JS 的复选框来过滤类似产品？，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/31627874/

24 4 0
文章推荐： sql - 控制到达功能结束而没有 RETURN
文章推荐： postgresql - 如何计算销售成本
文章推荐： sql - 编写一个 SQL 触发器来比较旧值和新值
文章推荐： ios - 测试时 Xamarin iOS UIButton 图像未显示在设备上
行者123
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
全站热门文章
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com