The Bakery Everything CakePHP

1. In Cake 1.2 you should use App::import() rather than uses()

2. Sanitize methods can be called statically, you don't need to make an instance

3. Sanitize::escape may be more appropriate than Sanitize::clean. The latter will performa a number of transformations on your data by default - such as encoding HTML characters and stripping carriage returns. Unless the data you are searching has been similarly modified, then you may miss matches.

4. I can't see the point of the '1'=>'1 AND' part of the condition - just use a string.

PHP Snippet:

<?php 
# query comes from GET request parameter 'q'
$input = $this->params['url']['q'];

# sanitize the query
App::import('Sanitize');
$q = Sanitize::escape($input);

# now the pagination options hack to perform a fulltext search
# remember we are searching a table called 'listings'
$options['conditions'] = array(
    "MATCH(Listing.title,Listing.description) AGAINST('$q' IN BOOLEAN MODE)"
);

$this->set('results' => $this->paginate('Listing', $options);
?>

Grant, thanks - I've been overlooking the fact that Sanitize methods can be called statically!

For some reason, without the '1' => '1...' the query generation was simply not working for me. I did not investigate, simply tried this and it worked. I will try to find some time to reproduce or try your method in the near future and update the article.

it seems this code:
$this->set('results' => $this->paginate('Listing', $options));

generates this error:
Parse error: syntax error, unexpected T_DOUBLE_ARROW

when i change the line to:
$this->set('results', $this->paginate('Listing', $options));

nothing gets displayed in the browser...

any ideas what's wrong?

I'm pretty new to Cake but I found a different way to get the code working which was submitted by Brit.

Controller Class:

<?php      function index() {

        $this->Line->recursive = 1;
        $conditions = array();
        
        if (isset($this->params['url']['q'])) {
        
            $input = $this->params['url']['q'];
            
            App::import('Sanitize');
            $q = Sanitize::escape($input);
            
            $conditions = array(" MATCH(Listing.title,Listing.description) AGAINST('$q' IN BOOLEAN MODE) ");
        }
    
        $this->set('results', $this->paginate('Listing', $conditions));
         
    } 
?> I'm not sure if it's the best way, but it seems to work fine.
I've eliminated the awkward '1' => "1 snippet
This is using cake_1.2.0.7296-rc2 & php5

Eric

I've updated the tutorial to implement the syntax error in #3 and to remove the 'hack' that does not appear to be necessary anymore.