Inserting multiple json elements into document using CodeIgniter MongoDB

Question

I want to insert json array elements like below using MongoDB and CodeIgniter.

"ticket" : [
     {
     "problem" : "testing",
     "time_taken" : "5 hrs",
     "number_of_visits" : "7",
     "expenses" : {
             "amount" : "2000",
             "distance_travelled" : "4 km"
              }
     },
     {
     "problem" : "testing",
     "time_taken" : "5 hrs",
     "number_of_visits" : "4",
     "expenses" : {
             "amount" : "2500",
             "distance_travelled" : "5 km"
              }
     }
]

What is the query I have to use for this?

Visit [ http://stackoverflow.com/questions/21139190/where-to-insert-functions-in-codeigniter-mongodb ] — Nishant Nair, Jan 23 '17 at 04:26

score 1 · Answer 1 · answered Jan 23 '17 at 05:05

1

What you need is the Bulk Write functions (https://docs.mongodb.com/manual/core/bulk-write-operations/)

The PHP depends on which library you are using (old or new, hopefully the new one!) but in plain English you:

create an array of operations (in your case "inserts")
call bulk write.

answered Jan 23 '17 at 05:05

Robbie

17,605
4
35
72

Well, you've obviously done something wrong, but I'm afraid my crystal ball isn't showing me what you've done. So not really in a position to help... – Robbie Jan 23 '17 at 10:16

Uma · Accepted Answer · 2021-01-02T05:38:57.040

0

$this->mongo_db->where('_id', new MongoId($id))->push("ticket",$data)->update('engineer');

This is the query I'm using for inserting multiple array values in mongodb codeigniter.

edited Jan 02 '21 at 05:38

answered Jan 25 '17 at 09:54

Uma

109
1
1
10

Inserting multiple json elements into document using CodeIgniter MongoDB

2 Answers2