Advertisement
Guest User

Untitled

a guest
Nov 10th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.59 KB | None | 0 0
  1. <html>
  2.     <head>
  3.     <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  4.     <?php
  5.         header("Content-Type:text/html; charset=utf-8");
  6.     ?>
  7.         <title>ESP8266 Live Demo</title>
  8.         <style>
  9.         html, body{
  10.             background-color: #F2F2F2;
  11.             font-family: Arial;
  12.             font-size: 1em;
  13.         }
  14.         table{
  15.             border-spacing: 0;
  16.             border-collapse: collapse;
  17.             margin: 0 auto;
  18.         }
  19.         th{
  20.             padding: 8px;
  21.             background-color: #FF837A;
  22.             border: 1px solid #FF837A;
  23.         }
  24.         td{
  25.             padding: 10px;
  26.             background-color: #FFF;
  27.             border: 1px solid #CCC;
  28.         }
  29.         </style>
  30.     </head>
  31.     <body>
  32.         <?php  
  33.             // Database credentials.
  34.             $servername = "140.118.70.162";
  35.             $username = "kevin";
  36.             $dbname = "trash_data";
  37.             $password = "HGPK82LO27HXXGr9";
  38.  
  39.             // Create connection.
  40.             $conn = mysqli_connect("140.118.70.162", "kevin", "HGPK82LO27HXXGr9", "trash_data");
  41.             if (!$conn) {
  42.                 die("Connection failed: " . mysqli_connect_error(). PHP_EOL);
  43.             }
  44.  
  45.             $result = mysqli_query($conn, "SELECT id, time, chip_id, trash_amount, trash_gas FROM trash_data WHERE 1");
  46.             echo "<table><tr><th>id</th><th>time</th><th>chip_id</th><th>trash_amount</th><th>trash_gas</th></tr>";
  47.             /*while($row = mysqli_fetch_assoc($result)) {
  48.                 echo "<tr><td>";
  49.                 echo $row["id"];
  50.                 echo "</td><td>";
  51.                 echo $row["time"];
  52.                 echo "</td><td>";
  53.                 echo $row["chip_id"];
  54.                 echo "&deg;C</td><td>";
  55.                 echo $row["trash_amount"];
  56.                 echo "%</td><td>";
  57.                 echo $row["trash_gas"];
  58.                 echo "/1024</td></tr>";
  59.             }*/
  60.             echo "</tr></table>";
  61.             // Close connection.
  62.             mysqli_close($conn);
  63.         ?>
  64.     </body>
  65. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement