[SOLVED] Saving values from checkboxes into MySql

[karinne]

I have form where I'm displaying checkboxes with data taken from a MySQL table

PHP: Select all

<?
    $selectint = mysql_query("select * from interets order by interet asc"); 
    while ($rowint = mysql_fetch_array($selectint)) {
        $interet = stripslashes($rowint['interet']);
        $iID = $rowint['iID'];
    ?>
        <input type="checkbox" name="iID" id="interets" value="<?=$iID?>" /> <?=$interet?><br />
    <?
    } ?>

which displays this when you view the source online

HTML: Select all

<input type="checkbox" name="iID" id="interets" value="1" /> Activités de réseautage<br />
<input type="checkbox" name="iID" id="interets" value="3" /> Coaching<br />
<input type="checkbox" name="iID" id="interets" value="6" /> Comité amélioration physique<br />
<input type="checkbox" name="iID" id="interets" value="8" /> Comité développement écon.<br />
<input type="checkbox" name="iID" id="interets" value="7" /> Comité marketing<br />
<input type="checkbox" name="iID" id="interets" value="2" /> Formations et ateliers gratuits divers<br />
<input type="checkbox" name="iID" id="interets" value="5" /> Implication comme bénévole<br />
<input type="checkbox" name="iID" id="interets" value="4" /> Publicité commune<br />

What I wanted to do was to store the results like this

1-3-7

I think this is the easiest way...

What I want to know is, then user clicks submit, how do go about grabbing the ones that were checked and putting them in the format above?

[Rakuli]

When a user clicks a form that has checkboxes, only the checked boxes are sent. Any that were left unchecked don't even arrive at the next page.

Then with php, you can just check if the name of the checkbox exists

PHP: Select all

if (isset($_POST['iID'])

//etc 

I am a bit worried about your form though as checkboxes should all have different names because each is treated as an individual form field as opposed to radio buttons where a group of them can all have the same name with differing values.

In its current form, PHP will only receive the last checkbox ticked because all previous one's will be overwritten by the last.


Alternatively, you can name your checkboxes with

HTML: Select all

name="iID[]"

When PHP receives the form request, it will build all of the checked elements into an array so if the name of the element isn't an issue, this would be the best way to proceed.

Hope that helps.

[JustinStudios]

Drats, the one time karinne needs help I get beaten by Rakuli to the punch! Man, I wanted to help! haha

[karinne]

Thanks Rakuli ...

OK ... so if there were checkboxes checked, how do I get it to save it in one variable like 3-6-8 ?

I was trying to check the php.net site but I can't seem to access it this morning.

I know how to split a variable like that using the explode() so ... is there an implode() function that creates it

[Rakuli]

Yes.. okay so say you go for the multi-form array option and your form turns out like this

HTML: Select all

<input type="checkbox" name="iID[]" id="interets" value="1" /> Activités de réseautage<br />
<input type="checkbox" name="iID[]" id="interets" value="2" /> Activités de réseautage<br />

<input type="checkbox" name="iID[]" id="interets" value="3" /> Activités de réseautage<br />

<input type="checkbox" name="iID[]" id="interets" value="4" /> Activités de réseautage<br />

<input type="checkbox" name="iID[]" id="interets" value="5" /> Activités de réseautage<br />

<!-- etc //-->

On the page the the form is sent to you could use some PHP similar to: (assuming you use $_POST, if not ust replace with $_GET

PHP: Select all

// First check if ANY of them were checked.. PHP will place all the the checked box values into an array found in $_POST['iID']



if (isset($_POST['iID']))

{

   // Now use the PHP implode function which is exatly like explode except you use the second argument as the glue for the string and it joins the array together



  $variableString = implode($_POST['iID'], '-'); // Join on the hyphen



echo $variableString



} 

PHP normally has an opposite to everything... This function is quite handy

Cheers

[karinne]

Ah ... poor Justin ... got beaten by Rakuli again

Peeeerfect! Thanks Rakuli!

[Rakuli]

Ah ... poor Justin ... got beaten by Rakuli again

** Rakuli blows smoke from quick fired gun **

You're welcome.

[JustinStudios]

NOOESS!!! lol I think Rakuli is a hogging the forumz :P. Well good job Rakuli.