使用neo4j-php-client访问collect（）的结果

Question

The below displays: Marlena has 12 paintings (which is basically from the docs)

How do I access the data in collect(Paintings) ex: title

$query = "MATCH (n:Artist)-[:PAINTED]->(Painting) RETURN n.first_name, collect(Painting) as paintings";
$result = $client->run($query);

foreach ($result->getRecords() as $record) {
    echo sprintf('%s has %d paintings', $record->value('n.first_name'), count($record->value('paintings')));
    echo '<br/>';
}

I would like to display:

Artist Name:

• painting title
• painting title
• etc

I assume this data can be pull from either Painting or paintings. I am just unsure how to put together the query. It will display using print_r and the record so I know the data is coming through.

Answer 1

a) I suggest you alias your return values, it is easier to fetch them at the driver level

b) The paintings record value returns an array of Node objects, thus is iterable, no need to count for doing the for loop :

$query = "MATCH (n:Artist)-[:PAINTED]->(Painting) RETURN n.first_name as firstName, collect(Painting) as paintings";
$result = $client->run($query);

foreach($result->records() as $record) {
    echo sprintf('%s painted %d paintings', $record->get('firstName'), count($record->get('paintings'))) . PHP_EOL;
    foreach ($record->get('paintings') as $painting) {
        echo sprintf('%s - %d views', $painting->value('title'), $painting->value('views')) . PHP_EOL;
    }
}