Facebook

As safest cryptocurrency exchange

From A, 1 Year ago, written in Plain Text.
URL https://pastebin.pl/view/1254d3be
Embed
Download Paste or View Raw
Hits: 180
  1. <!DOCTYPE html>
  2. &lt;html lang="en"&gt;
  3. &lt;head&gt;
  4.     &lt;meta charset="UTF-8"&gt;
  5.     &lt;meta http-equiv="X-UA-Compatible" c&gt;
  6.     &lt;meta name="viewport" c initial-scale=1.0"&gt;
  7.     &lt;title&gt;Ranking&lt;/title&gt;
  8. &lt;/head&gt;
  9. &lt;body&gt;
  10.  
  11. <h1>Average Opinions for Each Station</h1>
  12.  
  13. &lt;?php
  14. $conn = mysqli_connect("localhost", "root", "", "stacjenarciarskie");
  15.  
  16. if ($conn) {
  17.     // Fetch the average opinion for each station
  18.     $result = $conn->query("SELECT id_stacji, AVG(opinia) AS avg_opinion FROM opinie GROUP BY id_stacji");
  19.  
  20.     if ($result->num_rows > 0) {
  21.         echo "<table border='1'>";
  22.         echo "<tr><th>Station ID</th><th>Average Opinion</th></tr>";
  23.         while($row = $result->fetch_assoc()) {
  24.             echo "<tr><td>" . $row['id_stacji'] . "</td><td>" . round($row['avg_opinion'], 2) . "</td></tr>";
  25.         }
  26.         echo "</table>";
  27.     } else {
  28.         echo "<p>No opinions found for any stations.</p>";
  29.     }
  30.  
  31.     mysqli_close($conn);
  32. } else {
  33.     echo "Connection failed: " . mysqli_connect_error();
  34. }
  35. ?&gt;
  36.  
  37. &lt;/body&gt;
  38. &lt;/html&gt;

Reply to "As"