Untitled

<!DOCTYPE html>
<html>

<head>
  <meta charset="utf-8">
  <title>Szkoła</title>
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta.2/css/bootstrap.min.css" integrity="sha384-PsH8R72JQ3SOdhVi3uxftmaW6Vc51MKb0q5P2rRUpPvrszuE4W1povHYgTpBfshb" crossorigin="anonymous">
  <script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
  <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.3/umd/popper.min.js" integrity="sha384-vFJXuSJphROIrBnz7yo7oB41mKfc8JzQZiCq4NCceLEaO4IHwicKwpJf9c9IpFgh" crossorigin="anonymous"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta.2/js/bootstrap.min.js" integrity="sha384-alpBpkh1PFOepccYVYDB4do5UnbKysX5WZXm3XxPqe5iKTfUKjNkCk9SaVuEZflJ" crossorigin="anonymous"></script>
</head>

<body>
  <div class="container">
    <div class="jumbotron">
      <?php
      $servername = "localhost";
      $username = "root";
      $password = "";
      $conn = new mysqli($servername, $username, $password, "uczniowie");
      if ($conn->connect_error) {
        die("Błąd: " . $conn->connect_error);
      }

      $sql = "SELECT dane.id, dane.imie, dane.nazwisko, oceny.matematyka, oceny.polski, oceny.informatyka
     FROM dane
     INNER JOIN oceny ON oceny.id_ucznia=dane.id";
      $result = $conn->query($sql);
      echo "<table border='1' width='100%'>  <tr>
     <th>ID</th>
     <th>Imię</th>
     <th>Nazwisko</th>
     <th>Matematyka</th>
     <th>Informatyka</th>
     <th>Polski</th>
     </tr>";
      if ($result->num_rows > 0) {
        while($row = $result->fetch_assoc()) {
          echo "<tr>";
          echo "<td>" . $row["id"]. "</td><td>" . $row["imie"]. "</td><td>" . $row["nazwisko"]. "</td><td>" . $row["matematyka"]. "</td><td>" . $row["polski"]. "</td><td>" . $row["informatyka"] . "</td>";
          echo "</tr>";
        }
      } else {
        echo "Błąd";
      }
      echo "</table";
      ?>

    </div>
    <!--
  <form method="post">
    <div class="form-group">
      <label for="przedmiot">Przedmiot</label>
      <input type="text" class="form-control" id="przedmiot" name="przedmiot" required placeholder="Wpisz nazwę przedmiotu">
    </div>
    <div class="form-group">
      <label for="imie">Imię</label>
      <input type="text" class="form-control" id="imie" name="imie" required placeholder="Wpisz imię nauczyciela">
    </div>
    <div class="form-group">
      <label for="nazwisko">Nazwisko</label>
      <input type="text" class="form-control" id="nazwisko" name="nazwisko" required placeholder="Wpisz nazwisko nauczyciela">
    </div>
    <div class="form-group">
      <label for="wiek">Wiek</label>
      <input type="text" class="form-control" id="wiek" name="wiek" required placeholder="Wpisz wiek nauczyciela">
    </div>
    <button type="submit" class="btn btn-primary">Dodaj</button>
  </form>
</div>
-->
<?php
if(isset($_POST['przedmiot'])){

  $stmt = $conn->prepare("INSERT INTO lekcje (firstname, lastname, email) VALUES (?, ?, ?) UNION");
  $stmt->bind_param("sss", $firstname, $lastname, $email);

  // set parameters and execute
  $firstname = $_POST['a'];
  $lastname = "Doe";
  $email = "john@example.com";
  $stmt->execute();

  $stmt = $conn->prepare("INSERT INTO lekcje (firstname, lastname, email) VALUES (?, ?, ?) UNION");
  $stmt->bind_param("sss", $firstname, $lastname, $email);

  echo "New records created successfully";

  $stmt->close();


}

$conn-> close();
 ?>
</body>

</html>