How to separate elements from an array values on php and built new array?

Question

i've got this array (from a csv file) :

array (
 0 => 'entity_id;commission_book;old_price;new_price',
 1 => '667;667;667;667',
 2 => '668;668;668;668'
 )

How to build a new array that looks like :

[0] : (
 'entity_id' => '667',
 'commission_book' => '667',
 'old_price' => '667',
 'new_price' => '667',
);
[1] : (
 'entity_id' => '668',
 'commission_book' => '668',
 'old_price' => '668',
 'new_price' => '668',
 )

In other words, i want to buid 2 objects using the first array, is there any way to perfom that please ? I'm trying for hours now

arkascha · Accepted Answer · 2016-02-07 19:00:36Z

3

This is a simply but elegant way to do that:

<?php

$input = [
    0 => 'entity_id;commission_book;old_price;new_price',
    1 => '667;667;667;667',
    2 => '668;668;668;668'
];
$output = [];

// drop header entry
array_shift($input);
// process remaining entries
foreach ($input as $key=>$entry) {
    $x = &$output[$key];
    list(
        $x['entity_id'],
        $x['commission_book'],
        $x['old_price'],
        $x['new_price']
    ) = explode(';', $entry);
}


print_r($output);

The output of the above is:

Array
(
    [0] => Array
        (
            [new_price] => 667
            [old_price] => 667
            [commission_book] => 667
            [entity_id] => 667
        )

    [1] => Array
        (
            [new_price] => 668
            [old_price] => 668
            [commission_book] => 668
            [entity_id] => 668
        )

)

edited Feb 7, 2016 at 19:00

answered Feb 7, 2016 at 18:49

arkascha

43.2k8 gold badges61 silver badges97 bronze badges

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

2 Comments

arkascha Over a year ago

Well, I hope you do. We all do. Life would be boring otherwise, wouldn't it?

arkascha Over a year ago

Made another modification, a foreach loop is easier to follow and that version is more robust against gaps in the input keys.

RomanPerekhrest · Accepted Answer · 2016-02-07 19:10:04Z

Short solution with array_slice and array_combine:

$from_csv = [
    0 => 'entity_id;commission_book;old_price;new_price',
    1 => '667;667;667;667',
    2 => '668;668;668;668'
];

$result = [];
$keys = explode(";", $from_csv[0]);  // header fields

foreach(array_slice($from_csv, 1) as $v){
    $result[] = array_combine($keys, explode(";", $v));
}

echo '<pre>';
var_dump($result);

// the output:
array(2) {
  [0]=>
  array(4) {
    ["entity_id"]=>
    string(3) "667"
    ["commission_book"]=>
    string(3) "667"
    ["old_price"]=>
    string(3) "667"
    ["new_price"]=>
    string(3) "667"
  }
  [1]=>
  array(4) {
    ["entity_id"]=>
    string(3) "668"
    ["commission_book"]=>
    string(3) "668"
    ["old_price"]=>
    string(3) "668"
    ["new_price"]=>
    string(3) "668"
  }

}

Andreas · Accepted Answer · 2016-02-07 19:14:46Z

0

$array = array(
0 => 'entity_id;commission_book;old_price;new_price',
1 => '667;667;667;667',
2 => '668;668;668;668');

$array[0] = explode(";",$array[0]);
$array[1] = explode(";",$array[1]);
$array[2] = explode(";",$array[2]);
$newarray = array();

for ($i=0;$i<count($array[0]);$i++){
    $newarray[0][$array[0][$i]] = $array[1][$i]; 
    $newarray[1][$array[0][$i]] = $array[2][$i]; 
}

echo "<pre>";
var_dump($array);
var_dump($newarray);
echo "</pre>";

answered Feb 7, 2016 at 19:14

Andreas

24k7 gold badges34 silver badges75 bronze badges

Collectives™ on Stack Overflow

How to separate elements from an array values on php and built new array?

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related