Untitled

<!DOCTYPE html>
<html>
  <head>
    <meta charset="UTF-8" />
    <title>Hello World</title>

    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css" integrity="sha384-MCw98/SFnGE8fJT3GXwEOngsV7Zt27NXFoaoApmYm81iuXoPkFOJwJ8ERdknLPMO" crossorigin="anonymous">
    <style>
        .link{
            display:block;
            margin: 23px auto;
            width:200px;
        }

    </style>

  </head>
  <body>
      <a  class="link btn btn-primary" href="./add_users.php">Dodaj uzytkownika</a>
      <?php
      $mysql_host = 'localhost';
      $port = '3306';
      $username = 'root';
      $password = '';
      $database = 'library';

        try {
            $pdo = new PDO('mysql:host='.$mysql_host.';dbname='.$database.';port='.$port, $username, $password );
            $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

            $stmt = $pdo->query('SELECT surname,name FROM users_list');
            echo '<table class="table">';
            echo ' <thead>
            <tr>
              <th scope="col" >Imie</th>
              <th scope="col">Nazwisko</th>
              <th scope="col"></th>
              <th scope="col"></th>
              <th scope="col"></th>
              <th scope="col"></th>
            </tr>
          </thead>';
            foreach($stmt as $row)
            {
                echo '<tr>
                        <td>'.$row['name'].'</td>
                        <td>'.$row['surname'].'</td>
                        <td><a class="btn btn-warning" href="#">Edytuj</a></td>
                        <td><form action="library.php" method="delete"><input type="submit" class="btn btn-warning" href="#">Usun</a></form></td>
                        <td><a class="btn btn-warning" href="#">Ksiazki</a></td>
                        <td><a class="btn btn-warning" href="#">Pozycz ksiazke</a></td>
                        </tr>';
            }
            $stmt->closeCursor();
            echo '</table>';


        } catch (PDOException $e) {
            print "Error!: " . $e->getMessage() . "<br/>";
            die();
        }
    ?>


    <script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js" integrity="sha384-ZMP7rVo3mIykV+2+9J3UJ46jBk0WLaUAdn689aCwoqbBJiSnjAK/l8WvCWPIPm49" crossorigin="anonymous"></script>
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js" integrity="sha384-ChfqqxuZUCnJSK3+MXmPNIyE6ZbWh2IMqE241rYiqJxyMiZ6OW/JmZQ5stwEULTy" crossorigin="anonymous"></script>

  </body>
</html>