how to check a checkbox based on database value

[vinaip]

Hi,

 

I have saved a "Y" or "N" in the database field, based on a Checkbox setting in the "Add Contact" screen.

 

Now, in the Edit screen, I want to show the same checkbox, but it should be checked or unchecked, based on the value from the database.

 

How do I check the checkbox based on the edit screen, based on the database value, in PHP? Please help.

 

Thanks,

Vinai

 

[per1os]

$checked = (($dbval == 'Y')?"CHECKED":"";

print '<input type=checkbox name=cbox value=y ' . $checked . '/>';

[TecBrat]

I usually code with the more verbose if() statement, and I put PHP inside HTML more than I echo HTML, but there are times for both. Here's another example that does the same thing.

<?
if ($dbval=="Y"){$fieldnamechecked="checked"}
?>

<input type=checkbox name=fieldname <? echo($fieldnamechecked); ?> value=y >

[emehrkay]

im modifying frost's code

 

$checked = ($dbval == 'Y') ? 'checked="checked"' : '';

 

echo "<input type=\"checkbox\" name=\"name\" value=\"". $dbreturnval ."\" ". $checked ." />\n";

[per1os]

Ah yes, thanks for the correction emehrkay!