Creating an array

[boblee]

Hello all, I want to create an array from information posted from checkboxes which are created by a foreach statement. For example information is taken out of the database table full of product numbers and several checkboxes are displayed for every product number, when the user checks multiple boxes and hit submit an array of the products in created. I got the checkbox part working, but I don't how to create the array. Would any one mind filling me in? -Thanks

 

the code that works do far:

$conn = "SELECT product_id FROM `products`";
$result = mysql_query($conn, $query);

while ($row = mysql_fetch_row($result)) {
  $product[] = $row[0];
}

foreach ($product as $y) {
  echo "<input class='checkbox' type='checkbox'  name='$i++' value='$y'>\n" . $y . "</input>\n";
}

[php1]

To create an array of checkbox you have to use name='checkbox[]'

 

foreach ($product as $y) {

  echo "<input class='checkbox' type='checkbox'  name='$i++[]' value='$y'>\n" . $y . "</input>\n";

}

[kenrbnsn]

Why are you creating an extra array to hold the "products"? Also, where is the variable "$i" set?

You can create the checkbox line in the while loop:

<?php
$conn = "SELECT product_id FROM `products`";
$result = mysql_query($conn, $query);

while ($row = mysql_fetch_assoc($result)) {
  echo '<input class="checkbox" type="checkbox" name="product[]" value="' . $row['product_id'] . '">' . $row['product_id'] . "</input>\n";
}
?>

 

Ken

[boblee]

Probably because I don't know what I'm doing As for the the variable "$i", just a typo I guess, I thought I had 'products_id' in there.

 

alright so using that while statement I can create the series of check boxes, but how do I create an array based on the boxes the user has checked? -Thanks