php select input checkbox from a mysql query

Question

How to add checked="yes" from a php mysql result when $row['checkbox'] == input.value?

for example: If now $row['checkbox']='3' How to add checked="yes" in <li><input type="checkbox" name="my_check" value="3" checked="yes" />Guangzhou</li>? Thanks.

<?php
// db_connect, mysql_query
while($row = mysql_fetch_array($query)){
// If($row['checkbox']='3)
?>
<li><input type="checkbox" name="my_check" value="1" />Beijing</li>
<li><input type="checkbox" name="my_check" value="2" />Shanghai</li>
<li><input type="checkbox" name="my_check" value="3" />Guangzhou</li>
<li><input type="checkbox" name="my_check" value="4" />Chongqin</li>
<li><input type="checkbox" name="my_check" value="5" />Tianjing</li>
<li><input type="checkbox" name="my_check" value="6" />Chengdu</li>
<li><input type="checkbox" name="my_check" value="7" />Wuhan</li>
<li><input type="checkbox" name="my_check" value="8" />Nanjing</li>
<li><input type="checkbox" name="my_check" value="9" />Shenzhen</li>
<li><input type="checkbox" name="my_check" value="10" />Hangzhou</li>
<li><input type="checkbox" name="my_check" value="11" />Ningbo</li>
<?php
}
?>

@heyanshukla, No, they ain't, your answer can do that, but I should parse <?php if($row['checkbox']=='3') echo 'checked="yes"' ?> in each input, however, in my page, I have more than 100 checkbox. any easy way? Thanks. — fish man
– fish man, Commented Apr 14, 2012 at 12:30

PeeHaa · Accepted Answer · 2012-04-14 12:28:14Z

3

I would first create an array for the checkboxes:

$checkBoxes = array(1=>'Beijing',
                    2=>'Shanghai',
                    3=>'Guangzhou',
                    4=>'etc',
                    );

Then I would simply loop through them:

<?php
while($row = mysql_fetch_array($query)){
    foreach($checkBoxes as $value => $name) {
        $checked = '';
        if ($row['value'] == $value) $checked = ' checked="true"';
        echo '<li><input type="checkbox" name="my_check" value="' . $value . '"' . $checked . ' />' . $name . '</li>';
    }
}

answered Apr 14, 2012 at 12:28

PeeHaa

73.1k60 gold badges195 silver badges264 bronze badges

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

Comments

Vad.Gut · Accepted Answer · 2012-04-14 12:33:11Z

try this

<?php
// db_connect, mysql_query
while($row = mysql_fetch_array($query)){
// If($row['checkbox']='3)
$checked[$row['checkbox']] = ' checked="checked" ';
?>
<li><input type="checkbox" name="my_check" value="1" <?php echo $checked[1] ?> />Beijing</li>
<li><input type="checkbox" name="my_check" value="2" <?php echo $checked[2] ?> />Shanghai</li>
<li><input type="checkbox" name="my_check" value="3" <?php echo $checked[3] ?> />Guangzhou</li>
<li><input type="checkbox" name="my_check" value="4" <?php echo $checked[4] ?> />Chongqin</li>
<li><input type="checkbox" name="my_check" value="5" <?php echo $checked[5] ?> />Tianjing</li>
<li><input type="checkbox" name="my_check" value="6" <?php echo $checked[6] ?> />Chengdu</li>
<li><input type="checkbox" name="my_check" value="7" <?php echo $checked[7] ?> />Wuhan</li>
<li><input type="checkbox" name="my_check" value="8" <?php echo $checked[8] ?> />Nanjing</li>
<li><input type="checkbox" name="my_check" value="9" <?php echo $checked[9] ?> />Shenzhen</li>
<li><input type="checkbox" name="my_check" value="10" <?php echo $checked[10] ?> />Hangzhou</li>
<li><input type="checkbox" name="my_check" value="11" <?php echo $checked[11] ?> />Ningbo</li>
<?php
}
?>

good luck

heyanshukla · Accepted Answer · 2012-04-14 12:25:00Z

1

    <input type="checkbox" name="my_check" value="3" <?php if($row['checkbox']=='3') checked="yes" ?>/>

answered Apr 14, 2012 at 12:25

heyanshukla

6698 silver badges17 bronze badges

Collectives™ on Stack Overflow

php select input checkbox from a mysql query

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related