How to access data returned in MongoDB cursor in laravel controller?

Question

I am using Laravel 5.6 with MongoDB using Jenssegers Package

Here I want to get total count using group by a method as we do in Mysql eg.

select latitude,longitude,count(*) as `count` from event_logger group by latitude,longitude

According to docs of the package, in MongoDB we can't use aggregate functions simple as we do in eloquent but instead we have to use raw query with MongoDB syntax.

public static function getUsersByTypeLogin()
{

        $q = self::raw()->aggregate(
            [
                array(
                    '$group'=>array(
                        '_id'=>array(
                            'lat'=>'$latitude',
                            'long'=>'$longitude'
                        ),
                        'count'=>array('$sum'=>1)
                    )
                )
            ]
        );

        dd($q);
}

When I do dd(dump and die), I am getting Cursor {#586} as result. So basically how to get/access data in cursor into my laravel application?

FGDeveloper · Accepted Answer · 2018-12-28 13:14:48Z

2

I'm using too this package a project. I'm using raw closure method that returns aggregation data.

For Example:

$data = YourModel::raw(function($collection)
{
    return $collection->aggregate(
        [
            array(
                '$group'=>array(
                    '_id'=>array(
                        'lat'=>'$latitude',
                        'long'=>'$longitude'
                    ),
                    'count'=>array('$sum'=>1)
                )
            )
        ]
    );
});

$data should be your data.

Can you try above codes?.

answered Dec 28, 2018 at 13:14

FGDeveloper

1,0509 silver badges24 bronze badges

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

Comments

Tiago Peres · Accepted Answer · 2018-12-28 12:54:25Z

0

Use

foreach ($q as $row) {
    //$row contains data for every row
 }

where q is the cursor.

edited Dec 28, 2018 at 12:54

Tiago Peres

15.9k22 gold badges105 silver badges174 bronze badges

answered Dec 28, 2018 at 12:19

Tofeeq

2,7491 gold badge25 silver badges20 bronze badges

Collectives™ on Stack Overflow

How to access data returned in MongoDB cursor in laravel controller?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related