Esempio n. 1
0
$error = array();
$updateMessage = '';
//批量修改
if ($dopost == 'mut_edit') {
    $idArr = $_POST["cid"];
    $totalExec = 0;
    foreach ($idArr as $id) {
        $alias = isset($_POST["alias"][$id]) ? $_POST["alias"][$id] : '';
        $sort = isset($_POST["sort"][$id]) ? $_POST["sort"][$id] : '';
        $sql = 'SELECT * FROM `help_category` WHERE `alias`="' . $alias . '" AND `id`<>"' . $id . '"';
        $rs = $pdo->query($sql);
        $row = $rs->fetchAll();
        //取得所有记录
        if (count($row) == 0) {
            $row = array('sort' => $sort, 'alias' => $alias);
            $result = Help_categoryModel::model()->update(array('id' => $id), $row);
            $totalExec += $result;
            $totalExec += $result;
        } else {
            $error[] = $title . '【名称重复】!';
        }
    }
    if ($totalExec <= 0) {
        echo $sql;
    }
    $updateMessage = "更新" . $totalExec . "条数据";
}
//删除单个数据
$delflag = $_GET["delflag"];
if ($delflag == 1) {
    $id = $_GET["id"];
Esempio n. 2
0
        if ($level == 3) {
            $topParentId = $_POST['top_parent_id'] = $help_categoryData['parent_id'];
        } elseif ($level == 2) {
            $topParentId = $_POST['top_parent_id'] = $help_categoryData['id'];
        } else {
            $topParentId = $_POST['top_parent_id'] = 0;
        }
        $_POST['level'] = $level;
    }
    if ($name == "" || $alias == "") {
        $createMessage = "请把分类信息填写完整!!";
    } else {
        $sql = 'SELECT * FROM `help_category` WHERE name="' . $name . '" or alias ="' . $alias . '"';
        $rs = $pdo->query($sql);
        $row = $rs->fetchAll();
        //取得所有记录
        $count = count($row);
        if ($count == 0) {
            // var_dump($_POST);
            $lastetId = Help_categoryModel::model()->create($_POST);
            if ($lastetId != FALSE) {
                $createMessage = "添加成功";
            } else {
                echo $sql;
                $createMessage = "添加失败";
            }
        } else {
            $createMessage = '分类名称重复 或者 别名重复!';
        }
    }
}