PHP search associative array with values from another array

Question

I have two arrays one contains ids that's going to check if it exists on the second array which is an associative array:

Array 1: [1,2,11, 4]

Array 2:

[["id" => 1, "name" => "abc"], ["id" => 2, "name"=> "xyz"]]

Currently using a nested foreach to iterate over and match them but I wanted to know if there was anything more efficient as the arrays will be a lot larger.

$item = [1,2,11, 4];
$data = [["id" => 1, "name" => "abc"], ["id" => 2, "name"=> "xyz"]];

foreach($items as $item)
{
    foreach($data as $key => $products)
    {
        foreach($products as $product)
        {
            if($product['id'] == $item)
            {
                echo $product['name'];
            }
        }
    }
}

Had a look at this and this but none really fit my scenario.

Any help appreciated.

lukas.j · Accepted Answer · 2022-03-26 13:47:26Z

1

array_filter would be an option:

$ids = [ 1, 2, 11, 4 ];

$data = [ [ 'id' => 1, 'name' => 'abc' ], [ 'id' => 2, 'name' => 'xyz' ], [ 'id' => 3, 'name' => 'nono' ] ];

$result = array_filter($data, fn($value) => (in_array($value['id'], $ids)));

answered Mar 26, 2022 at 13:47

lukas.j

7,2442 gold badges9 silver badges30 bronze badges

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

Comments

M. Eriksson · Accepted Answer · 2022-03-26 13:48:37Z

1

You can use array_column() to get all product ids as an indexed array.

Then you can use array_intersect() to fetch the id's that exists in both arrays.

$item = [1,2,11, 4];
$products = [["id" => 1, "name" => "abc"], ["id" => 2, "name"=> "xyz"]];

// Get the ids of all products as an indexed array
$prodIds = array_column($products, 'id');

// Check the id's that exists in both
$existingIds = array_intersect($item, $prodIds);

Demo: https://3v4l.org/HJSoq

Of if you rather do it as a one-liner:

$existingIds = array_intersect($item, array_column($products, 'id'));

answered Mar 26, 2022 at 13:48

M. Eriksson

13.7k4 gold badges31 silver badges42 bronze badges

2 Comments

Abu Nooh Over a year ago

Thank you! How does this or the array_filter compare to the nested looping in terms of efficiency and/or cost?

M. Eriksson Over a year ago

I can't say since I haven't benchmarked it. However, this is two single function calls while the array_filter() will call in_array() for each product in your list, so if you have 100 products, it will iterate through them and call in_array() 100 times.

emomaliev · Accepted Answer · 2022-03-26 14:09:03Z

-1

You can also use the array_map and the anonymous function.

    $item = [1, 2, 11, 4];
    $products = [["id" => 1, "name" => "abc"], ["id" => 2, "name" => "xyz"]]; 
    
    $result = array_map(function ($row) use ($item) {
       return (in_array($row['id'], $item))?$row:false;
    }, $products);

Result dump:

Array
(
    [0] => Array
        (
            [id] => 1
            [name] => abc
        )

    [1] => Array
        (
            [id] => 2
            [name] => xyz
        )

)

edited Mar 26, 2022 at 14:09

answered Mar 26, 2022 at 14:03

emomaliev

2,4233 gold badges12 silver badges17 bronze badges

Collectives™ on Stack Overflow

PHP search associative array with values from another array

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related