Line 107 in /home/peerless/public_html/mysite/code/Pages/Page.php
98 requirements::javascript("themes/peerless/dist/js/libs/jquery-3.4.1.min.js"); 99 requirements::javascript("themes/peerless/dist/js/legacy.js"); 100 requirements::javascript("themes/peerless/dist/js/app.js"); 101 requirements::javascript("//fast.fonts.net/jsapi/d016b805-8d04-4cf2-a354-397132bc4125.js"); 102 } 103 public function results($data, $form){ 104 //Requirements::javascript("themes/realserve/js/jquery.highlight.js"); 105 $data = $_REQUEST; 106 //$siteTreeClasses = array('Page','ServiceLandingPage','ServicePage'); 107 $query = htmlspecialchars($data['Search'], ENT_QUOTES,'UTF-8'); 108 109 $sqlQuery = new SQLQuery(); 110 /*$sqlQuery->setFrom('ProductPage_Live'); 111 $sqlQuery->setSelect("SiteTree_Live.*, ProductPage_Live.SKU, ProductPage_Live.ModelNumber, MATCH (SiteTree_Live.Title, SiteTree_Live.Content, ProductPage_Live.SKU, ProductPage_Live.ModelNumber) AGAINST ('$query' IN BOOLEAN MODE) as Score"); 112 $sqlQuery->addLeftJoin('SiteTree_Live','ProductPage_Live.ID = SiteTree_Live.ID'); 113 $sqlQuery->setOrderBy('Score', 'DESC');