Esempio n. 1
0
$curpage = isset($curpage) && is_numeric($curpage) ? $curpage : 1;
if ($curpage < 1) {
    $curpage = 1;
}
$searchkey = $_POST["searchkey"];
$keywhere = "";
if ($searchkey != "") {
    $keywhere = "where name like '%{$searchkey}%'";
}
$keywordsdata = new Keywords();
$keywordscount = $keywordsdata->GetKeywordsList($keywhere);
$total = count($keywordscount);
$take = 20;
$skip = ($curpage - 1) * $take;
$totalpage = (int) ($total % $take == 0 ? $total / $take : $total / $take + 1);
$keywordslist = $keywordsdata->TakeKeywordsList($skip, $take, $keywhere);
$action = $_POST["action"];
if ($action == "update") {
    $idarr = $_POST["chk"];
    if (count($idarr) > 0) {
        foreach ($idarr as $id) {
            $name = $_POST["name"];
            $url = $_POST["url"];
            $order = $_POST["order"];
            if (is_numeric($id)) {
                $sql = "update yiqi_keywords set name='" . $name[$id] . "',url='" . $url[$id] . "',displayorder='" . $order[$id] . "' WHERE kid = '{$id}' limit 1";
                $yiqi_db->query(CheckSql($sql));
            }
        }
        ShowMsg("指定关键词更新成功");
    }