Search Array Values in Another multidimensional array php

Question

I have db array :

Array
(
    [28] => Array
        (
            [0] => child
            [1] => baby
            [2] => new d
            [3] => christmas
        )

    [29] => Array
        (
            [0] => christmas
        )

    [30] => Array
        (
            [0] => business
            [1] => stock
        )

    [32] => Array
        (
            [0] => apparel
            [1] =>  clothing
            [2] =>  contemporary apparel
        )

    [49] => Array
        (
            [0] => car rental
            [1] => car rent
            [2] => rent car
            [3] => rent a car
            [4] => car rentals
            [5] => car1 rentals1
        )
)

I have another array Search This array values in above array array ("christmas","apparel");

So I want the result : 28,29,32 (This is key of array)

have you tried anything?

Ares Draguna
– Ares Draguna

2014-12-05 11:30:12 +00:00
Commented Dec 5, 2014 at 11:30 — Ares Draguna
– Ares Draguna, Commented Dec 5, 2014 at 11:30

Sougata Bose · Accepted Answer · 2014-12-05 11:31:24Z

4

Try this -

$b = array("christmas","apparel");
$keys = array();
foreach ($dbArray as $key => $values) {
   $check = array_intersect($values, $b);
   if (!empty($check)) {
       $keys[] = $key;
   }
}

answered Dec 5, 2014 at 11:31

Sougata Bose

31.8k8 gold badges52 silver badges89 bronze badges

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

2 Comments

Yatin Mistry Over a year ago

If dbArray is too big means 10000 Records then i looping then will it takes too much time or not?

Sougata Bose Over a year ago

You should take care if there is very large number of records.I dont think (not sure) there would be any other solution to do this with php, rather you can do this with your query.

Veerendra · Accepted Answer · 2014-12-05 11:36:27Z

Below is a recursive function to search a value in multidimensional array.

function search_in_array($srchvalue, $array)
    {
        if (is_array($array) && count($array) > 0)
        {
            $foundkey = array_search($srchvalue, $array);
            if ($foundkey === FALSE)
            {
                foreach ($array as $key => $value)
                {
                    if (is_array($value) && count($value) > 0)
                    {
                        $foundkey = search_in_array($srchvalue, $value);
                        if ($foundkey != FALSE)
                            return $foundkey;
                    }
                }
            }
            else
                return $foundkey;
        }
    }

It will return you the key where the value is found. Don't forget to accept answer if it helps you

Collectives™ on Stack Overflow

Search Array Values in Another multidimensional array php

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related