PHP Array of arrays of arrays

Question

I am trying to search this array by the value of ['field'] and then return the value of ['value'] associated with that field in the array.

For example, I want to say "Tell me the value associated with theThirdField".

I've tried many, many permutations of something like the following: $myVariable = $Array['result']['totalrows'][0]['rownum'][0]['field'];

To further clarify, I will never know which order / sub-array my search field is located in, I only know the string value associated with ['field'].

How would I accomplish this?

Array
(
    [result] => Array
        (
            [totalrows] => 1
            [rows] => Array
                (
                    [0] => Array
                        (
                            [rownum] => 1
                            [values] => Array
                                (
                                    [0] => Array
                                        (
                                            [field] => testMeOnce
                                            [value] => 436586498
                                        )

                                    [1] => Array
                                        (
                                            [field] => testMeTwice
                                            [value] => 327698034
                                        )

                                    [2] => Array
                                        (
                                            [field] => theThirdField
                                            [value] => 108760374
                                        )

                                    [3] => Array
                                        (
                                            [field] => theFourthField
                                            [value] => 2458505
                                        )

                                    [4] => Array
                                        (
                                            [field] => fifthField
                                            [value] => -0.0201
                                        )

                                )

                        )

                )

        )

)

Do you have some error when try to do that?

Professor Zoom
– Professor Zoom

2017-05-09 20:57:49 +00:00
Commented May 9, 2017 at 20:57 — Professor Zoom
– Professor Zoom, Commented May 9, 2017 at 20:57

Adam W. · Accepted Answer · 2017-05-09 21:11:47Z

1

Did you expect something like that?

$needle = 'theThirdField'; // searched field name
$valuesArray = $Array['result']['rows'][0]['values']; //now you have clearer array

array_walk($valuesArray, function($element, $key) use ($needle) {
    if ($element['field'] == $needle) {
        echo $element['value'];
    }
});

answered May 9, 2017 at 21:11

Adam W.

2021 silver badge5 bronze badges

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

Comments

Mike Casan Ballester · Accepted Answer · 2017-05-09 21:28:32Z

1

I would do something like this, assuming you want to search only in the $myVariable dimension :

$myVariable = $Array['result']['rows'][0]['values'];

foreach ($myVariable as $key => $value) {
    if( $value['field'] === 'theThirdField' ) { 
        echo $value['value']; 
        break;
    }
}

answered May 9, 2017 at 21:28

Mike Casan Ballester

1,77021 silver badges35 bronze badges

Comments

joowtjuh · Accepted Answer · 2017-05-09 21:36:05Z

when I ran your code, I got some syntax errors. I have changed your Array to this (changed syntax only):

$a = Array
    (
        'result' =>
            [
                'totalrows' => 1,
                'rows' =>
                    [
                        0 =>
                            [
                                'rownum' => 1,
                                'values' =>
                                    [
                                        0 => 
                                            [
                                                'field' => 'testMeOnce',
                                                'value' => 436586498
                                            ],

                                        1 => 
                                            [
                                                'field' => 'testMeTwice',
                                                'value' => 327698034
                                            ],

                                        2 => 
                                            [
                                                'field' => 'theThirdField',
                                                'value' => 108760374
                                            ],

                                        3 => 
                                            [
                                                'field' => 'theFourthField',
                                                'value' => 2458505
                                            ],

                                        4 => 
                                            [
                                                'field' => 'fifthField',
                                                'value' => -0.0201
                                            ]

                                    ]

                            ]

                    ]

            ]

    );

now you can get the value like this:

print($a['result']['rows'][0]['values'][2]['value']); // --> 108760374

I hope that this is what you are looking for!

JackBurton · Accepted Answer · 2017-05-10 00:34:18Z

0

Thanks everyone. I used a mix of your suggestions and ended up doing the following:

$valuesArray = $Array['result']['rows'][0]['values'];

foreach ($valuesArray as $value) {
    $fieldName = $value['field'];
    $$fieldName = $value['value'];
}

Since I know the names of all the fields I want, but not the order, this allowed me to capture all of the values of each field with the name of the field becoming the variable name.

answered May 10, 2017 at 0:34

JackBurton

2631 gold badge4 silver badges13 bronze badges

Collectives™ on Stack Overflow

PHP Array of arrays of arrays

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related