No problem. If you have more questions you know what to do. Dave
-----Original Message----- From: Simon [mailto:[email protected]] Sent: September-24-09 12:21 PM To: CakePHP Subject: Re: Search and Find all thank you Dave And Brian i got it i'm knida blonde haha here is what i did function search($item = null) { $item = $this->params['url']['q']; $params = array('conditions' => array( 'AND' => array( 'OR' =>array( 'Post.name LIKE' => '%' . $item . '%', 'Post.date LIKE' => '%' . $item . '%', 'Post.poster LIKE' => '%' . $item . '%'), 'NOT'=>array('Post.active'=> '0'))), 'order' => 'Post.name', 'recursive' => 1)); if (!$item) { $this->Session->setFlash(__('No Search Items Found', true)); $this->redirect(array('action'=>'index')); } $this->set('results', $this->Post->find('all' , $params)); } On Sep 24, 7:18 am, Simon <[email protected]> wrote: > you ment like this correct me if i worng > > function search($item = null) { > $item = $this->params['url']['q']; > $post = $this->Post->find('all', $params => > array('conditions' => array( > 'AND' => array( > 'OR' =>array( > 'Post.name LIKE' => '%' . $item . '%', > 'Post.date LIKE' => '%' . $item . '%', > 'Post.poster LIKE' => '%' . $item . '%'), > 'NOT'=>array('Post.active'=> '0'))), > 'order' => 'Post.name', > 'recursive' => 1)); > > if (!$item) { > $this->Session->setFlash(__('No Search Items > Found', true)); > $this->redirect(array('action'=>'index')); > } > > $this->set('search', $posts); > $this->set('results', $this->Post->find('all' , > $params)); > > } > > On Sep 24, 6:56 am, "Dave Maharaj :: WidePixels.com" > > > > <[email protected]> wrote: > > Your telling it to find nothing. > > > You need to tell it what to find. > > > Like you had before > > > $params => array('conditions' => array( > > 'AND' => array( > > 'OR' =>array( > > 'Post.name LIKE' => '%' . $item . '%', > > 'Post.date LIKE' => '%' . $item . '%', > > 'Post.poster LIKE' => '%' . $item . '%'), > > 'NOT'=>array('Post.active'=> '0'))), > > 'order' => 'Post.name', > > 'recursive' => 1)); > > > $this->set('results', $this->Post->find('all' , $params)); > > > It will find ALL Posts that meet these PARAMS and whatever you > > define in the PARAMS > > > Dave > > > > > > -----Original Message----- > > From: Simon [mailto:[email protected]] > > Sent: September-24-09 11:09 AM > > To: CakePHP > > Subject: Re: Search and Find all > > > hi > > thanks for you time i get parse erorr when i do this > > > $this->set('results', $this->find(...)); > > > i tried it without the dots > > > $this->set('results', $this->find()); > > > then i get > > Call to undefined method PostsController::find() > > > thank you > > > On Sep 23, 5:45 pm, brian <[email protected]> wrote: > > > You're testing for $item but your controller setting a variable $search. > > > > lthough, on 2nd look, you have a problem there, also. You're > > > assigning the result of your find() to $post but, further down, refer to $posts. > > > > Maybe you should simply do: > > > > $this->set('results', $this->find(...)); > > > > view: > > > > if (empty($results)) { ... > > > > On Wed, Sep 23, 2009 at 6:32 PM, Simon <[email protected]> wrote: > > > > > whats the best way to show the user if there is no items found > > > > any code i can use in my view > > > > > this i used but didnt work i got error > > > > > <?php > > > > if (!$item) { > > > > > echo'<p> no items found found</p>'; } ?> > > > > > this is in my post controller > > > > > function search($item = null) { > > > > $item = $this->params['url']['q']; > > > > $post = $this->Post->find('all', > > > > array('conditions' => array( > > > > 'AND' => array( > > > > 'OR' =>array( > > > > 'Post.name LIKE' => '%' . $item . '%', > > > > 'Post.date LIKE' => '%' . $item . '%', > > > > 'Post.poster LIKE' => '%' . $item . '%'), > > > > 'NOT'=>array('Post.active'=> '0'))), > > > > 'order' => 'Post.name', > > > > 'recursive' => 1)); > > > > > if (!$item) { > > > > $this->Session->setFlash(__('No Search > > > > Items Found', true)); > > > > > > > > $this->redirect(array('action'=>'index')); > > > > } > > > > > $this->set('search', $posts); > > > > }- Hide quoted text - > > > > - Show quoted text -- Hide quoted text - > > > - Show quoted text -- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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 -~----------~----~----~----~------~----~------~--~---
