php array search from multidimensional array by single or multiple word

Question

I've a multidimensional array. I want to search in array using single or double word inside it and return the array's that contain any matched word...

Here is my example array:

$array = array(
            array('First_name' => 'Dina', 'Last_Name' => 'Gomez', 'Location' => 'Los Angeles, CA', 'Work' => 'Youtube Service')
            array('First_name' => 'Lopa', 'Last_Name' => 'Mitchel', 'Location' => 'New York, NY', 'Work' => 'Works with Mark')
            array('First_name' => 'Mark ', 'Last_Name' => 'Nailson Jr.', 'Location' => 'Dallas, USA', 'Work' => 'SEO Industry')
            array('First_name' => 'Jenna', 'Last_Name' => 'Gomez', 'Location' => 'Florida, CA', 'Work' => 'Work at Youtube')
            );

Now If someone search "Gomez" then it should return 1st and last array..I can do it using in_array() but problem is this, I in_array() only return exact match. I want partial match content too.. like if someone search "Mark Gomez" then it should return 1st array, last array for "Gomez" and 2nd & third array for "Mark" .. 2nd array has "Mark" word at Work Key.

I collect a function from another stackoverflow answer.. which is only work for exact match.. or for some key's only..

function checkarrayvalues($term, $arr, $strict = false, $partial = false) {
        if ($partial) {  // whether it should perform a partial match
            $fn = ($strict) ? "strpos" : "stripos";
        }
        foreach ($arr as $item) {
            if (is_array($item)) {
                if (checkarrayvalues($term, $item, $strict, $partial))
                    return true;
            } elseif (($partial && call_user_func($fn, $item, $term) !== false) 
                    || ($strict ? $item === $term : $item == $term)) {
                return true;
            }
        }
        return false;
    }

    var_dump(checkarrayvalues($query, $results, false, true));

I also tried array_search function :( No luck.

Please help :(

Have you looked into ElasticSearch? This is what it excels at. — Latheesan
– Latheesan, Commented Apr 17, 2018 at 22:47
Your function checkarrayvalues() returns a boolean. Do you want to return data or a boolean? — Syscall
– Syscall, Commented Apr 18, 2018 at 11:26
currently I want Boolean.. but I'll use this later to show data & I know how to do that — I Am Stack
– I Am Stack, Commented Apr 18, 2018 at 18:03
@Syscall .. currently I'm using an alternative method .. see my code here: http://prntscr.com/j71luo but if you have any easy and handy way, please share — I Am Stack
– I Am Stack, Commented Apr 18, 2018 at 19:12

Syscall · Accepted Answer · 2018-04-18 19:41:54Z

1

You were very close. You can explode the input terms and search them separately to find occurrences in the array. Then, you cannot return directly the value of the recursive array, because you'll break the loop. You can use a variable and return it at the end of the loop

Here is a demo.

The function :

function checkarrayvalues(&$out, $terms, $input, $strict = false, $partial = false) {

    if ($partial) {  // whether it should perform a partial match
        $fn = ($strict) ? "strpos" : "stripos";
    }

    $found = false ;
    foreach ($input as $key => $item) {
        if (is_array($item)) {
            if (checkarrayvalues($out, $terms, $item, $strict, $partial)) {
                $found = true;
            }
        }
        else {
            foreach ($terms as $term) {
                if (($partial && call_user_func($fn, $item, $term) !== false)
                    || ($strict ? $item === $term : $item == $term))
                {
                    $out[] = ['item' => $item, 'key' => $key] ;
                    $found = true;
                }
            }
        }
    }
    return $found;
}

Usage:

$array = [
    ['First_name' => 'Dina', 'Last_Name' => 'Gomez', 'Location' => 'Los Angeles, CA', 'Work' => 'Youtube Service'],
    ['First_name' => 'Lopa', 'Last_Name' => 'Mitchel', 'Location' => 'New York, NY', 'Work' => 'Works with Mark'],
    ['First_name' => 'Mark', 'Last_Name' => 'Nailson Jr.', 'Location' => 'Dallas, USA', 'Work' => 'SEO Industry'],
    ['First_name' => 'Jenna', 'Last_Name' => 'Gomez', 'Location' => 'Florida, CA', 'Work' => 'Work at Youtube'],
];


$out = [];
if (checkarrayvalues($out, ["New York"], $array, false, false)) {
    print_r($out);
}
$out = [];
if (checkarrayvalues($out, ["Mark","Gomez"], $array, false, false)) {
    print_r($out);
}
$out = [];
if (checkarrayvalues($out, ["Mark"], $array, false, true)) {
    print_r($out);
}

Outputs:

Array ( [0] => Array ( [item] => New York, NY [key] => Location ) ) 
Array ( [0] => Array ( [item] => Gomez [key] => Last_Name ) [1] => Array ( [item] => Mark [key] => First_name ) [2] => Array ( [item] => Gomez [key] => Last_Name ) ) 
Array ( [0] => Array ( [item] => Works with Mark [key] => Work ) [1] => Array ( [item] => Mark [key] => First_name ) )

Of course, instead of storing the item, you could store the $input, or the index.

edited Apr 18, 2018 at 19:41

answered Apr 18, 2018 at 19:14

Syscall

19.8k10 gold badges44 silver badges60 bronze badges

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

3 Comments

I Am Stack Over a year ago

Thanks for your nice work. But its can't search within Location, Work array.. 3v4l.org/qYfZE

Syscall Over a year ago

@IAmStack But, for this case, you need partial match. But I'll update y answer.

I Am Stack Over a year ago

I need one more favor .. if I search "Dina Youtube" then it will return the most relevant array's that has Dina & Youtube both keyword..& is there any way to exclude a key from array search?

Collectives™ on Stack Overflow

php array search from multidimensional array by single or multiple word

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related