Login   Register  
PHP Classes
elePHPant
Icontem

regex

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

      PHP Classes blog  >  Developing scalable P...  >  All threads  >  regex  >  (Un) Subscribe thread alerts  
Subject:regex
Summary:did you find how to?
Messages:4
Author:geert van bommel
Date:2010-03-01 20:00:11
Update:2012-02-03 08:07:31
 

  1. regex   Reply  
Picture of geert van bommel
geert van bommel
2010-03-01 20:04:02
Hi,
very good article! I have been playing around with php/mongodb as well. Unfortunately I haven't found how to use a regular expression to find records. Or a simple %bar% (like the SQL rlike equivalent) even. I see examples in other languages, just not in php. Do you happen to know how it's done?

Looking forward to your mongo classes!
Best,
Geert

  2. Re: regex   Reply  
Picture of Cesar D. Rodas
Cesar D. Rodas
2010-03-01 21:52:57 - In reply to message 1 from geert van bommel
Hello,

I forgot to mention this in the Post, thanks for asking.

With PHP you can represent most of data types supported by MongoDB, integers, floats numbers, strings, arrays, nested arrays and so forth, but they are some data type that can't be represented, here is the list:

http://www.php.net/manual/en/mongo.types.php

In the blog post I already used MongoCode to send javascript code to Map/Reduce.

In order to use Regex, you simple need to create a MongoRegex object:

http://www.php.net/manual/en/class.mongoregex.php

Regular expressions follows this format "/<regex>/<flags>", and it is evaluated at the server. In my local tests, if the regexp contains an error the query returns an empty cursor, beware with this.

The equivalent request to the SQL statement username LIKE '%bar%' is this:

<?php
$filter = array(
'username' => new MongoRegex("/.*bar.*/i"),
);

$collection->find($filter);
?>

Be careful using Regex, most of the times it can't use indexes, so it will perform a data scan, therefore it is a good idea to limit the number of documents to analyze:

<?php
$filter = array(
'username' => new MongoRegex("/.*bar.*/i"),
/* I assume that 'Karma' has an index */
'karma' => array('$gt' => 10),
);

$collection->find($filter);
?>

With Regex you can do really complex queries like this:

<?php
$filter = array(
'username' => new MongoRegex("/[a-z][a-z0-9\_]+(\_[0-9])?/i"),
/* I assume that 'Karma' has an index */
'karma' => array('$gt' => 10),
);

$collection->find($filter);
?>

I hope it clarified your doubt,

Regards,

  3. Re: regex   Reply  
Picture of geert van bommel
geert van bommel
2010-03-02 15:05:15 - In reply to message 2 from Cesar D. Rodas
Hello,

excellent! That answers my question. Boy, mongodb sure is powerful and you seem to know everything about it! :-)

Thank you very much.
Best,
Geert

  4. Re: regex   Reply  
Picture of Wayne Rademan
Wayne Rademan
2012-02-03 08:07:31 - In reply to message 2 from Cesar D. Rodas
I found the following useful when trying to do searches on multiple fields or a collection:

$host = 'localhost';
$conn = new Mongo($host);
$db = $conn->DBName;
$collection = $db->CollectionName;

$regexObj = new MongoRegex("/$search_term/i");
$where = array( '$or' => array(array( "Name" => $regexObj), array("image.caption.text" => $regexObj), array("image.user.username" => $regexObj)));

$cursor = $collection->find($where);


// Parsing the results
while ($cursor->hasNext())
{
$obj = $cursor->getNext();

$profile_image = $obj['image']['user']['profile_picture'];
echo $profile_image;
}


Hope this helps someone.