create a multi dimensional array from csv

Question

i have a csv file with data shown in the picture.What i want to do is,read the csv file and make a multidimensional array given below

Array(
     array(
           [ZAIN BUSINESS EMPIRE PVT LTD]=>['10684054','10686738','10686688','10684062']

          ),

     );

I have read the csv and stored the name of companies and ids in separate arrays.

  $file_name=$_FILES['file_upload']['tmp_name'];
  $csv = array_map("str_getcsv", file($file_name,FILE_SKIP_EMPTY_LINES));
  $keys = array_shift($csv);
   foreach ($csv as $i=>$row) 
     {
     $csv[$i] = array_combine($keys, $row);
     }
     foreach ($csv as $data)
     {
       $company_id_arr[]=$data['Customer_ID'];
       $name[]=$data['STANDARD NAME IN M2M DB'];
     }

why only ['10684054','10686738','10686688','10684062']? what about other id's.Also what's the column-name for these entries? — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Feb 2, 2018 at 8:53
Why have the extra Array() around it all? Or in other words, I don't understand the result you want. It's unclear. — KIKO Software
– KIKO Software, Commented Feb 2, 2018 at 8:55

Priyank · Accepted Answer · 2018-02-02 09:23:37Z

2

<?php
$file_name=$_FILES['file_upload']['tmp_name'];
$csv = array_map("str_getcsv", file($file_name,FILE_SKIP_EMPTY_LINES));
$keys = array_shift($csv);
 foreach ($csv as $i=>$row) {
    $csv[$i] = array_combine($keys, $row);
   }
   foreach ($csv as $data){
 $company_id_arr[$data['STANDARD NAME IN M2M DB']][]=$data['Customer_ID'];
    //$name[]=$data['STANDARD NAME IN M2M DB'];

    
   }

?>

edited Feb 2, 2018 at 9:23

answered Feb 2, 2018 at 9:16

Priyank

4702 silver badges11 bronze badges

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

Comments

u_mulder · Accepted Answer · 2018-02-02 08:59:19Z

2

The solution is:

// your result array
$result = [];
foreach ($csv as $data)
{
    // check if your key not exists in $result
    if (empty($result[$data['STANDARD NAME IN M2M DB']])) {
        $result[$data['STANDARD NAME IN M2M DB']] = [];
    }

    // Add value under required key
    $result[$data['STANDARD NAME IN M2M DB']][] = $data['Customer_ID'];
}

answered Feb 2, 2018 at 8:59

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

Collectives™ on Stack Overflow

create a multi dimensional array from csv

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related