PHP - creating new array value based on explode name in the original array

Question

I have array with this format:

$components = [
    [
        'name'   => 'ADIPIC ACID',
        'cas'    => '123',
        'einecs' => '321'
    ],
    [
        'name'   => 'ADIPIC ACID/DIMETHY- LAMINOHYDROXY- PROPYL DIETHYLENE- TRIAMINE COPOLYMER',
        'cas'    => '456',
        'einecs' => '654'
    ]
]

I need to find each name which has a / character, break it and create a new entry in the $components array with cas and einecs being empty string.

Also the first part of the name will have cas and einecs values from the original entry.

Expected array:

$components = [
        [
            'name'   => 'ADIPIC ACID',
            'cas'    => '123',
            'einecs' => '321'
        ],
        [
            'name'   => 'ADIPIC ACID',
            'cas'    => '456',
            'einecs' => '654'
        ],[
            'name'   => 'DIMETHY- LAMINOHYDROXY- PROPYL DIETHYLENE- TRIAMINE COPOLYMER',
            'cas'    => '',
            'einecs' => ''
        ]
    ]

How can I do this?

I need to insert all the components in the db. In this case name can have multiple components, and I need them all. — Sasha
– Sasha, Commented Nov 13, 2015 at 18:03
I think what he is asking is for you to produce what you expect the example array to look like so that we can compare. It's currently a little bit unclear what you are asking for. — VictorKilo
– VictorKilo, Commented Nov 13, 2015 at 18:04

Professor Abronsius · Accepted Answer · 2015-11-13 18:13:42Z

1

Quite crude I admit and it doesn't account for multiple / characters in a value but it does return the result expected.

        foreach( $components as $index=> $arr ){
            foreach( $arr as $key => $value ){
                if( $key=='name' && strstr( $value, '/' ) ){
                    list($pre,$post)=explode('/',$value);
                    $components[$index][$key]=$pre;
                    $components[]=array('name'=>$post,'cas'=>'','einecs'=>'');
                }
            }
        }

answered Nov 13, 2015 at 18:13

Professor Abronsius

33.9k5 gold badges36 silver badges49 bronze badges

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

Comments

stas.yaranov · Accepted Answer · 2015-11-13 18:12:06Z

1

<?php

$components = [
    [
        'name'   => 'ADIPIC ACID',
        'cas'    => '123',
        'einecs' => '321'
    ],
    [
        'name'   => 'ADIPIC ACID/DIMETHY- LAMINOHYDROXY- PROPYL DIETHYLENE- TRIAMINE COPOLYMER',
        'cas'    => '456',
        'einecs' => '654'
    ]
];

$new = [];

foreach ($components as &$component) {
    if ($items = explode('/', $component['name'])) {
        $component['name'] = array_shift($items);
        $new = array_merge($new, $items);
    }
}

foreach ($new as $item) {
    $components[] = ['name' => $item, 'cas' => '', 'einecs' => ''];
}

var_dump($components);

answered Nov 13, 2015 at 18:12

stas.yaranov

1,78711 silver badges17 bronze badges

Comments

Gerard de Jong · Accepted Answer · 2015-11-13 18:17:47Z

1

I would try something like this where I use the explode function using the '/' character on the name of each component. Then I'd create a new array of all the new components taking the values of the component being evaluated.

$newComponents = array();
foreach($components as $component) {
  foreach(explode('/', $component['name']) as $newComponentName) {
    $newComponents[] = array('name'   =>$newComponentName, 
                             'cas'    => $component['cas'],
                             'einecs' => $component['einecs']);
  }
}

answered Nov 13, 2015 at 18:17

Gerard de Jong

6181 gold badge5 silver badges11 bronze badges

Comments

Marcus Abrahão · Accepted Answer · 2015-11-13 18:27:55Z

1

foreach($components as $component)
{
   if(strpos($component["name"],"/") !== false){
      $temp = explode("/",$component["name"]);
      $components[] = new array("name"=>$temp[1], "cas"=>"", "einecs"=>"");
   }
}

edited Nov 13, 2015 at 18:27

answered Nov 13, 2015 at 18:12

Marcus Abrahão

6961 gold badge8 silver badges18 bronze badges

Collectives™ on Stack Overflow

PHP - creating new array value based on explode name in the original array

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related