Search code examples
phpexplodetext-parsingtext-formatting

Reformat a string with two sets of delimiters into more human-readable, multiline text

$string = "706AN=0,503-PP=0,504-PP=0,519=0,606BOX=0,417=2"; // This variable is a result from a database column type text

I need to get individually the code before "=" and the result assigned to that code, after "=". The split string should return me something like:

Code 706AN has quantity 0  
Code 503-PP has quantity 0  
Code 504-PP has quantity 0  
Code 519 has quantity 0  
Code 606BOX has quantity 0  
Code 417 has quantity 2

How can I substract each code with his own quantity result?

Solution

  • You can use explode

    Working Demo: https://eval.in/869203

    $string = "706AN=0,503-PP=0,504-PP=0,519=0,606BOX=0,417=2";
$temp = explode(',', $string);


foreach ($temp as $key => $value) {
    list($code,$quantity) = explode('=', $value);
    echo "Code $code has quantity $quantity </br>";
}