checkboxes checked when mysql row = true?

Question

Hi, I am making a page where the user can set there own settings. I need a loop to check the checkbox when the row is true and to be unchecked when its not. How would I go about this? in php/javascript.

Thanks

echo "<form method=\"post\">";

echo "<table>
<tr>
  <td>1</td>
   <td><input name=\"checkbox[]\" type=\"checkbox\" id=\"checkbox[]\"></td>
</tr>

<tr>
     <td>2</td>
     <td><input name=\"checkbox[]\" type=\"checkbox\" id=\"checkbox[]\"></td>
</tr>


</table>"; 
echo"<input name=\"update\" type=\"submit\" id=\"update\" value=\"Update\" method\"post\">";
echo "</form>";

Answer 1

Suppose you get a value from row and then while iterating do:

<input type="checkbox" <? if ($value==true) echo "checked=checked"; ?> />

PS. I just hope you are not expecting us to wrote here the entire whole code for you, right?

Answer 2

In your loop, add this:

 echo "<input type=\"checkbox\" ";
 if ( $value_which_should_be_true ) { echo "checked=\"checked\""; }
 echo "/>";

This uses the checked HTML attribute for checkboxes, which specifies the default state.

Answer 3

while($row = mysql_fetch_assoc($rs))
{
    // some code...

    $checked = '';
    if($row['setting_1'] === TRUE)
    {
          $checked = 'checked="checked"';
    }

    echo '<input type="checkbox" name="setting_1" value="value_1" '.$checked.' />';

    // some code...

}

Answer 4

The checked attribute takes "checked" (see here), so I'd do something like:

<input type="checkbox" <? if ($value == true) echo 'checked="checked"'; ?> />

Alternatively, you can do something like:

if ($value == true) { $checked = 'checked="checked"' };
echo '<input type="checked".$checked.' />;