Get keys from multidimensional array according to other keys

Question

I have a multidimensional array like this which I converted from JSON:

Array (

    [1] => Array (
        [name] => Test
        [id]   => [1]
    )

    [2] => Array (
        [name] => Hello
        [id]   => [2]
    )
)

How can I return the value of id if name is equal to the one the user provided? (e.g if the user typed "Test", I want it to return "1")

Edit: Here's the code that works if anyone wants it:

$array = json_decode(file_get_contents("json.json"), true);
foreach($array as $item) {
    if($item["name"] == "Test")
        echo $item["id"];
}

and what have you tried?

mishu
– mishu

2014-02-25 12:25:32 +00:00
Commented Feb 25, 2014 at 12:25 — mishu
– mishu, Commented Feb 25, 2014 at 12:25

Jon · Accepted Answer · 2014-02-25 12:26:51Z

1

The classical solution is to simply iterate over the array with foreach and check the name of each row. When it matches your search term you have found the id you are looking for, so break to stop searching and do something with that value.

If you are using PHP 5.5, a convenient solution that works well with less-than-huge data sets would be to use array_column:

$indexed = array_column($data, 'id', 'name');
echo $indexed['Test']; // 1

answered Feb 25, 2014 at 12:26

Jon

439k85 gold badges756 silver badges820 bronze badges

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

Comments

Tuyoshi Vinicius · Accepted Answer · 2014-02-25 12:46:14Z

1

You can use this function

function searchObject($value,$index,$array) {
    foreach ($array as $key => $val) {
       if ($val[$index] === $value)
            return $val;
    }
    return null;
}

$MyObject= searchObject("Hello","name",$MyArray);
$id = $MyObject["id"];

answered Feb 25, 2014 at 12:46

Tuyoshi Vinicius

8618 silver badges22 bronze badges

Comments

Revolution88 · Accepted Answer · 2014-02-25 12:39:55Z

0

You can do it manually like, in some function:

   function find($items, $something){
       foreach($items as $item)
       {
          if ($item["name"] === $something)
             return $item["id"];
       }
       return false;
    }

edited Feb 25, 2014 at 12:39

answered Feb 25, 2014 at 12:27

Revolution88

7085 silver badges17 bronze badges

Comments

Nishant Solanki · Accepted Answer · 2014-02-25 12:26:23Z

0

here is the solution

$count = count($array);
$name = $_POST['name']; //the name which user provided
for($i=1;$i<=$count;$i++)
{
  if($array[$i]['name']==$name)
  {
   echo $i;
   break;
  }
}

enjoy

answered Feb 25, 2014 at 12:26

Nishant Solanki

2,1283 gold badges19 silver badges32 bronze badges

7 Comments

Jon Over a year ago

Using for instead of foreach is almost always a bad idea. In this case it makes the code unnecessarily brittle: if the input changes slightly it will stop working (or worse, working correctly all of the time).

Nishant Solanki Over a year ago

yeah you are right .. but I like to give the answers which are easy to understant for the asker ... @Jon

James Over a year ago

@NishantSolanki Well, I've never understood for loops :P The output: Unexpected $end on line 14

Nishant Solanki Over a year ago

@Will ..there is a problem in your array structure... [id]=>[2] ... the value should not be in square brackets.. it should be in commas ..

Jon Over a year ago

@NishantSolanki: I don't see how for is easier to understand than foreach. The manual itself says "The foreach construct provides an easy way to iterate over arrays."

|

Amal · Accepted Answer · 2014-02-25 12:41:47Z

0

Try this:

$name = "Test";

foreach($your_array as $arr){
  if($arr['name'] == $name){
     echo $arr['id'];
  }
}

edited Feb 25, 2014 at 12:41

Amal

76.8k18 gold badges133 silver badges154 bronze badges

answered Feb 25, 2014 at 12:27

Vinod VT

7,18912 gold badges54 silver badges78 bronze badges

Collectives™ on Stack Overflow

Get keys from multidimensional array according to other keys

5 Answers 5

Comments

Comments

Comments

7 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related