CODEWITHSUNDEEP
phpneo4jcyphergraphaware
Grant
Grant

Reputation: 7

Accessing results from collect() using neo4j-php-client

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:

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.

Upvotes: 0

Views: 434

Answers (3)

Christophe Willemsen
Christophe Willemsen

Reputation: 20185

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;
    }
}

Upvotes: 0

Grant
Grant

Reputation: 7

I ended up getting it to work with the following:

foreach ($result->getRecords() as $record) {
    $fname = $record->values()[0]->get('first_name');
    $lname = $record->values()[0]->get('last_name');
    echo '<strong>'.$fname.' '.$lname.' painted:</strong><br/>';
    for ($x = 0; $x < count($record->values()[1]); $x++) {
            print_r($record->values()[1][$x]->get('title'));
            echo ' - ';
            print_r($record->values()[1][$x]->get('views'));
            echo ' views<br/>';
    }
    echo '<br/>';
}

Which provides the following output:

First Name Last Name painted:

  • Lumine - 86 views
  • Pooled Water - 69 views
  • Still Lake - 125 views

Final Notes I actually tried code similar to what you suggested during my struggle to get this working. I'm a bit confused why it does not.

So I'm left wondering. Is what I come up with acceptable?

Upvotes: 0

cybersam
cybersam

Reputation: 67044

This should work for you:

$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:<br/>', $record->value('n.first_name'), count($record->value('paintings')));
    foreach ($record->value('n.paintings') as $painting) {
        echo sprintf('- %s<br/>', $painting->value('title'));
    }
    echo '<br/>';
}

Upvotes: 1

Related Questions