Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html lang="en">
- <head>
- <meta charset="UTF-8">
- <title>Oef3</title>
- </head>
- <body>
- <form action="oef3verwerk.php" method="get">
- <label for="selectBookId">bookId:</label>
- <select id="selectBookId" name="bookIdSelect">
- <?php
- $user='root';
- $password='root';
- try {
- $pdo = new PDO("mysql:host=localhost" . ";dbname=examen",
- $user,
- $password );
- $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
- $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); //excetions opvangen
- $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false); //statement prepare
- $statement = $pdo->query("SELECT id FROM book");
- $statement->execute();
- $bookIDs = $statement->fetchAll();
- foreach ($bookIDs as $bookID) {
- print('<option value="'.$bookID['id'].'">'.$bookID['id'].'</option>');
- }
- } catch ( PDOException $exception ) {
- echo '<label>';
- var_dump($exception);
- echo '</label>';
- }
- ?>
- };
- </select>
- <input type="submit" value="delete"/>
- </form>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement