当前位置：首页 > PHP

php实现比赛

2026-03-13 00:10:10PHP

PHP 实现比赛功能

在 PHP 中实现比赛功能通常涉及以下几个关键部分：比赛创建、选手管理、成绩记录和排名计算。以下是一个基本的实现方法。

数据库设计

创建一个数据库表来存储比赛信息：

CREATE TABLE competitions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    description TEXT,
    start_date DATETIME,
    end_date DATETIME
);

创建选手表：

CREATE TABLE participants (
    id INT AUTO_INCREMENT PRIMARY KEY,
    competition_id INT,
    name VARCHAR(255) NOT NULL,
    email VARCHAR(255),
    FOREIGN KEY (competition_id) REFERENCES competitions(id)
);

创建成绩表：

CREATE TABLE scores (
    id INT AUTO_INCREMENT PRIMARY KEY,
    participant_id INT,
    competition_id INT,
    score DECIMAL(10,2),
    recorded_at DATETIME,
    FOREIGN KEY (participant_id) REFERENCES participants(id),
    FOREIGN KEY (competition_id) REFERENCES competitions(id)
);

创建比赛

function createCompetition($name, $description, $startDate, $endDate) {
    $conn = new PDO("mysql:host=localhost;dbname=your_database", "username", "password");
    $stmt = $conn->prepare("INSERT INTO competitions (name, description, start_date, end_date) VALUES (?, ?, ?, ?)");
    $stmt->execute([$name, $description, $startDate, $endDate]);
    return $conn->lastInsertId();
}

添加选手

function addParticipant($competitionId, $name, $email) {
    $conn = new PDO("mysql:host=localhost;dbname=your_database", "username", "password");
    $stmt = $conn->prepare("INSERT INTO participants (competition_id, name, email) VALUES (?, ?, ?)");
    $stmt->execute([$competitionId, $name, $email]);
    return $conn->lastInsertId();
}

记录成绩

function recordScore($participantId, $competitionId, $score) {
    $conn = new PDO("mysql:host=localhost;dbname=your_database", "username", "password");
    $stmt = $conn->prepare("INSERT INTO scores (participant_id, competition_id, score, recorded_at) VALUES (?, ?, ?, NOW())");
    $stmt->execute([$participantId, $competitionId, $score]);
}

计算排名

function getRankings($competitionId) {
    $conn = new PDO("mysql:host=localhost;dbname=your_database", "username", "password");
    $stmt = $conn->prepare("
        SELECT p.name, AVG(s.score) as average_score
        FROM participants p
        JOIN scores s ON p.id = s.participant_id
        WHERE p.competition_id = ?
        GROUP BY p.id
        ORDER BY average_score DESC
    ");
    $stmt->execute([$competitionId]);
    return $stmt->fetchAll(PDO::FETCH_ASSOC);
}

显示比赛结果

function displayCompetitionResults($competitionId) {
    $rankings = getRankings($competitionId);
    echo "<h3>比赛结果</h3>";
    echo "<table border='1'>";
    echo "<tr><th>排名</th><th>选手</th><th>平均分</th></tr>";
    $rank = 1;
    foreach ($rankings as $row) {
        echo "<tr><td>{$rank}</td><td>{$row['name']}</td><td>{$row['average_score']}</td></tr>";
        $rank++;
    }
    echo "</table>";
}