📞 09318539889 📧 yxp@gansuwangzhan.cn

PHPCMS制作搜索

作者:admin时间:2021-04-20点击量:6次

$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');