search.php

<?php
// Loads everything needed to run PacerCMS
include_once('includes/cm-header.php');

// List of acceptable values
$sort_by_list['article_publish'] = 'article_publish';
$sort_by_list['article_title'] = 'article_title';
$sort_by_list['article_subtitle'] = 'article_subtitle';
$sort_by_list['article_author'] = 'article_author';
$sort_by_list['article_word_count'] = 'article_word_count';

// Get set values
$string = strip_tags($_GET['s']);
$index = strip_tags($_GET['index']);
$sort_by = strip_tags($sort_by_list[$_GET['sort_by']]);
$sort_dir = strip_tags($_GET['sort_dir']);

// Make sure defaults are set
if (empty($index)) { $index = 'article'; }
if ($sort_dir != 'ASC') { $sort_dir = 'DESC'; }
if (empty($sort_by)) { $sort_by = 'article_publish'; }

// These allow for short inline URLs
if ($_GET['s_by'] == "author")
{
	$index = "author";
	$sort_by = "article_publish";
	$sort_dir = "DESC";

}
if ($_GET['s_by'] == "keyword")
{
	$index = "keyword";
	$sort_by = "article_publish";
	$sort_dir = "DESC";
}

$current_issue_id = current_issue('id');
$next_issue_date = next_issue('date');

// Set search mode
if ($index == "article") { $field = "article_text,article_title,article_subtitle"; }
if ($index == "author") { $field = "article_author"; }
if ($index == "keyword") { $field = "article_keywords"; }

$query = "SELECT cm_articles.id, cm_articles.id AS article_id, "; // article_id depreciated
$query .= " article_title, article_summary, article_author, article_word_count, article_publish, section_name ";
$query .= " FROM cm_articles INNER JOIN cm_sections ON cm_articles.section_id = cm_sections.id ";
$query .= " WHERE MATCH ($field) AGAINST ('$string' IN BOOLEAN MODE) AND article_publish < '$next_issue_date' ";
$query .= " ORDER BY $sort_by $sort_dir;";

// Run query
$result = run_query($query);
if (!empty($result)) {
    while ($array = $result->GetArray()) {
        $article_list = $array;
    }
}

$smarty->assign("article_list", $article_list);

// Assign variables
$smarty->assign("search_string", stripslashes($string) );
$smarty->assign("page_title", "Search for ''$string''");

// Index
$smarty->assign("s_index_values", array("article","author","keyword"));
$smarty->assign("s_index_names", array("Article &amp; Headlines","Author","Keyword"));
$smarty->assign("s_index_select", $index);

// Sort By
$smarty->assign("s_sort_by_values", array("article_publish","article_title","article_subtitle","article_author","article_word_count"));
$smarty->assign("s_sort_by_names", array("Publish Date","Headline","Sub-Headline","Author Name","Word Count"));
$smarty->assign("s_sort_by_select", $sort_by);

// Sort Direction
$smarty->assign("s_sort_dir_values", array("DESC","ASC"));
$smarty->assign("s_sort_dir_names", array("Descending","Ascending"));
$smarty->assign("s_sort_dir_select", $sort_dir);


// Render
$smarty->display("search.tpl");