Using options in MongoDB\Driver\Query

Question

I'm trying to use options in MongoDB\Driver\Query:

$options = array();
...
if (isset($limit['page']))
    {$options['skip']=($limit['page'] - 1) * $limit['hpp'];}//20
if (isset($limit['hpp']))
    {$options['limit']=$limit['hpp'];//20
    $options['batchSize']=$limit['hpp'];}//20
print('<br />--------$options :<br />');
print_r($options);
$query = new MongoDB\Driver\Query($search, $options);
print('<br />********$query :<br />');
echo '<pre>';
print_r($query);
echo  '</pre>';

If $options seems ok:

--------$options :
Array ( [sort] => Array ( [_id] => 1 ) [skip] => 20 [limit] => 20 [batchSize] => 20 )

$query doesn't give me the good options:

********$query :  
MongoDB\Driver\Query Object  
(  
[query] => stdClass Object  
    (  
        [$orderby] => stdClass Object  
            (  
                [_id] => 1  
            )  
         [$query] => stdClass Object  
            (  
            )  
     )  
[selector] =>  
[flags] => 0  
[skip] => 20  
[limit] => 0  
[batch_size] => 0  
[readConcern] =>  
)

limit and batch_size are not equals to 20, why? and how to do, please?

Thanks in advance

The query object looks very old. Something like v1.0 of the driver. What versions you are using? php, mongodb, and the driver. — Alex Blex
– Alex Blex, Commented Feb 19, 2018 at 14:18
The Query should be like filter=>Object, options=>Object, readConcern=>Object, see SaschaM78's answer. Your print_r($query); returns options on the top level, not within the options object. IIRC it used to be like that a long time ago. — Alex Blex
– Alex Blex, Commented Feb 19, 2018 at 15:14

SaschaM78 · Accepted Answer · 2018-02-19 15:56:20Z

1

Tested on PHP 7.2.2:

<?php
$options= [
    'skip' => 20,
    'limit' => 20,
    'batchSize' => 20   
];

$filter= [
'_id' => '5a8adcf335f6d112d00e46c8'
];

$query= new MongoDB\Driver\Query($filter, $options);
print_r($query);

outputs:

MongoDB\Driver\Query Object ( [filter] => stdClass Object ( [_id] => 5a8adcf335f6d112d00e46c8 )
 [options] => stdClass Object
    (
        [batchSize] => 20
        [skip] => 20
        [limit] => 20
    )

[readConcern] =>  )

Solution (taken from comments)

The parameters passed as options to the Query instance are treated in a type-sensitive manner, in the author's case the parameters were passed from user input and transferred as "string" rather than "number" as excepted. The solution was to use intval() on the parameters which solved the problem.

In case things still don't work as expected - update MongoDB

I checked the changelog of the MongoDB PECL repo but couldn't find when the bug was fixed. I would recommend updating to the most current version and test again.

edited Feb 19, 2018 at 15:56

answered Feb 19, 2018 at 14:47

SaschaM78

4,5074 gold badges36 silver badges46 bronze badges

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

4 Comments

Pim92 Over a year ago

Thanks, well, if I write $options= [ 'skip' => 20, 'limit' => 20, 'batchSize' => 20 ]; It is ok: [flags] => 0 [skip] => 20 [limit] => 20 [batch_size] => 20 but I don't understand why my first try doesn't work...

SaschaM78 Over a year ago

I can only assume that it's due to your variables being initialised from user input (i.e. provided as GET or POST parameters) rather than statically set values. Could you post the output of var_dump($options);, after that change your code to use intval($limit['hpp']); and try again?

Pim92 Over a year ago

Thanks, intval() works :) without it, var_dump gives: array(4) { ["sort"]=> array(1) { ["_id"]=> int(1) } ["skip"]=> int(20) ["limit"]=> string(2) "20" ["batchSize"]=> string(2) "20" }... strings weren't here my friends. Thanks again

SaschaM78 Over a year ago

You're welcome & great it works! And thanks for accepting! I'll add the final solution to my answer, perhaps somebody else will also fall over this :-).

Collectives™ on Stack Overflow

Using options in MongoDB\Driver\Query

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related