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
-~----------~----~----~----~------~----~------~--~---

Reply via email to