Inserting multi select values into database codeigniter

Question

The data posted, including the multi select field is

Array ( [id] => 16 [pAttr] => Array ( [0] => Colour [1] => Size ) )

I am trying to insert an id with one attribute only and do it again in second row.

____________________
|  id  | attribute |
--------------------
|  16  |  Colour   |
|  16  |  Size     |

The controller method

public function add_config_product()
{
    $data['id'] = $this->input->post('id');
    $data['attribute'] = $this->input->post('pAttr');

    /*$data = array(

        'id' => $this->input->post('id'),
        'attribute' => $this->input->post('pAttr')
    );*/

    //print_r($data);
    $this->inventory_model->add_config_product($data);
}

Model

public function add_config_product($data)
{
    $this->db->insert('product_attr_value', $data);
}

jtheman · Accepted Answer · 2014-01-14 22:40:03Z

1

Try this:

Controller:

public function add_config_product()
{
    $data['id'] = $this->input->post('id');
    foreach ($this->input->post('pAttr') as $attribute):
        $data['attribute'] = $attribute;
        $this->inventory_model->add_config_product($data);
    endforeach;
}

This will loop through the pAttr input array and add values in each rows.

edited Jan 14, 2014 at 22:40

answered Jan 14, 2014 at 22:24

jtheman

7,5013 gold badges32 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

László Papp · Accepted Answer · 2014-01-15 05:03:06Z

0

If you pass an array of values to a function in model to insert, then you can use the following type :

public function add_config_product($data)
{
   $this->db->insert_batch('product_attr_value',$data);
}

edited Jan 15, 2014 at 5:03

László Papp

53.5k40 gold badges118 silver badges142 bronze badges

answered Jan 15, 2014 at 4:43

Adarsh M Pallickal

8213 gold badges16 silver badges38 bronze badges

Collectives™ on Stack Overflow

Inserting multi select values into database codeigniter

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related