Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- /* Verbindung aufnehmen */
- $con = mysqli_connect("localhost","NUTERNAME_PHPMYADMIN","PASSWORT_PHPMYADMIN");
- /* Datenbank auswählen */
- mysqli_select_db($con, "wohnzimmer");
- /* SQL-Abfrage ausführen */
- $res = mysqli_query($con, "select * from sensorwerte ORDER BY ID DESC LIMIT 1");
- /* Datensätze aus Ergebnis ermitteln, */
- /* in Array speichern und ausgeben */
- echo "<table border=1>";
- echo "<tr>";
- echo "<td>" . ID . "</td>";
- echo "<td>" . Zeit . "</td>";
- echo "<td>" . Temperatur . "</td>";
- echo "<td>" . Luftfeuchte . "</td>";
- echo "<td>" . Druck . "</td>";
- echo "</tr>";
- while ($dsatz = mysqli_fetch_assoc($res))
- {
- echo "<tr>";
- echo "<td>" . $dsatz["ID"] . "</td>";
- echo "<td>" . $dsatz["Zeit"] . "</td>";
- echo "<td>" . $dsatz["Temperatur"] . "</td>";
- echo "<td>" . $dsatz["Luftfeuchte"] . "</td>";
- echo "<td>" . $dsatz["Druck"] . "</td>";
- echo "</tr>";
- }
- echo "</tr>";
- echo "</table>";
- /* Verbindung schließen */
- mysqli_close($con);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement