PHP: How can I get the value from a key in a multiple array

Question

The multiple array looks like

Array
(
    [id] => description
    [header] => 
    [width] => 20
    [dbfield] => description
    [type] => text
)
Array
(
    [id] => quantity
    [header] => Menge
    [dbfield] => QUANTITY_NEW
    [width] => 60
    [type] => decimal
)

How can I get the value from dbfield where id is 'quantity' without knowing the numeric value of the id?

The actual code looks like

foreach($array as $id => $fieldData) {

   if($fieldData['type'] == 'decimal') 
   {
     doSomething...();
   }
}

In the part with doSomething I need access to other fields from the array, but I only know the id. I already tried it with dbfield['quantity']['dbfield'] etc. which obviously fails.

Can you show any code attempts? My first suggestion would be to think about how to derive a data structure against which you can perform the lookup you want. Beyond that, you should at least be able to cobble together a brute force approach and show you efforts here. — Mike Brant
– Mike Brant, Commented Aug 18, 2014 at 13:51
possible duplicate of PHP - Accessing Multidimensional Array Values — ɴᴀᴛᴇ ᴅᴇᴠ
– ɴᴀᴛᴇ ᴅᴇᴠ, Commented Aug 18, 2014 at 13:51

ilpaijin · Accepted Answer · 2014-08-18 14:12:12Z

1

A simple alternative using array_keys:

function getValues($data, $lookForValue, $column)
{
    $res = array();

    foreach ($data as $key => $data) 
    {
        if($idx = array_keys($data, $lookForValue))
        {
            $res[$idx[0]] = $data[$column];
        }
    } 

    return $res;
}

$values = getValues($myData, "quantity", "dbfield");

var_dump($values);

answered Aug 18, 2014 at 14:12

ilpaijin

3,7152 gold badges25 silver badges26 bronze badges

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

Comments

Arrow · Accepted Answer · 2014-08-19 07:18:27Z

1

echo out the array as such..

$array = array();

$array['qty'] = 'qtty';
$array['dbfield'] = 'QUANTITY_NEW';

if($array['qty'] = 'qtty'){

echo $array['dbfield'];

} 

returns - QUANTITY_NEW

edited Aug 19, 2014 at 7:18

answered Aug 18, 2014 at 13:58

Arrow

497 bronze badges

Comments

hlscalon · Accepted Answer · 2014-08-18 13:55:08Z

0

You can do this with several methods, one of them is using array_map to get those values:

$dbfield = array_filter(array_map(function($a){
    if($a["id"] === "quantity"){
        return $a["dbfield"];
    }
}, $array));

print_r($dbfield);

You iterate over the array, and return the key dbfield where id is 'quantity'. Array filter is just to not return null values where it doesn't have 'quantity' id.

Online attempt to reproduce your code can be found here

answered Aug 18, 2014 at 13:55

hlscalon

7,6004 gold badges35 silver badges41 bronze badges

Collectives™ on Stack Overflow

PHP: How can I get the value from a key in a multiple array

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related