Dynamic Checkboxes insert into db

[mhodge87]

I have a form that dynamicly adds checkboxes per a table my code is as follows:

//creates position list checkboxes

$sql = "SELECT * FROM `jos_event_positions` ORDER BY `NAME`";
$query = mysql_query($query, $con) or die("There was an error with your query!");

 while ($row = mysql_fetch_array($query))
 {
    //outputs all the checkboxes here

 }

That part works, so it creates a list of checkboxes that corresponds with the database entries.

My question is how would i go about submitting those checkbox values into another table. I know how to do it when they are static, but since the checkboxes are dynamic I don't know where to begin

Any help is once again appreciated.

-Mike

[Kudose]

if(isset($_POST)){
  echo '<pre>';
  print_r($_POST['boxes']);
  echo '</pre>';
}
$sql = "SELECT * FROM `jos_event_positions` ORDER BY `NAME`";
$query = mysql_query($query, $con) or die("There was an error with your query!");

while ($row = mysql_fetch_array($query))
{
    //outputs all the checkboxes here
  echo '<input type="checkbox" name="boxes[]" value="'.$row['something'].'" />';

} 

[mhodge87]

Thanks for the snippet of code. Could you please explain what is happening so I can learn as opposed to asking the same question later on 🙂

[Kudose]

name="boxes[]" creates an HTML checkbox "boxes" array

When you post the data, it shows up in $_POST['boxes']

It is pretty much the same as you are used to, except the [] (which creates an array)