how to compare mutiple checkbox values in sql using php?

Question

      $Brand=$_POST['Brand'];
         if(isset($_POST['Brand']))
          {
          $Brand = implode(",", $_POST['Brand']);   
           } else {
            $Brand = "";
          }
       echo "brands are :" .$Brand;
       echo "<br>";
       $sql2= "SELECT * FROM brand_master1 WHERE brand_name in ('$Brand')";
       $result2 = mysql_query($sql2);
       $row = mysql_fetch_array($result2,MYSQL_BOTH);
       $bid=$row['id'];
       echo "brand id is:";      
        print_r($bid);

in the below code am trying to get ids of brands by giving brand values to the query.... but it is giving only single id.... please anyone help me... my tables are... brand_master1(id,brand_name)

score 0 · Answer 1 · edited May 23 '17 at 12:13

0

Try this $Brand = implode("','", $_POST['Brand']);

if(isset($_POST['Brand']))
      {
      $Brand = implode("','", $_POST['Brand']);   
       } else {
        $Brand = "";
      }
   echo "brands are :" .$Brand;
   echo "<br>";
   $sql2= "SELECT * FROM brand_master1 WHERE brand_name in ('$Brand')";

Note this line of code "','"

it is not only appending the elements with , comma but also with ' single quotes

Now what will be the output of this

brand_name in ('$Brand')"

OUTPUT

brand_name in ('a','b','c')

But in your case it was

brand_name in ('a,b,c')

WARNING

Also mysql_* functions are deprecated you must have to look at this Why shouldn't I use mysql_* functions in PHP?

edited May 23 '17 at 12:13

Community

1
1

answered Mar 11 '14 at 06:08

zzlalani

22,960
16
44
73

for that code the out put is like this.. brands are :Thumsup','Pepsi','Coke – siri Mar 11 '14 at 06:48
no you also need to give the `'` to brand variable `('$Brand')"` – zzlalani Mar 11 '14 at 07:11
ya i already gave... but it is giving only single value... which value is first in the list – siri Mar 11 '14 at 07:24

how to compare mutiple checkbox values in sql using php?

1 Answers1