$addsql = '';
if ($keyword) {
$keyword = trim($keyword);
$keywordarray = explode(",", $keyword);
foreach ($keywordarray as $value) {
$value = str_replace('*', '%', $value);
$keywhere .= " OR keyword LIKE " . S::sqlEscape("%{$value}%");
}
$keywhere = substr_replace($keywhere, "", 0, 3);
$addsql .= " AND ({$keywhere}) ";
}
if ($createtime_s) {
$addsql .= " AND created_time >= " . s::sqlEscape(PwStrtoTime($createtime_s));
}
if ($createtime_e) {
$addsql .= " AND created_time <= " . s::sqlEscape(PwStrtoTime($createtime_e));
}
$statisticDb = array();
$sql = "SELECT keyword, sum( num ) AS times FROM `pw_searchstatistic` WHERE 1 {$addsql} GROUP BY keyword ORDER BY times DESC LIMIT 0 , 500";
$qurey = $db->query($sql);
while ($rt = $db->fetch_array($qurey)) {
$rt['keyword'] = str_replace(array(" ", "=", " ", "<", "<", ">", ">", "(", ")", ")"), array(" "), $rt['keyword']);
$statisticDb[] = $rt;
}
}
include PrintEot('searcher');
exit;
/**
* 更新缓存
*/
function updatecache_search()
