Filter With Checkbox Using Jquery

(1) SQL> create  database  test;

(2)create table   product:

CREATE TABLE IF NOT EXISTS `product` (
  `id` int(25) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  `products` varchar(250) NOT NULL,
  `brand` varchar(250) NOT NULL,
  `price` varchar(250) NOT NULL,
  `color` varchar(250) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=55 ;

insert  some values...
(3)write file  php database connectivity code for  config.php file:

<?php
$connection = mysql_connect('localhost', 'root','');
$db = mysql_select_db('test', $connection);
?>

(4)write code for  main.php  file:

<html>
<head>

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script>
$(document).ready(function(){

$('.ids').on('change',function(){ //on checkboxes check

//sending checkbox value into serialize form

var hi=$('.ids:checked').serialize();
 if(hi){

$.ajax({
type: "POST",
cache: false,
url: "filter.php",
data:{brandss:hi},
success: function(response){
document.getElementById('getdata').style.display = "block";
document.getElementById("getdata").innerHTML = response;
$('#result').hide();
}
});
}
else
{
document.getElementById('getdata').style.display = "none";
$('#result').show();
}
});
});
</script>
<style>
#frm
{
width:150px;
float:left;
}
#result
{
border:2px dotted #ededed;
height:auto;
width:350px;
}
h3
{
border-bottom:2px solid;
}
</style>
</head>
<body>
<div id="frm" >
<form method="POST">
 <ul class="filter">
 <h4>Filter By Brand</h4>
   <?php
 include("config.php");
 $sql = mysql_query("SELECT * FROM `product` GROUP BY `brand`");

  while($rows=mysql_fetch_array($sql))
  {
  ?>

<label><?php echo $rows['brand'];?></label><input type="checkbox" name="ids[]" value="<?php echo $rows['brand'];?>" id="<?php echo $rows['id'];?>" class="ids"/><br>
 <?php }
 ?>
   </ul>

</form>
</div>
 <center> <div id="result">
 <h3>Search Results</h3>
  <?php
$sql = mysql_query("SELECT * FROM product");
while($rows=mysql_fetch_array($sql)){
?>
  <?php echo $rows['name']."<br>";  ?>
<?php
  }
 ?>
 </div><div id="getdata" style="border:2px dotted #ededed;height:auto;width:350px;"></div>
</center>
</body>
</html>

(4)write code for filter.php   file:

<h3 style="border-bottom:2px solid;">Search Results</h3>
<?php
include('config.php');

if($_POST['brandss']){

//unserialize to jquery serialize variable value
$brandis=array();

parse_str($_POST['brandss'],$brandis); //changing string into array 

//split 1st array elements
foreach($brandis as $ids)
{
$ids;
}
$brandii=implode("','",$ids); //change into comma separated value to sub array
echo "<br>";
$sql = mysql_query("SELECT * FROM product WHERE brand IN ('$brandii')");
while($rows=mysql_fetch_array($sql)){
?>
  <?php echo $rows['name']."<br>";  ?>
<?php
  }
  }
  ?>
Previous
Next Post »

1 comments:

Write comments
Garima Ahuja
AUTHOR
23 October 2017 at 01:44 delete

informative blog
we are also provide web development services please check this link https://sisgain.com/angular-js-development

Reply
avatar