Check if a specific value exists at a specific key in any subarray of a multidimensional array

Question

I need to search a multidimensional array for a specific value in any of the indexed subarrays   In other words  I need to check a single column of the multidimensional array for a value   If the value exists anywhere in the multidimensional array  I would like to return true otherwise false   my array   array          0   gt   array             name      gt   john              id       gt   4                1     gt   array             name    gt    mark              id    gt  152               2     gt   array             name    gt    Eduard              id    gt  152              I would like to know the fastest and most efficient way to check if the array  my array contains a value with the key  id    For example  if id   gt  152 anywhere in the multidimensional array  I would like true

User · Answer

function checkMultiArrayValue  array            global  test          foreach   array as  key   gt   item                 if  empty  item   amp  amp  is array  item                     checkMultiArrayValue  item                else                   if  item                    test  key     item                                   return  test              multiArray   array                      0   gt   array                           country      gt                               price       gt  4                           discount-price    gt  0                          test   checkMultiArrayValue  multiArray   echo   lt pre gt   print r  test     Will return array who have index and value

User · Answer

The simplest way is this    my array   array          0   gt   array             name      gt   john              id       gt   4                1     gt   array             name    gt    mark              id    gt  152               2     gt   array             name    gt    Eduard              id    gt  152             if  array search 152  array column  my array   id        FALSE    echo  FOUND    else   echo  NOT FOUND

User · Answer

TMTOWTDI  Here are several solutions in order of complexity   Short primer on complexity follows  O n  or  quot big o quot  means worst case scenario where n means the number of elements in the array  and o n  or  quot little o quot  means best case scenario  Long discrete math story short  you only really have to worry about the worst case scenario  and make sure it s not n   2 or n   It s more a measure of change in computing time as n increases than it is overall computing time  Wikipedia has a good article about computational aka time complexity  If experience has taught me anything  it s that spending too much time optimizing your programs  little-o is a distinct waste of time better spent doing something - anything - better  Solution 0  O n    o 1  complexity  This solution has a best case scenario of 1 comparison - 1 iteration thru the loop  but only provided the matching value is in position 0 of the array  The worst case scenario is it s not in the array  and thus has to iterate over every element of the array  foreach   my array as  sub array        if    sub array  id       152            return true          return false   Solution 1  O n    o n  complexity  This solution must loop thru the entire array no matter where the matching value is  so it s always going to be n iterations thru the array  return 0  lt  count      array filter           my array          function   a                return array key exists  id    a   amp  amp   a  id      152                      Solution 2  O n log n    o n log n  complexity  A hash insertion is where the log n comes from  n hash insertions   n   log n  There s a hash lookup at the end which is another log n but it s not included because that s just how discrete math works   existence hash       foreach   my array as  sub array         existence hash  sub array  id      true    return   existence hash  152

User · Answer

You can use this with only two parameter function whatever  array   val        foreach   array as  item          if  isset  item   amp  amp  in array  val  item               return 1      return 0

User · Answer

If you have to make a lot of  id  lookups and it should be really fast you should use a second array containing all the  ids  as keys    lookup array array     foreach  my array as  arr        lookup array  arr  id    1      Now you can check for an existing id very fast  for example   echo  isset  lookup array 152     yes   no

User · Answer

I came upon this post looking to do the same and came up with my own solution I wanted to offer for future visitors of this page  and to see if doing this way presents any problems I had not forseen    If you want to get a simple true or false output and want to do this with one line of code without a function or a loop you could serialize the array and then use stripos to search for the value   stripos serialize  my array   needle   It seems to work for me

User · Answer

Nothing will be faster than a simple loop  You can mix-and-match some array functions to do it  but they ll just be implemented as a loop too   function whatever  array   key   val        foreach   array as  item          if  isset  item  key    amp  amp   item  key      val              return true      return false

User · Answer

PHP    5 5  simply u can use this   key   array search 40489  array column  userdb   uid       Let s suppose this multi dimensional array    userdb Array    0    gt  Array                uid    gt   100            name    gt   Sandra Shush            url    gt   urlof100           1    gt  Array                uid    gt   5465            name    gt   Stefanie Mcmohn            pic square    gt   urlof100           2    gt  Array                uid    gt   40489            name    gt   Michael            pic square    gt   urlof40489             key   array search 40489  array column  userdb   uid

User · Answer

As in your question  which is actually a simple 2-D array wouldn t it be better  Have a look-  Let say your 2-D array name  my array and value to find is  id  function idExists  needle      haystack array           now go through each internal array     foreach   haystack as  item            if   item  id      needle                return true                      return false      and to call it   idExists  id   my array     As you can see  it actually only check if any internal index with key name  id  only  have your  value  Some other answers here might also result true if key name  name  also has  value

User · Answer

Try with this below code  It should be working fine for any kind of multidimensional array search   Here you can see LIVE DEMO EXAMPLE  function multi array search  search for   search in        foreach   search in as  element            if     element      search for                 return true           elseif is array  element                 result   multi array search  search for   element               if  result    true                  return true                      return false

User · Answer

I wrote the following function in order to determine if an multidimensional array partially contains a certain value   function findKeyValue   array   needle   value   found   false       foreach   array as  key   gt   item              Navigate through the array completely          if  is array  item                 found    this- gt findKeyValue  item   needle   value   found                         If the item is a node  verify if the value of the node contains            the given search parameter  E G    value   lt   gt   This contains the value          if     empty  key   amp  amp   key     needle  amp  amp  strpos  item   value      false               return true                       return  found      Call the function like this    this- gt findKeyValue  array   key   value

User · Answer

A good solution can be one provided by  Elias Van Ootegan in a comment that is    ids   array column  array   id    id    echo isset  ids 40489    Exist   Not Exist     I tried it and worked for me  thanks buddy   Edited  Note  It will work in PHP 5 5

User · Answer

Here is an updated version of Dan Grossman s answer which will cater for multidimensional arrays  what I was after    function find key value  array   key   val        foreach   array as  item                if  is array  item   amp  amp  find key value  item   key   val   return true           if  isset  item  key    amp  amp   item  key      val  return true             return false

[php] Check if a specific value exists at a specific key in any subarray of a multidimensional array

Examples related to php

Examples related to arrays

Examples related to search

Examples related to multidimensional-array

Examples related to array-column