Form Processing Checkbox

[andrewteg]

Hi,

I have a series of checkboxes dynamically generated and it could be just one or two or 100 depending on the user ... it's like this:

<input type=checkbox name=c1[] value=ABC>
<input type=checkbox name=c1[] value=DEF>
<input type=checkbox name=c1[] value=GHI>

I thought giving them all the same name would be the easiest as I know other languages will just output the variable = ABC,DEF if you pick the first two for example. However, PHP doesn't seem to be doing this as easy as I thought. I've tried naming them all c1[] or just plain c1 and neither seems to work.

How can I output in PHP just what has been checked? I need to do a database call where the "WHERE" clause only gets those checked (ie SELECT * FROM TABLE WHERE ID In(ABC,DEF))

Thanks,
Andrew

[eoghain]

You are on the right track. Keep your variables named c1[], then you just need to process the c1 array to get your selected checkboxes.

$checked = $_POST["c1"];

$sql = "SELECT * FROM TABLE";

if (count($checked) > 0) // make sure we have something checked
{
   // This line only works if ID is a numeric value
   // More work would need to be done if ID is a string and needs
   // quotes.
   $sql .= " WHERE ID IN (" . implode(",", $checked) . ")";
}

[andrewteg]

Thank you for your help as it works great now!