I clean a little bit the code :)
This works for me, but my question is:
Where do i have toi clean the data for this search, here in the
controller or inside the model?
function index() {
$this->Benchlink->recursive = 0;
uses('sanitize');
$sanitize = new Sanitize();
$this->set('findUrlNotCleaned', trim($this->data['formFind']
['find']) );
$this->cleanData = $sanitize->clean( $this->data );
$findUrl = low( trim($this->cleanData['formFind']['find']) );
if ( $findUrl != '' ) {
$this->set('benchlinks', $this->paginate('Benchlink',
array("LOWER(`Benchlink`.`url`) LIKE '%" . $findUrl . "%'")));
} else {
$this->set('benchlinks', $this->paginate());
}
}
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---