Original

Versions

07.09 php saved
louiemiranda
Tags add more
 
Note
paginate with fulltext search, working if $keyword is static. Since this code is dynamic, the pagination is not working when going to page 2 and so on.
  1. function sresults() {
  2.       $options = array();
  3.       $keywords = trim($this->data['Publication']['keywords']);
  4.  
  5.       $scope = array("MATCH(Publication.ITEMCODE, Publication.ITEMCODE_OLD, Publication.ITEMSTOCK, Publication.ITEMSUBCAT, Publication.ITEMNAME, Publication.ITEMLANGUAGE, Publication.ITEMISSUE, Publication.ITEMINFORMATION, Publication.ITEMDISTRIBUTION, Publication.ITEMPRODURL, Publication.ITEMKEYWORDS, Publication.ITEMREPORTTYPE)
  6.       AGAINST ('".$keywords."')");
  7.       $results = $this->paginate('Publication',$scope);
  8.       $this->set('results', $results);
  9.  
  10.       $this->set('flashMessage', 'Status of item');
  11.       $this->render('sresults');
  12. }
Parsed in 0.029 seconds, using GeSHi 1.0.7.14

Modify this Paste