Multiple Checkbox Selection in form

[phpbeginner]

I am using a form to update my database and within the form there are a large number of fields which I update on GO.

 

Within that form one of the fields I am updating, I would like to have a multiple selection choice for that field as below.

 

<input type=checkbox name=flooring[] value=Hardwood> Hardwood
<input type=checkbox name=flooring[] value=Carpet> Carpet
<input type=checkbox name=flooring[] value=Linoleum> Linoleum

 

Now when I submit go there are all kinds of things I am inserting including flooring

 

$query = "INSERT INTO styles (flooring) values($flooring)

 

But in the database all that is inserted is ARRAY. Also, what is the best field type to insert multiple selections in?

 

Thanks In Advance

[Barand]

what is the best field type to insert multiple selections in?

 

A separate table, properly normalized,

[phpbeginner]

And for the ARRAY issue?

[phpbeginner]

I changed the value to $flooring[$i] and added this but will not insert anything.....

 

$flooringCount = count($flooring);
for ($i=0; $i < $flooringCount; $i++);

[Barand]

it sounds like you want to

 

$flooringTypes = join (',', $floorings);
$query = "INSERT INTO styles (flooring) values($flooringTypes)";

 

I'd recommend

foreach ($floorings as $flooringType)
{
    $query = "INSERT INTO styles (flooring) values($flooringType)";
}

 

where the flooring style table has an autoinc id

[phpbeginner]

Tried option 1 which I was trying to achieve but still just adds ARRAY to the fldflooring

[Barand]

post the code

[phpbeginner]

Form.....

 

<input type=checkbox name=flooring[] value=Hardwood> Hardwood
<input type=checkbox name=flooring[] value=Carpet> Carpet
<input type=checkbox name=flooring[] value=Linoleum> Linoleum

 

Then

 

if ($action=="go")
                                 
                   		{
                        $flooringCount = count($flooring);
                        for ($i=0; $i < $flooringCount; $i++)

                       $query = "INSERT INTO styles (flooring) values($flooring[$i])

 

 

[Barand]

that should be the same as my option 2

 

what does this output

echo '<pre>', print_r($flooring, 1), '</pre>';

[Barand]

of course, you need to execute the queries

 

foreach ($flooring as $flooringType)
{
    $query = "INSERT INTO styles (flooring) values('$flooringType')";
    mysql_query($query);
}

 

or in your code

for ($i=0; $i < $flooringCount; $i++)
{
     $query = "INSERT INTO styles (flooring) values('$flooring[$i]')";
     mysql_query($query);
}

[phpbeginner]

I dunno.....will still only insert 1 selection

[Barand]

what does this output

echo '<pre>', print_r($flooring, 1), '</pre>';

[phpbeginner]

Hi Barand, I got it to work using the following.

 

$flooring=$_POST["flooring"];
        $flooringstr="";
        for($i=0;$i<sizeof($flooring);$i++){
        $flooringstr .= $flooring[$i]." ";}

 

and changing value to ($flooringstr).

 

NOW, I having a tremendous amount of difficulty with populating the checkboxes on my edit page.

 

I am inserting the values in a text type field, and as you can see, seperated by a space. Any ideas on this one?

 

Appreciate your help.