Posted by Chung Leong on 01/24/06 07:51

info@octavum.com wrote:
> novice....
>
> i started a php site in dreamweaver and i try fill data into MySql
> database.
>
> i set up a page with a form and i can fill in all the fields.
>
> just for one field, i like to have several checkboxes. every checkbox
> has a value, and they should fill the same field with their vale when
> checked. i also want to keep my text box, so i can write additional
> information.
>
> at the moment, when i click more than one checkbox, only the value of
> the first checkbox appears in the database. also, if there is already
> some data in this cell, it delete previous data, but i would like to
> keep it. preferably it should just add to information allready in the
> database.
>
> cheers, dimitri

Put [] (open and block square brackets) behind the field name so that
the values are placed into an array, then join them together using
implode().

Example:

<input type="checkbox" name="pets[]" value="dingo"> Dingo
<input type="checkbox" name="pets[]" value="donkey"> Donkey
<input type="checkbox" name="pets[]" value="bob dillon"> Bob Dillon
<input type="text" name="pets[]" value="" size="8">

.... and then ...

$pets = implode(', ', $_POST['pets']);

[Back to original message]