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直播尤文图斯直播尤文图斯直播尤文图斯直播尤文图斯直播尤文图斯直播