Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
- <?php
- header("Content-Type:text/html; charset=utf-8");
- ?>
- <title>ESP8266 Live Demo</title>
- <style>
- html, body{
- background-color: #F2F2F2;
- font-family: Arial;
- font-size: 1em;
- }
- table{
- border-spacing: 0;
- border-collapse: collapse;
- margin: 0 auto;
- }
- th{
- padding: 8px;
- background-color: #FF837A;
- border: 1px solid #FF837A;
- }
- td{
- padding: 10px;
- background-color: #FFF;
- border: 1px solid #CCC;
- }
- </style>
- </head>
- <body>
- <?php
- // Database credentials.
- $servername = "140.118.70.162";
- $username = "kevin";
- $dbname = "trash_data";
- $password = "HGPK82LO27HXXGr9";
- // Create connection.
- $conn = mysqli_connect("140.118.70.162", "kevin", "HGPK82LO27HXXGr9", "trash_data");
- if (!$conn) {
- die("Connection failed: " . mysqli_connect_error(). PHP_EOL);
- }
- $result = mysqli_query($conn, "SELECT id, time, chip_id, trash_amount, trash_gas FROM trash_data WHERE 1");
- echo "<table><tr><th>id</th><th>time</th><th>chip_id</th><th>trash_amount</th><th>trash_gas</th></tr>";
- /*while($row = mysqli_fetch_assoc($result)) {
- echo "<tr><td>";
- echo $row["id"];
- echo "</td><td>";
- echo $row["time"];
- echo "</td><td>";
- echo $row["chip_id"];
- echo "°C</td><td>";
- echo $row["trash_amount"];
- echo "%</td><td>";
- echo $row["trash_gas"];
- echo "/1024</td></tr>";
- }*/
- echo "</tr></table>";
- // Close connection.
- mysqli_close($conn);
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement