Stars: 179
Forks: 34
Pull Requests: 30
Issues: 36
Watchers: 13
Last Updated: 2023-03-05 19:46:24
A JsonPath implementation in PHP
License: Apache License 2.0
Languages: PHP
This is a JSONPath implementation for PHP.
This implementation features all elements in the specification except the ()
operator (in the spcecification there is the $..a[(@.length-1)]
, but this can be achieved with $..a[-1]
and the latter is simpler).
In case of no matches for the query it will return an empty array.
This implementation has the following features:
$.*[?(/^bo{2}k$/)]
or $[?(/a\wthors/)]
).$.store.book[?(@.author =~ /.*Tolkien/)]
)[]
there is no need to surround child names with quotes (p.e. $[store][book, bicycle]
) except if the name of the field is a non-valid javascript variable name..length
can be used to get the length of a string, get the length of an array and to check if a node has children.in
operator allows filtering for a value in a specified list: $..[?(@.author in ["Nigel Rees", "Evelyn Waugh", $.store.book[3].author])]
__get
: $obj->{'$...'}
.__set
: $obj->{'$...'} = $val
.__toString
: echo $obj
prints the json representation of the JsonObject.eval()
.To install JsonPath you will need to be using Composer in your project. To install it please see the docs.
composer require galbar/jsonpath
In every file you use it add:
use JsonPath\JsonObject;
Now you can create an instance of JsonObject and use it:
// $json can be a string containing json, a PHP array, a PHP object or null.
// If $json is null (or not present) the JsonObject will be empty.
$jsonObject = new JsonObject();
// or
$jsonObject = new JsonObject($json);
// get
$obj->get($jsonPath);
$obj->{'$.json.path'};
// set
$obj->set($jsonPath, $value);
$obj->{'$.json.path'} = $value;
// get the json representation
$obj->getJson();
$str = (string)$obj;
echo $obj;
// get the PHP array representation
$obj->getValue();
// add values
$obj->add($jsonPath, $value[, $field]);
// remove values
$obj->remove($jsonPath, $field);
When creating a new instance of JsonObject, you can pass a second parameter to the constructor. This sets the behaviour of the instance to use SmartGet.
What SmartGet does is to determine if the given JsonPath branches at some point, if it does it behaves as usual;
otherwise, it will directly return the value pointed by the given path (not the
array containing it) or false
if not found.
Sometimes you need to access multiple values of a subobject that has a long prefix (p.e. $.a.very.long.prefix.for.[*].object
), in this case you would first get said object
and make a JsonObject of it and then access its properties.
Now if you want to edit the object (set or add values) and want these changes to affect the original object, the way of doing this is by using
JsonObject::getJsonObjects($jsonpath)
. This method works the same way get does, but it will return the results as JsonObject instances containing a reference to the value in the source JsonObject.
This library implements the following specification:
var_name¹ = /^\.([\p{L}\p{N}\_\$][\p{L}\p{N}\_\-\$]*|\*)(.*)/u
number = ([0-9]+(\.[0-9]*) | ([0-9]*\.[0-9]+))
string = ('\''.*?'\'' | '"'.*?'"')
boolean = ('true' | 'false')
regpattern = '/'.*?'/i?x?'
null = 'null'
index = -?[0-9]+
jsonpath = '$' operator*
childpath = '@' operator*
operator = (childname | childfilter | recursive) operator*
childname = '.' (var_name | '*')
childfilter = '[' ('*' | namelist | indexlist | arrayslice | filterexpr) ']'
recursive = '..' (var_name | childfilter | '*')
namelist = var_name (',' (var_name | '\'' .*? '\'' | '"' .*? '"'))*
indexlist = index (',' index)*
arrayslice = index? ':' index? ':' index?
filterexpr = '?(' ors ' | regpattern)'
ors = ands (' ' ( 'or' | '\|\|' ) ' ' ands)*
ands = expr (' ' ( 'and' | '&&' ) ' ' expr)*
expr = ( 'not ' | '! ' )? (value | comp | in_array)
comp = value ('==' | '!=' | '<' | '>' | '<=' | '>=' | '=~') value
value = (jsonpath | childpath | number | string | boolean | regpattern | null | length)
length = (jsonpath | childpath) '.length'
in_array = value 'in' '[' value (',' value)* ']'
¹var_name
: the regex roughly translates to "any valid JavaScript variable
name", plus some quirks such as names starting with numbers or containing
dashes (-
).
or
, and
or any comparator.false
if no result.and
s are run before or
s. That means that a and 1 = b or c != d
is the same
as (a and 1) or (c != d)
The .length
operator can be used to:
$..*[?(@.length > 3)]
$..*[?(@.length)]
$..*[?(not @.length)]
$.path.to[?(@.a.string.length > 10)]
$.path.to.field.length
$.path.to.array.length
$.path.to.array[*].array[*].length
$.path.to.array[*].array[*].key.length
The comparators:
==
, !=
, <
, >
, <=
, >=
do what expected (compare by type and value).
=~
is a regex comparator, matches the left operand with the pattern in the right operand. The value on the left must be a string and on
the right regpattern. Other wise returns false
.
Consider the following json:
{ "store": {
"book": [
{ "category": "reference",
"author": "Nigel Rees",
"title": "Sayings of the Century",
"price": 8.95,
"available": true
},
{ "category": "fiction",
"author": "Evelyn Waugh",
"title": "Sword of Honour",
"price": 12.99,
"available": false
},
{ "category": "fiction",
"author": "Herman Melville",
"title": "Moby Dick",
"isbn": "0-553-21311-3",
"price": 8.99,
"available": true
},
{ "category": "fiction",
"author": "J. R. R. Tolkien",
"title": "The Lord of the Rings",
"isbn": "0-395-19395-8",
"price": 22.99,
"available": false
}
],
"bicycle": {
"color": "red",
"price": 19.95,
"available": true
}
},
"authors": [
"Nigel Rees",
"Evelyn Waugh",
"Herman Melville",
"J. R. R. Tolkien"
]
}
JsonPath | Result |
---|---|
$.store.bicycle.price |
The price of the bicycle. |
$.store.book[*] |
All books. |
$.store.book[1,3] |
The second and fourth book. |
$.store.book[1:3] |
From the second book to the third. |
$.store.book[:3] |
From the first book to the third. |
$.store.book[x:y:z] |
Books from x to y with a step of z. |
$..book[?(@.category == 'fiction')] |
All books with category == 'fiction'. |
$..*[?(@.available == true)].price |
All prices of available products. |
$..book[?(@.price < 10)].title |
The title of all books with price lower than 10. |
$..book[?(@.author==$.authors[3])] |
All books by "J. R. R. Tolkien" |
$[store] |
The store. |
$['store'] |
The store. |
$..book[*][title, 'category', "author"] |
title, category and author of all books. |
$..book[?(@.author in [$.authors[0], $.authors[2]])] |
All books by "Nigel Rees" or "Herman Melville". |
$.store.book[?(@.category == 'fiction' and @.price < 10 or @.color == "red")].price |
Books of fiction with a price lower than 10 or something with of color red. (and takes precedence to or ) |
See more examples in the ./tests/Galbar/JsonPath
folder.
To run tests, from the project root folder:
php app/test.php <jsonpath> [<file to json file>]
If no json file is given it defaults to the json object described previously in this file.
For example:
php app/test.php "$..*[?(@.category == 'fiction' and @.price < 10 or @.color == \"red\")].price"
Result should be:
[19.95,8.99]
you can open the project in your browser and can start coding
To generate the docs, from the project root folder:
php vendor/bin/sami.php update app/docgen.php