Creating an Array from Form Checkboxes

blueman

Hi all,

This should be an easy one.

I have a form with a series of checkboxes, example:

<input type="checkbox" name="cat_id" value=22> <b>ASP Scripts</b><br>
<input type="checkbox" name="cat_id" value=17> <b>Audio Tools</b><br>
<input type="checkbox" name="cat_id" value=28> <b>Business Tools</b><br>
<input type="checkbox" name="cat_id" value=23> <b>CGI Scripts</b><br>

and I need to collect all the checked options into an array, so I can loop the insert query X times (the same amount of marked checkboxes)

what would be the syntax code for creating this array?

thanks in advance.

LordShryku

Just change them to name="cat_id[]"

Then, once submitted, $_POST['cat_id'] will be an array of checked values.

blueman

Hi
Thanks,

I got it, but there is still something missing.
The loop does the insert as many times as there are marked check boxes, however, the actual $cat_id is not being passed properly

here's my code:

	
$idarray = array();
$idarray = $_POST['cat_id'];
          for ($count=0; $row = mysql_fetch_array($idarray); $count++)
$idarray[$count] = $row;
     foreach ($idarray as $row)
    {
    $cat_id = ($row["cat_id"]);
	$query = "insert into ban_to_cat values ($ban_id, $cat_id)"; 
    }

Can you guys tell me what's wrong or missing here?

thanks a bunch
Blueman

LordShryku

mysql_fetch_array has an argument of the sql resource. So when you execute a query, you pass that executed query to mysql_fetch_array so it can fetch the query resultset. You seem to be passing it an array? Plus, where do you get $ban_id from?

blueman

The $ban_id is being sent through a hidden field on the form, so its not an issue.

I dont know if I need to do this:

$idarray = array(); 
$idarray = $_POST['cat_id'];

or if I should pass $_POST['cat_id']; directly to mysql_fetch_array

thats where it gets confusing to me...

thanks for all your help 🙂