Untitled

<!doctype html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <meta name="description" content="">
    <meta name="author" content="">
    <link rel="icon" href="images/favicon.ico">

    <title>Jumbotron Template for Bootstrap</title>

    <!-- Bootstrap core CSS -->
    <link href="css/bootstrap.min.css" rel="stylesheet">

    <!-- Custom styles for this template -->
    <link href="jumbotron.css" rel="stylesheet">
  </head>

  <body>

    <nav class="navbar navbar-expand-md navbar-dark fixed-top bg-dark">
      <a class="navbar-brand" href="#">Navbar</a>
      <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarsExampleDefault" aria-controls="navbarsExampleDefault" aria-expanded="false" aria-label="Toggle navigation">
        <span class="navbar-toggler-icon"></span>
      </button>

      <div class="collapse navbar-collapse" id="navbarsExampleDefault">
        <ul class="navbar-nav mr-auto">
          <li class="nav-item active">
            <a class="nav-link" href="#">Home <span class="sr-only">(current)</span></a>
          </li>
          <li class="nav-item">
            <a class="nav-link" href="#">Log in</a>
          </li>
          <li class="nav-item">
            <a class="nav-link disabled" href="#">Log out</a>
          </li>
          <li class="nav-item dropdown">
            <a class="nav-link dropdown-toggle" href="http://example.com" id="dropdown01" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">User</a>
            <div class="dropdown-menu" aria-labelledby="dropdown01">
              <a class="dropdown-item" href="#">Profile</a>
              <a class="dropdown-item" href="#">Security</a>
              <a class="dropdown-item" href="#">Log out</a>
            </div>
          </li>
        </ul>
        <form class="form-inline my-2 my-lg-0">
          <input class="form-control mr-sm-2" type="text" placeholder="Search" aria-label="Search">
          <button class="btn btn-outline-success my-2 my-sm-0" type="submit">Search</button>
        </form>
      </div>
    </nav>

    <main role="main">

      <!-- Main jumbotron for a primary marketing message or call to action -->
      <!--
        <div class="jumbotron">
        <div class="container">
          <h1 class="display-3">Hello, world!</h1>
          <p>This is a template for a simple marketing or informational website. It includes a large callout called a jumbotron and three supporting pieces of content. Use it as a starting point to create something more unique.</p>
          <p><a class="btn btn-primary btn-lg" href="#" role="button">Learn more &raquo;</a></p>
        </div>
      </div>
        -->
      <div class="container" style="margin-top:88px">
        <!-- Example row of columns -->
          <div class="col">
            <center><?php

    $servername = "mysql.cba.pl";
    $username = "mmalewski";
    $password = "Haslo123";
    $dbname = "mmalewski";

    $conn = new mysqli($servername, $username, $password, $dbname);
    if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
    }

        echo "<table class='table'>";
        echo "<tr><th>Id</th><th>Imię</th><th>Nazwisko</th><th>Wiek</th><th>Płeć</th><th>Zainteresowania</th><th>Opis</th><th>Zdjęcie</th><th>Opcje</th></tr>";
        $sql = "SELECT id, Imie, Nazwisko, Wiek, Plec, Zainteresowania, Opis, Zdjecie FROM DB";
        $image = $row["Zdjecie"];
        $result = $conn->query($sql);
        if ($result->num_rows > 0) {

        while($row = $result->fetch_assoc()) {
         $idd = $row["id"];
        echo "<tr><td>" . $row["id"]. "</td> <td> " . $row["Imie"]. " </td> <td> " . $row["Nazwisko"]. "</td> <td>" . $row["Wiek"]. "</td> <td> " . $row["Plec"]. "</td> <td>" .$row[Zainteresowania]. "</td> <td> " .$row[Opis]. " </td> <td> " .'<a href=getimage.php?id='.$idd.' target=_blank> <img width=75px src="data:image/jpeg;base64,'.base64_encode($row['Zdjecie'] ).'"/> </a>'. "</td> <td> <form> <input type='button' value='Usuń' onclick=window.location.href='delete.php?id=$idd' /> </form> </td></tr><br>";
            }
     } else {
    echo "0 results";
}

echo "</table>";
  $conn->close();
 ?></center>
          </div>
        </div>

        <hr>

      </div> <!-- /container -->

    </main>

    <footer class="container">
      <p>&copy; Company 2017</p>
    </footer>

    <!-- Bootstrap core JavaScript
    ================================================== -->
    <!-- Placed at the end of the document so the pages load faster -->
    <script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
    <script>window.jQuery || document.write('<script src="../../../../assets/js/vendor/jquery-slim.min.js"><\/script>')</script>
    <script src="js/vendor/popper.min.js"></script>
    <script src="js/bootstrap.min.js"></script>
  </body>
</html>