php项目怎么看两队的主客场战绩差异?

wen PHP项目 23

PHP 项目查看两队主客场战绩差异的实现思路

在体育数据类 PHP 项目中(足球、篮球等),分析两队主客场战绩差异是常见需求,下面给你一套完整实现思路 + 代码示例。

php项目怎么看两队的主客场战绩差异?


核心逻辑

主客场战绩差异分析要拆解成几个维度:

维度 说明
主队主场战绩 主队在本方主场的胜/平/负、进球/失球
客队客场战绩 客队在本方客场的胜/平/负、进球/失球
胜率差异 主队主场胜率 vs 客队客场胜率
净胜球差异 场均净胜球对比
近期状态 N 场的主/客场表现

数据库设计(示例)

-- 比赛表
CREATE TABLE matches (
    id INT PRIMARY KEY,
    league_id INT,
    home_team_id INT,
    away_team_id INT,
    home_goals INT,
    away_goals INT,
    match_date DATE,
    status TINYINT  -- 1=已结束
);
-- 球队表
CREATE TABLE teams (
    id INT PRIMARY KEY,
    name VARCHAR(50)
);

核心统计 SQL

主队主场战绩

SELECT 
    COUNT(*) AS total,
    SUM(home_goals > away_goals) AS win,
    SUM(home_goals = away_goals) AS draw,
    SUM(home_goals < away_goals) AS loss,
    SUM(home_goals) AS goals_for,
    SUM(away_goals) AS goals_against
FROM matches
WHERE home_team_id = :team_id
  AND status = 1
  AND match_date >= :since_date;

客队客场战绩

SELECT 
    COUNT(*) AS total,
    SUM(away_goals > home_goals) AS win,
    SUM(away_goals = home_goals) AS draw,
    SUM(away_goals < home_goals) AS loss,
    SUM(away_goals) AS goals_for,
    SUM(home_goals) AS goals_against
FROM matches
WHERE away_team_id = :team_id
  AND status = 1
  AND match_date >= :since_date;

PHP 封装类

class HomeAwayAnalyzer
{
    private PDO $pdo;
    public function __construct(PDO $pdo)
    {
        $this->pdo = $pdo;
    }
    /**
     * 获取球队主场战绩
     */
    public function getHomeStats(int $teamId, string $since = '-1 year'): array
    {
        $sql = "SELECT 
                    COUNT(*) AS total,
                    SUM(home_goals > away_goals) AS win,
                    SUM(home_goals = away_goals) AS draw,
                    SUM(home_goals < away_goals) AS loss,
                    SUM(home_goals) AS goals_for,
                    SUM(away_goals) AS goals_against
                FROM matches
                WHERE home_team_id = :tid
                  AND status = 1
                  AND match_date >= :since";
        $stmt = $this->pdo->prepare($sql);
        $stmt->execute([':tid' => $teamId, ':since' => date('Y-m-d', strtotime($since))]);
        return $this->formatStats($stmt->fetch(PDO::FETCH_ASSOC));
    }
    /**
     * 获取球队客场战绩
     */
    public function getAwayStats(int $teamId, string $since = '-1 year'): array
    {
        $sql = "SELECT 
                    COUNT(*) AS total,
                    SUM(away_goals > home_goals) AS win,
                    SUM(away_goals = home_goals) AS draw,
                    SUM(away_goals < home_goals) AS loss,
                    SUM(away_goals) AS goals_for,
                    SUM(home_goals) AS goals_against
                FROM matches
                WHERE away_team_id = :tid
                  AND status = 1
                  AND match_date >= :since";
        $stmt = $this->pdo->prepare($sql);
        $stmt->execute([':tid' => $teamId, ':since' => date('Y-m-d', strtotime($since))]);
        return $this->formatStats($stmt->fetch(PDO::FETCH_ASSOC));
    }
    /**
     * 对比两队主客场差异
     */
    public function compare(int $homeTeamId, int $awayTeamId): array
    {
        $home = $this->getHomeStats($homeTeamId);
        $away = $this->getAwayStats($awayTeamId);
        return [
            'home_team' => ['team_id' => $homeTeamId, 'stats' => $home],
            'away_team' => ['team_id' => $awayTeamId, 'stats' => $away],
            'diff' => [
                'win_rate'    => round($home['win_rate'] - $away['win_rate'], 2),
                'goal_avg'    => round($home['goal_avg'] - $away['goal_avg'], 2),
                'concede_avg' => round($home['concede_avg'] - $away['concede_avg'], 2),
                'net_avg'     => round($home['net_avg'] - $away['net_avg'], 2),
            ],
        ];
    }
    private function formatStats(?array $row): array
    {
        if (!$row || !$row['total']) {
            return [
                'total' => 0, 'win' => 0, 'draw' => 0, 'loss' => 0,
                'win_rate' => 0, 'goal_avg' => 0, 'concede_avg' => 0, 'net_avg' => 0,
            ];
        }
        $total = (int)$row['total'];
        $gf = (int)$row['goals_for'];
        $ga = (int)$row['goals_against'];
        return [
            'total'       => $total,
            'win'         => (int)$row['win'],
            'draw'        => (int)$row['draw'],
            'loss'        => (int)$row['loss'],
            'win_rate'    => round($row['win'] / $total * 100, 2),
            'goal_avg'    => round($gf / $total, 2),
            'concede_avg' => round($ga / $total, 2),
            'net_avg'     => round(($gf - $ga) / $total, 2),
        ];
    }
}

