Query Result to Json

Question

I tried hard to find a way how to convert the result of an chyper query into a Json string or object, whatever.

I tried several ways.

$client = ClientBuilder::create()
->addConnection('default', 'http://XXX:XXX@XX.XXX.XX.XX:7474')
->build();

$query = "MATCH p=()-[:BETEILIGTER]->()-[:UNTERPROJEKT]->() RETURN p LIMIT 100";
$result = $client->run($query);
$result->records();

foreach ($result->records() as $record) {
    print_r($record);      
    echo json_encode($record);

}

At the moment print_r($record) presents the data. However, json_encode returns only empty objects "{}". (1) I read about the problem that variables might be protected, which I found here but the sulution did not worked for me. (2) I tried to cast the variable:

foreach ($result->records() as $record) {
     $array =  (array) $record;
     echo json_encode($array);
}

But it didn't worked as well. The result was a bit more compared to the fist option:

{"\u0000*\u0000keys":["p"],"\u0000*\u0000values":[{}],"\u0000GraphAware\Neo4j\Client\Formatter\RecordView\u0000keyToIndexMap":{"p":0}}{"\u0000*\u0000keys":["p"],"\u0000*\u0000values":[{}],"\u0000GraphAware\Neo4j\Client\Formatter\RecordView\u0000keyToIndexMap":{"p":0}}

But still not a lot and not what I expected.

(3) I found a function in the source code of the neo4j-php-client called getJsonResponse(). But I can't call the procedure:

Call to undefined method GraphAware\Neo4j\Client\Formatter\Result::getJsonResponse() in /var/www/html/bpPhpHelper_4.php:15

and even don't know if this is a usefull approach.

Does anyone have a gues what to do? Thanks!

Here a small piece of the print_r($record) structure:

Answer to OldPadawan suggestion:

Code was:

addConnection('default', 'http://XXX:XXX@XX.XX.XX.XX:7474')
    ->build();

    $query = "MATCH p=()-[:BETEILIGTER]->()-[:UNTERPROJEKT]->() RETURN p LIMIT 100";

    $result = $client->run($query);

    $list = array();
    $element = array();


    foreach ($result->records() as $record) {
         // print_r($record);
         $element = "$record";
         array_push($list,$element);
         // $array =  (array) $record;
         // echo json_encode($array);
    }

        //echo json_encode($list);

?>

Error: PHP Catchable fatal error: Object of class GraphAware\Neo4j\Client\Formatter\RecordView could not be converted to string in /var/www/html/bpPhpHelper_6.php on line 23

Second Answer to OldPadawan suggestion:

You gave me this code

addConnection('default', 'http://XXX:XXX@XX.XXX.XX.XX:7474')
->build();

$query = "MATCH p=()-[:BETEILIGTER]->()-[:UNTERPROJEKT]->() RETURN p LIMIT 100";
$result = $client->run($query);
$result->records();

foreach ($result->records() as $record) {
    print_r($record);
}

echo json_encode($record);

?>

I changed the limit to "2" due the size of response.

This is the response:

The last piece "{}" is the result of "echo json_encode($record);" while the rest is procuded by "print_r($record);" There was no reported error.

Query Result to Json

Answers (0)

Related Questions