PHP match values between 2 arrays not same key

Question

I have made researches and havent fount any solutions for this yet. So final thought is come to Stackoverflow and ask the question.

I have 2 array like below:

BigArray

Array
(
    [0] => Array
        (
            [id] => 1
            [category_name] => Accountancy
            [category_name_vi] => Kế toán
            [category_id] => 1
        )

    [1] => Array
        (
            [id] => 2
            [category_name] => Armed forces
            [category_name_vi] => Quân đội
            [category_id] => 2
        )

    [2] => Array
        (
            [id] => 3
            [category_name] => Admin & Secretarial
            [category_name_vi] => Thư ký & Hành chính
            [category_id] => 3
        )

    [3] => Array
        (
            [id] => 4
            [category_name] => Banking & Finance
            [category_name_vi] => Tài chính & Ngân hàng
            [category_id] => 4
        )
)

and SmallArray:

Array
(
    [0] => Array
        (
            [id] => 7
            [category_id] => 2
            [jobseeker_id] => 1
        )

    [1] => Array
        (
            [id] => 8
            [category_id] => 3
            [jobseeker_id] => 1
        )
)

Ok, now I wanted to match each category_id from SmallArray link with respectively category_name from BigArrayand the output I only need matched values between SmallArray and BigArraywhere category_id of SmallArray is key and category_name of BigArray is value like below:

Matched array:

Array
    (
        [0] => Array
            (
                [2] => Armed forces                    
            )

        [1] => Array
            (
                [3] => Admin & Secretarial
            )
    )

So far, I have tried array_intersect, 2 foreach loops but no luck. Any advise would be very appreciated :(

Thanks

Ali Farhoudi · Accepted Answer · 2016-03-21 10:58:52Z

1

This should do that:

foreach ($smallArray as $smallKey => $smallElement) {
    foreach ($bigArray as $bigKey => $bigElement) {
        if ($bigElement['id'] == $smallElement['category_id']) {
            $smallArray[$smallKey] = array(
                $bigElement['id'] => $bigElement['category_name'],
            );
            break; // for performance and no extra looping
        }
    }
}

After these loops, you have what you want in $smallArray.

answered Mar 21, 2016 at 10:58

Ali Farhoudi

6,1487 gold badges29 silver badges49 bronze badges

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

2 Comments

SonDang Over a year ago

btw, these 2 arrays are get directly from 2 tables in database (BigArray and SmallArray table). Do you think I should add extra column in smallArray table name "category_name" and insert category name to speed up performance instead do foreach loops like above ? :)

Ali Farhoudi Over a year ago

No, not a good idea :) . They are completely separate concepts. There are other ways to improve performance. If you are reading from database then the best way is join tables (on product.category_id=category.id) when you are querying.

Collectives™ on Stack Overflow

PHP match values between 2 arrays not same key

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related