Parse a string with three delimiters into an associative array of indexed arrays

Question

I have this line of string

Fruits-banana|apple|orange:Food-fries|sausages:Desserts-ice cream|apple pie

the : (colon) is the separator for the main topic, and the | is the separator for the different type of sub topics.

I tried to explode it out and put it into array, I need the result to be something like this to be displayed in a drop down menu:-

Fruits
  banana
  apple
  orange
Food
  fries 
  sausages
...

Code:

$result = explode(":", $data);
foreach ($result as $res) {
    $sub_res[] = explode("-", $res);
}

foreach ($sub_res as $sub) {
    //echo $sub[1] . "<br>";

    \*
       Over here, I can get the strings of 
       [0] => banana|apple|orange,
       [1] => sausages|fries,
    */
    // I explode it again to get each items 
    $items[] = explode("|", $sub[1]);
    $mainCategory[] = $sub[0]; // This is ([0]=>Fruits, ]1]=>Food, [2]=>dessert
    // How do I assign the $items into respective categories?
}

Are you needing one drop-down for all or a separate drop-down for each type? — Jason Durbin
– Jason Durbin, Commented Oct 25, 2010 at 19:20
The line is auto generated from a system. I need only one drop down. — Sylph
– Sylph, Commented Oct 25, 2010 at 22:40

mickmackusa · Accepted Answer · 2024-09-29 09:34:54Z

6

You can do:

$result = explode(":", $data);
foreach ($result as $res) {
    $sub = explode("-", $res);
    $mainCategory[$sub[0]] = explode("|", $sub[1]);
}

Working link

edited Sep 29, 2024 at 9:34

mickmackusa♦

49.2k13 gold badges98 silver badges165 bronze badges

answered Oct 25, 2010 at 19:22

codaddict

457k83 gold badges501 silver badges537 bronze badges

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

Comments

Jason Durbin · Accepted Answer · 2010-10-25 19:25:06Z

3

Code:

$data = "Fruits-banana|apple|orange:Food-fries|sausages:Desserts-ice cream|apple pie";
 foreach(explode(":",$data) as $res) { // explode by ":"
  $cat = explode("-",$res); // explode by "-"
  $ilovefood[$cat[0]] = explode("|",$cat[1]); // explode by "|"
 }
 print_r($ilovefood);
 //Returns : Array ( [Fruits] => Array ( [0] => banana [1] => apple [2] => orange ) [Food] => Array ( [0] => fries [1] => sausages ) [Desserts] => Array ( [0] => ice cream [1] => apple pie ) )
 foreach($ilovefood as $type=>$yum){
  echo "$type:<select>";
  foreach($yum as $tasty){
   echo "<option>$tasty</option>";
  }
  echo "</select>";
 }

Updated to reflect the drop-down addition. Looks like I just did your homework, though I'll leave it up to you to combine all the into one foreach loop.

edited Oct 25, 2010 at 19:25

answered Oct 25, 2010 at 19:12

Jason Durbin

3,4971 gold badge25 silver badges32 bronze badges

2 Comments

Sylph Over a year ago

Thanks Jason! I do not need 3 drop down but your answer did help me to understand better:D

Jason Durbin Over a year ago

I just realized that I have $ilovefood[$cat[0]] I don't actually love to each cats.

Community · Accepted Answer · 2017-05-23 10:32:31Z

1

I'd propose an arguably more readable version of codeaddicts' answer

$str = "Fruits-banana|apple|orange:Food-fries|sausages:Desserts-ice cream|apple pie";

$topics = array();
foreach (explode(':', $str) as $topic) {
  list($name, $items) = explode('-', $topic);
  $topics[$name] = explode('|', $items);
}

edited May 23, 2017 at 10:32

CommunityBot

11 silver badge

answered Oct 25, 2010 at 19:30

user229044♦

241k41 gold badges347 silver badges350 bronze badges

Collectives™ on Stack Overflow

Parse a string with three delimiters into an associative array of indexed arrays

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related