put tick on checkbox based on database value

Question

I'm updating some countries values into db table. All countries fetch from TBL_COUNTRY table. Then few countries store to another table. I'm using implode function to store multiple values. it works fine. it stored like this in my db table Afghanistan,Argentina,Austria,Bangladesh.

I have tried this code

           <?php
                $exp_str = explode(',', $model_availability);
                foreach($exp_str as $get_str)
                {
                    echo $get_str;
                }
            ?>

This above code return this output AfghanistanArgentinaAustriaBangladesh

How do I put tick on the checkbox based on this value?

            <?php
                $sql = "SELECT * FROM ".TBL_COUNTRY." ORDER BY country_name ASC";
                $exe = mysql_query($sql, $CN);
                while($r = mysql_fetch_array($exe))
                {   
            ?>
            <input type="checkbox" name="model_availability[]" value="<?=$r['country_name']?>" id="<?=$r['country_name']?>" />
            <label for="<?=$r['country_name']?>"><?=$r['country_name']?></label>
            <?php } ?>

Cpecific · Accepted Answer · 2014-08-23 11:35:00Z

1

<input type="checkbox" name="model_availability[]" value="<?=$r['country_name']?>" id="<?=$r['country_name']?>"<?=(in_array($r['country_name'],$model_availability)?" checked":"")?> />

answered Aug 23, 2014 at 11:35

Cpecific

573 bronze badges

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

Comments

Dinesh Patra · Accepted Answer · 2014-08-23 11:41:48Z

0

//In the input box just add a checked attribute, you will get.

 " id="" checked = "true" />

answered Aug 23, 2014 at 11:41

Dinesh Patra

1,14512 silver badges23 bronze badges

Collectives™ on Stack Overflow

put tick on checkbox based on database value

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related