Advertisement
Guest User

Untitled

a guest
Feb 14th, 2019
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.90 KB | None | 0 0
  1. <!doctype html>
  2. <html lang="en">
  3. <head>
  4. <!-- Required meta tags -->
  5. <meta charset="utf-8">
  6. <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  7.  
  8. <!-- Bootstrap CSS -->
  9. <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
  10.  
  11. <title>Speiseplan</title>
  12. </head>
  13. <body>
  14. <div class="container">
  15. <h1>Speiseplan pro Tag</h1>
  16. <?php
  17. $servername = "127.0.0.1";
  18. $username = "ROOT";
  19. $password = "AQ";
  20. $database = "Speiseplan";
  21.  
  22. try {
  23. $conn = new PDO("mysql:host=$servername;dbname=$database", $username, $password);
  24.  
  25. $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  26.  
  27. $sql = "SELECT * FROM $database";
  28. $result = $conn->query($sql)
  29.  
  30. if ($result->num_rows->0) {
  31. while($row = $result->fetch_assoc()) {
  32. echo $row['Tag']."<br />";
  33. echo $row['Menü1']."<br />";
  34. echo $row['Menü2']."<br />";
  35. echo $row['Vegetarisch']."<br />";
  36. echo $row['Dessert']."<br /><br />";
  37. }
  38. } else {
  39. echo "0 results";
  40. }
  41. }
  42. catch(PDOException $e) {
  43. echo "Error: " . $e->getMessage();
  44. }
  45.  
  46. ?>
  47. </div>
  48. </body>
  49. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement