setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo->exec("SET NAMES utf8");
echo "数据库连接成功！
";
} catch (PDOException $e) {
die("数据库连接失败: " . $e->getMessage());
}
// 查询最近的记录
try {
$stmt = $pdo->query("SELECT * FROM task ORDER BY id DESC LIMIT 20");
$records = $stmt->fetchAll(PDO::FETCH_ASSOC);
echo "最近20条记录
";
if (count($records) > 0) {
echo "";
echo "| ID | 用户名 | 工具名称 | 任务名称 | 节省时间 | 花费时间 | 时间戳 |
|---|
";
foreach ($records as $record) {
echo "";
echo "| {$record['id']} | ";
echo "{$record['username']} | ";
echo "{$record['tool_name']} | ";
echo "{$record['task_name']} | ";
echo "{$record['time_saved']} | ";
echo "{$record['time_cost']} | ";
echo "{$record['timestamp']} | ";
echo "
";
}
echo "
";
} else {
echo "没有找到记录";
}
} catch (PDOException $e) {
echo "查询失败: " . $e->getMessage();
}
// 检查API请求日志
echo "API请求日志检查
";
// 检查api.php是否正确处理请求
echo "请确认以下几点：
";
echo "";
echo "- api.php文件是否正确接收和处理请求
";
echo "- 数据库连接信息是否正确
";
echo "- TaskReporter.py是否正确发送数据到api.php
";
echo "
";
// 显示刷新页面的链接
echo "刷新数据查询页面
";
?>