Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <meta charset="UTF-8">
- <head>
- <title>Szkoła Ponadgimnazjalna</title>
- <link rel="stylesheet" type="text/css" href="style.css">
- </head>
- <body>
- <header>
- <h1>Oceny uczniów: język polski</h1>
- </header>
- <div id="lewy">
- <h2>lista uczniów:<br/></h2>
- <?php
- $servername = "localhost";
- $username = "root";
- $password = "";
- $dbname = "szkola";
- $conn = mysqli_connect($servername, $username, $password,$dbname);
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- $sql = "SELECT id,imie, nazwisko FROM uczen ";
- $result = mysqli_query($conn,$sql);
- while($row = mysqli_fetch_array($result)) {
- echo "<br>".$row["id"].". " . $row["imie"]. " ". $row["nazwisko"]. "<br>";
- }
- $conn->close();?>
- </div>
- <div id="prawy">
- <?php
- $servername = "localhost";
- $username = "root";
- $password = "";
- $dbname = "szkola";
- $conn = mysqli_connect($servername, $username, $password,$dbname);
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- $sql = "SELECT imie, nazwisko FROM uczen WHERE id=2";
- $result = mysqli_query($conn,$sql);
- while($row = mysqli_fetch_array($result)) {
- echo "<h2>Uczeń: ". $row["imie"]. " ". $row["nazwisko"]. "</h2>";
- }
- $conn->close();?>
- </br>
- <?php
- $servername = "localhost";
- $username = "root";
- $password = "";
- $dbname = "szkola";
- $conn = mysqli_connect($servername, $username, $password,$dbname);
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- $sql = "SELECT ROUND(AVG(ocena),2) FROM ocena WHERE przedmiot_id=1 AND uczen_id=2 ";
- $result = mysqli_query($conn,$sql);
- while($row = mysqli_fetch_array($result)) {
- echo "<h2>Średnia ocen z języka polskiego: ". $row["AVG(ocena)"]. "</h2>";
- }
- $conn->close();?>
- </div>
- <footer>
- <h3>Zespół Szkół Ponadgimnazjalnych</h3></br>
- <p>Stronę opracował:mojpeselxd</p>
- </footer>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement