Check if value exist in array and get array from multidimensional array

Question

I have below PHP array:

Array ( 
       [0] => Array ( [policy_id] => 1 [category_id] => 5 [limit_amount] => 11.00 [limit_amount2] => 23.00 ), 
       [1] => Array ( [policy_id] => 1 [category_id] => 7 [limit_amount] => 32.00 [limit_amount2] => 23.00 ), 
       [2] => Array ( [policy_id] => 1 [category_id] => 4 [limit_amount] => 12.00 [limit_amount2] => 12.00 ) )

Now i want to do two things:

Want to check if category_id = 7 exists in this array or not, and if it is there.
then i would like to get that complete array from this multidimensional array,

Example, if category_id = 7 is in array then it should output

Array ([policy_id] => 1 ,
       [category_id] => 7 ,
       [limit_amount] => 32.00,
       [limit_amount2] => 23.00 )

I tried to use in_array(), but could not get required values,

Thanks for help,

Possible duplicate of PHP multidimensional array search by value — yoeunes
– yoeunes, Commented Aug 21, 2017 at 8:57

trincot · Accepted Answer · 2017-08-21 08:59:00Z

5

You can use array_column before doing the array_search (I assume your data is in $array):

$match = $array[array_search(7, array_column($array, "category_id"))];

If you need to first check whether the entry really exists, then first check the return value of array_search, and return something distinctive when the value is not found, e.g. false:

$index = array_search(7, array_column($array, "category_id"));
$match = $index === false ? false : $array[$index];

edited Aug 21, 2017 at 8:59

answered Aug 21, 2017 at 8:28

trincot

357k38 gold badges282 silver badges338 bronze badges

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

5 Comments

axiac Over a year ago

It's worth mentioning that array_column() is available only in PHP 5.5 and newer.

trincot Over a year ago

... and that all PHP versions up to 5.5 have end of life status, i.e. they are no longer supported ;-)

axiac Over a year ago

Sure, but no longer supported is not the same as no longer in use.

yoeunes Over a year ago

@trincot what if 7 does not exists in the array, this will always show the first item of the multidimentional array

trincot Over a year ago

@younes, I added the code to return false if the value is not in the array. Thanks!

axiac · Accepted Answer · 2017-08-21 09:06:30Z

There are multiple ways to achieve your goal. This is a solution that uses array_filter():

$input = array(
    array('policy_id' => 1 , 'category_id' => 5 , 'limit_amount' => 11.00 , 'limit_amount2' => 23.00, ),
    array('policy_id' => 1 , 'category_id' => 7 , 'limit_amount' => 32.00 , 'limit_amount2' => 23.00, ),
    array('policy_id' => 1 , 'category_id' => 4 , 'limit_amount' => 12.00 , 'limit_amount2' => 12.00, ),
);

$categoryId = 7;
$output = array_filter(
    $input,
    function (array $item) use ($categoryId) {
        return $item['category_id'] == $categoryId;
    }
);
print_r($output);

The output is:

Array
(
    [1] => Array
        (
            [policy_id] => 1
            [category_id] => 7
            [limit_amount] => 32
            [limit_amount2] => 23
        )
)

The code above finds all entries from $input that have 7 in category_id, associated to the original keys in $input.

You can enumerate $output using foreach ($output as item) { ... } or, if you need only the first match you can get it using current():

print_r(current($output));

produces:

Array
(
    [policy_id] => 1
    [category_id] => 7
    [limit_amount] => 32
    [limit_amount2] => 23
)

Update:

If the item cannot be found in the input list (f.e. when $categoryId = 1;), $output is an empty array (array()). It can still be enumerated using foreach but current($output) returns FALSE.

All in all, the code:

$categoryId = 7;
$output = current(array_filter(
    $input,
    function (array $item) use ($categoryId) {
        return $item['category_id'] == $categoryId;
    }
));

puts in $output the first item found or FALSE if there is none.

Tan Bui · Accepted Answer · 2017-08-21 08:24:40Z

0

With that problem u can use foreach array to check exists it! I had make a function for that:

function checkArray($cat_id){
  foreach($arr as $index => $value){
    if($value->category_id == $cat_id){
      return $arr[$index];
    }
    return false;
  }
}

if $cat_id exists return array u need, and if not exists return false

answered Aug 21, 2017 at 8:24

Tan Bui

1373 silver badges11 bronze badges

1 Comment

aslawin Over a year ago

This is array of arrays, so you should check index, not object property: if($value[$category_id] == $cat_id){ ...

MrChux · Accepted Answer · 2017-08-21 08:46:16Z

0

$val = 7;
$key = 'category_id';

foreach ($array as $item){
    if (isset($item[$key]) && $item[$key] === $val)
            print_r($item);
   }

answered Aug 21, 2017 at 8:46

MrChux

1201 silver badge10 bronze badges

Collectives™ on Stack Overflow

Check if value exist in array and get array from multidimensional array

4 Answers 4

5 Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

5 Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related