MongoDB / PHP Library: $regex does not work

Question

There are no errors & also no results. My query looks like this:

Array
(
    [$or] => Array
        (
            [0] => Array
                (
                    [title] => Array
                        (
                            [$regex] => /.*Palmer \- The ArT oF.*/
                            [$options] => i
                        )

                )

        )

)

If I change title to match the entire string from database, it works.
I tried the same query with MongoChef and it works.

Also tried to change the title value with:
1. new MongoDB\BSON\Regex('Palmer - The ArT oF', 'i');
2. direct regex string /.*Palmer \- The ArT oF.*/i
...but still no results.

This is the Cursor object of the find() operation:

MongoDB\Driver\Cursor Object
(
    [cursor] => Array
        (
            [stamp] => 0
            [is_command] => 
            [sent] => 1
            [done] => 1
            [end_of_event] => 1
            [in_exhaust] => 
            [has_fields] => 
            [query] => stdClass Object
                (
                    [$query] => stdClass Object
                        (
                            [$or] => Array
                                (
                                    [0] => stdClass Object
                                        (
                                            [title] => stdClass Object
                                                (
                                                    [$regex] => /.*Palmer \- The ArT oF.*/
                                                    [$options] => i
                                                )

                                        )

                                )

                        )

                )

            [fields] => stdClass Object
                (
                )

            [read_preference] => Array
                (
                    [mode] => 1
                    [tags] => Array
                        (
                        )

                )

            [flags] => 0
            [skip] => 0
            [limit] => 0
            [count] => 1
            [batch_size] => 0
            [ns] => laravel.movie_list
        )

    [server_id] => 1
)

I'm using the mongo-php-library for this operations.

Bhargav Rao · Accepted Answer · 2017-02-08 15:50:39Z

1

We should use '^Hello' instead of /^Hello/'. So, the following will work:

$filter = ['NAME' => new MongoDB\BSON\Regex('^Hello', 'i')]; // Works
$cursor = $collection->find($filter);

That's it.

edited Feb 8, 2017 at 15:50

Bhargav Rao

52.6k29 gold badges130 silver badges142 bronze badges

answered Feb 8, 2017 at 13:54

CEDA

554 bronze badges

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

Comments

V. Razvan · Accepted Answer · 2016-03-24 08:33:00Z

0

Also, when comparing two distinct regex objects the returned result is true.

$a = new Regex('a', 'i');
$b = new Regex('b', 'i');
var_dump($a == $b); // will return true
var_dump($a === $b); // will return false

answered Mar 24, 2016 at 8:33

V. Razvan

11 bronze badge

Collectives™ on Stack Overflow

MongoDB / PHP Library: $regex does not work

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