$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()