Codeigniter insert_batch giving error

Question

I am using codeigniter's **$this->db->insert_batch('mytable', $data); ** but it is giving me error as :

A PHP Error was encountered

Severity: Warning

Message: array_keys() expects parameter 1 to be array, string given

Filename: database/DB_active_rec.php

Line Number: 1113

my controller code is (just a part of it):

foreach ($arrAllergy as $allergy) {
            $allergyData[] = array(
                "user_id" => $userid,
                "allergy_name" => $allergy
            );

        }
        $this->register_model->addAllergy($allergyData);

model:

public function addAllergy($decoded_data) {

  $this->db->insert_batch('allergies', $decoded_data);
}

I have searched a lot for this error but didn't found any solution. Any help would be highly appreciated.

Would be good if you could post your solution for this, if you got it solved. — Highly Irregular
– Highly Irregular, Commented Mar 3, 2014 at 0:49

tomexsans · Accepted Answer · 2013-12-12 13:27:15Z

1

insert_batch requires

key => value pairs where the

key is the column name of the database

and the value is the value

your array must be formatted like

Array
(
    [0] => Array
        (
            [column1] => value
            [column2] => value
            [column3] => value
        )

[1] => Array
    (
        [column1] => value
        [column2] => value
        [column3] => value
    )

)

print_r your array ,what it looks like..

answered Dec 12, 2013 at 13:27

tomexsans

4,5374 gold badges37 silver badges49 bronze badges

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

2 Comments

tomexsans Over a year ago

@user2936213 how about you dump it. and lets have a look? what CI version are you using?

user2936213 Over a year ago

I am using Codeigniter 1.0

Collectives™ on Stack Overflow

Codeigniter insert_batch giving error

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related