PHPCMS制作搜索
$siteid = isset($_REQUEST['siteid']) && trim($_REQUEST['siteid']) ? intval($_REQUEST['siteid']) : 1;
$typeid = empty($_GET['typeid']) ? 1 : intval($_GET['typeid']);
$database = pc_base::load_model('content_model');
$q = safe_replace(trim($_GET['q']));
$q = new_html_special_chars(strip_tags($q));
$q = str_replace('%', '', $q); //过滤'%',用户全文搜索
$search_q = $q;
$time = empty($_GET['time']) || !in_array($_GET['time'],array('all','day','month','year','week')) ? 'all' : trim($_GET['time']);
$sql = "`title` like '%$q%'";
//按时间搜索
if($time == 'day') {
$search_time = SYS_TIME - 86400;
$sql_time = ' AND inputtime > '.$search_time;
} elseif($time == 'week') {
$search_time = SYS_TIME - 604800;
$sql_time = ' AND inputtime > '.$search_time;
} elseif($time == 'month') {
$search_time = SYS_TIME - 2592000;
$sql_time = ' AND inputtime > '.$search_time;
} elseif($time == 'year') {
$search_time = SYS_TIME - 31536000;
$sql_time = ' AND inputtime > '.$search_time;
} else {
$search_time = 0;
$sql_time = '';
}
if($sql_time){
$sql = $sql.$sql_time;
}
$data1 = $result = $this->db->listinfo($sql, 'id DESC', $page, 10);
$pages = $this->db->pages;
$totalnums = $this->db->number;
include template('search','list');