Re: search by username or email

not working is a little bit vage..

you should post in more detail what exactly is happening

also note, that it usually is better to use array syntax as cake can clean/prepare the sql statements then a little bit better:

    $scope[] = array('User.' . $field . ' LIKE' => '%' . $filter[$field] . '%');

Am Dienstag, 25. Dezember 2012 03:45:23 UTC+1 schrieb zuha:

That is some funky looking code there, but you could just use the "OR" key.  Here's an example...

$this->find('first', array(

     'conditions' => array(

          'OR' => array(

               'User.username' => $value,

               'User.email' => $value

           )

      )

));

On Saturday, December 15, 2012 4:12:13 AM UTC-5, Chris wrote:

hi guys,... I have a admin function that need find users by username or email from search field,... and used to work on cake1.2 

I moved script to 1.3 ,... and it's not working.... what am I doing wrong,... ?? please help

      $filter = $this->params['pass'];

      unset($filter['page']);

      unset($filter['sort']);

      unset($filter['direction']);

      $this->data = array('User' => $filter);

      $this->set('url_options', $filter);

      $scope = array();

      foreach(array('username', 'email') as $field)

      {

        if(!empty($filter[$field]))

          $scope[] = 'User.' . $field . ' LIKE \'%' . $filter[$field] . '%\'';

      } 

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 post to this group, send email to cake-php@googlegroups.com.
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.