<html lang="en"> <head> <meta charset="UTF-8"> <meta http-equiv="X-UA-Compatible" c> <meta name="viewport" c initial-scale=1.0"> <title>Ranking</title> </head> <body>

Average Opinions for Each Station

<?php $conn = mysqli_connect("localhost", "root", "", "stacjenarciarskie"); if ($conn) { // Fetch the average opinion for each station $result = $conn->query("SELECT id_stacji, AVG(opinia) AS avg_opinion FROM opinie GROUP BY id_stacji"); if ($result->num_rows > 0) { echo ""; echo ""; while($row = $result->fetch_assoc()) { echo ""; } echo "

Station ID	Average Opinion
" . $row['id_stacji'] . "	" . round($row['avg_opinion'], 2) . "

"; } else { echo "

No opinions found for any stations.

"; } mysqli_close($conn); } else { echo "Connection failed: " . mysqli_connect_error(); } ?> </body> </html>