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, Apr 10 '14 at 10:58

Fisherman · Accepted Answer · 2014-04-10T11:57:50.257

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 '14 at 11:57

answered Apr 10 '14 at 11:03

Fisherman

5,949
1
29
35

thanks but my questions is for the case when multiple checkboxes are selected. – user3478137 Apr 10 '14 at 11:10
can you give your html for checkbox ? – Fisherman Apr 10 '14 at 11:11
Here it is:
5 Star 4 Star 3 Star 2 Star Less than 2 Star
– user3478137 Apr 10 '14 at 11:42

score 1 · Answer 2 · answered Apr 10 '14 at 11:17

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.
    }
}

score 0 · Answer 3 · answered Apr 10 '14 at 11:00

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 '14 at 11:00

Arsen Ibragimov

425
4
18

but what when multiple checkboxes are selected.for example there are 10 checkboxes: 1,2,3....10. – user3478137 Apr 10 '14 at 11:11

score 0 · Answer 4 · edited May 23 '17 at 12:06

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...
}
...

Dynamically Creating mysql select Query

5 Answers5

Linked