Select array values based on another array

Question

I have 2 arrays : “Array-List” and “Array-Criteria” :

Array-List
(
    [1] => APPLE
    [2] => BANANA
    [3] => ORANGE
    [4] => LEMON
)

Array-Criteria
(
    [0] => 1
    [1] => 3
)

Is there a quick way (my Array-List can consist of thousands of entries) to select the values from Array-List based on Array-Criteria without looping through Array-List in PHP?

What is the expected result? Have you had a look at array_filter? — Nico Haase
– Nico Haase, Commented Oct 10, 2018 at 15:01
$arrayList[$arrayCriteria[1]] => "Orange" - Is that what you mean? If not: How is criteria else connected to the list? — Jeff
– Jeff, Commented Oct 10, 2018 at 15:01
what are you actually looking for? Select what values? How do the arrays link up? — treyBake
– treyBake, Commented Oct 10, 2018 at 15:02
If it would be SQL, it would be SELECT value FROM Array-List WHERE key IN (SELECT value FROM Array-Criteria) — flaggalagga
– flaggalagga, Commented Oct 10, 2018 at 15:05

Gufran Hasan · Accepted Answer · 2018-10-10 15:14:46Z

3

Use array_intersect_key and array_flip functions to get data as:

$arr1 = Array-List
(
    [1] => APPLE
    [2] => BANANA
    [3] => ORANGE
    [4] => LEMON
)

$arr2 = Array-Criteria
(
    [0] => 1
    [1] => 3
)



var_dump(array_intersect_key($arr1, array_flip($arr2)));

edited Oct 10, 2018 at 15:14

answered Oct 10, 2018 at 15:03

Gufran Hasan

9,4297 gold badges44 silver badges57 bronze badges

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

1 Comment

flaggalagga Over a year ago

Thank you so very much. This was exactly what I was looking for !

Nigel Ren · Accepted Answer · 2018-10-10 15:28:18Z

0

If you loop over the criteria, you can build a list of the macthing items...

$selected = [];
foreach ( $arrayCriteria as $element ) {
    $selected[] = $arrayList[$element];
}

Then $selected will be a list of the items your after.

Also in a quick test, it's about twice as fast as using the array_ methods.

edited Oct 10, 2018 at 15:28

answered Oct 10, 2018 at 15:05

Nigel Ren

57.3k11 gold badges49 silver badges59 bronze badges

4 Comments

flaggalagga Over a year ago

True, but it's still a loop involved. I think Gufran Hasan's solution is slicker.

Nigel Ren Over a year ago

Not disagreeing with the other answer being good, but any solution will involve a loop.

flaggalagga Over a year ago

I did some speed tests and array_intersect_key solution seems to be the fastest.

Nigel Ren Over a year ago

Difficult to know as it's all affected by the number of entries etc. But as I said, I tried it and found this to take 1/2 the time in my tests.

Collectives™ on Stack Overflow

Select array values based on another array

2 Answers 2

1 Comment

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest