README.md
# JSONPath for PHP 8.1+
[![Build](https://img.shields.io/github/actions/workflow/status/SoftCreatR/JSONPath/.github/workflows/Test.yml?branch=main)](https://github.com/SoftCreatR/JSONPath/actions/workflows/Test.yml) [![Latest Release](https://img.shields.io/packagist/v/SoftCreatR/JSONPath?color=blue&label=Latest%20Release)](https://packagist.org/packages/softcreatr/jsonpath)
[![MIT licensed](https://img.shields.io/badge/license-MIT-blue.svg)](./LICENSE) [![Plant Tree](https://img.shields.io/badge/dynamic/json?color=brightgreen&label=Plant%20Tree&query=%24.total&url=https%3A%2F%2Fpublic.offset.earth%2Fusers%2Fsoftcreatr%2Ftrees)](https://ecologi.com/softcreatr?r=61212ab3fc69b8eb8a2014f4)
[![Codecov branch](https://img.shields.io/codecov/c/github/SoftCreatR/JSONPath)](https://codecov.io/gh/SoftCreatR/JSONPath)
[![Code Climate maintainability](https://img.shields.io/codeclimate/maintainability-percentage/SoftCreatR/JSONPath)](https://codeclimate.com/github/SoftCreatR/JSONPath)
This is a [JSONPath](http://goessner.net/articles/JsonPath/) implementation for PHP based on Stefan Goessner's JSONPath script.
JSONPath is an XPath-like expression language for filtering, flattening and extracting data.
This project aims to be a clean and simple implementation with the following goals:
- Object-oriented code (should be easier to manage or extend in future)
- Expressions are parsed into tokens using code inspired by the Doctrine Lexer. The tokens are cached internally to avoid re-parsing the expressions.
- There is no `eval()` in use
- Any combination of objects/arrays/ArrayAccess-objects can be used as the data input which is great if you're de-serializing JSON in to objects or if you want to process your own data structures.
## Installation
```bash
composer require softcreatr/jsonpath:"^0.9"
```
## JSONPath Examples
JSONPath | Result
--------------------------|-------------------------------------
`$.store.books[*].author` | the authors of all books in the store
`$..author` | all authors
`$.store..price` | the price of everything in the store.
`$..books[2]` | the third book
`$..books[(@.length-1)]` | the last book in order.
`$..books[-1:]` | the last book in order.
`$..books[0,1]` | the first two books
`$..books[:2]` | the first two books
`$..books[::2]` | every second book starting from first one
`$..books[1:6:3]` | every third book starting from 1 till 6
`$..books[?(@.isbn)]` | filter all books with isbn number
`$..books[?(@.price<10)]` | filter all books cheaper than 10
`$..books.length` | the amount of books
`$..*` | all elements in the data (recursively extracted)
Expression syntax
---
Symbol | Description
----------------------|-------------------------
`$` | The root object/element (not strictly necessary)
`@` | The current object/element
`.` or `[]` | Child operator
`..` | Recursive descent
`*` | Wildcard. All child elements regardless their index.
`[,]` | Array indices as a set
`[start:end:step]` | Array slice operator borrowed from ES4/Python.
`?()` | Filters a result set by a script expression
`()` | Uses the result of a script expression as the index
## PHP Usage
#### Using arrays
```php
<?php
require_once __DIR__ . '/vendor/autoload.php';
$data = ['people' => [
['name' => 'Sascha'],
['name' => 'Bianca'],
['name' => 'Alexander'],
['name' => 'Maximilian'],
]];
print_r((new \Flow\JSONPath\JSONPath($data))->find('$.people.*.name')->getData());
/*
Array
(
[0] => Sascha
[1] => Bianca
[2] => Alexander
[3] => Maximilian
)
*/
```
#### Using objects
```php
<?php
require_once __DIR__ . '/vendor/autoload.php';
$data = json_decode('{"name":"Sascha Greuel","birthdate":"1987-12-16","city":"Gladbeck","country":"Germany"}', false);
print_r((new \Flow\JSONPath\JSONPath($data))->find('$')->getData()[0]);
/*
stdClass Object
(
[name] => Sascha Greuel
[birthdate] => 1987-12-16
[city] => Gladbeck
[country] => Germany
)
*/
```
More examples can be found in the [Wiki](https://github.com/SoftCreatR/JSONPath/wiki/Queries)
### Magic method access
The options flag `JSONPath::ALLOW_MAGIC` will instruct JSONPath when retrieving a value to first check if an object
has a magic `__get()` method and will call this method if available. This feature is *iffy* and
not very predictable as:
- wildcard and recursive features will only look at public properties and can't smell which properties are magically accessible
- there is no `property_exists` check for magic methods so an object with a magic `__get()` will always return `true` when checking
if the property exists
- any errors thrown or unpredictable behaviour caused by fetching via `__get()` is your own problem to deal with
```php
use Flow\JSONPath\JSONPath;
$myObject = (new Foo())->get('bar');
$jsonPath = new JSONPath($myObject, JSONPath::ALLOW_MAGIC);
```
For more examples, check the JSONPathTest.php tests file.
## Script expressions
Script expressions are not supported as the original author intended because:
- This would only be achievable through `eval` (boo).
- Using the script engine from different languages defeats the purpose of having a single expression evaluate the same way in different
languages which seems like a bit of a flaw if you're creating an abstract expression syntax.
So here are the types of query expressions that are supported:
[?(@._KEY_ _OPERATOR_ _VALUE_)] // <, >, <=, >=, !=, ==, =~, in and nin
e.g.
[?(@.title == "A string")] //
[?(@.title = "A string")]
// A single equals is not an assignment but the SQL-style of '=='
[?(@.title =~ /^a(nother)? string$/i)]
[?(@.title in ["A string", "Another string"])]
[?(@.title nin ["A string", "Another string"])]
## Known issues
- This project has not implemented multiple string indexes e.g. `$[name,year]` or `$["name","year"]`. I have no ETA on that feature, and it would require some re-writing of the parser that uses a very basic regex implementation.
## Similar projects
[FlowCommunications/JSONPath](https://github.com/FlowCommunications/JSONPath) is the predecessor of this library by Stephen Frank
Other / Similar implementations can be found in the [Wiki](https://github.com/SoftCreatR/JSONPath/wiki/Other-Implementations).
## Changelog
A list of changes can be found in the [CHANGELOG.md](CHANGELOG.md) file.
## License 🌳
[MIT](LICENSE.md) © [1-2.dev](https://1-2.dev)
This package is Treeware. If you use it in production, then we ask that you [**buy the world a tree**](https://ecologi.com/softcreatr?r=61212ab3fc69b8eb8a2014f4) to thank us for our work. By contributing to the ecologi project, you’ll be creating employment for local families and restoring wildlife habitats.
## Contributors ✨
<table>
<tr>
<td align="center" style="word-wrap: break-word; width: 150.0; height: 150.0">
<a href=https://github.com/SoftCreatR>
<img src=https://avatars.githubusercontent.com/u/81188?v=4 width="100;" alt=Sascha Greuel/>
<br />
<sub style="font-size:14px"><b>Sascha Greuel</b></sub>
</a>
</td>
<td align="center" style="word-wrap: break-word; width: 150.0; height: 150.0">
<a href=https://github.com/warlof>
<img src=https://avatars.githubusercontent.com/u/648753?v=4 width="100;" alt=Loïc Leuilliot/>
<br />
<sub style="font-size:14px"><b>Loïc Leuilliot</b></sub>
</a>
</td>
<td align="center" style="word-wrap: break-word; width: 150.0; height: 150.0">
<a href=https://github.com/SG5>
<img src=https://avatars.githubusercontent.com/u/3931761?v=4 width="100;" alt=Sergey/>
<br />
<sub style="font-size:14px"><b>Sergey</b></sub>
</a>
</td>
<td align="center" style="word-wrap: break-word; width: 150.0; height: 150.0">
<a href=https://github.com/drealecs>
<img src=https://avatars.githubusercontent.com/u/209984?v=4 width="100;" alt=Alexandru Pătrănescu/>
<br />
<sub style="font-size:14px"><b>Alexandru Pătrănescu</b></sub>
</a>
</td>
<td align="center" style="word-wrap: break-word; width: 150.0; height: 150.0">
<a href=https://github.com/oleg-andreyev>
<img src=https://avatars.githubusercontent.com/u/1244112?v=4 width="100;" alt=Oleg Andreyev/>
<br />
<sub style="font-size:14px"><b>Oleg Andreyev</b></sub>
</a>
</td>
<td align="center" style="word-wrap: break-word; width: 150.0; height: 150.0">
<a href=https://github.com/rcjsuen>
<img src=https://avatars.githubusercontent.com/u/15629116?v=4 width="100;" alt=Remy Suen/>
<br />
<sub style="font-size:14px"><b>Remy Suen</b></sub>
</a>
</td>
</tr>
<tr>
<td align="center" style="word-wrap: break-word; width: 150.0; height: 150.0">
<a href=https://github.com/esomething>
<img src=https://avatars.githubusercontent.com/u/64032?v=4 width="100;" alt=esomething/>
<br />
<sub style="font-size:14px"><b>esomething</b></sub>
</a>
</td>
</tr>
</table>