How to merge the following array structure into one array, showing only the results [duplicate]

Question

I have this weird array output after I execute a query and it looks like this

array:32 [▼
  0 => array:1 [▼
    "key" => "overview.domain"
  ]
  1 => array:1 [▼
    "key" => "overview.msg_latest_translation"
  ]
  2 => array:1 [▼
    "key" => "overview.no_stats"
  ]

But all i want it to be only one array, not a nested array. SO it would look something like this

array:32 [▼
  "overview.domain",
  "overview.msg_latest_translation",
  "overview.no_stats"
]

What would be the best way to solve this ?

This is the query that i am executing, which is giving me the first output:

  return $this->createQueryBuilder('t')
        ->select('t.key')
        ->getQuery()
        ->getResult()
    ;

Sina Kadkhodaei · Accepted Answer · 2021-09-13 16:16:22Z

1

Use this (PHP array_map):

$rows = $this->createQueryBuilder('t')
        ->select('t.key')
        ->getQuery()
        ->getResult();
    
$arr = array_map(function($_v){return $_v['key'];}, $rows);

With array_map you can change the values of the array by its value.

edited Sep 13, 2021 at 16:16

answered Sep 13, 2021 at 16:08

Sina Kadkhodaei

5105 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

How to merge the following array structure into one array, showing only the results [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related