Convert comma separated string with value to nested array [duplicate]

Question

I am receiving csv data as separate strings which I am trying to convert into nested arrays, and then json.

The strings I am receiving are like this, where the last element is the value.

$str1 = "name,firstname,Bob";
$str2 = "name,lastname,Dylan";

Here I need to convert the strings into nested arrays which would be equivalent to the arrays below. This is the bit I am struggling with.

$arr1 = ["name" => ["firstname" => "Bob"]];
$arr2 = ["name" => ["lastname" => "Dylan"]];

I can then use a array_merge_recursive to combine them

$merged = array_merge_recursive($arr1, $arr2);

After that I can convert the merged array into json

Does this answer your question? How to access and manipulate multi-dimensional array by key names / path? — C3roe
– C3roe, Commented Mar 10, 2022 at 9:43

mickmackusa · Accepted Answer · 2022-03-10 01:37:55Z

0

Pass in your dynamic number of strings to a loop.
Parse the comma-separated values.
Use the values to push data into your array structure.

Code: (Demo)

$strings = ["name,firstname,Bob", "name,lastname,Dylan"];
$result = [];
foreach ($strings as $csv) {
    [$level1, $level2, $value] = str_getcsv($csv);
    $result[$level1][$level2] = $value;
}
var_export($result);

Output:

array (
  'name' => 
  array (
    'firstname' => 'Bob',
    'lastname' => 'Dylan',
  ),
)

Or more succinctly, you can push directly from the array destructuring step to achieve the same result as above: (Demo)

$result = [];
foreach ($strings as $csv) {
    [$level1, $level2, $result[$level1][$level2]] = str_getcsv($csv);
}
var_export($result);

answered Mar 10, 2022 at 1:37

mickmackusa♦

49.2k13 gold badges98 silver badges165 bronze badges

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

Collectives™ on Stack Overflow

Convert comma separated string with value to nested array [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related