hi cricket,... thank you for your reply,... I have tried it,... and still
have no luck,...
$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(
'limit' => $limit,
'page' => $page,
'conditions' => array(
"MATCH(User.firstname) AGAINST('${q}' IN BOOLEAN MODE)"
),
'contain' => array()
)
);
}
On Monday, March 4, 2013 4:56:18 PM UTC-8, cricket wrote:
>
> $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 <[email protected] <javascript:>>
> 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'))
> >> ?>
> >> <?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 [email protected] <javascript:>.
> > To post to this group, send email to [email protected]<javascript:>.
>
> > 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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
