Mysql fetch data selection from html checkbox

Question

I want to get multiple return value for checkbox. But problem is with following code check box only can echo a single value. Even I select multiple checkbox I am getting only single value form it. How to solve it

$q2 = mysqli_query($conn,"SELECT product_img_url FROM temp_img");

while ($row = mysqli_fetch_array($q2)) {
    $product_img_url = $row['product_img_url'];
    $target_dir = "../assets/img/temp_img/";
    $img_link = $target_dir.$product_img_url;

    echo '<br>Add it<br><input type="checkbox" name="pic_tobe_add" value="'.$img_link.'"><br><img src="'.$img_link.'" class="img-rounded" alt="Uploaded image" width="152" height="118"><br><br>';
}
if(isset($_POST['submit_p'])) {
   if (empty($_POST['pic_tobe_add'])) {
      echo "Error: select a pic";
  }else{echo $pic_tobe_add = $_POST['pic_tobe_add'];}
}
echo '<br><input type="submit" name="submit_p" value="Add this product"><form>';

Since nameof each check -box is same that's why you get only single value.change name="pic_tobe_add" to name="pic_tobe_add[]" now you will get all values. On the next page confirm it by printing out POST value using echo "<pre/>";print_r($_POST); — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Jun 23, 2016 at 5:01

Death-is-the-real-truth · Accepted Answer · 2016-06-23 05:05:08Z

1

Actually name of each check-box is same that's why you get only single value which is last-one.

change name="pic_tobe_add" to name="pic_tobe_add[]" (Make it array type so that you will get all the value)

On the next page confirm it by printing out POST value using echo "<pre/>";print_r($_POST);

answered Jun 23, 2016 at 5:05

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

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

4 Comments

Beauty akter Over a year ago

how can i receive all of these values in $_POST then?

Death-is-the-real-truth Over a year ago

I already told you. Also you have </form>. but i didn't see any form open code. that's strange

Beauty akter Over a year ago

yes. i have open form too above that code but i didnt post here to make it small and easy to understand. since my above codes are long about 100+ lines

Death-is-the-real-truth Over a year ago

your form have action = 'somepage.php' ? on that action page you have to recieve all the value . so on that page write echo "<pre/>";print_r($_POST); and check did you get all the values of check-boxes or not?

Naisa purushotham · Accepted Answer · 2016-06-23 05:02:06Z

1

use <input type="checkbox" name="pic_tobe_add[]" value="'.$img_link.'">

$q2 = mysqli_query($conn,"SELECT product_img_url FROM temp_img");

while ($row = mysqli_fetch_array($q2)) {
    $product_img_url = $row['product_img_url'];
    $target_dir = "../assets/img/temp_img/";
    $img_link = $target_dir.$product_img_url;

    echo '<br>Add it<br><input type="checkbox" name="pic_tobe_add[]" value="'.$img_link.'"><br><img src="'.$img_link.'" class="img-rounded" alt="Uploaded image" width="152" height="118"><br><br>';

}
//
    if(isset($_POST['submit_p'])) {
        if (empty($_POST['pic_tobe_add'])) {
            echo "Error: select a pic";
        }else{echo $pic_tobe_add = $_POST['pic_tobe_add'];}

}

echo '<br><input type="submit" name="submit_p" value="Add this product"><form>';

answered Jun 23, 2016 at 5:02

Naisa purushotham

91310 silver badges19 bronze badges

3 Comments

Death-is-the-real-truth Over a year ago

Why your answer is useful and why OP should have to try that. please add some description. thanks

Beauty akter Over a year ago

yes i have add name="pic_tobe_add[]" instate of name="pic_tobe_add" but problem now how can i receive it from $_POST? I need all of these results in variable.

Naisa purushotham Over a year ago

$pic_tobe_add_arr=$_POST['pic_tobe_add']; here $pic_tobe_add_arr contains all selected pic_tobe_add values or use directly foreach($_POST['pic_tobe_add'] as $item){}

Collectives™ on Stack Overflow

Mysql fetch data selection from html checkbox

2 Answers 2

4 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related