服务器列表

require_once 'config/database.php'; $conn = connectToDatabase($servername, $username, $password, $dbname); // 获取筛选参数 $search = isset($_GET['search']) ? trim($_GET['search']) : ''; $statusFilter = isset($_GET['status']) ? $_GET['status'] : ''; // 构建SQL查询 - 显示所有状态 $sql = "SELECT server_number, status, version, series, created_at FROM tasks"; $conditions = []; $params = []; $types = ''; // 添加搜索条件 if (!empty($search)) { $conditions[] = "(server_number LIKE ? OR version LIKE ? OR series LIKE ?)"; $searchParam = "%{$search}%"; $params[] = $searchParam; $params[] = $searchParam; $params[] = $searchParam; $types .= 'sss'; } // 添加状态筛选条件 if (!empty($statusFilter)) { $conditions[] = "status = ?"; $params[] = $statusFilter; $types .= 's'; } // 如果有条件，添加WHERE子句 if (!empty($conditions)) { $sql .= " WHERE " . implode(" AND ", $conditions); } // 添加排序 $sql .= " ORDER BY created_at DESC"; // 准备并执行查询 $stmt = $conn->prepare($sql); if (!empty($params)) { $stmt->bind_param($types, ...$params); } $stmt->execute(); $result = $stmt->get_result(); $servers = []; if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { // 隐藏服务器号后4位 $server_number = substr($row['server_number'], 0, -4) . '****'; $servers[] = [ 'server_number' => $server_number, 'original_number' => $row['server_number'], 'status' => $row['status'], 'version' => $row['version'], 'series' => $row['series'], 'created_at' => $row['created_at'] ]; } } // 获取所有状态用于筛选器（包括准备发布） $statuses = []; $statusSql = "SELECT DISTINCT status FROM tasks ORDER BY status"; $statusResult = $conn->query($statusSql); if ($statusResult->num_rows > 0) { while($row = $statusResult->fetch_assoc()) { $statuses[] = $row['status']; } } // 如果"准备发布"状态不在数据库中，手动添加 $hasReleaseStatus = false; foreach($statuses as $s) { if($s == '准备发布') { $hasReleaseStatus = true; break; } } if(!$hasReleaseStatus) { $statuses[] = '准备发布'; sort($statuses); // 保持排序 } $conn->close(); ?> 服务器列表

共
Warning: count(): Parameter must be an array or an object that implements Countable in /wwwroot/wwwroot/lejiaedt.fu123.top/server_list.php on line 445
0 个查询

暂无符合条件的服务器

尝试调整搜索条件或筛选器，查看更多服务器信息