使用示例

$analyzer = new HomeAwayAnalyzer($pdo);
$result = $analyzer->compare(101, 202);
print_r($result);

输出示例:

[
  'home_team' => ['team_id' => 101, 'stats' => [
      'total' => 15, 'win' => 10, 'draw' => 3, 'loss' => 2,
      'win_rate' => 66.67, 'goal_avg' => 2.13, 'concede_avg' => 0.87, 'net_avg' => 1.26
  ]],
  'away_team' => ['team_id' => 202, 'stats' => [
      'total' => 14, 'win' => 4, 'draw' => 4, 'loss' => 6,
      'win_rate' => 28.57, 'goal_avg' => 1.07, 'concede_avg' => 1.5, 'net_avg' => -0.43
  ]],
  'diff' => [
      'win_rate' => 38.10,
      'goal_avg' => 1.06,
      'concede_avg' => -0.63,
      'net_avg' => 1.69
  ]
]

进阶优化建议

分时间段对比

按"近 5 场 / 近 10 场 / 本赛季 / 近 1 年"分档,避免长周期数据失真。

$periods = ['近5场' => 5, '近10场' => 10, '本赛季' => '-6 month'];

加权近期比赛

// 用时间衰减权重,越近权重越大
$weight = exp(-$daysAgo / 30);

对手强度修正

用 Elo 或对手平均排名修正"含金量":

-- 关联对手排名表,按对手强度加权
SUM(home_goals * opponent_strength_weight)

大数据量优化

  • 用物化视图 / 汇总表(team_home_stats、team_away_stats)预计算
  • 加索引:(home_team_id, match_date)、(away_team_id, match_date)

缓存结果

$cacheKey = "ha_diff:{$homeTeamId}:{$awayTeamId}";
$data = $redis->get($cacheKey);
if (!$data) {
    $data = $analyzer->compare($homeTeamId, $awayTeamId);
    $redis->setex($cacheKey, 3600, json_encode($data));
}

展示层建议

对比表格示例:

指标 主队(主场) 客队(客场) 差值
胜率 67% 57% +38.10%
场均进球 13 07 +1.06
场均失球 87 50 -0.63
场均净胜 +1.26 -0.43 +1.69

差异越大,越说明主场优势 / 客场劣势明显,可作为赛前预测参考。


需要我针对你的具体项目框架(Laravel / ThinkPHP / 原生)或联赛数据表结构再细化吗?

直播入口

曼联直播曼联直播曼联直播曼联直播曼联直播利物浦直播利物浦直播利物浦直播利物浦直播利物浦直播巴萨直播巴萨直播巴萨直播巴萨直播巴萨直播U17直播U17直播U17直播U17直播U17直播尤文图斯直播尤文图斯直播尤文图斯直播尤文图斯直播尤文图斯直播曼联直播曼联直播曼联直播曼联直播曼联直播利物浦直播利物浦直播利物浦直播利物浦直播利物浦直播巴萨直播巴萨直播巴萨直播巴萨直播巴萨直播U17直播U17直播U17直播U17直播U17直播尤文图斯直播尤文图斯直播尤文图斯直播尤文图斯直播尤文图斯直播曼联直播曼联直播曼联直播曼联直播曼联直播利物浦直播利物浦直播利物浦直播利物浦直播利物浦直播巴萨直播巴萨直播巴萨直播巴萨直播巴萨直播U17直播U17直播U17直播U17直播U17直播尤文图斯直播尤文图斯直播尤文图斯直播尤文图斯直播尤文图斯直播曼联直播曼联直播曼联直播曼联直播曼联直播利物浦直播利物浦直播利物浦直播利物浦直播利物浦直播巴萨直播巴萨直播巴萨直播巴萨直播巴萨直播U17直播U17直播U17直播U17直播U17直播尤文图斯直播尤文图斯直播尤文图斯直播尤文图斯直播尤文图斯直播曼联直播曼联直播曼联直播曼联直播曼联直播利物浦直播利物浦直播利物浦直播利物浦直播利物浦直播巴萨直播巴萨直播巴萨直播巴萨直播巴萨直播U17直播U17直播U17直播U17直播U17直播尤文图斯直播尤文图斯直播尤文图斯直播尤文图斯直播尤文图斯直播

抱歉,评论功能暂时关闭!

友情链接攻略窝 · 礼包窝 · 配置窝 · 换算窝 · 算法窝 · 查文窝 · 手册窝 · 问答窝 · 全文搜 · 手册库
相关站点礼包窝 · 查文窝