帝国CMS调用用户热门搜索关键词方法

<?php
$urls = $_SERVER["QUERY_STRING"];
$sid = explode("=", $urls);
$sids = $sid[2];
$res = $empire->fetch1("select * from {$dbtbpre}enewssearch where searchid = $sids");
$sql = $empire->query("select * from {$dbtbpre}enewssearch where keyboard LIKE '%$res[keyboard]%' ORDER BY onclick DESC");
while($tr = $empire->fetch($sql)){
    $url = '/search-0-'.$tr[searchid].'.html';
    echo '搜索关键词：'.$tr[keyboard].'<br>';
    echo '关键词url：'.$url.'<br>';
    echo '搜索次数：'.$tr[onclick].'<hr>';
}
?>