$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"];
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 = '分类名称重复 或者 别名重复!'; } } }