dvd

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <link href="css/bootstrap.min.css" rel="stylesheet">
    <link href="css/main.css" rel="stylesheet">
    <script src="js/bootstrap.min.js"></script>
</head>

<body>
    <div class="container">
           <nav class="clearfix">
               <ul>
                  <li><a href="index.php">Home</a></li>
                   <li><a href="orders.php">Orders</a></li>
                   <li><a href="dvds.php">Dvds</a></li>
                   <li><a href="clients.php">Clients</a></li>
               </ul>
           </nav>
            <div class="row">
                <h2>Dvds</h2>
            </div>
            <div class="row">
                <p>
                    <a href="create_dvds.php" class="btn btn-success">Create a new dvd</a>
                </p>
                <table class="table table-striped table-bordered">
                  <thead>
                    <tr>
                      <th>Title</th>
                      <th>Description</th>
                      <th>Release date</th>
                      <th>Duration</th>
                      <th>Genre</th>
                      <th>Action</th>
                    </tr>
                  </thead>
                  <tbody>
<?php
                   include 'database.php';
                   $pdo = Database::connect();
                   $sql = 'SELECT DISTINCT tl_dvd.id, tl_dvd.title, tl_dvd.description, tl_dvd.release_date, tl_order.returned FROM tl_dvd, tl_order WHERE tl_dvd.id = tl_order.dvd_id AND returned = 1';
                   foreach ($pdo->query($sql) as $row) {
                            echo '<tr>';
                            echo '<td>'. $row['title'] . '</td>';
                            echo '<td>'. $row['duration'] . '</td>';
                            echo '<td>'. $row['release_date'] . '</td>';
                            echo '<td>'. $row['description'] . '</td>';
                            echo '<td>'. $row['name'] . '</td>';
                            echo '<td><a class="btn" href="delete_dvd.php?id='.$row['id'].'">Delete</a></td>';
                            echo '</tr>';
                   }
                   Database::disconnect();
                  ?>
                  </tbody>
            </table>
        </div>
    </div> <!-- /container -->
  </body>
</html>