Radio Button Array - Need Help

Question

I have a radio button array that I need help with. Here is the code:

            <input type="radio" name="radio" id="academic" value="1"<?php
                    if ($row_EventInfo['academic'] == '1') {
                    echo ' checked="checked"';
                    }
                    else {$row_EventInfo['academic'] = '';}
                    ?>>
        <label for="academic">Academic</label><br />

        <input type="radio" name="radio" id="personal" value="1"<?php
                    if ($row_EventInfo['personal'] == '1') {
                    echo ' checked="checked"';
                    }
                    else {$row_EventInfo['personal'] = '';}
                    ?>>
        <label for="personal">Personal</label><br />

        <input type="radio" name="radio" id="diversity" value="1"<?php
                    if ($row_EventInfo['diversity'] == '1') {
                    echo ' checked="checked"';
                    }
                    else {$row_EventInfo['diversity'] = '';}
                    ?>>
        <label for="diversity">Diversity</label><br />

What I'm trying to do is this. I have a column in my database table for each radio button because we have to have their inputs separately. However, I want them to only be able to select one of the buttons at a time. I changed all the names to be the same ("radio"), but since PHP MYSQL uses the names to know where to post the information in the table it doesn't know where to post.

Is there any way to create an if statement to tell it to only allow one button at a time to be selected and keep the inputs separate for the database table?

Please let me know if you need clarification. Thanks!

score 1 · Accepted Answer · answered May 25 '11 at 20:28

1

set the value to the column name, eg

<input type="radio" name="radio" id="diversity" value="diversity"

on the php end, simply do something like

$sql = "UPDATE table SET {$_POST['radio']} = 1";

answered May 25 '11 at 20:28

David Chan

7,347
1
28
49

Side note: This makes sense as an example, but for actual production use, it might be a good idea to sanitize the form input before using it in a SQL query. The query as written is potentially vulnerable to an injection attack. – Jed Hartman Nov 04 '12 at 23:48

score 0 · Answer 2 · answered May 25 '11 at 20:32

0

this is in a form, right? Then you get the data in the POST. I wouldn't set the value to 1, set the value to the value you want to select, e.g. Then in the post, get the value and use this to set the data in the DB.

Hope this helps!

BR,

TJ

answered May 25 '11 at 20:32

TerenceJackson

1,776
15
24

Oh, I just saw that there is already an answer on this ;) But it is the same approach... ;) – TerenceJackson May 25 '11 at 20:32

Lawrence Cherone · Answer 3 · 2011-05-25T20:50:05.600

If you use:

<input type="radio" name="radio" id="diversity" value="value1">
<input type="radio" name="radio" id="diversity" value="value2">
<input type="radio" name="radio" id="diversity" value="value3">
<input type="radio" name="radio" id="diversity" value="value4">

it will be available in $_POST['radio']; with what ever radio button you selected. eg.value3 dont confuse yourself by naming input types with the same name

If you use:

<input type="radio" name="myradio" id="diversity" value="value1">

It will be available in $_POST['myradio'];

and so on

plus you may want to look into using the ternary operator

if ($row_EventInfo['diversity'] == '1') {
    echo ' checked="checked"';
}
else {$row_EventInfo['diversity'] = '';}

into

echo ($row_EventInfo['diversity'] == '1') ? ' checked="checked"':'';

Radio Button Array - Need Help

3 Answers3