How to retrieve MongoDB multiple array values in php?

Question

I want to retrieve all the values of the field color. How do php handle this values?

{
    _id : 1,

    color : ["red","blue","yellow"]
},
{
    _id : 2,

    color : ["green","black","grey"]
}

PHP code :

<?php

    $connect = new MongoClient();

    $collection = $database->database_name->collection;

    $cursor = $collection->find( array(), array( 'color' ) );

    foreach( $cursor as $val )

     echo json_encode( $val );

?>

As a result it does not return any values. How do I get the array values?

Bertrand Martel · Accepted Answer · 2016-12-28 18:45:24Z

1

Use distinct to get distinct values of your array :

$cursor = $collection->distinct('color');

A full example :

<?php

    $m = new MongoClient();
    $db = $m->selectDB("testDB");
    $cursor = $db->users->distinct('color');
    var_dump($cursor);

?>

answered Dec 28, 2016 at 18:45

Bertrand Martel

46k17 gold badges156 silver badges170 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

YSuraj Over a year ago

the values are returned as a single value, I want the values to be returned as an array.

Bertrand Martel Over a year ago

Do you mean like ["red","blue","yellow"],["green","black","grey"] ?

YSuraj Over a year ago

Ok! got it, resolved. Your code worked. Ignore the previous comment. Thanks.

Collectives™ on Stack Overflow

How to retrieve MongoDB multiple array values in php?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related