Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!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 tl_dvd.id, tl_dvd.title, tl_dvd.duration, tl_dvd.release_date, tl_dvd.description, tl_genre.name FROM tl_dvd, tl_genre WHERE tl_dvd.genre_id = tl_genre.id';
- 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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement