贴地飞行计时服务系统
成绩证书在线查询
查询结果
请填写完整的查询信息
';
} else {
try {
// 连接数据库
$conn = new mysqli("localhost", "root", "19369200", "racedata");
if ($conn->connect_error) {
throw new Exception("数据库连接失败");
}
$conn->set_charset("utf8mb4");
// 1. 查询比赛信息
$sql = "SELECT race_id, can_downloadcert FROM races WHERE race_name = ?";
$stmt = $conn->prepare($sql);
if (!$stmt) {
throw new Exception("SQL语句准备失败");
}
$stmt->bind_param("s", $race_name);
$stmt->execute();
$result = $stmt->get_result();
if ($result->num_rows === 0) {
echo '未找到该比赛信息
';
} else {
$race = $result->fetch_assoc();
$race_id = $race['race_id'];
$can_downloadcert = $race['can_downloadcert'];
if (!$can_downloadcert) {
echo '成绩证书不能下载！
';
} else {
// 2. 查询选手成绩证书
$sql2 = "SELECT bibnumber, name FROM players_current WHERE raceid = ? AND idcardno = ?";
$stmt2 = $conn->prepare($sql2);
if (!$stmt2) {
throw new Exception("SQL语句准备失败");
}
// 确保身份证号大写
$upper_idcardno = strtoupper($idcardno);
$stmt2->bind_param("is", $race_id, $upper_idcardno);
$stmt2->execute();
$result2 = $stmt2->get_result();
if ($result2->num_rows === 0) {
echo '无此成绩证书
';
echo '';
echo '
';
} else {
$player = $result2->fetch_assoc();
$bibnumber = $player['bibnumber'];
$name = $player['name'];
// 构建证书路径
$cert_filename = $name . "_" . $bibnumber . ".jpg";
$cert_path = "/www/wwwroot/bugs/cert/20251123/" . $cert_filename;
$cert_url = "http://rtftiming.com/cert/20251123/" . $cert_filename;
// 验证证书文件是否存在
$cert_exists = false;
$headers = @get_headers($cert_url);
if ($headers && strpos($headers[0], '200') !== false) {
$cert_exists = true;
}
echo '可能原因：
'; echo '- ';
echo '
- 参赛号码或身份证信息有误 '; echo '
- 成绩正在审核处理中 '; echo '
- 请确认比赛名称选择正确 '; echo '
- 身份证号码可能需要全大写 '; echo '
查询成功！已找到您的成绩证书
';
echo '';
echo '
';
echo '';
echo '比赛名称';
echo '' . htmlspecialchars($race_name) . '';
echo '
';
echo '';
echo '参赛号码';
echo '' . htmlspecialchars($bibnumber) . '';
echo '
';
echo '';
echo '选手姓名';
echo '' . htmlspecialchars($name) . '';
echo '
';
echo '';
echo '证书状态';
if ($cert_exists) {
echo '可查看';
} else {
echo '文件未找到';
}
echo '
';
echo '';
echo '
';
echo '
';
}
}
}
$conn->close();
} catch (Exception $e) {
echo '成绩证书预览
';
if ($cert_exists) {
echo '';
echo '下载证书';
echo '
';
} else {
echo '';
echo '
';
}
echo '证书文件未找到
'; echo '预期文件路径：' . htmlspecialchars($cert_path) . '
'; echo '注：证书仅供参考，正式成绩以官方公布为准
'; echo '系统繁忙，请稍后重试
';
}
}
}
?>