Untitled

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <link href="bootstrap/css/bootstrap.min.css" rel="stylesheet">
    <script src="bootstrap/js/bootstrap.min.js"></script>
    <title>orders</title>
</head>

<body>
    <h1>Videotheek Hollywood</h1>
    <ul class="nav nav-pills">
        <li role="presentation" class="active"><a href="orders.php">Orders</a></li>
        <li role="presentation"><a href="dvds.php">Dvds</a></li>
        <li role="presentation"><a href="clients.php">Clients</a></li>
    </ul>
    <div class="container">
        <div class="row">
            <p> <a href="add_order.php" class="btn btn-success">Order toevoegen</a> </p>
            <table class="table table-striped table-bordered">
                <thead>
                    <tr>
                        <th>Voornaam</th>
                        <th>Achternaam</th>
                        <th>Titel</th>
                        <th>Start datum van het order</th>
                    </tr>
                </thead>
                <tbody>
                    <?php
                    ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
                   include 'database.php';
                   $pdo = Database::connect();

                   $sql = 'SELECT tl_client.first_name,tl_client.last_name, tl_dvd.title, tl_order.start_date
                   FROM tl_order, tl_dvd, tl_client
                   WHERE tl_order.dvd_id = tl_dvd.id AND returned = 0;
                   AND tl_order.client_id = tl_client.id '; //ORDER BY id ASC

                   foreach ($pdo->query($sql) as $row) {
                            echo '<tr>';
                            echo '<td>'. $row['first_name'] . '</td>';
                            echo '<td>'. $row['last_name'] . '</td>';
                            echo '<td>'. $row['title'] . '</td>';
                            echo '<td>'. $row['start_date'] . '</td>';
                            echo '<td><a class="btn btn-info" href="returned.php?id='.$row['id'].'">Teruggebracht</a></td>';

                            echo '</tr>';
                   }
                   Database::disconnect();
                  ?>
                </tbody>
            </table>
        </div>
    </div>
    <!-- /container -->
</body>

</html>