Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host = "localhost";
- $user = "root";
- $pass = "";
- $db = "sportowcy";
- $connection = mysqli_connect($host, $user, $pass, $db);
- ?>
- <!DOCTYPE html>
- <html>
- <head>
- <meta charset="utf-8">
- <title>Rzut oszczepem</title>
- <link rel="stylesheet" type="text/css" href="styl_oszczep.css">
- </head>
- <body>
- <header>
- <h1>Klub sportowy: rzut oszczepem</h1>
- </header>
- <section>
- <h1>Nasz rekord: <?php
- $rekord = $connection->query("SELECT MAX(wynik) FROM wyniki WHERE dyscyplina_id = 3;");
- while($row = mysqli_fetch_assoc($rekord)) {
- echo $row['MAX(wynik)'];
- }
- ?>m</h1>
- <table>
- <?php
- $ilosc = $connection->query("SELECT COUNT(id) FROM sportowiec");
- while($row = mysqli_fetch_assoc($ilosc)) {
- $z = $row['COUNT(id)'];
- $a = $z/2;
- $c = 1;
- for($i = 0; $i < $a; $i++) {
- echo "<tr>";
- for($j = 0; $j < 2; $j++) {
- $sportowiec = $connection->query("SELECT imie, nazwisko FROM sportowiec WHERE id = {$c};");
- $wyniczek = $connection->query("SELECT AVG(wynik) FROM wyniki WHERE dyscyplina_id = 3 AND sportowiec_id = {$c};");
- while(($s = mysqli_fetch_assoc($sportowiec)) && ($w = mysqli_fetch_assoc($wyniczek))) {
- echo "<td>
- <h3>{$s['imie']} {$s['nazwisko']}</h3>
- <p>średni wynik: {$w['AVG(wynik)']}</p>
- </td>";
- }
- $c++;
- }
- echo "</tr>";
- }
- }
- ?>
- </table>
- </section>
- <footer>
- <p>Klub sportowy<br>Strone opracował: xyz</p>
- </footer>
- </body>
- </html>
- <?php
- mysqli_close($connection);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement