Retrieve mysql value from php for radio buttons

Question

As trivial as it can seems, I'm having problems retrieving values for radio buttons from MySql database through PHP. It's my first learning project so I'm trying my best

Question has already been asked but I found no useful answer.

The php code does a simple "Select *" so I retrieve all the fields.

This is the php code

<label>Owner: <?php echo $row['Owner']; ?></label></br>
<input type="radio" name="Owner" checked=<?php if($row['Owner'] = "A") { echo "true"; }?>  value="A">A
<input type="radio" name="Owner" checked=<?php if($row['Owner'] = "B") { echo "true"; }?> value="B">B</br></br>

and I retrieve the values with mysqli_fetch_array().

This is the result:

As you can see the label retrieves the correct value, the radio buttons not.

I've already tried putting == instead of = and putting ' instead of " but I don't know why the checkbox "B" is checked, since Owner value is A.

Also, if there are any best practices which are better than this, you're welcome.

You are clear, but maybe I'm not. I clearly stated: "I've already tried putting == instead of = and putting ' instead of " but I don't know why the checkbox "B" is checked, since Owner value is A." — Liquid Core
– Liquid Core, Commented Nov 7, 2015 at 9:01

trincot · Accepted Answer · 2015-12-27 18:03:04Z

12

The HTML attribute checked should not get a value, its mere presence indicates that the radio button is checked. So do this:

<label>Owner: <?php echo $row['Owner']; ?></label></br>
<input type="radio" name="Owner" <?php if($row['Owner']=="A") {echo "checked"}?> value="A">A
<input type="radio" name="Owner" <?php if($row['Owner']=="B") {echo "checked"}?> value="B">B

Or using the more compact short echo tag <?= .. ?> and ternary operator:

<label>Owner: <?=$row['Owner']?></label></br>
<input type="radio" name="Owner" <?=$row['Owner']=="A" ? "checked" : ""?> value="A">A
<input type="radio" name="Owner" <?=$row['Owner']=="B" ? "checked" : ""?> value="B">B

Note that you need double equals signs for comparisons.

edited Dec 27, 2015 at 18:03

answered Nov 7, 2015 at 9:02

trincot

357k38 gold badges282 silver badges338 bronze badges

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

Comments

jay · Accepted Answer · 2015-11-07 09:01:05Z

4

try this code not = but use ==

<input type="radio" name="Owner" <?php if($row['Owner'] == "A") { echo "checked"; }?> value="A">

answered Nov 7, 2015 at 9:01

jay

1341 silver badge11 bronze badges

3 Comments

M. Eriksson Over a year ago

@LiquidCore - He's also using "checked" instead of "true" to mark what's checked.

Liquid Core Over a year ago

Yeah, it ended up that I didn't knew how to use checked properly. I marked as answer who came first, since that guy answer was correct too.

jay Over a year ago

<input type="radio" name="Owner" value="A" checked >

rene · Accepted Answer · 2017-10-11 20:47:36Z

0

$gender=$row['gender'];


<input type="radio" name="gender" <?php if($gender=="Male"){?> checked="true" <?php } ?> />Male

<input type="radio" name="gender" <?php if($gender=="Female"){?> checked="true" <?php } ?>/>Female

edited Oct 11, 2017 at 20:47

rene

42.6k78 gold badges122 silver badges166 bronze badges

answered Oct 11, 2017 at 20:44

Muhammad

1

1 Comment

mickmackusa Over a year ago

This is a code-only answer (which should be avoided as much as possible on SO because it does a poor job of educating future readers). The radio inputs do not have value attributes as the OP's snippet uses. If you are going to bother writing a new answer to a question that already has an educational and working solution, you need to bring new information or a new technique that is valuable to the page ...otherwise, it is just page bloat that SO and its readers can do without.

Mostafa Aabed · Accepted Answer · 2018-06-14 12:04:59Z

0

$owner=$row['owner'];
$owners= ['A'=>'', 'B'=> ''];
$owners[$owner] = 'checked';

<input type="radio" name="Owner" <?php echo $owners['A']?>  value="A">A
<input type="radio" name="Owner" <?php echo $owners['B']?>  value="B">B

i think it's easy and simple and so useful if you have many values in DB.

answered Jun 14, 2018 at 12:04

Mostafa Aabed

112 bronze badges

Comments

shabir ullah · Accepted Answer · 2017-07-05 07:46:25Z

-1

i tried the answer given by @trincot but it give me errors so i have make little changes to improve the answer

<input type="radio" name="Owner" <?php if($row['Owner']=="A") {?> <?php echo "checked";?> <?php }?> value="A">A

<input type="radio" name="Owner" <?php if($row['Owner']=="B") {?> <?php echo "checked";?> <?php }?> value="B">B

answered Jul 5, 2017 at 7:46

shabir ullah

1531 silver badge15 bronze badges

Collectives™ on Stack Overflow

Retrieve mysql value from php for radio buttons

5 Answers 5

Comments

3 Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

3 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related