Use database to check a checkbox

Question

I have a page to view assets with an Edit link. When I click the link it goes to edit_case.php which has a form to edit what elements of the row are in the database as checkboxes. However the boxes do not show them as checked. I have the following code...

// get already checked box values 
$repop = "SELECT * FROM case_audit WHERE case_id = $case_id";
$popresults = mysqli_query($dbc, $repop);
$row = mysqli_fetch_array($popresults, MYSQLI_ASSOC);

print_r ($row);

The print_r does show the whole record row from DB. which is either a 1 or 0, checked || not checked.

The form...

<div id="facepics">
 <label><input type="checkbox" name="Facial1" value="<?php echo $row['frontrest']; ?>" >Front at Rest </label><br>
 <label><input type="checkbox" name="Facial2" value="<?php echo $row['frontbigsmile']; ?>" >Front Big Smille</label><br>
 <label><input type="checkbox" name="Facial3" value="<?php echo $row['profile']; ?>" >Profile</label><br>
 <label><input type="checkbox" name="Facial4" value="<?php echo $row['subvertex']; ?>" >SubMento Vertex</label><br>
</div>

I know I need to turn the 1's to "checked" just not sure how best to do that.

you can try http://stackoverflow.com/a/28815506/4535386 – YesItsMe Aug 20 '15 at 03:20 — YesItsMe, Aug 20 '15 at 03:20

Minhaz · Accepted Answer · 2015-08-20T11:58:43.170

0

so basically checked="true" attribute in input creates a checked checkbox. HTML Code looks like

<input type="checkbox" checked="true">

In your case you can do it like:

<input type="checkbox" name="Facial1" value="frontrest" <?= (intval($row['frontrest']) == 1) ? 'checked' : '';>

Also note that I changed value attribute, with frontrest so that you can identify the checkbox uniquely

EDIT: I have modified the code

edited Aug 20 '15 at 11:58

answered Aug 19 '15 at 23:55

Minhaz

937
1
10
25

That just checks all the checkboxes, I need it to only check those boxes which have a value of 1. – Steveep Aug 20 '15 at 00:28
my bad, the current answer should do! – Minhaz Aug 20 '15 at 11:59
after a few rounds of testing, that works. Wonderful – Steveep Aug 20 '15 at 16:28

score 0 · Answer 2 · answered Aug 20 '15 at 01:16

0

<input type="checkbox" name="Facial1" <?=$row['frontrest']==1?'checked':''?>>

I often have the same issue where the browser ignores checked="false" and checks all so I use

<input type="checkbox" checked>

answered Aug 20 '15 at 01:16

Dug

315
5
11

Use database to check a checkbox

2 Answers2