real_escape_string($powername) . "' AND id != " . $id; $result = $conn->query($sql); if ($result->fetch_assoc()['count'] > 0) { echo ""; exit; } $sql = "UPDATE power SET powername = '" . $conn->real_escape_string($powername) . "', powercontent = '" . $conn->real_escape_string($powercontent) . "' WHERE id = " . $id; $conn->query($sql); } else { // Check if power name exists $sql = "SELECT COUNT(id) as count FROM power WHERE powername = '" . $conn->real_escape_string($powername) . "'"; $result = $conn->query($sql); if ($result->fetch_assoc()['count'] > 0) { echo ""; exit; } $sql = "INSERT INTO power (powername, powercontent, powerstate) VALUES ('" . $conn->real_escape_string($powername) . "', '" . $conn->real_escape_string($powercontent) . "', 1)"; $conn->query($sql); } header("Location: ?keys=$keys&Ord=$ord&Page=$page"); exit; } // Handle postchk action if ($act == "postchk") { if (isset($_POST['chkbox']) && is_array($_POST['chkbox'])) { $ids = array_map('intval', $_POST['chkbox']); $idList = implode(',', $ids); $chkact = $_POST['chkact'] ?? ''; if ($chkact == "0" || $chkact == "1") { $sql = "UPDATE power SET powerstate = " . (int)$chkact . " WHERE id IN (" . $idList . ")"; } else { $sql = "DELETE FROM power WHERE id IN (" . $idList . ")"; } $conn->query($sql); } header("Location: ?Keys=$keys&Ord=$ord&Page=$page"); exit; } // Now start HTML output ?> 管理区域
query($sql); if ($row = $result->fetch_assoc()) { $powername = textUncode($row['powername']); $powercontent = $row['powercontent']; } else { $isedit = false; } } $hrefstr = "?keys=$keys&Ord=$ord&Page=$page"; ?>
权限名称
可用权限
信息管理 /> /> /> />
售后管理 /> />
1 AND (powername LIKE '%" . $conn->real_escape_string($keyscode) . "%' OR powercontent LIKE '%" . $conn->real_escape_string($keyscode) . "%') ORDER BY $orderby"; $result = $conn->query($sql); $total_records = $result->num_rows; $records_per_page = 10; $total_pages = ceil($total_records / $records_per_page); if ($page == "") $page = 1; if ($page == "end") $page = $total_pages; if (!is_numeric($page) || $page < 1) $page = 1; $page = (int)$page; if ($page > $total_pages) $page = $total_pages; $start = ($page - 1) * $records_per_page; $sql .= " LIMIT $start, $records_per_page"; $result = $conn->query($sql); $hrefstr = "?keys=$keys"; ?>
num_rows > 0) { $tempNum = ($page - 1) * $records_per_page; while ($row = $result->fetch_assoc()) { $tempNum++; ?>
序号 ">权限名称 ">可用权限 ">状态 操作
修改
Sorry,当前暂无权限
Sorry,没有找到""相关的权限,点击返回
1) { $pageName = "?Keys=$keys&Ord=$ord&"; $pagelen = 3; if ($page > 1) { echo "首页"; echo "上一页"; } if ($pagelen * 2 + 1 >= $total_pages) { $startPage = 1; $endPage = $total_pages; } else { if ($page <= $pagelen + 1) { $startPage = 1; $endPage = $pagelen * 2 + 1; } else { $startPage = $page - $pagelen; $endPage = $page + $pagelen; } if ($page + $pagelen > $total_pages) { $startPage = $total_pages - $pagelen * 2; $endPage = $total_pages; } } for ($i = $startPage; $i <= $endPage; $i++) { if ($i == $page) { echo "$i"; } else { echo "$i"; } } if ($page < $total_pages) { if ($total_pages - $page > $pagelen) { echo "...$total_pages"; } echo "下一页"; echo "尾页"; } echo ""; } ?>