PHP Multidimensional Array Merge Issue

Question

I am running a query that outputs a multidimensional array like this: -

Array
(
[0] => Array
    (
        [0] => Array
            (
                [id] => 772
                [display_name] => Test Company Ltd
                [profile_page] => partners/test-company
            )

    )

[1] => Array
    (
    )

[2] => Array
    (
        [0] => Array
            (
                [id] => 772
                [display_name] => Test Company Ltd
                [profile_page] => partners/test-company

            )

)

I am trying to make the Array look like this so that we can loop through it on our site: -

Array
(
[0] => Array
    (
        [id] => 772
        [display_name] => Test Company Ltd
        [profile_page] => partners/test-company
    )
)

This is all being generated using PHP using Symfony2 and Doctrine2. I have tried a couple of methods to get this working but I have reverted back to my first method which is this: -

$companies = array();

foreach($postcodes as $key=>$value) {
    $conn = $em->getConnection();

    $query = $conn->prepare("SELECT a.id, a.display_name, a.profile_page, b.meta_data FROM companies a, `cms`.pages b WHERE b.slug = a.profile_page AND a.active = 1 AND a.postcode = ".$value."  ORDER BY a.display_name ASC");
    $execute = $query->execute();
    $companies[] = array_replace_recursive($query->fetchAll());
}

echo '<pre>'; print_r($companies); echo '</pre>';

die();

If someone can show me how to get around this, that would be great.

Alok Patel · Accepted Answer · 2016-08-22 09:24:35Z

2

$query->fetchAll() is itself is an multidimensional array you're in need.

Just replace following line

$companies[] = array_replace_recursive($query->fetchAll());

with

$innCompnies=$query->fetchAll();
foreach($innCompnies as $inComp) {
     $companies[]=$inComp;
}

It wasn't working because you were pushing multidimensional array into another array. What we actually need to do is to push element one by one into the main array.

edited Aug 22, 2016 at 9:24

answered Aug 22, 2016 at 9:15

Alok Patel

8,0726 gold badges35 silver badges48 bronze badges

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

4 Comments

Matt Toner Over a year ago

I tried this and when I remove the square brackets from $companies as well as the array_replace_recursive it showed an empty array. When I put the square brackets back in and removed the array_replace_recursive, I have exactly the same answer as before.

Matt Toner Over a year ago

Hi Alok, thats great and that worked a treat. Thank you. However, how would I merge it as the two values are similar.

Alok Patel Over a year ago

You will need to keep track of the IDs you visit in foreach only insert array if the id is not visited before.

Matt Toner Over a year ago

Of course. Monday mornings eh? Thank you Alok. I will mark this as answered. Thanks again mate, I really appreciate your help. Sometimes too much coding can cloud your judgement, haha!

Ziumin · Accepted Answer · 2016-08-22 09:34:05Z

0

I suggest you to avoid SQL-queries in loop. Also you have potential SQL-injection vulnerability concatenating postcodes to your query. So the possible solution may be replacing your foreach loop with something like:

$companies = $conn->fetchAll(
    "SELECT a.id, a.display_name, a.profile_page, b.meta_data FROM companies a, `cms`.pages b WHERE b.slug = a.profile_page AND a.active = 1 AND a.postcode IN :postcodes  ORDER BY a.display_name ASC",
    compact('postcodes')
);

answered Aug 22, 2016 at 9:34

Ziumin

4,8701 gold badge29 silver badges34 bronze badges

Comments

Maodo Sow · Accepted Answer · 2016-08-22 10:14:36Z

0

you can transform the multidimentional array like this.

$new_companies = array();
array_walk($companies, function($companie) use($companies, &$new_companies){
  if(is_array($companie)) {
    foreach ($companie as $c) {
        $new_companies[] = $c;
    }
  }
});

$new_companies is what you want.

edited Aug 22, 2016 at 10:14

answered Aug 22, 2016 at 10:05

Maodo Sow

11 bronze badge

Collectives™ on Stack Overflow

PHP Multidimensional Array Merge Issue

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related