Codeigniter combine two array in foreach loop

Question

I have problem to combining two array, here my sample code

$arr1 = [];
$data = $this->db->query("SELECT QUERY");

foreach ($data->result_array() as $row) {

$arr1[] = array(
   "type"                   => "column",
   "name"                   => $row['name'],
   "legendText"             => $row['name'],
   "showInLegend"           => true
);

}


$count = $this->db->query("SELECT QUERY");

foreach ($count->result_array() as $rows) {

$arr1[]["dataPoints"] = array(
   "label" => $rows['data']
);

}

With this code, result is

[
  {
    "type": "column",
    "name": "LA 1",
    "legendText": "LA 1",
    "showInLegend": true
  },
  {
    "dataPoints": {
      "label": "1"
    }
  }
]

I want to combine two array, So the output should be like this:

[
  {
    "type": "column",
    "name": "LA 1",
    "legendText": "LA 1",
    "showInLegend": true,
    "dataPoints": [{
      "label": "1"
    }]
  }
]

Please someone help me to find out the easiest way to solve this issue.

php.net/manual/en/function.array-merge.php

Gerrit Luimstra
– Gerrit Luimstra

2017-12-02 19:42:58 +00:00
Commented Dec 2, 2017 at 19:42 — Gerrit Luimstra
– Gerrit Luimstra, Commented Dec 2, 2017 at 19:42
Not the best option for multidimensional arrays

Alex
– Alex

2017-12-02 21:03:19 +00:00
Commented Dec 2, 2017 at 21:03 — Alex
– Alex, Commented Dec 2, 2017 at 21:03

miknik · Accepted Answer · 2017-12-02 20:04:03Z

2

The proper way to fix this would be to change your database queries to one which would return all the information in a single query.

$data = $this->db->query("SELECT a.*, b.datapoints FROM table1 a, table2 b....");

answered Dec 2, 2017 at 20:04

miknik

5,9671 gold badge14 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

Codeigniter combine two array in foreach loop

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related