douzhao6584
douzhao6584
2016-09-22 16:07
浏览 117
已采纳

使用neo4j-php-client访问collect()的结果

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.

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

3条回答 默认 最新

  • duanfeiqu1989
    duanfeiqu1989 2016-09-26 11:31
    已采纳

    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;
        }
    }
    
    点赞 评论
  • donglv9116
    donglv9116 2016-09-23 20:44

    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/>';
    }
    
    点赞 评论
  • dqitk20644
    dqitk20644 2016-09-24 06:09

    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?

    点赞 评论

相关推荐