/**
* 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();
}
