php/mysql store and retrieve checkbox values

[jarvis]

Hi all,

 

Happy Bank holiday!

 

Rather embarassingly, I've never had to use checkboxes on my forms and now I need to. How do I store and retrieve checkbox values using php & mysql?

 

Any sample code would be most helpful!!!

 

Thanks in advanced!

[Alex]

You can store 1 for a checked box and 0 for an unchecked box. So..

 

Inserting:

 

$checkbox = (isset($_POST['some-check-box'])) ? 1 : 0;
//Insert $checkbox into mysql..

 

Getting back from the database:

 

//Query etc...
$checkbox = ($row['checkbox'] == 0) ? NULL : 'checked="checked"';
echo "<input type='checkbox' name='whatever' $checkbox />";

[jarvis]

Thanks alexWD but what if it's for multiple options? Like a menu for example?

[Alex]

For that it's a bit different, you'd store the selected value and do something like this:

 

Storing:

$selected = mysql_real_escape_string($_POST['select-menu']);
//Query

 

Then for displaying it with the selected one:

 

//Query..
$items = Array('Menu Option 1', 'Menu Option 2', 'Menu Option 3');
foreach($items as $item)
{
     $menu .= ($row['selected'] == $item) ? "<option value='$item' selected='selected'>$item</option>" : "<option value='$item'>$item</option>";
}

 

Then $menu would contain the contents of the <select..></select>.