如何从关联表检索数据并以teams_name替代home_team_fk显示？

看起来你需要通过JOIN操作关联games和teams表，把home_team_fk替换成对应的teams_name，同时还要修复代码里的SQL注入风险（直接把$_GET['season']拼进SQL是非常不安全的）。下面是具体的实现步骤：

1. 编写正确的SQL语句 #

我们用INNER JOIN来关联两张表，关联条件是games.home_team_fk = teams.teams_id，建议明确指定需要的字段（别用SELECT *，更高效也更易维护），比如：

SELECT 
    games.games_id,
    teams.teams_name AS home_team_name, -- 重命名为更易懂的字段名
    games.away_team_fk,
    games.games_season
    -- 这里可以继续添加你需要的其他games表字段
FROM games
INNER JOIN teams ON games.home_team_fk = teams.teams_id
WHERE games.games_season = ? -- 用占位符代替直接拼接变量

2. 修正PHP代码的预处理逻辑 #

原来的代码没有使用参数绑定，存在严重的SQL注入漏洞，我们需要用PDO的参数绑定功能来修复：

<?php
// 先处理赛季参数，避免空值或非法输入
$season = isset($_GET['season']) ? trim($_GET['season']) : '';

if (!empty($season)) {
    try {
        // 假设$DBcon是已经初始化好的PDO连接
        $stmt = $DBcon->prepare("
            SELECT 
                games.games_id,
                teams.teams_name AS home_team_name,
                games.away_team_fk,
                games.games_season
            FROM games
            INNER JOIN teams ON games.home_team_fk = teams.teams_id
            WHERE games.games_season = ?
        ");
        // 绑定参数，根据season的类型选择参数类型，字符串用PDO::PARAM_STR
        $stmt->bindParam(1, $season, PDO::PARAM_STR);
        $stmt->execute();
        
        // 获取查询结果，比如用关联数组格式
        $games = $stmt->fetchAll(PDO::FETCH_ASSOC);
        
        // 后续遍历结果时，直接用home_team_name获取球队名称
        foreach ($games as $game) {
            echo "主场球队：" . $game['home_team_name'] . "<br>";
        }
    } catch (PDOException $e) {
        echo "查询出错：" . $e->getMessage();
    }
} else {
    echo "请提供有效的赛季参数";
}
?>

额外扩展：同时显示客场球队名称 #

如果需要把away_team_fk也替换成球队名称，只需要给teams表起别名，再关联一次即可：

SELECT 
    games.games_id,
    home_team.teams_name AS home_team_name,
    away_team.teams_name AS away_team_name,
    games.games_season
FROM games
INNER JOIN teams AS home_team ON games.home_team_fk = home_team.teams_id
INNER JOIN teams AS away_team ON games.away_team_fk = away_team.teams_id
WHERE games.games_season = ?

内容的提问来源于stack exchange，提问作者Marko Hirsch