从多个阵列创建主阵列

Question

I have 2 arrays(which could be more too) and they might have scattering data.

Date    | Apple                       Date    | Banana  
-----------------                    -------------------
   1      |   5                         1     |   3
   4      |   5                         3     |   1
   5      |   5                         7     |   2

The array structure would be like as below.

array
(
   [0] => array
   (
      [date] => 4
      [apple] => 5
   )
   [1] => array
   (
       [date] => 5
       [apple] => 5
   )
)

What I need is to have a consolidated array having both the details. Example shown below.

Date      Apple      Banana
-------------------------------    
 1          5          3
 3          0          1
 4          5          0
 5          5          0
 7          0          2

How best we can do this considering the fact that array can hold multiple values? Any hint will help me to solve this. Or please point me to correct link if its already discussed. I could not find anything during search.

Thanks in advance.

Answer 1

Based on @Hristo response, I modified the code and it worked the following way. By this way, I get the expected output.

Below is not the exact code that I used. I have modified to be in alignment with my example posted in the question.

Will this work well in a huge array?

    $finalArray = array();

    foreach ($apple as $key => $value) {
         $finalArray[$value['date']]['apple'] = $value['apple'];
    }

    foreach ($banana as $key => $value) {
         $finalArray[$value['date']]['banana'] = $value['banana'];
    }

    var_dump($finalArray);

This gives an output of

 array
 (
     [1] => array
     (
        [apple] => 5
        [banana] => 3
     )
 )