setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
die("Błąd połączenia: " . $e->getMessage());
}
// Fetch Minsk data
$minskData = [];
$stmt = $conn->query("SELECT DATE, TEMP FROM dbo.MinskTemp ORDER BY ID");
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$minskData[] = $row;
}
// Fetch Warsaw data
$warsawData = [];
$stmt = $conn->query("SELECT DATE, TEMP FROM dbo.WarsawTemp ORDER BY ID");
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$warsawData[] = $row;
}
// Close DB connection
$conn = null;
// Prepare labels (dates) and temperature arrays
$labels = array_column($minskData, 'DATE');
$minskTemps = array_column($minskData, 'TEMP');
$warsawTemps = array_column($warsawData, 'TEMP');
?>
Temperature Chart
Temperature Comparison: Minsk vs Warsaw