Database Search with multiple parameters

Question

Im using the folowing to search a database :

   <script type="text/javascript">
      $(function() {
        $("#lets_search").bind('submit',function() {
          var cat1 = $('#cat1').val();
           $.post('db.php',{cat1:cat1}, function(data){
             $("#search_results").html(data);
           });
           return false;
        });
      });
    </script>

cat1 is the id of a drop down box. I want to add another drop down box so that the query would be :

SELECT * 
  FROM business
  WHERE category='".$_POST['cat1']."' and subcategory='".$_POST['cat2']."'

I cant seem to get the javascript to work with more than one drop down. I have tried this , but it didnt work.

<script type="text/javascript">
  $(function() {
    $("#lets_search").bind('submit',function() {
      var cat1 = $('#cat1').val();
       var cat2 = $('#cat2').val();
       $.post('db.php',{cat1:cat1},{cat2:cat2}, function(data){
         $("#search_results").html(data);
       });
       return false;
    });
  });
</script>

Sougata Bose · Accepted Answer · 2015-05-08 09:35:20Z

2

You are constructing the data in wrong wya. Try with -

$.post('db.php',{cat1:cat1,cat2:cat2}, function(data){ ...

answered May 8, 2015 at 9:35

Sougata Bose

31.8k8 gold badges52 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Sunil Pachlangia Over a year ago

Enough in comment also.No need of answer

Jess Over a year ago

Thanks. Ill make this the right answer when it lets me

Sougata Bose Over a year ago

@SunilPachlangia know that but according to - meta.stackoverflow.com/questions/271229/…. gave the answer.

Sunil Pachlangia Over a year ago

Its just a question we should follow help center's guide line

Sachin I · Accepted Answer · 2015-05-08 09:47:30Z

0

You can rewrite your function in more secure way by serializing the form if you have multiple elements to send.

Blockquote $.post('db.php',$('#form').serialize(), function(data){ ...});

answered May 8, 2015 at 9:47

Sachin I

1,5163 gold badges10 silver badges29 bronze badges

Collectives™ on Stack Overflow

Database Search with multiple parameters

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related