prepare($sql); $stmt->execute([$powername, $id]); if ($stmt->fetch(PDO::FETCH_ASSOC)['count'] > 0) { echo ""; exit; } $sql = "UPDATE power SET powername = ?, powercontent = ? WHERE id = ?"; $stmt = $conn->prepare($sql); $stmt->execute([$powername, $powercontent, $id]); } else { // Check if power name exists $sql = "SELECT COUNT(id) as count FROM power WHERE powername = ?"; $stmt = $conn->prepare($sql); $stmt->execute([$powername]); if ($stmt->fetch(PDO::FETCH_ASSOC)['count'] > 0) { echo ""; exit; } $sql = "INSERT INTO power (powername, powercontent, powerstate) VALUES (?, ?, 1)"; $stmt = $conn->prepare($sql); $stmt->execute([$powername, $powercontent]); } $page = $_GET['Page'] ?? ''; $keys = urlencode($_GET['Keys'] ?? ''); $ord = urlencode($_GET['Ord'] ?? ''); header("Location: ?keys=$keys&Ord=$ord&Page=$page"); exit; } if ($act == "add" || $act == "edit") { $id = $_GET['id'] ?? ''; $isedit = false; $powername = ''; $powercontent = ''; if ($id != "" && is_numeric($id)) { $isedit = true; $sql = "SELECT powername, powercontent FROM power WHERE id = ?"; $stmt = $conn->prepare($sql); $stmt->execute([$id]); if ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $powername = textUncode($row['powername']); $powercontent = $row['powercontent']; } else { $isedit = false; } } $page = $_GET['Page'] ?? ''; $keys = urlencode($_GET['Keys'] ?? ''); $ord = urlencode($_GET['Ord'] ?? ''); $hrefstr = "?keys=$keys&Ord=$ord&Page=$page"; ?>
权限名称
可用权限
信息管理 /> /> /> />
售后管理 /> />
prepare($sql); $stmt->execute($ids); } header("Location: ?Keys=$keys&Ord=$ord&Page=$page"); exit; } $keys = $_GET['Keys'] ?? ''; $keyscode = textEncode($keys); $ord = $_GET['Ord'] ?? ''; $page = $_GET['Page'] ?? ''; $orderby = "id DESC"; if (in_array($ord, ['powername', 'powername Desc', 'powerstate', 'powerstate Desc', 'powercontent', 'powercontent Desc'])) { $orderby = "$ord, id DESC"; } $sql = "SELECT id, powername, powercontent, powerstate FROM power WHERE id <> 1 AND (powername LIKE ? OR powercontent LIKE ?) ORDER BY $orderby"; $stmt = $conn->prepare($sql); $stmt->execute(["%$keyscode%", "%$keyscode%"]); $results = $stmt->fetchAll(PDO::FETCH_ASSOC); $total_records = count($results); $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; $results = array_slice($results, $start, $records_per_page); $keys = urlencode($keys); $ord = urlencode($ord); $hrefstr = "?keys=$keys"; ?>
序号 ">权限名称 ">可用权限 ">状态 操作
修改
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 ""; } ?>
" onFocus="if(this.value == ''){this.value='';}" onBlur="if(this.value == ''){this.value='';}" onKeyDown="if(event.keyCode==13){location.href='?Keys='+escape(document.getElementById('keys').value)}" />