Convert two-line csv string (header and values) to associative array

Question

I have a string that looks like the below:

Name,Age,Location
Jo,28,London

How would I convert this into an associative array so it reads like this:

Array
(
    [Name] => Jo
    [Age] => 28
    [Location] => London
)

I've tried to explode the string and manipulate it that way but got nowhere fast ($body = explode(',', $body);) I tried to use array_map() but it expected an array in the first place.

I've looked through a few articles (PHP CSV to Associative Array with Row Headings) but again they are using array_map().

The CSV solution should be more then enough. Do not get stuck on small things like this. You simply get the first row from the results. php.net/manual/en/function.str-getcsv.php#117692 — szab.kel
– szab.kel, Commented Sep 3, 2018 at 8:59

Marcin Orlowski · Accepted Answer · 2018-09-03 09:13:16Z

6

You are trying to over-engineer simple thing, which result in wasting too much time for having task done.

$str = "Name,Age,Location\nJo,28,London";

$lines = explode("\n", $str);
$keys = explode(',', $lines[0]);
$vals = explode(',', $lines[1]);

$result = array_combine($keys, $vals);

But even ordinary loop would do the trick in your case and this is what you should end up with unless you had better ideas:

$result = []; 
for($i=0; $i<count($keys); $i++) {
   $result[$keys[$i]] = $vals[$i];
}

I also recommend getting thru list of available built-in array functions for future benefits.

edited Sep 3, 2018 at 9:13

answered Sep 3, 2018 at 9:02

Marcin Orlowski

75.7k11 gold badges128 silver badges152 bronze badges

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

1 Comment

pee2pee Over a year ago

I tried something similar but the string had leading line breaks so doing a trim() on it sorted it - thank you

Andreas · Accepted Answer · 2018-09-03 09:31:14Z

1

This answer will handle multilined CSV files.

Array_shift will take the first line and make that the keys, then loop the rest of the lines and use the keys in array_combine.

$str = "Name,Age,Location
Jo,28,London
Do,35,London";

$arr= explode("\n", $str);
$keys = explode(",",array_shift($arr));
foreach($arr as $line){
    $new[]= array_combine($keys, explode(",", $line));
}

var_dump($new);

https://3v4l.org/hAmCN

array(2) {
  [0]=>
  array(3) {
    ["Name"]=>
    string(2) "Jo"
    ["Age"]=>
    string(2) "28"
    ["Location"]=>
    string(6) "London"
  }
  [1]=>
  array(3) {
    ["Name"]=>
    string(2) "Do"
    ["Age"]=>
    string(2) "35"
    ["Location"]=>
    string(6) "London"
  }
}

answered Sep 3, 2018 at 9:31

Andreas

24k7 gold badges34 silver badges75 bronze badges

Comments

Quan Lee · Accepted Answer · 2018-09-03 09:11:43Z

0

you try this code:

$ex = explode(PHP_EOL, $string)
$arr = array_combine(explode(',',$ex[0]), explode(',',$ex[1]));
print_r($arr);die;

edited Sep 3, 2018 at 9:11

answered Sep 3, 2018 at 9:03

Quan Lee

1464 bronze badges

Comments

Ahmad Al- Hashlamoun · Accepted Answer · 2020-04-09 15:58:26Z

0

Try this, it's working:

  $content = $string;
  $delimiter = ",";
  $enclosure = '"';
  $escape = "\\" ;
  $rows = array_filter(explode(PHP_EOL, $content));
  $header = NULL;
  $data = [];

  foreach($rows as $row)
  {
    $row = str_getcsv ($row, $delimiter, $enclosure , $escape);

    if(!$header) {
      $header = $row;
    } else {
      $data[] = array_combine($header, $row);
    }
  }

answered Apr 9, 2020 at 15:58

Ahmad Al- Hashlamoun

1431 silver badge11 bronze badges

Collectives™ on Stack Overflow

Convert two-line csv string (header and values) to associative array

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related