Dynamically Creating mysql select Query

Question

I have multiple checkboxes in my websites: checkbox 1 checkbox 2 checkbox 3 etc.

I want to dynamically generate mysql query based on the above checkboxes.

i:e if 1st checkbox is selected then the query should be:

$mysql="Select * from mytable where colname=" . $checkbox1 .;

if 1st and 2nd checkbox is selected then the query should be:

$mysql="Select * from mytable where colname=" . $checkbox1 ."AND colname=" . $checkbox2 ." ;

if all are selected then it should be :

$mysql="Select * from mytable where colname=" . $checkbox1 . "AND colname=" . $checkbox2 ."AND colname=" . $checkbox3 .  ;

Can someone pls help:

you've pretty much got it all figured out. now you just have to write it! — r3wt
– r3wt, Commented Apr 10, 2014 at 10:58

Fisherman · Accepted Answer · 2014-04-10 11:57:50Z

1

you have to change your form like follow because its taking multiple value its should be post as an array

<form action="register.php" method="POST"> 
  <input type="checkbox" name="rating[]" value="5">5 Star 
  <input type="checkbox" name="rating[]" value="4">4 Star 
  <input type="checkbox" name="rating[]" value="3">3 Star 
  <input type="checkbox" name="rating[]" value="2">2 Star 
  <input type="checkbox" name="rating[]" value="1">Less than 2 Star 
</form>

Then in php

  $where = '';
   if(isset($_POST['rating'])){
     $data = implode(',',$_POST['rating']); // beacuse your rating is only one column in db i think
     $where = "WHERE cloumn_name IN($data)";
   }
  $query = "SELECT * FROM your_table $where";

edited Apr 10, 2014 at 11:57

answered Apr 10, 2014 at 11:03

Fisherman

6,1311 gold badge33 silver badges37 bronze badges

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

3 Comments

user3478137 Over a year ago

thanks but my questions is for the case when multiple checkboxes are selected.

Fisherman Over a year ago

can you give your html for checkbox ?

user3478137 Over a year ago

Here it is: <form action="register.php" method="POST"> <input type="checkbox" name="rating" value="5">5 Star <input type="checkbox" name="rating" value="4">4 Star <input type="checkbox" name="rating" value="3">3 Star <input type="checkbox" name="rating" value="2">2 Star <input type="checkbox" name="rating" value="1">Less than 2 Star </form>

r3wt · Accepted Answer · 2014-04-10 11:17:15Z

You can use string concatenation with a bit of trickery to get the job done. do not rely on isset, instead use !empty.

<form action="example.php" method="post">
    <input type="checkbox" name="Col1" value="colname" />Col 1</br>
    <input type="checkbox" name="Col2" value="colname" />Col 2</br>
    <input type="checkbox" name="Col3" value="colname" />Col 3</br>
</form>
<?php
if(!empty($_POST)) {
    $string = '';
    if(!empty($_POST['col1'])) {

        $string.= "column1 ='".$_POST['col1']."'";
    }   
    if(!empty($_POST['col2'])){

        if(!empty($string)) {

            $string.=" AND ";

        } 
        $string.= "column2 ='".$_POST['col2']."'";

    }
    if(!empty($_POST['col3'])){
        if(!empty($string)) {

            $string.=" AND ";

        } 

        $string .= "column3 ='".$_POST['col3']."'";
    }

    if(!empty($string)) 
    {
        //execute your query here.
    }
}

Arsen Ibragimov · Accepted Answer · 2014-04-10 11:00:43Z

0

Something about it

<? if ($_POST[option]==1) { 
      //query 
   } 
?>

<form method="post">
   <input type="checkbox" name="option" value="1">1
   <input type="checkbox" name="option" value="2">2
   <input type="checkbox" name="option" value="3">3
</form>

answered Apr 10, 2014 at 11:00

Arsen Ibragimov

4354 silver badges21 bronze badges

1 Comment

user3478137 Over a year ago

but what when multiple checkboxes are selected.for example there are 10 checkboxes: 1,2,3....10.

Community · Accepted Answer · 2017-05-23 12:06:20Z

0

Just check if your Checkboxes are selcted via (isset($_POST[checkbox1]))

So you could do something like

if (isset($_POST[checkbox1])
{
//statement
}
else if (isset($_POST[checkbox2])
{
//statement2...
}
...

Comments

Strawberry · Accepted Answer · 2014-04-10 12:42:56Z

0

It should be apparent from the code provided below that I'm certainly no PHP coder. But anyway, here's an idea to think about...

Try it with different values for input between 0 and 127, e.g. ?input=66

<?php

if(isset($_GET['input'])){

   $input = $_GET['input'];

   }else{

   $input=0;
}

$days = array('mon', 'tue', 'wed', 'thu', 'fri', 'sat', 'sun');

for( $i=0; $i<7; $i++ ) {
    $daybit = pow(2,$i);
    if( $input & $daybit ) {
        echo "<input type = checkbox checked/>$days[$i]";
    }else{
        echo "<input type = checkbox>$days[$i]";
}
}
?>

answered Apr 10, 2014 at 12:42

Strawberry

34k14 gold badges43 silver badges57 bronze badges

Collectives™ on Stack Overflow

Dynamically Creating mysql select Query

5 Answers 5

3 Comments

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

3 Comments

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related