Concatinate Check Boxs into one insert

Goal: Have a dynamic list to check boxes which will be inserted into one field in the DB coma separates!

For example; I have check boxes for red(1), green(2), blue(3) and yellow(4). I want the client to select as many as they wish and insert the numbers into one field in the DB. So the field colors might have a value of 1,3,4.

Any ideas

Nick

the first key to this is to name your chechboxes the same name, and ending with "[]"


for example:
<inpout type="checkbox" name="color[]" value="red" />


Now in the insert record behavior, when you bind to the checkbox. the code will look like:

<?php echo(isset($_POST['color'])?$_POST['color']:""); ?>

you will need to edit this to use the implode function to convert the array to a comma separated list:

<?php echo(isset($_POST['color'])?implode(", ", $_POST['color']):""); ?>

I'm using this in an update. Becauce you had me change the and to include [] it was picked up as I added the update. Do I need to delete the []?

This is my before and after, do I have his right?

<?php echo ((isset($_POST["theme_img[]"]))?$_POST["theme_img[]"]:""); ?>

<?php echo ((isset($_POST["theme_img[]"]))?implode(",",$_POST["theme_img[]"]:"")); ?>

Thanks Nick

Not update happening and no errors, the redirect works so the update thinks it's working but it's not.

There must be a problem with the update statement.

Got it to work on e one: <?php echo (isset($_POST['theme_img'])?implode(", ", $_POST['theme_img']):""); ?>

This is awesome! Opens doors..

Thanks

yes, the brackets "[]" should only be included in the form element name, not in the echo statement


Think of it this way:
By adding the brackets at the end, you are creating an array.

the brackets are not needed when referencing the array though, they are only needed to create it.