Adding arrays to multi-dimensional array within loop

Question

I am attempting to generate a multi-dimensional array with each sub array representing a row I want to insert into my DB. The reason for this is so I can use CodeIgniters batch_insert function to add each row to the DB.

I am attempting to create each sub array within a loop and insert it into a multidimensional array. Google suggested using array_merge, but after using 'print_r' on the multidimensional array with the code below, only the last sub-array is being displayed.

Here is my code:

$allplayerdata = array(); //M-D container array
for ($i = 1; $i <= 11; $i++)
{
    $playerdata = array(
                        'player_id' => $this->input->post('player' . $i),
                        'goals' => $this->input->post('playergoals' . $i),
                        'player_num' => $i,
                        'fixture_id' => $this->input->post('fixture_id')
                    );

    //Merge each player row into same array to allow for batch insert
    $allplayerdata = array_merge($allplayerdata, $playerdata);
}
print_r($allplayerdata);

Can anyone spot where I'm going wrong? Help is appreciated!

Mark Biesheuvel · Accepted Answer · 2017-04-21 09:35:39Z

35

This is because array_merge is not the right operation for this situation. Since all the $playerdata arrays have the same keys, the values are overridden.

You want to use array_push to append to an array. This way you will get an array of $playerdata arrays.

array_push($allplayerdata, $playerdata);

Which is equivalent to adding an element with the square bracket syntax

$allplayerdata[] = $playerdata;

edited Apr 21, 2017 at 9:35

answered Jul 31, 2011 at 20:44

Mark Biesheuvel

6547 silver badges26 bronze badges

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

Comments

JK. · Accepted Answer · 2011-07-31 20:42:45Z

9

This will add the second array to the first array: A merge is something different.

$allplayerdata[] = $playerdata;

answered Jul 31, 2011 at 20:42

JK.

5,1261 gold badge29 silver badges26 bronze badges

1 Comment

Code Bunny Over a year ago

I think you should clarify that merge replaces the elements with the same index. It would be more helpful that way

Collectives™ on Stack Overflow

Adding arrays to multi-dimensional array within loop

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related