多个复选框过滤器 [英] Multiple checkbox filter

问题描述

我试图过滤产品搜索。但不工作我从后端检索数据。

在我的代码下面我尝试了什么。



我尝试了什么：



产品展示：

 <   div     class   = 位置相对filter_product结果 >  
 <？ php 
  $ sql  =   SELECT * FROM wm_products; 
  $ result  = $ conn-> query（$ sql）; 
 if（$ result-> num_rows> 0）{
 while（$ row = $ result-> fetch_assoc（））{
  ？>  
 <！ -    启动团队项目   - >   
 <  < span class =code-leadattribute> div     class   =  col-md-4 padding-15px-lr team-block text-left team-style-1 md-margin-70px-bottom wow fadeInUp  >  
 <   div     class   =  agileinfo_new_products_grid >  
 <   div     class   =  agile_ecommerce_tab_left agileinfo_new_products_grid1 >  
 <   div     class   =  hs -wrapper hs-wrapper1 >  
 <   img     src   =  products_images /<？php echo $ row ['pro_img']; ？>    alt   =     class   =  img-responsive    /  >  
 <   img     src   =  products_images /<？php echo $ row ['pro_img']; ？>    alt   =     class   =  img-responsive    /  >  
 
 <   div     class   =  w3_hs_bottom w3_hs_bottom_sub >  
 <   ul  >  
 <   li  >  
 <   a     href   =     class   =  prod_detail    data-toggle   =  modal    data-target   = ＃product_popup    dataid   = < ;？php echo $ row ['pro_id']; ？> >  
 <   span     class   =   glyphicon glyphicon-eye-open    aria -hidden   =  true >  <   / span  >  
 <   / a  >  
 <   / li   >  
 <   / ul  >  
 <   / div  >  
 <   / div  >  
 <   p     class   =   product-name >  <   a     href   = ＃。 >  <？ php  echo  $ row ['  pro_name']; ？>  <   / a  < span class =code-keyword>>  <   / p  >  
 <   div     class   =  simpleCart_shelfItem >  
 <   p  >   Rs。 <？ php  echo  $ row ['  pro_price']; ？>    <   / p  >  
 <   p  >  < ;   a     href  < span class =code-keyword> =     class   =  button add_to_cart_button    dataid   = <？php echo $ row ['pro_id']; ？> > 添加到购物车<   / a  >  <   / p  >  
 <   / div  >  
 <   / div  >  
 <   / div  >  
 <  < span class =code-leadattribute> / div  >  
 <！ -   结束团队项目   - >   
 <？ php 
} 
} 
 ？>  
 <   / div  >  

过滤类别

< ul class =list- style-6 margin-50px-bottom text-small tags> 
<？php 
 $ query = mysqli_query（$ conn，SELECT * FROM wm_occasion ORDER BY occasion_name ASC）; 
 if（mysqli_num_rows（$ query）> 0）{
 while（$ row = mysqli_fetch_assoc（$ query））{
？> 
< li> 
< input type =checkboxname =<？php echo $ row [occasion_id];？> value =<？php echo $ row [occasion_id];？> dataid =<？php echo $ row [occasion_id];？> class =filter_occasionid =<？php echo $ row [occasion_id];？>>< label for =<？php echo $ row [occasion_id];？> ><？php echo $ row ['occasion_name']; ？>< /标签> 
 
< / li> 
<？php 
} 
} 
？> 
< / ul> 

这里我的js要过滤

 $（document）.ready（function （）{
 $（'ul.tags'）。find（'input：checkbox'）。live（'click'，function（）{
 if（$（this）.prop（checked ））{
 $（'。results> div'）。toggle（'show'）; 
 $（'ul.tags'）。find（'input：checked'）。each（ function（）{
 $（'。results> div。'+ $（this）.attr（'rel'））。toggle（'show'）; 
}）; 
 } else {
 $（'。results> div'）。show（）; 
} 
}）; 
}）; 

解决方案

sql = SELECT * FROM wm_products;

result =

conn-> query（

Hi, i trying to filter for product search. But not working i retrive data from backend.
Below my code what i tryed.

What I have tried:

Product show:

<div class="position-relative filter_product results">                        
	<?php
	$sql = "SELECT * FROM wm_products";
	$result = $conn->query($sql);
	if($result->num_rows > 0){
		while($row = $result->fetch_assoc()){
			?>
			<!-- start team item -->
			<div class="col-md-4 padding-15px-lr team-block text-left team-style-1 md-margin-70px-bottom wow fadeInUp">
				<div class="agileinfo_new_products_grid">
					<div class="agile_ecommerce_tab_left agileinfo_new_products_grid1">
						<div class="hs-wrapper hs-wrapper1">
							<img src="products_images/<?php echo $row['pro_img']; ?>" alt=" " class="img-responsive" />
							<img src="products_images/<?php echo $row['pro_img']; ?>" alt=" " class="img-responsive" />
							
							<div class="w3_hs_bottom w3_hs_bottom_sub">
								<ul>
									<li>										
										<a href="" class="prod_detail" data-toggle="modal" data-target="#product_popup" dataid="<?php echo $row['pro_id']; ?>">
										<span class="glyphicon glyphicon-eye-open" aria-hidden="true"></span>
										</a>
									</li>
								</ul>
							</div>
						</div>
						<p class="product-name"><a href="#."><?php echo $row['pro_name']; ?></a></p>
						<div class="simpleCart_shelfItem">
							<p>Rs. <?php echo $row['pro_price'];?></p>
							<p><a href="" class="button add_to_cart_button" dataid="<?php echo $row['pro_id']; ?>"> Add to cart</a></p>
						</div>
					</div>
				</div>
			</div>
			<!-- end team item -->  
			<?php
		}
	}
	?>                           
</div>

Category to filter

<ul class="list-style-6 margin-50px-bottom text-small tags">
    <?php 									
	$query=mysqli_query($conn,"SELECT * FROM wm_occasion ORDER BY occasion_name ASC");
	if(mysqli_num_rows($query) > 0){
		while($row = mysqli_fetch_assoc($query)){
			?>
			<li>			
				<input type="checkbox" name="<?php echo $row["occasion_id"];?>" value="<?php echo $row["occasion_id"];?>" dataid="<?php echo $row["occasion_id"];?>" class="filter_occasion"  id="<?php echo $row["occasion_id"];?>"><label for="<?php echo $row["occasion_id"];?>"><?php echo $row['occasion_name']; ?></label>
			
			</li>
			<?php 
		}
	}
	?>								
</ul> 

here my js to filter

$(document).ready(function () {
	$('ul.tags').find('input:checkbox').live('click', function () {
		if ($(this).prop("checked")) {
			$('.results > div').toggle('show');
			$('ul.tags').find('input:checked').each(function () {
				$('.results > div.' + $(this).attr('rel')).toggle('show');
			});
		} else{
			$('.results > div').show();
		}
	});
}); 

解决方案

sql = "SELECT * FROM wm_products";

result =

conn->query(

这篇关于多个复选框过滤器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！