Send values to db when multiple checkboxes are checked

Question

I am loading some data from a db table to checkboxes. When a user checks boxes and submits, the values from these checkboxes need to be added to a different table. With the code I have now, I am able to send values of one checked box. What am I missing in sending the values of all the checked checkboxes?

<table>
    <?php       
    $q5=mysqli_query($link,"SELECT * FROM brands_offer WHERE Brand_Id='$bid' AND Published='1' ");
    while($row5 = mysqli_fetch_array($q5)){
        $catid= $row5['Catg_Id'];
        $subcatid= $row5['Subcatg_Id'];
        $pid= $row5['Product_Id'];      
    ?><tr><td>
    <form action="store-admin.php?search=<?php echo $stname;?>#stock" method="post">
    <input type="checkbox" name="checkbox" value="<?php echo "$bname,$catid,$subcatid,$pid";?>" >
    <?php
        echo $bname;
        echo " ->  ";
        echo $catid;
        echo ",  ";
        echo $subcatid;
        echo ",  ";
        echo $pid;
        echo "  ";
    }
    ?></td></tr>
    <input type="submit" value="Save Changes" name="add" >
    </form>
    </table>
    <?php
    if(isset($_POST['add']))
    {
    $chk = $_POST['checkbox'];

    $val = explode(",",$chk);
    $bn = $val[0];
    $cid= $val[1];
    $scid= $val[2];
    $prid= $val[3];

    echo "<script type='text/javascript'>alert('brand: ". $bn."')</script>";
    echo "<script type='text/javascript'>alert('cat: ". $cid."')</script>";
    echo "<script type='text/javascript'>alert('sub: ". $scid."')</script>";
    echo "<script type='text/javascript'>alert('pr: ". $prid."')</script>";

    }?>

TheDrot · Accepted Answer · 2016-05-12 00:01:50Z

1

Use brackets in your checkbox name attribute name="checkbox[]" and your post variable will be an array of selected values.

Edit: I noticed you have form opening tag inside the while loop. You need to put it before while loop otherwise its generating tons of opening form tags.

edited May 12, 2016 at 0:01

answered May 11, 2016 at 23:51

TheDrot

4,3381 gold badge18 silver badges26 bronze badges

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

7 Comments

Yohan Blake Over a year ago

just name="checkbox[]" would suffice? no need to change in the if(isset where I'm getting the values?

TheDrot Over a year ago

@YohanBlake Yes no need to change, only thing you need is obviously loop the post variable to get all values.

Yohan Blake Over a year ago

yes, I tried including the POST code in the while loop, but it didn't work. How do I loop the POST variable?

TheDrot Over a year ago

@YohanBlake Look at updated answer and also show how you are looping POST variable.

Yohan Blake Over a year ago

okay I added the form open before the while loop and did name="checkbox[]" , now I'm not getting any values into the POST. I'm not sure how to loop the POST variable

|

Allen Butler · Accepted Answer · 2016-05-11 23:54:05Z

0

So it looks like you have only one checkbox. If you want to POST the values of all the checkboxes as an array I believe you need to add [] to the name of your input field. So:

<input type="checkbox" name="checkbox[]" value="<?php echo "$bname";?>"/>
<input type="checkbox" name="checkbox[]" value="<?php echo "$catid";?>"/>
<input type="checkbox" name="checkbox[]" value="<?php echo "$subcatid";?>"/>
<input type="checkbox" name="checkbox[]" value="<?php echo "$pid";?>"/>

Hopefully I understood your question.

answered May 11, 2016 at 23:54

Allen Butler

3123 silver badges12 bronze badges

8 Comments

Yohan Blake Over a year ago

just name="checkbox[]" would suffice? no need to change in the if(isset where I'm getting the values?

Allen Butler Over a year ago

@YohanBlake Not from what I can see. You override the post parameter when you use the same name for multiple input fields unless you append [] to the name. This loads the POST parameters as an "array" instead of "normal" key:value pairs.

TheDrot Over a year ago

He has multiple checkboxes generating through while loop.

Allen Butler Over a year ago

Ah nice, didn't see that.

Allen Butler Over a year ago

@YohanBlake, TheDrot commented first and his answer should suffice to be marked as correct.

|

Collectives™ on Stack Overflow

Send values to db when multiple checkboxes are checked

2 Answers 2

7 Comments

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related