Get a column of values from the specified subarray of a multidimensional array [duplicate]

Question

I have an array which contains some data. for example:

$data = array(
    'CATEGORY 1' => array(
        array('id'=> 0, 'name' => 'John', 'category' => 'CATEGORY1'),
        array('id'=> 1, 'name' => 'Jack', 'category' => 'CATEGORY1'),
        array('id'=> 2, 'name' => 'Jame', 'category' => 'CATEGORY1'),
    ),
    'CATEGORY 2' => array(
        array('id'=> 0, 'name' => 'Mile', 'category' => 'CATEGORY2'),
        array('id'=> 1, 'name' => 'Mike', 'category' => 'CATEGORY2'),
        array('id'=> 2, 'name' => 'Matt', 'category' => 'CATEGORY2'),
    )
);

Now how can I write a function like this:

if ($post ='CATEGORY 1') {
    // filter all the name where category => CATEGORY1
}

Expected output:

['John', 'Jack', 'Jame']

I have tried like so:

$filters = array(
    "id" => array(
        "filter" => FILTER_VALIDATE_INT,
        "flags" => FILTER_FORCE_ARRAY,
        "options" => array(
            "min_range" => 1,
            "max_range" => 120
        )
    ),
    "name" => array(
        "filter" => FILTER_CALLBACK,
        "options" => "ucwords"                   
    ),
    "category" => array(
        "filter" => FILTER_CALLBACK,
        "options" => "ucwords"
    )
);

print_r(filter_var_array($data, $filters));

But that returns me null. How can I search within the array with the condition where category is category1 and fetch all the names which belongs to that?

@Uchiha thanks i have actually tried so but do not know where to put the condition in foreach where category is category1 ... — Istiak Mahmood
– Istiak Mahmood, Commented Oct 10, 2015 at 9:14
This isn't a filtration task, this is an array access task. In other words, you don't need to remove anything, just access the isolated data set. $data['CATEGORY 1'] targets the sub array. array_column() can isolate the name values. — mickmackusa
– mickmackusa ♦, Commented Nov 22, 2024 at 23:24

Tim Sheehan · Accepted Answer · 2015-10-10 09:25:46Z

2

<?php
$data = array(

    'CATEGORY 1' => array(
        array('id'=> 0, 'name' => 'John', 'category' => 'CATEGORY1'),
        array('id'=> 1, 'name' => 'Jack', 'category' => 'CATEGORY1'),
        array('id'=> 2, 'name' => 'Jame', 'category' => 'CATEGORY1'),
    ),
    'CATEGORY 2' => array(
        array('id'=> 0, 'name' => 'Mile', 'category' => 'CATEGORY2'),
        array('id'=> 1, 'name' => 'Mike', 'category' => 'CATEGORY2'),
        array('id'=> 2, 'name' => 'Matt', 'category' => 'CATEGORY2'),
    )

);

$post = 'CATEGORY 1';
$pluck = 'name';

var_dump( array_reduce($data['CATEGORY 1'], function($result, $array) use ( $pluck ) {
    isset($array[$pluck]) && $result[] = $array[$pluck];
    return $result;
}, array()));

answered Oct 10, 2015 at 9:25

Tim Sheehan

4,0141 gold badge17 silver badges18 bronze badges

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

Comments

Narendrasingh Sisodia · Accepted Answer · 2015-10-10 09:33:52Z

2

Simply use foreach like as

$result = [];
foreach($data as $value){
  foreach($value as $k => $v){
      if($v['category'] == 'CATEGORY1')
        $result[] = $v['name'];
  }
}
print_r($result);

Demo

answered Oct 10, 2015 at 9:33

Narendrasingh Sisodia

21.4k6 gold badges51 silver badges54 bronze badges

Comments

Jitendra Kumar. Balla · Accepted Answer · 2015-10-10 09:26:37Z

1

Bellow code will help you out

<?php
$data = array(

    'CATEGORY 1' => array(
        array('id'=> 0, 'name' => 'John', 'category' => 'CATEGORY1'),
        array('id'=> 1, 'name' => 'Jack', 'category' => 'CATEGORY1'),
        array('id'=> 2, 'name' => 'Jame', 'category' => 'CATEGORY1'),
    ),
    'CATEGORY 2' => array(
        array('id'=> 0, 'name' => 'Mile', 'category' => 'CATEGORY2'),
        array('id'=> 1, 'name' => 'Mike', 'category' => 'CATEGORY2'),
        array('id'=> 2, 'name' => 'Matt', 'category' => 'CATEGORY2'),
    )

);

$post='CATEGORY 1';
$elements=$data[$post];
$names=array();
foreach ($elements as $ele) {
$names[]=$ele['name'];
}

print_r($names);

click here get realtime output

answered Oct 10, 2015 at 9:26

Jitendra Kumar. Balla

1,2131 gold badge10 silver badges15 bronze badges

Collectives™ on Stack Overflow

Get a column of values from the specified subarray of a multidimensional array [duplicate]

3 Answers 3

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Linked

Related