CakePHP - Search bar

Contents

    This code snippet will create a search box that uses can use to search for text in the database. The control creates a query to search certain fields of publsihed stories

    View or layout: <?php echo $form->create('Stories', array('url' => array('action' => 'index'))); echo $form->input('search_text', array('label' => false)); echo $form->end('Search'); ?>

    Controler: <?php function admin_index( ) { $conditions = array( 'Story.terms !=' => '0' ) ; if( isset( $this->data['Stories']['search_text'] ) ) { $this->set('title', ' Search "'. $this->data['Stories']['search_text'] .'"' ); $conditions = array( 'Story.published' => '1', 'or' => array( 'Story.title LIKE' => '%' . $this->data['Stories']['search_text'] . '%', 'Author.name LIKE' => '%' . $this->data['Stories']['search_text'] . '%' )); }

    $data = $this->paginate( 'Story', $conditions); $this->set('data', $data ); } ?>