php项目统计球员评分最高者是谁？

wen PHP项目 2026-08-14 165

本文目录导读：

php项目统计球员评分最高者是谁？

场景一：数据存储在PHP数组中
场景二：数据从MySQL数据库查询
场景三：面向对象封装（推荐）
场景四：从JSON文件读取数据
性能优化建议

在PHP项目中统计球员评分最高者,可以根据数据存储方式（数组、MySQL数据库等）采用不同的方法，以下是几种常见场景的解决方案：

数据存储在PHP数组中

<?php
// 假设数据格式如下
$players = [
    ['name' => '梅西', 'rating' => 8.5],
    ['name' => 'C罗', 'rating' => 7.8],
    ['name' => '内马尔', 'rating' => 9.2],
    ['name' => '姆巴佩', 'rating' => 8.9],
    ['name' => '哈兰德', 'rating' => 8.7]
];
// 方法1：使用array_column获取所有评分
$ratings = array_column($players, 'rating');
$maxRating = max($ratings);
// 找到所有最高分的球员
$topPlayers = array_filter($players, function($player) use ($maxRating) {
    return $player['rating'] == $maxRating;
});
echo "最高评分: {$maxRating}<br>";
echo "最高分球员: ";
foreach ($topPlayers as $player) {
    echo $player['name'] . " ";
}
// 方法2：使用usort排序（更灵活）
usort($players, function($a, $b) {
    return $b['rating'] - $a['rating'];
});
echo "<br>排名第一的球员: " . $players[0]['name'] . " (评分: " . $players[0]['rating'] . ")";
?>

数据从MySQL数据库查询

<?php
// 假设有players表，包含name和rating字段
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "football_db";
try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    // 查询最高评分球员（可能有多个）
    $sql = "SELECT name, rating FROM players 
            WHERE rating = (SELECT MAX(rating) FROM players)";
    $stmt = $conn->prepare($sql);
    $stmt->execute();
    $topPlayers = $stmt->fetchAll(PDO::FETCH_ASSOC);
    echo "最高评分球员:<br>";
    foreach ($topPlayers as $player) {
        echo "姓名: " . $player['name'] . " | 评分: " . $player['rating'] . "<br>";
    }
} catch(PDOException $e) {
    echo "查询失败: " . $e->getMessage();
}
// 或者使用更高效的查询（只取前1条）
$sql = "SELECT name, rating FROM players ORDER BY rating DESC LIMIT 1";
?>

面向对象封装（推荐）

<?php
class PlayerStatistic {
    private $players;
    public function __construct($players) {
        $this->players = $players;
    }
    /**
     * 获取最高评分的球员
     * @return array 包含最高分球员信息
     */
    public function getHighestRatedPlayer() {
        if (empty($this->players)) {
            return ['error' => '暂无球员数据'];
        }
        // 计算最高分
        $maxScore = -INF;
        $bestPlayers = [];
        foreach ($this->players as $player) {
            if ($player['rating'] > $maxScore) {
                $maxScore = $player['rating'];
                $bestPlayers = [$player]; // 重置为当前球员
            } elseif ($player['rating'] == $maxScore) {
                $bestPlayers[] = $player; // 如果平分，加入数组
            }
        }
        return [
            'max_score' => $maxScore,
            'players' => $bestPlayers
        ];
    }
    /**
     * 获取球员排名（降序）
     * @return array 按评分降序排列的球员
     */
    public function getRanking() {
        $ranking = $this->players;
        usort($ranking, function($a, $b) {
            return $b['rating'] - $a['rating'];
        });
        return $ranking;
    }
    /**
     * 获取平均评分
     */
    public function getAverageRating() {
        if (empty($this->players)) return 0;
        $total = array_sum(array_column($this->players, 'rating'));
        return round($total / count($this->players), 2);
    }
}
// 使用示例
$playerData = [
    ['name' => '李华', 'rating' => 8.2],
    ['name' => '王强', 'rating' => 9.5],
    ['name' => '张伟', 'rating' => 7.9],
    ['name' => '赵敏', 'rating' => 9.5], // 与王强平分
    ['name' => '刘洋', 'rating' => 8.8]
];
$statistics = new PlayerStatistic($playerData);
$result = $statistics->getHighestRatedPlayer();
echo "最高评分: " . $result['max_score'] . "<br>";
echo "最高分球员: ";
foreach ($result['players'] as $p) {
    echo $p['name'] . " ";
}
?>

从JSON文件读取数据

<?php
// data.json 示例
// [{"name":"梅西","rating":8.5},{"name":"C罗","rating":7.8}]
$jsonData = file_get_contents('players.json');
$players = json_decode($jsonData, true);
$highest = null;
$maxScore = -INF;
foreach ($players as $player) {
    if ($player['rating'] > $maxScore) {
        $maxScore = $player['rating'];
        $highest = $player;
    }
}
if ($highest) {
    echo "最高评分球员: " . $highest['name'] . " | 评分: " . $maxScore;
} else {
    echo "暂无球员数据";
}
?>