Advertisement
Guest User

Untitled

a guest
Sep 5th, 2018
182
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.13 KB | None | 0 0
  1. <html>
  2. <head>
  3. <style>
  4. #data {
  5. font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;
  6. border-collapse: collapse;
  7. width: 100%;
  8. }
  9.  
  10. #data td, #customers th {
  11. border: 1px solid #ddd;
  12. padding: 8px;
  13. }
  14.  
  15. #data tr:nth-child(even){background-color: #f2f2f2;}
  16.  
  17. #data tr:hover {background-color: #ddd;}
  18.  
  19. #data th {
  20. padding-top: 12px;
  21. padding-bottom: 12px;
  22. text-align: left;
  23. background-color: #4CAF50;
  24. color: white;
  25. }
  26. </style>
  27. </head>
  28. <body>
  29. <?php
  30.  
  31. $servername = "localhost";
  32. $username = "sensem";
  33. $password = "h@";
  34.  
  35. $conn = new mysqli($servername, $username, $password);
  36. if ($conn->connect_error) {
  37. die("Connection failed: " . $conn->connect_error);
  38. }
  39. $sql = "SELECT id, tijd, waarde FROM weerstation.metingen";
  40. $result = $conn->query($sql);
  41.  
  42. echo "<table id=\"data\" style=\"width:100%\"><tr><th>Tijd</th><th>Temperatuur (Celcius)</th></tr>";
  43.  
  44. if ($result->num_rows > 0) {
  45. while($row = $result->fetch_assoc()) {
  46. echo "<tr><td>".$row["tijd"]."</td><td>".$row["waarde"]."</td></tr>";
  47. }
  48. } else {
  49. echo "0 resultaten";
  50. }
  51. echo "</table>";
  52.  
  53. ?>
  54. </body>
  55. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement