PHP项目统计"落叶球"射门成功率方案
落叶球(Knuckleball)是足球中一种特殊的射门方式,球在空中几乎不旋转、轨迹飘忽,下面给出一个完整的PHP实现思路。

数据模型设计
首先需要设计数据表结构,关键字段是射门类型和结果。
CREATE TABLE shots (
id INT AUTO_INCREMENT PRIMARY KEY,
player_id INT NOT NULL,
match_id INT NOT NULL,
shot_type ENUM('knuckleball','curve','power','chip','normal') NOT NULL,
is_goal TINYINT(1) NOT NULL DEFAULT 0, -- 是否进球
is_on_target TINYINT(1) DEFAULT 0, -- 是否射正
distance DECIMAL(5,2), -- 射门距离(米)
minute INT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
INDEX idx_type (shot_type),
INDEX idx_player (player_id)
);
核心统计逻辑
基础成功率统计(SQL)
<?php
class ShotStatistics
{
private PDO $pdo;
public function __construct(PDO $pdo)
{
$this->pdo = $pdo;
}
/**
* 统计指定射门类型的成功率
* 成功率 = 进球数 / 射门总数 * 100%
*/
public function successRate(string $shotType): array
{
$sql = "SELECT
COUNT(*) AS total_shots,
SUM(is_goal) AS goals,
SUM(is_on_target) AS on_target,
ROUND(SUM(is_goal) / COUNT(*) * 100, 2) AS goal_rate,
ROUND(SUM(is_on_target) / COUNT(*) * 100, 2) AS on_target_rate
FROM shots
WHERE shot_type = :type";
$stmt = $this->pdo->prepare($sql);
$stmt->execute([':type' => $shotType]);
return $stmt->fetch(PDO::FETCH_ASSOC) ?: [];
}
}
计算要点:
- 成功率分母必须是该类型射门总次数,不能只算射正次数
- 使用
ROUND(..., 2)保留两位小数 SUM(is_goal)因为字段是 0/1,直接求和即进球数
分类对比统计
public function compareAllTypes(): array
{
$sql = "SELECT
shot_type,
COUNT(*) AS total,
SUM(is_goal) AS goals,
ROUND(SUM(is_goal)/COUNT(*)*100, 2) AS rate
FROM shots
GROUP BY shot_type
ORDER BY rate DESC";
return $this->pdo->query($sql)->fetchAll(PDO::FETCH_ASSOC);
}
按球员统计落叶球成功率
public function playerKnuckleballStats(int $playerId): array
{
$sql = "SELECT
p.name,
COUNT(s.id) AS total,
SUM(s.is_goal) AS goals,
CASE WHEN COUNT(s.id) = 0 THEN 0
ELSE ROUND(SUM(s.is_goal)/COUNT(s.id)*100, 2)
END AS rate
FROM players p
LEFT JOIN shots s
ON s.player_id = p.id AND s.shot_type = 'knuckleball'
WHERE p.id = :pid
GROUP BY p.id";
$stmt = $this->pdo->prepare($sql);
$stmt->execute([':pid' => $playerId]);
return $stmt->fetch(PDO::FETCH_ASSOC) ?: [];
}
关键陷阱与处理
| 问题 | 处理方式 |
|---|---|
| 除以零 | 用 CASE WHEN COUNT(*)=0 THEN 0,或 PHP 层判断 $total > 0 |
| 样本量太小 | 低于 10 次射门不建议展示胜率,加阈值过滤 HAVING total >= 10 |
| 射正 vs 进球定义 | 明确"成功"定义:进球率 / 射正率,二者分开统计 |
| 数据一致性 | 进球数不要超过射门数,可加约束或定期校验 |
| NULL 值 | is_goal 建议 NOT NULL DEFAULT 0 |
防止小样本误导
public function reliableRate(string $type, int $minShots = 10): ?float
{
$stats = $this->successRate($type);
if (($stats['total_shots'] ?? 0) < $minShots) {
return null; // 样本不足,前端显示"数据不足"
}
return (float) $stats['goal_rate'];
}
进阶:按距离区间细分
落叶球成功率与距离强相关,可分段统计:
public function knuckleballByDistance(): array
{
$sql = "SELECT
CASE
WHEN distance < 20 THEN '禁区外远射'
WHEN distance < 30 THEN '中距离'
ELSE '超远距离'
END AS range_label,
COUNT(*) AS total,
SUM(is_goal) AS goals,
ROUND(SUM(is_goal)/COUNT(*)*100, 2) AS rate
FROM shots
WHERE shot_type = 'knuckleball' AND distance IS NOT NULL
GROUP BY range_label";
return $this->pdo->query($sql)->fetchAll(PDO::FETCH_ASSOC);
}
输出示例
$stats = new ShotStatistics($pdo);
print_r($stats->successRate('knuckleball'));
输出:
Array (
[total_shots] => 120
[goals] => 18
[on_target] => 45
[goal_rate] => 15.00
[on_target_rate] => 37.50
)
核心公式是 落叶球成功率 = 落叶球进球数 / 落叶球总射门数 × 100%,实现重点在于:正确区分射门类型、处理除零、设置样本量阈值、区分"进球率"和"射正率"两种成功定义,如需进一步扩展,可按赛季、主客场、对手强度等维度做分层统计。
需要我补充某一部分(如前端图表展示、数据导入脚本、或 API 接口设计)吗?
版权声明:本站文章为原创整理,转载请注明出处。