fortune.php 591 B

12345678910111213141516171819202122232425262728293031
  1. <?php
  2. function fortune($pdo) {
  3. $statement = $pdo->query( 'SELECT id, message FROM Fortune' );
  4. $arr = $statement->fetchAll(PDO::FETCH_KEY_PAIR);
  5. $arr[0] = 'Additional fortune added at request time.';
  6. asort($arr);
  7. ?>
  8. <!DOCTYPE html>
  9. <html>
  10. <head>
  11. <title>Fortunes</title>
  12. </head>
  13. <body>
  14. <table>
  15. <tr>
  16. <th>id</th>
  17. <th>message</th>
  18. </tr>
  19. <?php
  20. foreach ( $arr as $id => $fortune ) {
  21. ?>
  22. <tr>
  23. <td><?php echo htmlspecialchars($id, ENT_QUOTES, 'UTF-8'); ?></td>
  24. <td><?php echo htmlspecialchars($fortune, ENT_QUOTES, 'UTF-8'); ?></td>
  25. </tr>
  26. <?php } ?>
  27. </table>
  28. </body>
  29. </html>
  30. <?php
  31. }