Parse a string with key=value declarations and make an associative array [duplicate]

Question

How do I explode the following string:

$str = "ProductId=123, Name=Ancient Roots, Modern Pursuits, Country=India, City=Bangalore, Price=3368"

Such that the output array will contain:

[
    "ProductId" => "123",
    "Name" => "Ancient Roots, Modern Pursuits",
    "Country" => "India",
    "City" => "Bangalore",
    "Price" => "3368" 
]

I tried to explode by "comma", then each element again explode by "equal to" as.

$arr = explode(",", $str);

and again

$prodarr = explode("=", $arr[0]);  
$product["ProductId"] = $prodarr[1]

But I'm facing the problem when another comma exists in a value like in name Ancient Roots, Modern Pursuits.

Is there a safe rule to follow? E.g. that the word before = is always a single word without commas or spaces? Also, if you have control over it, can't you simply switch to an established format like JSON? — deceze
– deceze ♦, Commented May 29, 2018 at 11:40
As a comma can mean multiple things, don't think you'd be able to do this with explode alone. You'd be able to accomplish it with a regular expression with a lookahead... until the next weird data format hit you. It would be much easier if you could get it in a better data format, either the current format with a delimiter or a standardised format like JSON — SubjectCurio
– SubjectCurio, Commented May 29, 2018 at 11:41
@Bharat You should contact the support team for this API. It is not built well, the values should be encapsulated. — user3783243
– user3783243, Commented May 29, 2018 at 12:06

Justinas · Accepted Answer · 2018-05-29 11:49:14Z

4

Your structure is very weak for breaking. But you can still try to parse it.

First explode on =. You will have next key and current value.

Then loop these and explode on , and select last element for next key and all previous parts as value (sample):

<?php
$str = "ProductId=123, Name=Ancient Roots, Modern Pursuits, Country=India, City=Bangalore, Price=3368";

$chunks = explode('=', $str);
$keys = [];
$values = [];

foreach ($chunks as $i => $chunk) {
    $parts = explode(',', $chunk);

    if ($i != count($chunks) - 1) {
        $keys[] = trim(array_pop($parts));
    }

    if ($i != 0) {
        $values[] = implode(',', $parts);
    }
}

var_dump(array_combine($keys, $values));

answered May 29, 2018 at 11:49

Justinas

43.9k5 gold badges72 silver badges108 bronze badges

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

Comments

Bernhard · Accepted Answer · 2018-05-29 13:15:44Z

1

I played a little bit around. I used preg_match_all() to extract the Patterns which contain characters that are no , and no = followed by a = followed by characters that are no = followed by a , or end of line. here is the result:

$result = array();
preg_match_all('/([^=,]+=[^=]+)(,|$)/', $string, $matches);
foreach($matches[1] as $data){
 $data = explode('=', $data);
 $result[trim($data[0])] = trim($data[1]);
}
$result = json_encode($result);

The result is:

{"ProductId":"123","Name":"Ancient Roots, Modern Pursuits","Country":"India","City":"Bangalore"}

edited May 29, 2018 at 13:15

answered May 29, 2018 at 12:38

Bernhard

1,8701 gold badge12 silver badges19 bronze badges

Comments

Dilip Belgumpi · Accepted Answer · 2018-05-29 12:19:57Z

Try something like this

<?php
    $str = "ProductId=123, Name=Ancient Roots, Modern Pursuits, Country=India, City=Bangalore, Price=3368";
    $str_arr = explode(",", $str);
    $json_array = array();

for ($i = 0; $i < sizeof($str_arr); $i++)
    {
    if (isset($str_arr[$i + 1]))
        {
        if (strpos($str_arr[$i + 1], '=') !== false)
            {
            $prod = explode("=", $str_arr[$i]);
            $json_array["" . $prod[0] . ""] = "" . $prod[1] . "";
            }
          else
            {
            $textAppend = "," . $str_arr[$i + 1];
            $prod = explode("=", $str_arr[$i]);
            $json_array["" . $prod[0] . ""] = "" . $prod[1] . "" . $textAppend . "";
            $i++;
            }
        }
      else
        {
        $prod = explode("=", $str_arr[$i]);
        $json_array["" . $prod[0] . ""] = "" . $prod[1] . "";
        }
    }


var_dump($json_array);
?>

Collectives™ on Stack Overflow

Parse a string with key=value declarations and make an associative array [duplicate]

3 Answers 3

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Linked

Related