Advertisement
Guest User

Untitled

a guest
May 7th, 2018
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.29 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4. <meta charset="UTF-8">
  5. <title>Oef3</title>
  6. </head>
  7. <body>
  8.  
  9.  
  10. <form action="oef3verwerk.php" method="get">
  11. <label for="selectBookId">bookId:</label>
  12. <select id="selectBookId" name="bookIdSelect">
  13. <?php
  14. $user='root';
  15. $password='root';
  16.  
  17. try {
  18. $pdo = new PDO("mysql:host=localhost" . ";dbname=examen",
  19. $user,
  20. $password );
  21.  
  22. $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
  23. $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); //excetions opvangen
  24. $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false); //statement prepare
  25.  
  26. $statement = $pdo->query("SELECT id FROM book");
  27. $statement->execute();
  28. $bookIDs = $statement->fetchAll();
  29.  
  30. foreach ($bookIDs as $bookID) {
  31. print('<option value="'.$bookID['id'].'">'.$bookID['id'].'</option>');
  32. }
  33. } catch ( PDOException $exception ) {
  34. echo '<label>';
  35. var_dump($exception);
  36. echo '</label>';
  37. }
  38.  
  39. ?>
  40. };
  41. </select>
  42. <input type="submit" value="delete"/>
  43. </form>
  44. </body>
  45. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement