how to insert multi-dimensional array to the database in codeigniter

Question

There is my code:

Array
(
    [head_family] => 1234
    [house_name] => abc
    [house_no] => 12
    [relationship] => son
    [family_ms_id] => KERTVMPMJF318
    [member_ms_id] => KERTVMPMJM318
)
Array
(
    [head_family] => varun
    [house_name] => nila
    [house_no] => 12
    [relationship] => son
    [family_ms_id] => KERTVMPMJF318
    [member_ms_id] => KERTVMPMJM318
)

Controller:

$this->Enrollment_model->add_member($appended);

Model:

function add_member($appended) {
        $this->db->insert('members', $appended);
        return $this->db->insert_id();
}

check http://stackoverflow.com/questions/17875706/how-to-create-codeigniter-batch-insert-array — Saty, Jul 20 '16 at 10:22
pls always be responsive to the given answers, mark with check as green and do upvote if it helps you — Pradeep, May 20 '18 at 13:56

score 0 · Answer 1 · edited May 05 '18 at 05:31

0

A nice approach would be inserting as JSON string. So first create a database column with type as LONGTEXT

Then use this in Model:

function add_member($appended) {
     $json_array = json_encode($appended);
        $this->db->insert('members', $json_array);
        return $this->db->insert_id();
}

And when fetching from database :

$appended = json_decode($json_array);

edited May 05 '18 at 05:31

Pradeep

9,667
13
27
34

answered Jul 20 '16 at 10:33

Aritra Debsarma

121
5

how to insert multi-dimensional array to the database in codeigniter

1 Answers1