Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <style>
- body{
- background-image: url(OK-Boomer.jpg);
- }
- </style>
- </head>
- <body>
- <?php
- $mysqli = new mysqli('localhost', 'root', '', 'tws');
- $query = "SELECT * FROM data WHERE data.storage='1'";
- $query2 = "SELECT * FROM data WHERE data.storage='2'";
- $query3 = "SELECT * FROM data WHERE data.storage='3'";
- echo '<table style="background-color:rgba(255, 255, 255, 0.8);margin-left:auto;margin-right:auto;margin-top:15%;margin-bottom:auto;">
- <tr>
- <td>';
- echo '<form class="box" action="storagea.php" method="POST">';
- echo '<table style="padding:10px;">
- <tr style="border:2px solid black; border-collapse:collapse; border-style: none none solid none; padding:10px">
- <td style="border:3px; border-style: none none solid none; padding:5px; padding-right"><font face="Arial">STORAGE A</font></td>
- </tr>';
- if ($result = $mysqli->query($query)) {
- while ($row = $result->fetch_assoc()) {
- $field1name = $row["minval"];
- $field2name = $row["maxval"];
- $field3name = $row["curdata"];
- echo '<tr>
- <td style="border:2px; border-style: none none solid none; padding:5px;">Min: '.$field1name.'</td>
- </tr>
- <tr>
- <td style="border:2px; border-style: none none solid none; padding:5px;">Max: '.$field2name.'</td>
- </tr>
- <tr>
- <td style="border:2px; border-style: none none solid none; padding:5px;">Cur: '.$field3name.'</td>
- </tr>';
- }
- $result->free();
- }
- echo '<tr>
- <td style="border:2px; border-style: none none solid none; padding:5px;">
- <input type="text" name="ops" size="4"> <input type="submit" value="OK">
- </td>
- </tr>';
- echo '</table></form></td>
- <td>';
- echo '<form class="box" action="storageb.php" method="POST">';
- echo '<table style="padding:10px;">
- <tr style="border:2px solid black; border-collapse:collapse; border-style: none none solid none; padding:10px">
- <td style="border:3px; border-style: none none solid none; padding:5px; padding-right"><font face="Arial">STORAGE B</font></td>
- </tr>';
- if ($result = $mysqli->query($query2)) {
- while ($row = $result->fetch_assoc()) {
- $field1name = $row["minval"];
- $field2name = $row["maxval"];
- $field3name = $row["curdata"];
- echo '<tr>
- <td style="border:2px; border-style: none none solid none; padding:5px;">Min: '.$field1name.'</td>
- </tr>
- <tr>
- <td style="border:2px; border-style: none none solid none; padding:5px;">Max: '.$field2name.'</td>
- </tr>
- <tr>
- <td style="border:2px; border-style: none none solid none; padding:5px;">Cur: '.$field3name.'</td>
- </tr>';
- }
- $result->free();
- }
- echo '<tr>
- <td style="border:2px; border-style: none none solid none; padding:5px;">
- <input type="text" name="ops" size="4"> <input type="submit" value="OK">
- </td>
- </tr>';
- echo '</table></form></td>
- <td>';
- echo '<form class="box" action="storagec.php" method="POST">';
- echo '<table style="padding:10px;">
- <tr style="border:2px solid black; border-collapse:collapse; border-style: none none solid none; padding:10px">
- <td style="border:3px; border-style: none none solid none; padding:5px; padding-right"><font face="Arial">STORAGE C</font></td>
- </tr>';
- if ($result = $mysqli->query($query3)) {
- while ($row = $result->fetch_assoc()) {
- $field1name = $row["minval"];
- $field2name = $row["maxval"];
- $field3name = $row["curdata"];
- echo '<tr>
- <td style="border:2px; border-style: none none solid none; padding:5px;">Min: '.$field1name.'</td>
- </tr>
- <tr>
- <td style="border:2px; border-style: none none solid none; padding:5px;">max: '.$field2name.'</td>
- </tr>
- <tr>
- <td style="border:2px; border-style: none none solid none; padding:5px;">Cur: '.$field3name.'</td>
- </tr>';
- }
- $result->free();
- }
- echo '<tr>
- <td style="border:2px; border-style: none none solid none; padding:5px;">
- <input type="text" name="ops" size="4"> <input type="submit" value="OK">
- </td>
- </tr>';
- echo '</table></form></td></tr></table>'
- ?>
- <br><br>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement