/** * Print search results for a given search string. * @param $searchString * @param $limit * @param $page * @param $viewAll */ function printSearchResults($searchString, $limit = 0, $page = 0, $viewAll = 0) { global $dbi, $login; $result = $dbi->query("SELECT id,MATCH(name) AGAINST ('{$searchString}' IN BOOLEAN MODE) AS score FROM " . contributorTableName . " WHERE MATCH(name) AGAINST ('{$searchString}' IN BOOLEAN MODE) ORDER BY name" . (!empty($limit) && $viewAll ? " LIMIT " . $limit * $page . "," . $limit : (!empty($limit) ? " LIMIT " . $limit : ""))); if ($result->rows()) { $highlight = str_replace("\"", "", stripslashes($searchString)); for ($i = 0; list($id, $score) = $result->fetchrow_array(); $i++) { $contributor = new Contributor($id); printSearchResultItem($searchString, $contributor->name, "Ingen beskrivelse.", $contributor->getLink($id), $score); } } $result->finish(); }
/** * Print search results for a given search string. * @param $searchString * @param $limit * @param $page * @param $viewAll */ function printSearchResults($searchString, $limit = 0, $page = 0, $viewAll = 0) { global $dbi, $login; $result = $dbi->query("SELECT id,MATCH(subject,summary,text) AGAINST ('{$searchString}' IN BOOLEAN MODE) AS score FROM " . blogPostTableName . " WHERE MATCH(subject, summary, text) AGAINST ('{$searchString}' IN BOOLEAN MODE) AND draft=0 ORDER BY posted DESC" . (!empty($limit) && $viewAll ? " LIMIT " . $limit * $page . "," . $limit : (!empty($limit) ? " LIMIT " . $limit : ""))); if ($result->rows()) { $highlight = str_replace("\"", "", stripslashes($searchString)); for ($i = 0; list($id, $score) = $result->fetchrow_array(); $i++) { $post = new Post($id); printSearchResultItem($searchString, $post->subject, !empty($post->text) ? $post->text : $post->summary, $post->getPostLink(), $score); } } $result->finish(); }
/** * Print search results for a given search string. * @param $searchString * @param $limit * @param $page * @param $viewAll */ function printSearchResults($searchString, $limit = 0, $page = 0, $viewAll = 0) { global $dbi, $login; $result = $dbi->query("SELECT id,MATCH(title,text,leftText,rightText) AGAINST (" . $dbi->quote($searchString) . " IN BOOLEAN MODE) AS score FROM " . pageTableName . " WHERE MATCH(title, text, leftText, rightText) AGAINST (" . $dbi->quote($searchString) . " IN BOOLEAN MODE) ORDER BY score DESC" . (!empty($limit) && $viewAll ? " LIMIT " . $limit * $page . "," . $limit : (!empty($limit) ? " LIMIT " . $limit : ""))); $highlight = str_replace("\"", "", stripslashes($searchString)); for ($i = 0; list($id, $score) = $result->fetchrow_array(); $i++) { $page = new Page($id); printSearchResultItem($searchString, $page->title, $page->text, $page->getPageLink(), $score); } $result->finish(); }