MongoDB - problem finding by geolocation does not work

Question

MongoDB - problem finding by geolocation does not work

Francisco Prado Jan '18

Created Jan '18	Last Reply None	Replies 0	Views 356	Votes 1

Francisco Prado 885

Jan '18

Hi,

I try the code below in PHP in order to get two results, but it returns all results. I tested this query in mongo and it works, just in the PHP it does not work. I use the incubator library and PHP 7.1.

$query = ['location' => 
    ['$near' => 
        ['$geometry' => 
            ['type' => "Point", 
            'coordinates' => [-23.9768691, -46.194405]], 
            '$minDistance' => 0, 
            '$maxDistance' => 5000]
        ]
    ];

$events = Events::find($query);

I don't know what's the problem. I did not have problems finding by text, and others. I have tried to query direct with the MongoClient object, but no success too.

Thanks,

1

Francisco Prado · Answer 1 · 2018-01-31T17:52:49-07:00

Wow... It looks that writing about the problem I could solve it. Now it works:

$events = Events::find([$query]);

Encapsulating the query array inside an array... It was missing... Posting here in case it helps someone in the future...