PHP multidimensional array search by value

Question

I have an array where I want to search the uid and get the key of the array   Examples  Assume we have the following 2-dimensional array    userdb   array      array           uid    gt   100            name    gt   Sandra Shush            pic square    gt   urlof100             array           uid    gt   5465            name    gt   Stefanie Mcmohn            pic square    gt   urlof100             array           uid    gt   40489            name    gt   Michael            pic square    gt   urlof40489             The function call search by uid 100   uid of first user  should return 0   The function call search by uid 40489  should return 2   I tried making loops  but I want a faster executing code

User · Answer

If question i e    a                     id    gt   5a96933414d48831a41901f2           discount amount    gt  3 29          discount id    gt   5a92656a14d488570c2c44a2                           id    gt   5a9790fd14d48879cf16a9e8           discount amount    gt  4 53          discount id    gt   5a9265b914d488548513b122                           id    gt   5a98083614d488191304b6c3           discount amount    gt  15 24          discount id    gt   5a92806a14d48858ff5c2ec3                           id    gt   5a982a4914d48824721eafe3           discount amount    gt  45 74          discount id    gt   5a928ce414d488609e73b443                          id    gt   5a982a4914d48824721eafe55           discount amount    gt  10 26          discount id    gt   5a928ce414d488609e73b443                   Ans    function searchForId  id   array         did 0       dia 0     foreach   array as  key   gt   val           if   val  discount id        id                dia    val  discount amount                did                      if  dia                  echo  dia          var dump  did            return null     print r searchForId  5a928ce414d488609e73b443   a

User · Answer

I want to check tha in the following array  arr is there  abc  exists in sub arrays or not   arr   array      array           title    gt   abc             Then i can use this   res   array search  abc   array column  arr   title     if  res             echo  exists     else       echo  notExists       I think This is the Most simple way to define

User · Answer

In later versions of PHP     5 5 0  you can use this one-liner    key   array search  100   array column  userdb   uid

User · Answer

Just share  maybe can like this   if    function exists  arraySearchMulti     function arraySearchMulti  search  key  array  returnKey false        foreach   array as  k   gt   val            if  isset  val  key                  if   string  val  key      string  search                    return   returnKey    k    val                          else              return  is array  val    arraySearchMulti  search  key  val  returnKey    null                       return null

User · Answer

Try this   lt  php  function recursive array search  needle  haystack        foreach  haystack as  key  gt  value             current key  key          if  needle    value OR  is array  value   amp  amp               recursive array search  needle  value      false                  return  current key                      return false        gt

User · Answer

I know this was already answered  but I used this and extended it a little more in my code so that you didn t have search by only the uid  I just want to share it for anyone else who may need that functionality   Here s my example and please bare in mind this is my first answer  I took out the param array because I only needed to search one specific array  but you could easily add it in  I wanted to essentially search by more than just the uid   Also  in my situation there may be multiple keys to return as a result of searching by other fields that may not be unique                param array multidimensional          param string value to search for  ie a specific field name like name first         param string associative key to find it in  ie field name                 return array keys               function search revisions  dataArray   search value   key to search               This function will search the revisions for a certain value            related to the associative key you are looking for           keys   array            foreach   dataArray as  key   gt   cur value                if   cur value  key to search      search value                     keys      key                                  return  keys          Later  I ended up writing this to allow me to search for another value and associative key  So my first example allows you to search for a value in any specific associative key  and return all the matches    This second example shows you where a value   Taylor   is found in a certain associative key  first name  AND another value  true  is found in another associative key  employed   and returns all matches  Keys where people with first name  Taylor  AND are employed            param array multidimensional      param string  search value The value to search for  ie a specific  Taylor      param string  key to search The associative key to find it in  ie first name     param string  other matching key The associative key to find in the matches for employed     param string  other matching value The value to find in that matching associative key  ie true         return array keys  ie all the people with the first name  Taylor  that are employed       function search revisions  dataArray   search value   key to search   other matching value   null   other matching key   null           This function will search the revisions for a certain value        related to the associative key you are looking for       keys   array        foreach   dataArray as  key   gt   cur value            if   cur value  key to search      search value                if  isset  other matching key   amp  amp  isset  other matching value                     if   cur value  other matching key      other matching value                         keys      key                                  else                      I must keep in mind that some searches may have multiple                    matches and others would not  so leave it open with no continues                   keys      key                                    return  keys      Use of function    data   array      array           cust group    gt  6           price    gt  13 21           price qty    gt  5            array           cust group    gt  8           price    gt  15 25           price qty    gt  4            array           cust group    gt  8           price    gt  12 75           price qty    gt  10            findKey   search revisions  data  8    cust group    10    price qty    print r  findKey     Result   Array    0    gt  2

User · Answer

for   i  0   i  lt  sizeof  allUsers    i                  NEEDLE1  firstname        NEEDLE2  emailAddress        sterm  Tofind        if isset  allUsers  i   NEEDLE1    amp  amp  isset  allUsers  i   NEEDLE2                          Fname   allUsers  i   NEEDLE1                Lname   allUsers  i   NEEDLE2                 pos1   stripos  Fname   sterm                pos2 stripos  Lname   sterm    not case sensitive               if  pos1     false    pos2     false                resultsMatched     allUsers  i                else                 continue                              Print r  resultsMatched     will give array for matched values even partially matched   With help of above code one can find any partially matched  data from any column in 2D array so user id can be found as required in question

User · Answer

Building off Jakub s excellent answer  here is a more generalized search that will allow the key to specified  not just for uid    function searcharray  value   key   array       foreach   array as  k   gt   val           if   val  key      value               return  k                   return null      Usage   results   searcharray  searchvalue   searchkey   array

User · Answer

