Hi ! We use your library in our project but I encounter the following problem : how to get data for an entry which has spaces in its key ? Like this :

{
  "2020-08-05 15:59:09": {
    "added": {
      "evaluation": {
        "id": 1,

I tried many things like $.[the date] or $[the date] but didn't succeed:(

Have you any idea ?

Thanks !

So we can customize the returned JSON using the native json_encode options http://php.net/manual/en/function.json-encode.php

Example: $jsonObj->getJson( JSON_UNESCAPED_UNICODE | JSON_PRETTY_PRINT )

I have added extra functionality in my fork. Unfortunatelly I could not extend the by including the lib as dependency and had to modify the core files in the fork.

I think, this could be a great extension and might become the part of the main lib.

Here is the usage example:

JSON:

{
   "store":{
      "name":"My Store",
      "book":[
         {
            "category":"reference",
            "author":"Nigel Rees",
            "title":"Sayings of the Century",
            "price":8.95,
            "available":true,
            "authors":[
               "Nigel Rees"
            ]
         },
         {
            "category":"fiction",
            "author":"Evelyn Waugh",
            "title":"Sword of Honour",
            "price":12.99,
            "available":false,
            "authors":[
               
            ]
         },
         {
            "category":"fiction",
            "author":"Herman Melville",
            "title":"Moby Dick",
            "isbn":"0-553-21311-3",
            "price":8.99,
            "available":true,
            "authors":[
               "Nigel Rees"
            ]
         },
         {
            "category":"fiction",
            "author":"J. R. R. Tolkien",
            "title":"The Lord of the Rings",
            "isbn":"0-395-19395-8",
            "price":22.99,
            "available":false,
            "authors":[
               "Evelyn Waugh",
               "J. R. R. Tolkien"
            ]
         }
      ],
      "bicycle":{
         "color":"red",
         "price":19.95,
         "available":true,
         "model":null,
         "sku-number":"BCCLE-0001-RD"
      },
      "bicycleSet":[
         {
            "color":"red",
            "price":19.95,
            "available":true,
            "model":null,
            "sku-number":"BCCLE-0001-RD"
         },
         {
            "color":"green",
            "price":19.75,
            "available":false,
            "model":null,
            "sku-number":"RCADF-0002-CQ"
         }
      ]
   },
   "authors":[
      "Nigel Rees",
      "Evelyn Waugh",
      "Herman Melville",
      "J. R. R. Tolkien"
   ],
   "Bike models":[
      1,
      2,
      3
   ]
}

The code:

        $jsonObject = new JsonObject($json);
        $result = $jsonObject->getTable('[$.store.book[*].price,$.store.book[*].price,$.store.book[*].authors[*],$.store.book[*].title,$.store.name]');

The result:

                array(
                    array(8.95, 8.95, "Nigel Rees", "Sayings of the Century", "My Store"),
                    array(12.99, 12.99, null, "Sword of Honour", "My Store"),
                    array(8.99, 8.99, "Nigel Rees", "Moby Dick", "My Store"),
                    array(22.99, 22.99, "Evelyn Waugh", "The Lord of the Rings", "My Store"),
                    array(22.99, 22.99, "J. R. R. Tolkien", "The Lord of the Rings", "My Store")
                ),

My fork with the implementation: https://github.com/kirill533/JsonPath-PHP

Hi Galbar, my users would like to use .length operator outside of brackets in order to get length of a JSON array or string value length. Like they can do at https://jsonpath.com. So, I've made a simple update to your lib, it should work fine in case there is nothing with key 'length' at these array level. What do you think about that?

I'm trying to follow the installation instructions, so I've added this ...

"require": {
    "skyscanner/jsonpath": "dev-master"
}

in my composer.json and then I've tried

composer update

but my system (Ubuntu 15.10), says ...

Loading composer repositories with package information
Updating dependencies (including require-dev)
Your requirements could not be resolved to an installable set of packages.

  Problem 1
    - The requested package skyscanner/jsonpath 0.8.0.0 could not be found.

Potential causes:
 - A typo in the package name
 - The package is not available in a stable-enough version according to your minimum-stability setting
   see <https://groups.google.com/d/topic/composer-dev/_g3ASeIFlrc/discussion> for more details.

Read <https://getcomposer.org/doc/articles/troubleshooting.md> for further common problems.

I can't find that file in the repo .... Suggestions?

Cesare

Hello,

I am facing performance issue when using your library in my symfony project. I have a JSON file containing a multidimensional structure and manage to use your library to query this.

I use a query with multiple conditions.

However the execution time is quicker when using my MySQL db compared to using the JSON file. I have joined the JSON file containing the data and its structure, and a PHP test command file so that you can have a better understanding of what is executed.

Is there something wrong in my way of using it ?

Many thanks, Daniel

json.txt

TestPerfCommand.txt

On upgrading from 1.2 to 1.3, quite a few of our tests broke since the .length query now seems to return an array with the length in most cases instead of the raw count.

Hello,

I found this package via packagist, it was the stable version 1.0 on there. Currently, the dev-master were maintains the .length feature, would you please release a new stable version on packagist?

I've been trying to use different notations to get the last item in an array of objects. It seems that the '-' character is breaking the code:

$.Line[-1:].Amount --> error: Invalid JSON path expression. The error is around character position 7

$.Line[-1].Amount --> error: Invalid JSON path expression. The error is around character position 7

$.Line[0].Amount --> successfully returns the Amount of the first object in the Line array

Trying to get a value of a key in hash form, and got an exception

Error in JSONPath near '.6ea500130ed280048b262ce6b3fe4ea0f97b75ad'

So the simple fix is to add a numbers to a string keys.

This is not an issue rather asking for help or suggestion .

I have a situation where I need to create nodes dynamically and it has worked far.

I have two cases If i want to created an array like ['contacts'=>['firstName'=>'first name']] then i can do

$jsonPathObject = new JsonObject([]) ; $res = $jsonPathObject->set('$.contacts.firstName', 'first name')->getValue();

$res is ['contacts'=>['firstName']]

but

$res = $jsonPathObject->set('$.contacts[*].firstName', 'first name')->getValue(); would result in

['contacts'=>[] ]

Is there any possibility for it to create an array and create array of array instead of an empty array because my need would be to have array

$res = ['contacts'=> [ ['firstName'=>'foo']] when I set
$jsonPathObject->set('$.contacts[*].firstName', 'first name')->getValue();

Hi I'm just stumbled across a bug when using negative index, but the element with this index does not exist. The error can be triggered like this:

$object = new \JsonPath\JsonObject('{"data": []}');
$result = $object->get('$.data[-1]');
// Triggers DivisionByZeroError

When less objects are present than the negative index, it does overflow, and this seems strange to me. But at least it does not trigger an Error. This might be a secondary bug:

$object = new \JsonPath\JsonObject('{"data": [{"id": 1},{"id": 2}]}');
$result = $object->get('$.data[-5].id');
// $result is [2]

In case index is less than the size of the object, everything works as intended.

$object = new \JsonPath\JsonObject('{"data": [{"id": 1}]}');
$result = $object->get('$.data[-1].id');
// $result is [1]

$object = new \JsonPath\JsonObject('{"data": [{"id": 1},{"id": 2}]}');
$result = $object->get('$.data[-1].id');
// $result is [2]

The bug does not apear with positive index, which does not exist. Also this behaviour does make more sense to me than the one with negative index that does not exist:

$object = new \JsonPath\JsonObject('{"data": []}');
$result = $object->get('$.data[1].id');
// $result is []

$object = new \JsonPath\JsonObject('{"data": [{"id": 1},{"id": 2}]}');
$result = $object->get('$.data[3].id');$
// $result is []

suppose I have

{
"a": {
   "v": "va"
    },
"b": {
   "v": "vb"
    }
}

$..[?(@.v=="va")] returns

[
{
	"v":"va"
}
]

how can I get the key of this object which is a ?

https://extendsclass.com/jsonpath-tester.html suports ~, such that $..[?(@.v=="va")]~ returns

[
"a"
]

How can I do this in JsonPath-PHP?

I did a bit of experimentation with a PR but wasn't quite able to get it to work, so I thought I'd take this to an issue to look for some ideas on how to implement :)

Given the sample document, I'm interested in being able to use remove() without providing a field, e.g. removing all matching paths.

Essentially supporting something like this:

$jsonObject = new JsonObject($json);

$jsonObject->remove("$..book[?(@.category == 'fiction')]");

$results = $jsonObject->toValue();

// $results with all fiction books removed.

I tried a simple unset($element); in the remove code but PHP's unset only unsets the reference, not the original value, so it doesn't quite work.

The following queries provide results that do not match those of other implementations of JSONPath (compare https://cburgmer.github.io/json-path-comparison/):

• [ ] $.2 Input:

  {"a": "first", "2": "second", "b": "third"}
  

  Expected output:

  ["second"]
  

  Error:

  Invalid JSONPath error: 'Error in JSONPath near '.2''
  

• [ ] $[0:0] Input:

  ["first", "second"]
  

  Expected output:

  []
  

  Error:

  jsonpath returned false, this might indicate an error
  

• [ ] $[?(@.key<42)] Input:

  [{"key": 0}, {"key": 42}, {"key": -1}, {"key": 41}, {"key": 43}, {"key": 42.0001}, {"key": 41.9999}, {"key": 100}, {"some": "value"}]
  

  Expected output:

  [{"key": 0}, {"key": -1}, {"key": 41}, {"key": 41.9999}]
  

  Actual output:

  [{"key": 0}, {"key": -1}, {"key": 41}, {"key": 41.9999}, {"some": "value"}]
  

• [ ] $..* Input:

  {"key": "value", "another key": {"complex": "string", "primitives": [0, 1]}}
  

  Expected output:

  ["string", "value", 0, 1, [0, 1], {"complex": "string", "primitives": [0, 1]}]
  

  Actual output:

  ["string", "value", 0, 1, [0, 1], {"complex": "string", "primitives": [0, 1]}, {"another key": {"complex": "string", "primitives": [0, 1]}, "key": "value"}]
  

• [ ] $..* Input:

  [40, null, 42]
  

  Expected output:

  [40, null, 42]
  

  Actual output:

  [[40, null, 42], 40, null, 42]
  

• [ ] $..* Input:

  42
  

  Expected output:

  []
  

  Actual output:

  [42]
  

For reference, the output was generated by the program in https://github.com/cburgmer/json-path-comparison/tree/master/implementations/PHP_galbar-jsonpath.

README.md needs to be updated:

• [ ] https://github.com/Galbar/JsonPath-PHP/issues/29#issuecomment-499373986 : missing examples of jsonpath
• [x] #30 : change getArray() for getValue()

Hi,

The JsonObject class turns empty objects into empty arrays and thus is unable to give back the original JSON representation.

For example:

{
 "item1": {},
 "item2": {}
}

Is returned as:

{
 "item1": [],
 "item2": []
}

Here is how to reproduce it:

 public function test() {
        $this->assertEquals('[{"item":"value"}]', (new JsonObject('[{"item":"value"}]'))->getJson());
        $this->assertEquals('{"item":"value"}', (new JsonObject('{"item":"value"}'))->getJson()); 
        $this->assertEquals('[]', (new JsonObject('[]'))->getJson());
        $this->assertEquals('{}', (new JsonObject('{}'))->getJson());  // FAILS!
    }

Failed asserting that two strings are equal.
Expected :'{}'
Actual   :'[]'

Best regards,