index_admin

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css">
    <title>Document</title>
</head>
<body>
    <br>
    <div class="container">
       <br><br>
       <h4>Adm</h4>
        <a href="home">Início</a> | <a href="pesquisar">Pesquisar imagem</a>
        <br><br><br>

       <?php
$pdo = new PDO('mysql:host=xxxx;dbname=nomedobanco', 'usuario', 'senha');
$stmt = $pdo->prepare("SELECT * FROM tabimagem ORDER BY id DESC");
$pdo->exec("SET NAMES utf8");
$stmt->execute();
$images = $stmt->fetchAll();
?>

<table class="table">
  <thead>
    <tr>
      <th>Nome</th>
      <th>Imagem</th>
      <th>Postagem</th>
      <th>Apagar</th>
      <th>Editar</th>

    </tr>
  </thead>
  <tbody>
  <?php foreach($images as $image): ?>
    <tr>
      <!--<td><?php echo $image['name']; ?></td>-->
      <td><a href="postagem/<?php echo $image["slug"]; ?>"><?php echo $image['name']; ?></a></td>
      <!--<td><a href="postagem/<?php echo $image["slug"]; ?>"><img src="<?php echo $image["arquivo"]; ?>" width="150" class="img-fluid"></a></td>-->
      <td><a href="<?php echo  $image["arquivo"]; ?>" target="_blank"><img src="<?php echo  $image["arquivo"]; ?>" width="150" class="img-fluid"></a></td>
      <td><?php echo $image['postagem']; ?></td>
      <td>
        <form action="delete.php" method="post">
          <input type="hidden" name="id" value="<?php echo $image['id']; ?>">
          <input type="submit" class="btn btn-danger" value="Apagar">
        </form>
      </td>
      <td>
        <form action="edit.php" method="post">
            <input type="hidden" name="id" value="<?php echo $image['id']; ?>">
            <input type="submit" class="btn btn-primary" value="Editar">
        </form>
      </td>


      </td>
    </tr>
  <?php endforeach; ?>
  </tbody>
</table>


    </div>

</body>
</html>