I modified one of examples below description function array search  Function searchItemsByKey return all value s  by  key from multidimensional array   N levels   Perhaps   it would be useful for somebody  Example     arr   array        XXX   gt array                  YYY   gt  array                       AAA   gt  array                             keyN    gt  value1                                                        ZZZ   gt  array                       BBB   gt  array                             keyN    gt   value2                                                                                 result   searchItemsByKey  arr  keyN     print   lt pre gt    print r  result   print   lt pre gt       OUTPUT Array      0    gt  value1    1    gt  value2     Function code   function searchItemsByKey  array   key        results   array       if  is array  array           if  isset  array  key    amp  amp  key  array    key           results      array  key        foreach   array as  sub array           results   array merge  results  searchItemsByKey  sub array   key          return   results

User · Answer

Looks array filter will be suitable solution for this     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                PHP Code  lt  php   search   5465   found   array filter  userdb function  v  k  use   search     return  v  uid       search    ARRAY FILTER USE BOTH     With latest PHP third parameter is mandatory   Available Values - ARRAY FILTER USE BOTH OR ARRAY FILTER USE KEY     values  print r array values  found     keys    print r array keys  found

User · Answer

Here is one liner for the same    pic square    userdb array search  uid array column  userdb   uid      pic square

User · Answer

you can use this function      https   github com serhatozles ArrayAdvancedSearch   lt  php  include  ArraySearch php      query    a  Example World  and b gt   2      Array   array   a    gt  array  d    gt   2    array  a    gt   Example World   b    gt   2    array  c    gt   3    array  d    gt   4         Result   ArraySearch  Array  query 1    echo   lt pre gt    print r  Result   echo   lt  pre gt         Output     Array             0    gt  Array                            a    gt  Example World                b    gt  2

User · Answer

If you are using  PHP 5    5 5 0  you don t have to write your own function to do this  just write this line and it s done    If you want just one result    key   array search 40489  array column  userdb   uid       For multiple results   keys   array keys array column  userdb   uid    40489     In case you have an associative array as pointed in the comments you could make it with    keys   array keys array combine array keys  userdb   array column  userdb   uid    40489     If you are using PHP  lt  5 5 0  you can use this backport  thanks ramsey   Update  I ve been making some simple benchmarks and the multiple results form seems to be the fastest one  even faster than the Jakub custom function

User · Answer

searches a simple as well as multi dimension array     param type  needle     param type  haystack     return boolean     public static function in array multi  needle   haystack        needle   trim  needle       if  is array  haystack           return False       foreach  haystack as  key  gt  value           if is array  value                if self  in array multi  needle   value                   return True              else                self  in array multi  needle   value                     else         if trim  value      trim  needle     visibility fix               error log   value      needle setting visibility to 1 hidden                return True                       return False

User · Answer

a     x    gt    eee    ccc     b    gt    zzz       found   null   search    eee    array walk  a  function   k   v  use   search   amp  found        if  in array  search   k              found    v             var dump  found

User · Answer

function searchForId  id   array       foreach   array as  key   gt   val           if   val  uid        id               return  key                   return null      This will work  You should call it like this    id   searchForId  100    userdb     It is important to know that if you are using     operator compared types have to be exactly same  in this example you have to search string or just use    instead       Based on angoru answer  In later versions of PHP   gt   5 5 0  you can use one-liner    key   array search  100   array column  userdb   uid       Here is documentation  http   php net manual en function array-column php

User · Answer

I had to use un function which finds every elements in an array  So I modified the function done by Jakub Trunecek as follow   function search in array r  needle   array         found   array        foreach   array as  key   gt   val            if   val 1      needle                array push  found   val 1                        if  count  found     0          return  found      else         return null

User · Answer

Expanding on the function  mayhem created  this example would be more of a  fuzzy  search in case you just want to match part  most  of a search string    function searchArrayKeyVal  sKey   id   array        foreach   array as  key   gt   val            if  strpos strtolower  val  sKey    strtolower trim  id        false                return  key                           return false       For example the value in the array is Welcome to New York  and you wanted the first instance of just  New York

User · Answer

You can use array column for that   search value    5465    search key      uid    user   array search  search value  array column  userdb   search key     print r  userdb  user     5465 is the user ID you want to search  uid is the key that contains user ID and  userdb is the array that is defined in the question

User · Answer

Even though this is an old question and has an accepted answer  Thought i would suggest one change to the accepted answer   So first off  i agree the accepted answer is correct here   function searchArrayKeyVal  sKey   id   array       foreach   array as  key   gt   val           if   val  sKey      id               return  key                   return false      Replacing the preset  uid  with a parameter in the function instead  so now calling the below code means you can use the one function across multiple array types  Small change   but one that makes the slight difference          Array Data Of Users  userdb   array       array   uid    gt   100   name    gt   Sandra Shush   url    gt   urlof100         array   uid    gt   5465   name    gt   Stefanie Mcmohn   url    gt   urlof100         array   uid    gt   40489   name    gt   Michael   url    gt   urlof40489            Obtain The Key Of The Array  arrayKey   searchArrayKeyVal  uid    100    userdb   if   arrayKey   false        echo  Search Result      userdb  arrayKey   name      else       echo  Search Result can not be found       PHP Fiddle Example

User · Answer

No one else has used array reduce yet  so thought I d add this approach     find by uid    100    is in array   array reduce  userdb  function  carry   user  use   find by uid       return  carry    carry    user  uid        find by uid          Returns true  Gives you more fine control over the  search  logic than array search    Note that I have used strict equality here but you could opt for different comparison logic  The  carry means the comparison needs to be true once  and the final result will be TRUE

[php] PHP multidimensional array search by value

Examples related to php

Examples related to arrays

Examples related to multidimensional-array