johnitvn/json-query

Parser, create, edit, query and do validate json file.

Json Query

, _(*1)

A PHP library to parser, create, edit, query and do validate JSON., _(*2)

Installation

The preferred way to install this extension is through composer., _(*3)

Either run, _(*4)

php composer.phar require --prefer-dist johnitvn/json-query "*"

or add, _(*5)

"johnitvn/json-query": "*"

to the require section of your composer.json file., _(*6)

Usage

The library is intended to be used with nested json structures, or with json data that needs validation. Or in any situation where you would find it is easier to do something like this:, _(*7)

$document = new johnitvn\jsonquery\JsonDocument();
$document->addValue('/path/to/nested/array/-', array('firstName'=> 'Fred', 'lastName' => 'Blogg'));
$json = $document->toJson(true);

which will give you the following json:, _(*8)

{
    "path": {
        "to": {
            "nested": {
                "array": [
                    {
                        "firstName": "Fred",
                        "lastName": "Blogg"
                    }
                ]
            }
        }
    }
}

You can query this value by calling:, _(*9)

$person = $document->getValue('/path/to/nested/array/0');

and update it with:, _(*10)

$document->addValue('/path/to/nested/array/0/lastName', 'Bloggs');

and move it with:, _(*11)

$document->moveValue('/path/to/nested/array/0', '/users/-');
$document->tidy();
$json = $document->toJson(true);

to end up with:, _(*12)

{
    "users": [
        {
            "firstName": "Fred",
            "lastName": "Bloggs"
        }
    ]
}

then delete it with:, _(*13)

$document->deleteValue('/users/0');

Json Query includes an implementation of JSON Schema, version 4. This allows you to validate your data. The following example schema describes an array containing objects whose properties are all required and whose types are defined., _(*14)

$schema = '{
    "items": {
        "properties": {
            "firstName": {"type": "string"},
            "lastName": {"type": "string"}                  
        },
        "required": ["firstName", "lastName"]
    }
}';

Now when you try to add values, Jquery Query will only do so if they are valid. So you have to check., _(*15)

$document->loadSchema($schema);

$result = $document->addValue('/-', array('firstName'=> 'Fred', 'lastName' => 'Bloggs'));
# true

$result = $document->addValue('/-', array('firstName'=> 'Fred', 'lastName' => 3));
# false, lastName is not a string

$result = $document->addValue('/0', array('firstName'=> 'Fred'));
# true, required values are not checked when we are building

# but are checked if we validate directly

$result = $document->validate();
# false - required lastName is missing

Without a schema, any value can be added anywhere, of course, _(*16)