[Quarterbore]

HOW TO ADD CHECK BOXES!

Disclaimer: There may be better ways to do this but I searched quite a bit and finally hacked this together using some basic PHP!

About this example: In this example I am going to work with results from a database query. This is a worst case example (I think) so anybody should be able to figure it out for a simpler case.

Page 1: This is the form that the Admin Adds the data to!

PHP Code:


$cell[1] = 'This is a Demo!<dfn> Imagine you had a list of options (usergroups perhaps).</dfn>';

        //Following is an example of data already saved (perhaps called back from a database)
        $selected_OPTIONS = 'Radio|Power Brakes|V8|4x4';

        //Following is a query to get a list of ALL options that are possible
        $checkboxs_get = mysql_query("
                SELECT option, optionid, display
                FROM " . TABLE_PREFIX . "demo
                ORDER BY display

        //Need to Start to Build the Checkbox DIV
        $checkbox_options = '<div align="left">';

        //Loop through the Possibilities from the database
       while ($checkbox = mysql_fetch_array($checkboxs_get))
    {
          //  If the checkbox was selected before, we need to define $checkboxselected
          if (in_array(trim($checkbox[option]), $selected_types))
         { $checkboxselected = "checked=\"checked\""; }

          // Need to create this option for the checkbox list
          $checkbox_options .='<input type="checkbox" name="option[]" value="' . $checkbox[optionid] . '"' . $checkboxselected . '>' .  $checkbox[option] . '<br />'; 
    
          // Need to clear the $checkboxselected for the next pass!
          $checkboxselected ='';
    }

        // Need to Close the Checklist DIV
        $checkbox_options .='</div>';

$cell[2] = $checkbox_options;

print_cells_row($cell); 


Page Two - This is the page that receives the data!

PHP Code:

foreach($_POST['option'] as $value) {
$selected_options .= $value;
$selected_options .= '|';
}
// From Here you would likely want to save the data in your database!

$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "demo SET options = '$selected_options' WHERE some_field = $something");