sorting mongo regex query in php

Question

I have a mongo collection and I'd like to obtain all the document whose names start with a given letter on PHP. My code:

$letter = "c";
$client = new MongoDB\Client();
$pme = $client->selectCollection("belgium", "pme");     
$regex = new MongoDB\BSON\Regex  ("^$letter", "i"); 
$query = array('name' =>  $regex); // 1
$query = array('name' =>  $regex, array( 'sort' => array( 'OrderBy' => 1 ) )); // 2
$query = new MongoDB\Driver\Query( array('name' => $regex), array( 'sort' => array( 'OrderBy' => 1 ) ) ); // 3
$cursor = $pme->find($query);

Whe I use query 1. I got all documents starting with letter c but not ordered. When I use query 2, I got nothing. And finally when I use query 3 I get almost every document, not just those starting with with 'c'. What I am doing wrong here?

Mike Shauneu · Accepted Answer · 2016-10-24 13:05:23Z

1

In mongo method sort should be applied on cursor obtained by find:

$letter = "c";
$client = new MongoDB\Client();
$pme = $client->selectCollection("belgium", "pme");     
$regex = new MongoDB\BSON\Regex  ("^$letter", "i"); 
$query = array('name' =>  $regex);
// sort by field `name` happens here
$options = array("sort" => array("name" => 1), );
$cursor = $pme->find($query, $options);

edited Oct 24, 2016 at 13:05

answered Oct 24, 2016 at 10:40

Mike Shauneu

3,31924 silver badges23 bronze badges

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

3 Comments

Juan Chô Over a year ago

Thanks, but the sort method of cursor no longer exist.

Mike Shauneu Over a year ago

I've updated answer. Pls see github.com/mongodb/mongo-php-driver/issues/214 for details.

Juan Chô Over a year ago

Thanks Mike, I was about to publish exactly this solution. I works now.

Collectives™ on Stack Overflow

sorting mongo regex query 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