alert('两次密码输入不一致');history.back();"; exit; } if($isEdit) { $query = "SELECT * FROM employee WHERE id=$id"; $result = $conn->query($query); if($result->num_rows > 0) { $password_sql = $nullPwd ? "" : ",em_password='".md5($em_password)."'"; $sql = "UPDATE employee SET em_user='$em_user'$password_sql,em_role=$em_role, em_code='$em_code',em_email='$em_email',em_tel='$em_tel',em_permission_role_id=$em_permission_role_id WHERE id=$id"; $conn->query($sql); } $page = $_GET['Page'] ?? ''; $keys = urlencode($_GET['Keys'] ?? ''); $ord = urlencode($_GET['Ord'] ?? ''); header("Location: ?keys=$keys&Ord=$ord&Page=$page"); exit; } else { if($nullPwd) { $em_password = "MTB".$em_code; } $sql = "INSERT INTO employee(em_user,em_password,em_role,em_code,em_email,em_tel,em_permission_role_id) VALUES('$em_user','".md5($em_password)."',$em_role,'$em_code','$em_email','$em_tel',$em_permission_role_id)"; $conn->query($sql); header("Location: ?"); exit; } } if($act == "postchk") { $keys = urlencode($_GET['Keys'] ?? ''); $ord = urlencode($_GET['Ord'] ?? ''); $page = $_GET['Page'] ?? ''; $chkact = $_POST['chkact'] ?? ''; if(isset($_POST['chkbox']) && is_array($_POST['chkbox'])) { $sqlStr = "DELETE FROM employee WHERE id IN (" . implode(',', $_POST['chkbox']) . ")"; $conn->query($sqlStr); } header("Location: ?Keys=$keys&Ord=$ord&Page=$page"); exit; } // Now start HTML output ?> 管理区域
query($query); if($result->num_rows > 0) { $row = $result->fetch_assoc(); $em_user = textUncode($row['em_user']); $em_role = $row['em_role']; $em_code = textUncode($row['em_code']); $em_email = textUncode($row['em_email']); $em_tel = textUncode($row['em_tel']); $em_permission_role_id = $row['em_permission_role_id']; } else { $isEdit = false; } } $page = $_GET['Page'] ?? ''; $keys = urlencode($_GET['Keys'] ?? ''); $ord = urlencode($_GET['Ord'] ?? ''); $hrefstr = "?keys=$keys&Ord=$ord&Page=$page"; ?>
用户名
密码
重复密码
工号
该用户上级
权限角色
邮箱
手机
query($query); $keys = urlencode($keys); $ord = urlencode($ord); $hrefstr = "?keys=$keys"; ?>
num_rows > 0) { $pageSize = 13; $totalRows = $result->num_rows; $totalPages = ceil($totalRows / $pageSize); if($page == '') $page = 1; if($page == 'end') $page = $totalPages; if(!is_numeric($page) || $page < 1) $page = 1; $page = (int)$page; if($page > $totalPages) $page = $totalPages; $offset = ($page - 1) * $pageSize; $query .= " LIMIT $offset, $pageSize"; $result = $conn->query($query); $tempNum = $offset; while($row = $result->fetch_assoc()) { $tempNum++; ?> '; } else { echo ''; } } ?>
序号 姓名 工号 角色 操作
修改
Sorry,当前暂无信息
Sorry,没有找到"'.$keyscode.'"相关的信息,点击返回
1) { $pageName = "?Keys=$keys&Ord=$ord&"; $pageLen = 3; if($page > 1) { echo "首页"; echo "上一页"; } if($pageLen * 2 + 1 >= $totalPages) { $startPage = 1; $endPage = $totalPages; } else { if($page <= $pageLen + 1) { $startPage = 1; $endPage = $pageLen * 2 + 1; } else { $startPage = $page - $pageLen; $endPage = $page + $pageLen; } if($page + $pageLen > $totalPages) { $startPage = $totalPages - $pageLen * 2; $endPage = $totalPages; } } for($i = $startPage; $i <= $endPage; $i++) { if($i == $page) { echo "$i"; } else { echo "$i"; } } if($page < $totalPages) { if($totalPages - $page > $pageLen) { echo "...$totalPages"; } echo "下一页"; echo "尾页"; } echo ""; } ?>