Re: search filter in cake 1.3

$this->paginate = array(
'limit' => $limit,
'page' => $page,
'conditions' => array(
"MATCH(User.firstname) AGAINST('${q}' IN BOOLEAN MODE)"
),
'contain' => array()
);

The $limit & $page vars are gotten from $this->request. And you really
should be escaping the find param with the Sanitize class. The "IN
BOOLEAN MODE"part is of course optional.

On Mon, Mar 4, 2013 at 6:49 PM, Chris <chris69m@yahoo.com> wrote:
> anyone?
>
> On Sunday, March 3, 2013 4:45:08 PM UTC-8, Chris wrote:
>>
>> hi guys,... can anyone help please,... I'm using cake 1.3
>> how can I filter search results by user firstname
>>
>> this is my form input:
>>
>> <?php echo $this->Form->create('User', array('action' => 'search')); ?>
>> <?php echo $this->Form->text('find', array('style' => 'width: 60px'))
>> ?>&nbsp;
>> <?php echo $this->Form->end(__('Search', true)); ?>
>>
>> and this is my users_controller.php
>>
>>
>> function search()
>> {
>>
>> $this->User->recursive = 0;
>> $params = $this->params['url'];
>>
>> if (!array_key_exists("find", $params)) {
>>
>> $this->set('users', $this->paginate());
>> }
>> else
>> {
>> $this->set('users', $this->paginate(array("User.firstname LIKE
>> '{$params['find']}%'")));
>> }
>>
>> }
>>
>> thanks in advance
>> chris
>>
> --
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>
> ---
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to cake-php+unsubscribe@googlegroups.com.
> To post to this group, send email to cake-php@googlegroups.com.
> Visit this group at http://groups.google.com/group/cake-php?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.