Answers from Radio buttons and checkboxes to mysql using php

Question

For a survey app which has a combination of radiobuttons and checkboxes. How do I use PHP to insert the selected values to mysql db using php? This is the query for fetching the questions from db:

while($row2 = $result2->fetch_assoc())
{

if($row2["subtype"] =="radio")
{
 echo "<input id = \"radio\" class='radio_input' type=\"radio\" name=answergroup[".$row["PK_QUESTION_ID"].
"] value=".$row2["opt_id"].">".$row2["opt_text"]."</input>";

else if($row2["subtype"] =="checkbox")
{
echo "<input id = \"checkbox\" class='radio_input' type=\"checkbox\" name=answergroup[".$row["PK_QUESTION_ID"].
"] value=".$row2["opt_id"].">".$row2["opt_text"]."</input>";

}
}

I tried using $_POST['answergroup'] for fetching the selected options, but in the case of a checkbox, only one option is being fetched even if there are multiple selections made.

What you getting in print_r($_POST) ?

Ahmed Ginani
– Ahmed Ginani

2017-04-28 09:02:29 +00:00
Commented Apr 28, 2017 at 9:02 — Ahmed Ginani
– Ahmed Ginani, Commented Apr 28, 2017 at 9:02

Mayank Pandeyz · Accepted Answer · 2017-04-28 09:03:48Z

1

When you are dealing with multiple checkboxes with the same name, in that case the name of checkboxes must be an array like:

<input type="checkbox" name="options[]" value="1">

On form submit you can get the values like:

$options = $_POST['options'];

here $options is an array, so use foreach() to get its elements.

answered Apr 28, 2017 at 9:03

Mayank Pandeyz

26.3k4 gold badges43 silver badges61 bronze badges

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

1 Comment

Yaswanth Viswanath Over a year ago

The name is an array. The issue I'm facing is when there's a combination of radio buttons and checkboxes...

Collectives™ on Stack Overflow

Answers from Radio buttons and checkboxes to mysql using php

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related