Skip to main content

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 ;
(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
  }
  }
  ?>

Comments

Post a Comment

Popular posts from this blog

XSLT QUICK GUIDE

E X tensible  S tylesheet  L anguage  T ransformation commonly known as XSLT is a way to transform the XML document into other formats such as XHTML. XSL Before learning XSLT, we should first understand XSL which stands for E X tensible  S tylesheet  L anguage. It is similar to XML as CSS is to HTML. Need for XSL In case of HTML document, tags are predefined such as table, div, and span; and the browser knows how to add style to them and display those using CSS styles. But in case of XML documents, tags are not predefined. In order to understand and style an XML document, World Wide Web Consortium (W3C) developed XSL which can act as XML based Stylesheet Language. An XSL document specifies how a browser should render an XML document. Following are the main parts of XSL − ·          XSLT  − used to transform XML document into various other types of document. ·       ...
8 comments
Read more

Important Javascript and Jquery Code for web development

Important  Javascript and Jquery  Code for web development: (1)how to make multiple preview of single  image: http://phpdevelopmenttricks.blogspot.in/2017/01/how-to-make-multiple-preview-of-single.html (2)javascript code  for confirmation before delte and update:  http://phpdevelopmenttricks.blogspot.in/2016/12/javascript-code-for-confirmation-before.html (3)how to pass image file  with text to php using Ajax: http://phpdevelopmenttricks.blogspot.in/2016/12/how-to-pass-image-file-with-text-to-php.html (4)how to preview  form entered  value  in text: http://phpdevelopmenttricks.blogspot.in/2016/12/preview-form-entered-value-in-text.html (5)Drag and Drop  file  upload  : http://phpdevelopmenttricks.blogspot.in/2016/12/drag-and-drop-file-upload-using.html (6)write jquery code for image preview as well as uploading of image with php code: http://phpdevelopmenttricks.blogspot.in/2017/...
7 comments
Read more

Javascript countdown-timer-reloading-again-on-refreshing page

(1)write code  timer.html  file: <html> <head> <title> timer example by om sir</title> </head> <body> <div id="divCounter"></div> <script> var hoursleft = 0; var minutesleft = 35; var secondsleft = 0; var finishedtext = "Countdown finished!"; var end; if(localStorage.getItem("end")) {     end = new Date(localStorage.getItem("end")); } else {     end = new Date();     end.setMinutes(end.getMinutes()+minutesleft);     end.setSeconds(end.getSeconds()+secondsleft); } var counter = function () {     var now = new Date();     var diff = end - now;     diff = new Date(diff);     var sec = diff.getSeconds();     var min = diff.getMinutes();     if (min < 10) {         min = "0" + min;     }     if (sec < 10) {         sec = "0" + sec; ...
1 comment
Read more