我正在做购物车。我想发生的是,当我单击一个类别时,将根据其类别ID显示其下的所有产品。如果还有其他方法,请告诉我。
我使用以下方法从数据库中获取类别:
function getCats(){
global $con;
$get_cats = "select * from categories";
$run_cats = mysqli_query($con, $get_cats);
while ($row_cats = mysqli_fetch_array($run_cats)){
$cat_id = $row_cats['cat_id'];
$cat_title = $row_cats['cat_title'];
echo "<li><a href='#' class= 'category' cid='$cat_id'>$cat_title</a></li>";
}
}
并在我的index.php中调用它
<?php
getPro();
?;
这是我在functions.php中的代码
if(isset($_POST["get_product"]))
{
$cid = $_POST["cat_id"];
$sql = "SELECT * from products WHERE product_cat = '$cid'";
$run_query = mysqli_query($con,$query) or die(mysqli_query($con));
while($row = mysqli_fetch_array($run_query))
{
$pro_id = $row['product_id'];
$pro_title = $row['product_title'];
$pro_cat = $row['product_cat'];
$pro_price = $row['product_price'];
$pro_image = $row['product_image'];
echo"
<div class='col-md-4'>
<div class='panel panel-info'>
<div class='panel-heading'>$pro_title </div>
<div class='panel-body'>
<img src='admin_area/product_images/$pro_image' style='width:100px; height:100px;'/>
</div>
<div class='panel-heading'>$pro_price
<button pid='$pro_id' style='float:right;' class='btn btn-danger btn-xs'>Add to cart</button>
</div>
</div>
</div>
";
}
}
最佳答案
因此,基本上,您是每个类别的按钮,当您单击它时,它将显示一个带有产品的小菜单,按ID排序。我知道这可以通过下拉菜单完成。此仅由CSS制成。如果您弄错了,我很抱歉,但是请具体说明您想要的内容。
<style>
.dropdown {
position: relative;
display: inline-block;`enter code here`
}
.dropdown-content {
display: none;
position: absolute;
background-color: #f9f9f9;
min-width: 160px;
box-shadow: 0px 8px 16px 0px rgba(0,0,0,0.2);
padding: 12px 16px;
z-index: 1;
}
.dropdown:hover .dropdown-content {
display: block;
}
</style>
<div class="dropdown">
<span>Mouse over me</span>
<div class="dropdown-content">
<p>Hello World!</p>
</div>
</div>