Implement array_search() functionality on the rows of a 2d array while requiring multiple associative matches in a row

Question

I want to search a key in a multidimensional array with two values in the condition.

I know how to search a multi-dimensional array with a single search condition:

$key = array_search($journee, array_column($data,'journee'));

but not more than that. Here is my array setup:

Array
(
    [0] => Array
        (
            [pseudo] => titi
            [journee] => 11
            [pts] => 3
        )

    ...
    [10] => Array
        (
            [pseudo] => test
            [journee] => 10
            [pts] => 6
        )

    [11] => Array
        (
            [pseudo] => test
            [journee] => 11
            [pts] => 4
        )

)

If I only put 11 in array_search and for array_column the key journee, it will return 0.

I want to add pseudo in the search condition too (the keys journee and pseudo should be searched for a specific values).

How would I accomplish this?

With one simple function it's not possible. With combination - it is. — u_mulder
– u_mulder, Commented Nov 4, 2016 at 11:49
so you want to search in json using both condition to be matched, journee and pseudo? — Rohan Khude
– Rohan Khude, Commented Nov 4, 2016 at 11:52

u_mulder · Accepted Answer · 2016-11-04 12:08:39Z

8

With one simple function it's not possible.

Here's a solution with two:

$search = ['pseudo' => 'test', 'journee' => 10];
$keys = array_keys(
    array_filter(
        $array,
        function ($v) use ($search) { return $v['pseudo'] == $search['pseudo'] && $v['journee'] == $search['journee']; }
    )
);
$key = $keys[0];

But if you need to find one key only I advise to use foreach & break, because you don't have to iterate over all array of values (what will happen with using array_filter) and stop immediately when certain data is found:

$key = false;
$search = ['pseudo' => 'test', 'journee' => 10];
foreach ($array as $k => $v) {
    if ($v['pseudo'] == $search['pseudo'] && $v['journee'] == $search['journee']) {
        $key = $k;
        // key found - break the loop
        break;
    }
}

edited Nov 4, 2016 at 12:08

answered Nov 4, 2016 at 11:53

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

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

6 Comments

Ruslan Osmanov Over a year ago

Even if he doesn't need to break after the first match, a simple loop is better. So the answer is reduced to use a simple loop =)

u_mulder Over a year ago

Explain why simple loop is better.

Ruslan Osmanov Over a year ago

1) loop is more readable, 2) loop is a single construct, while the former solution uses a lambda and two function calls, all joined into a complicated expression; thus, loop should be more productive

u_mulder Over a year ago

Thanks, now OP can decide what to use)

Progrock Over a year ago

Typo here most probably: $return ?

|

mickmackusa · Accepted Answer · 2023-12-27 21:55:56Z

0

To enjoy the efficiency of a conditionally halted loop while excluding the temporary variables from the global scope, use an Immediately Invoked Functional Expression. The qualifying row can be identified using array_diff_assoc() to check that all associative elements in the search array where matched in the given row. Demo

$search = ['pseudo' => 'test', 'journee' => 10];

var_export(
    (function($haystack, $needle) {
        foreach ($haystack as $i => $row) {
            if (!array_diff_assoc($needle, $row)) {
                return $i;
            }
        }
        return null;
    })($array, $search)
);
// output: 10

edited Dec 27, 2023 at 21:55

answered Dec 27, 2023 at 11:41

mickmackusa♦

49.2k13 gold badges98 silver badges165 bronze badges

Collectives™ on Stack Overflow

Implement array_search() functionality on the rows of a 2d array while requiring multiple associative matches in a row

2 Answers 2

6 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related