CODEWITHSUNDEEP
phpmongodb
Flyingbeaver
Flyingbeaver

Reputation: 375

MongoDB php $in and $regex

i'm trying to combine $regex and $in to do simple search.

For example I have a user query of this kind :

$user_query = "for focus red";

In my mongodb collection for each document I have a keywords field. I want to get to get the document where the field keywords is :

{
    keywords :
        [0] => ford,
        [1] => focus,
        [2] => red
}

As you can see the user has done a mistake and typed "for" instead of "ford".

I can get the results with $in if the user types Ford, but I don't know how to combine $regex and $in, I have looked the mongodb doc and php mongo doc.

Upvotes: 3

Views: 7718

Answers (2)

Janis
Janis

Reputation: 8769

There is my quick snippet:

$user_query = preg_replace("/[[:blank:]]+/"," ", $user_query);
$arr_query = explode(' ', $user_query);

if (count($arr_query) > 1) {
    $tmp = array();

    foreach ($arr_query as $q) {
        $tmp[] = new MongoRegex( "/". $q ."/" );
    }

    $who['keywords'] = array('$in' => $tmp);

} else {
    $who['keywords'] = new MongoRegex( "/". $user_query ."/" );
}

$db->collection->find( $who );

Upvotes: 5

DrColossos
DrColossos

Reputation: 12998

I'm not using Mongo with PHP but i would do like this: (i'm using mongo shell syntax)

//find everything inside test that was either written by someone or text contains the word "and"
db.test.find( { $or : [ { "keywords" : { $in: ["Ford"] } } , { "keywords" : { $regex: "for.*" } } ] } )

I'm sure you can translate in into the proper PHP structure.

Upvotes: 0

Related Questions