How to push an array into json key/value pair of an object i codeigniter array

Question

What am I trying to achieve

So what I was trying to achieve was push an array key/value pair into a JSON object that is in itself an array, so that there is a single object and one of the key-value pairs contains an array.

THIS IS WHAT I AM TRYING TO ACHIEVE as JSON output, another data2 Array inside another data array.

   [
    {
    "data": {
        "temp_service_id": "3",
        "name": "health checkup",
        "price": "10000",
        "service_id": "41",
        "data2": [
             {
              "fees": "2000",
              "service_name": "Anaesthesiologist"
             },
             {
              "fees": "300",
              "service_name": "Andrologist"
             },
           ]
        },  
     }
   ]

What I have tried
THIS IS MY CONTROLLER :

        $where['subtype_id'] = $this->post('org_id');
        $where['is_active'] = 'Y';
        $table_package_master = 'package_master';
        $fetch_package_name = $this->$model_name->fetch($table_package_master,$where);
        $array = [];
        $array1 = [];
        $array2 = [];
        if($fetch_package_name){
            foreach($fetch_package_name as $row){
                $where_r['t1.package_num'] = $row->package_num;
                $where_r['t1.is_active'] = 'Y';
                $where_r['services.is_active'] = 'Y';
                $where_r['t4.is_active'] = 'Y';
                $fetch_packages1 = $this->$model_name->fetch_packages1($where_r);
                $array['data'] = $fetch_packages1;
                $fetch_packages = $this->$model_name->fetch_packages($where_r);
                foreach($fetch_packages as $row1){
                    $where_re['services.service_id'] = $row1->service_id;
                    $where_re['services.is_active'] = 'Y';
                    $where_re['template_services.is_active'] = 'Y';                          

                    $fetch_package_ser = $this->$model_name->fetch_service_details($where_re);
                    array_push($array1,$fetch_package_ser);
                }
            }
            $array['data2'] = $array1;
            $array3 = [$array];
            $this->response($array3);
          }

THIS IS MY MODEL :

             function fetch($table,$where_con){
             $this->db->select('*')->from($table)->where($where_con);
              return $this->db->get()->result();
                }

                function fetch_packages1($where){
             $this->db->select('t3.temp_service_id,t4.name,t4.price,services.service_id');
              $this->db->from('package_services as t1');
             $this->db->join('services','services.service_id = t1.service_id', 'LEFT');
             $this->db->join('template_services as t3','t3.temp_service_id = services.temp_service_id' , 'LEFT');
             $this->db->join('package_master as t4', 't4.package_num = t1.package_num','LEFT');
             $this->db->where($where);
             $this->db->group_by('t1.package_num');
             return $this->db->get()->row();
           }

          function fetch_service_details($where){
           $this->db->select('services.price as fees,template_services.service_name');
           $this->db->from('services');
           $this->db->join('template_services','template_services.temp_service_id = 
           services.temp_service_id','LEFT');
           $this->db->where($where);
           return $this->db->get()->row();
            }

Basically what I am trying to do is put a data object inside $array variable that is data coming from one table now what i did was push data from another query into $array1 Than at the end all i did was array_push into $array3 all the data from $array1 and $array2 to make them join together but MY OUTPUT IS THIS :

         [
            {
             "data": {
                "temp_service_id": "3",
                "name": "health checkup",
                "price": "10000",
                "service_id": "41"
                     },
             "data2":  [
                     {
               "fees": "2000",
               "service_name": "Anaesthesiologist"
                     },
                     {
               "fees": "300",
               "service_name": "Andrologist"
                     }
               ]
            }
        ]

What am i missing here? i am really confused and can't understand how to push data2 array. Thankyou in advance :)

Try to re-write $array['data2'] = $array1; with $array['data']['data2'] = $array1;, should help — Aksen P
– Aksen P, Commented Nov 25, 2019 at 11:56
thanks a lot for replying :) I did what you said and here is the error i got, Uncaught Error: Cannot use object of type stdClass as array in Stack trace: #0 C:\xampp\htdocs\sanatorium1\application\libraries\REST_Controller.php(431): Sanhc->fetch_packages_in_org_post() C:\xampp\htdocs\sanatorium1\application\libraries\REST_Controller.php(418): REST_Controller->_fire_method(Array, Array) #2 — Satyam thassu
– Satyam thassu, Commented Nov 25, 2019 at 12:02

Aksen P · Accepted Answer · 2019-11-25 12:24:00Z

1

Re-write one line in your Controller $array['data2'] = $array1; with $array->data['data2'] = $array1;.

It will put array data2 into the data index.

Working Demo

edited Nov 25, 2019 at 12:24

answered Nov 25, 2019 at 12:02

Aksen P

4,6153 gold badges16 silver badges27 bronze badges

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

9 Comments

Satyam thassu Over a year ago

do i need to declare above two that it is two dimesional array? $array = [][];

Aksen P Over a year ago

@Satyam, no, try simply create a new field data2

Satyam thassu Over a year ago

It is giving this error, Uncaught Error: Cannot use object of type stdClass as array

Aksen P Over a year ago

@Satyam, even with ->?

Satyam thassu Over a year ago

now it's still giving error, do i need to replace $array['data'] = $fetch_packages1; with ---> $array->data = $fetch_packages1;

|

Satyam thassu · Accepted Answer · 2019-11-27 07:13:17Z

I came up with a solution finally after thinking about it a lot

     $fetch_package_name = $this->$model_name->fetch($table_package_master,$where);
        $array = [];
        $array1 = [];
        if($fetch_package_name){
            for($i=0;$i<sizeof($fetch_package_name); $i++){
                $where_r['t1.package_num'] = $fetch_package_name[$i]->package_num;
                $where_r['t1.is_active'] = 'Y';
                $where_r['services.is_active'] = 'Y';
                $where_r['t4.is_active'] = 'Y';
                $fetch_packages1 = $this->$model_name->fetch_packages1($where_r);

                $array[$i]['name'] = $fetch_package_name[$i]->name;
                $array[$i]['price'] = $fetch_package_name[$i]->price;
                $where_re['t1.package_num'] = $fetch_package_name[$i]->package_num;
                $where_re['t1.is_active'] = 'Y';
                $where_re['services.is_active'] = 'Y';
                $fetch_packages = $this->$model_name->fetch_packages2($where_re);
                for($j=0; $j<sizeof($fetch_packages); $j++){
                    $array1[$j]['service_name'] = $fetch_packages[$j]->service_name;
                    $array1[$j]['price'] = $fetch_packages[$j]->price;
                }
                $array[$i]['data2'] = $array1;
            }
            // $this->response($array);
            $array2['data'] = $array;
            $array2['status'] = 10007; 
            // $data_response['data'] = $array;
            $this->response($array2);
    }

IT gave me the response that i desired in the first place.\

  { 
     "data":[ 
           { 
            "name":"Full body checkup",
             "price":"5000",
                "data2":[ 
                    { 
                    "service_name":"Allergist",
                    "price":"23"
                    },
                    { 
                    "service_name":"Andrologist",
                    "price":"300"
                    }
                 ]
            } 
      ],
  }

Cheers! happy coding :-)

Collectives™ on Stack Overflow

How to push an array into json key/value pair of an object i codeigniter array

2 Answers 2

9 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related