当前位置：首页 > PHP

php 实现排名

2026-01-15 13:11:36PHP

PHP 实现排名的方法

在 PHP 中实现排名功能通常涉及对数据进行排序、计算排名以及输出结果。以下是几种常见的实现方式：

基本数组排序排名

$scores = [85, 92, 78, 95, 88];
rsort($scores); // 降序排序

$rank = 1;
foreach ($scores as $score) {
    echo "Rank $rank: $score\n";
    $rank++;
}

处理并列排名

当存在相同分数时，需要处理并列排名：

$scores = [85, 92, 78, 92, 88];
rsort($scores);

$rank = 1;
$prevScore = null;
$count = count($scores);

for ($i = 0; $i < $count; $i++) {
    if ($scores[$i] != $prevScore) {
        $rank = $i + 1;
    }
    echo "Rank $rank: {$scores[$i]}\n";
    $prevScore = $scores[$i];
}

数据库查询排名

从数据库获取数据并计算排名：

// 假设使用 PDO 连接数据库
$pdo = new PDO('mysql:host=localhost;dbname=test', 'username', 'password');
$stmt = $pdo->query('SELECT name, score FROM users ORDER BY score DESC');

$rank = 1;
$prevScore = null;
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);

foreach ($results as $i => $row) {
    if ($row['score'] != $prevScore) {
        $rank = $i + 1;
    }
    echo "Rank $rank: {$row['name']} - {$row['score']}\n";
    $prevScore = $row['score'];
}

使用窗口函数（MySQL 8.0+）

如果使用 MySQL 8.0 或更高版本，可以直接在 SQL 查询中使用窗口函数计算排名：

$pdo = new PDO('mysql:host=localhost;dbname=test', 'username', 'password');
$stmt = $pdo->query('
    SELECT name, score, 
           DENSE_RANK() OVER (ORDER BY score DESC) AS rank
    FROM users
');

$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($results as $row) {
    echo "Rank {$row['rank']}: {$row['name']} - {$row['score']}\n";
}

分组排名

需要对不同组别分别计算排名时：

$pdo = new PDO('mysql:host=localhost;dbname=test', 'username', 'password');
$stmt = $pdo->query('
    SELECT department, name, score,
           DENSE_RANK() OVER (PARTITION BY department ORDER BY score DESC) AS dept_rank
    FROM employees
');

$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($results as $row) {
    echo "{$row['department']} - Rank {$row['dept_rank']}: {$row['name']} - {$row['score']}\n";
}