Combining 2D Arrays from CSV Files with Same Structure

Question

I am trying to add two arrays $arraydata1 and $arraydata2 to get the array $result. But it shows the result as if $result=$arraydata1;, not as $result=$arraydata1+$arraydata2;.

Here is the array I am trying to add after getting it from the CSV file and storing it in different array type variable.

$result = array();
$arraydata1 = array();
$arraydata2 = array();
$key1 = array("itemid","itembrand","itemname","itemmodel","itemdesc","itemtype","itemprice","itemimgfolder","itemimage");
$key2 = array("itemid","itembrand","itemname","itemmodel","itemdesc","itemtype","itemprice","itemimgfolder","itemimage");
foreach (file('data/dell/data.csv') as $key => $str)
{
    if ($key == 0) continue;  // to skip headings of the csv file
    $values = str_getcsv($str, "\t", '', '');
    $arraydata1[] = array_combine($key1, $values);
} // to store first array data

foreach (file('data/hp/data.csv') as $key => $str)
{
    if ($key == 0) continue;  // to skip headings of the csv file
    $values = str_getcsv($str, "\t", '', '');
    $arraydata2[] = array_combine($key2, $values);
}

$result = $arraydata2+$arraydata2; // result the combination of the two arrays

Everything else is working fine. I have also tried array_combine() but it did not work either.

Yeah `$result = array_merge($arraydata2,$arraydata1);` is alternate solution. — Vishal Kumar Sahu, May 10 '16 at 15:16

Don't Panic · Accepted Answer · 2016-05-09T19:29:30.580

1

As the possible duplicate comment suggests, I think the answer is to use use array_merge rather than +, but why not just store them all in the same array to begin with?

$keys = array("itemid","itembrand","itemname","itemmodel","itemdesc","itemtype","itemprice","itemimgfolder","itemimage");

$files = array('data/dell/data.csv', 'data/hp/data.csv');

foreach ($files as $file) {
    foreach (file($file) as $key => $str) {
        if ($key == 0) continue;  // to skip headings of the csv file
        $values = str_getcsv($str, "\t", '', '');
        $result[] = array_combine($keys, $values);
    }
}

edited May 09 '16 at 19:29

answered May 09 '16 at 19:14

Don't Panic

41,125
10
61
80

Thank you for the insight... – Vishal Kumar Sahu May 10 '16 at 15:05
I could do it by `$result = array_merge($arraydata2,$arraydata1);`. Using your code I am not able to print the data in desired way as I got with array `$result` in merge case. For example I cannot `echo result[0]['itemname']` now. – Vishal Kumar Sahu May 10 '16 at 15:15
Thank you, **Don't Panic**. It's working. I am using your method to use it in jQuery-UI autocomplete. Due to you my 120 line code will be reduced to 8-10 lines. Thank you! – Vishal Kumar Sahu May 11 '16 at 19:09
1

Great! I'm glad I could help. – Don't Panic May 11 '16 at 19:18
I was afraid of the error but your code is with no error. Thanks – Vishal Kumar Sahu May 12 '16 at 16:19

Combining 2D Arrays from CSV Files with Same Structure

1 Answers1