<?php 
   $pdo = new PDO("mysql:host=localhost;dbname=blog;", "root", "");
   $sql = 'SELECT * FROM sandbox';
   $statement = $pdo -> prepare($sql);
   $statement -> execute();
   $users = $statement->fetchALL(PDO::FETCH_ASSOC);
?>


<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="utf-8">
	<title>Document</title>
	<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css">
</head>
<body>  
   <div class="container">
      <div class="row">
         <div class="col-md-12">
            <h1>CRUD</h1>
   	    <a href="create.php" class="btn btn-success">Добавить</a>
   	   	<table class="table">
   	   	 <thead>
                  <tr>
   	   	  	 		<th>ID</th>
   	   	  	 		<th>Userame</th>
   	   	  	 		<th>Действия</th>
                  </tr>
   	   	  	</thead>

   	   	  	 	<tbody>
               <?php foreach($users as $user):?>   
   	   	  	 		<tr> 
                     <td><?php echo $user['id']; ?></td>
                     <td><?php echo $user['username']; ?></td>
                     <td>
                     	<a class="btn btn-info" href="show.php?id=<?php echo user['id'];?>">Просмотр</a>
                        <a class="btn btn-warning" href="edit.php?id=<php echo user['id'];?>">Редактировать</a>
                        <a class="btn btn-danger" href="delete.php?id=<php echo user['id'];?>">Удалить</a>

                   </td>

   	   	  	 	</tr>
             <?php endforeach;?>
   	   	  	</tbody>
   	   	  </table>
   	   	</div>
   	   </div>
   	  </div>
</body>
</html>