How to remove multiple columns from the multi dimensional array?

Question

I have a multi dimensional array like below.

array:1 [
  0 => array:3 [
    "picture_id" => "0"
    "car_name" => "CA"
    "from" => "2020"
    "to" => "2020"
  ]
]

I need to remove from & to from the above array and return result in same structure.

I have tried following code

    $whitelist = array("from", "to");
    $finalArray = [];
    foreach ($records as $record) {
        foreach ($record as $key => $item) {
            if (!in_array($key, $whitelist)) {
                $finalArray[$key] = $item;
            }
        }
    }

But the result I am getting is not multi-dimensional array like this:

array:1 [
  "picture_id" => "0"
  "car_name" => "CA"
]

My expected result is:

array:1 [
  0 => array:3 [
    "picture_id" => "0"
    "car_name" => "CA"
  ]
]

Yes I have updated the questions – S S Apr 23 '20 at 13:35 — S S, Apr 23 '20 at 13:35

JureW · Accepted Answer · 2020-04-23T13:59:56.063

You can try something like this:

$array = [
   [
    "picture_id" => "0",
    "car_name" => "CA",
    "from" => "2018",
    "to" => "2020"
  ],
       [
    "picture_id" => "1",
    "car_name" => "WA",
    "from" => "2010",
    "to" => "2019"
  ]
];

    $whitelist = array("from", "to");
    $finalArray = [];
    foreach ($array as $k =>  $record) {
        foreach ($record as $key => $item) {
            if (!in_array($key, $whitelist)) {
                $finalArray[$k][$key] = $item;
            }
        }
    }
print("<pre>".print_r($finalArray,true)."</pre>");

What will print out:

Array
(
    [0] => Array
        (
            [picture_id] => 0
            [car_name] => CA
        )

    [1] => Array
        (
            [picture_id] => 1
            [car_name] => WA
        )

)

A short explanation...Basically you are looping over multi dimensional array as

foreach($array as $key => $value)

Where value is "inner" array, so in order to remove some elements from inner, and create a new multi dimensionalarray, you have to use keys, like in my example, from original array. So you than actually make an array like:

$newArray[$key] = $innerArray

And this gives you multi dimensional array. BR

score 3 · Answer 2 · answered Apr 23 '20 at 13:55

Rather than having to go through each field to determine if it should be removed, you can use array_diff_key() to remove all of the columns in one go. This needs you to create a list of the fields you want to remove and for each record just get the difference between the record and the keys to remove...

// Keys to remove (note as key rather than value)
$remove = ["from" => 1, "to" => 1];
$finalArray = [];
foreach ($array as $record) {
    $finalArray[] = array_diff_key($record, $remove);
}
print_r($finalArray);

score 2 · Answer 3 · answered Apr 23 '20 at 14:03

2

Try This

$result = [];
foreach($yourArray as $key => $value){
  unset($value['from']);
  unset($value['to']);        //You can unset as many columns as you want specifically.
  $result[] = $value;
}
print_r($result);

answered Apr 23 '20 at 14:03

Sandesh

46
2

How to remove multiple columns from the multi dimensional array?

3 Answers3