PHP Search JSON for value

Question

So I have a json object which has a structure like so:

{
"John Doe": [
    {
        "childName": "Harry",
        "childAge": 15,
        "childGender": "Male"
    },
    {
        "childName": "Sally",
        "childAge": 9,
        "childGender": "Female"
    },
],
"Miss Piggy": [
    {
        "childName": "Jane",
        "childAge": 20,
        "childGender": "Female"
    }
],

}

What I want to do is be able to make a query for the childName, childAge, or childGender, and return that sub-object if it's found.

For example:

searchJson($jsonObj, 'childName', 'Sally') // returns {"childName":"Sally", "childAge":9,"childGender":"Female"}

What would be the best method at going at this?

score 17 · Accepted Answer · 2013-03-05 22:34:35Z

17

function searchJson($obj, $field, $value) {
    foreach($obj as $item) {
        foreach($item as $child) {
            if(isset($child->$field) && $child->$field == $value) {
                return $child;
            }
        }
    }
    return null;
}

edited Mar 5, 2013 at 22:34

answered Jan 1, 2012 at 1:21

user142162

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

2 Comments

user142162 Over a year ago

@JosephSilber: $obj is a stdClass object, which would be the result of json_decode().

Mischa Over a year ago

Is there a way to do it without looping through everything? E.g. returning json as an associative array and then using array_ functions to get what you need?

Collectives™ on Stack Overflow

PHP Search JSON for value

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related