CODEWITHSUNDEEP
php
user3651819
user3651819

Reputation: 497

How do I get checkbox as checked if value is stored in database?

I am having a problem in retrieving checkboxes from the database. Actually I am making edit form by using the input form which insert the values in database. I am facing problem with checkboxes and other inputs works fine.

My code looks like 

<input type="checkbox" name="proizvodi[]" value="0" <?if ($row['PROIZVODI'] == '0') $checked = 'checked="checked"'; ?> checked="checked"><b>product1<b/>                                    <input type="checkbox" name="proizvodi[]" value="1" <?if ($row['PROIZVODI'] == '1') $checked = 'checked="checked"'; ?> checked="checked"><b>product2<b/> <br/> 
<input type="checkbox" name="proizvodi[]" value="2" <?if ($row['PROIZVODI'] == '2') $checked = 'checked="checked"'; ?> checked="checked"><b>product3</b> <br/>

To make it more clear, I want only checkboes that are stored in db to be checked. for ex if value 1 is stored in db, product1 checkbox will be checked, if value 1 is no stored then check box will be not checked.

I appreciate any help or advice.

Thanks in advance!

Upvotes: 0

Views: 3639

Answers (2)

Eddie
Eddie

Reputation: 26844

How about this? You need to echo the 'checked="checked"' and do not assign it to a variable

    <input type="checkbox" name="proizvodi[]" value="0" <?php if (strpos($row['PROIZVODI'],'0') !== false) echo 'checked="checked"'; ?>><b>product1<b/>                                    
    <input type="checkbox" name="proizvodi[]" value="1" <?php if (strpos($row['PROIZVODI'],'1') !== false) echo 'checked="checked"'; ?>><b>product2<b/> <br/> 
    <input type="checkbox" name="proizvodi[]" value="2" <?php if (strpos($row['PROIZVODI'],'2') !== false) echo 'checked="checked"'; ?>><b>product3</b> <br/>

Upvotes: 1

Daan
Daan

Reputation: 12236

Write your rows like this don't make it any harder than it is:

<input type="checkbox" name="proizvodi[]" value="0" <?php if ($row['PROIZVODI'] == '0') { ?> checked="checked" <?php } ?> /><b>product1<b/>

Upvotes: 0

Related Questions