Monday, December 24, 2012

Re: search by username or email

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.
 
 

No comments: