Carrying out like searches using revo and XPDO

330 Posts

Pete Edley Reply #1, 16 years, 4 months ago

I have setup an xPDO schema for a project and carry out searches based on specific fields using $modx->getCollection where the full content of the field is known. Having searched through the docs I can’t find a way of carrying out a like based search using the % wildcard, to search where only part of the field content info is known. Is there a way of doing this using the getCollection or do I need to use newQuery and if so can someone give me some pointers on either way.

Personal site www.cww.org.ukMinistry site Children WorldwideWork site Handsworth Christian School

5,888 Posts

Bruno17 Reply #2, 16 years, 4 months ago

I think you can try this:

<?php

$search='searchme';

$c = $modx->newQuery('modResource');
$c->where(array('modResource.content LIKE "%'.$search.'%"'));
$resources = $modx->getCollection('modResource',$c);

-------------------------------

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

330 Posts

Pete Edley Reply #3, 16 years, 4 months ago

Hi thanks for the help as is normally the case in these situations I posted and carried on searching the solution I found about 10 min after posting was this.

    $name = '%search term%';
    $query = $modx->newQuery('classname');
    $query->where(array(
        'classname.fieldname:LIKE' => $name
     ));
     $people = $modx->getCollection('classname',$query);

Pretty much the same as yours except for the :LIKE. This seems to work.

Personal site www.cww.org.ukMinistry site Children WorldwideWork site Handsworth Christian School

MODX Staff
10,725 Posts

opengeek Reply #4, 16 years, 4 months ago

FWIW, the approach peteedley posted is the proper one as it uses the prepared statement facilities to automatically sanitize the search term, since this is typically user input. While Bruno17’s is valid, you would be responsible for sanitizing the user input yourself.

Jason Coward
Chief Architect @ MODX
http://www.jasoncoward.com | http://twitter.com/drumshaman | https://github.com/opengeek

4,149 Posts

splittingred Reply #5, 16 years, 4 months ago

http://svn.modxcms.com/docs/display/xPDO20/xPDOQuery

shaun mccormick | bigcommerce mgr of software engineering, former modx co-architect | github | splittingred.com